Hello,
In a Saas application that has 1 database per customer, you may have
thousands of customers and therefore thousands of databases.
Creating thousands of connection pools is very costly memory wise.
What options are there with the postgres java driver currently?
Say I have 1 server with 500 customer databases on it.
Can I somehow create 1 connection pool to the server, and then switch to
the correct database on a per query basis? Or does the driver not support
this?
Or maybe this isn't a driver specific issue but rather a connection pool
question?