java.net.SocketException: Too many open files

[ratheesh-kr]

I am Using pgCassandra to create FDW tables from Cassandra,

My Application is a real-time monitoring system and continues data will insert in Cassandra and the FDW table also will grow based on that.

But While using this which throws the error Too many open files.

While checking in google I got the reason something like "the socket connections are treated like files and they use file descriptor, which is a limited resource".

While we use FDW, every time which is trying to connect with Cassandra using the PORT 9042? or if we create an FDW table and the data will fetch from the FDW with out communicating the Cassandra through the port 9042?

Can you please suggest and solution for this?