I have a scenario where a database server need to maintain a huge number of small databases. So to keep TLS clients connected to this server is a pain because PG requires to have a unique connection for each database.
For databases deployed in cloud (like AWS) it is even worse, because we cannot proxy the connections from the database server. So in order to keep the number of connections acceptable for my env I usually use a pgbouncer like solution to manage the connections and reduce the number of connections to the server. It would be great if PG protocol support reusabilty of TLS connections and enable clients to switch the database for an established connection. I'd like to hear about your experience. Have you seen such scenarios? How are you dealing with it? -- Carlo Pires
