What is a good way to determine the number of available transaction connections when using
pgBouncer to pool database connections? Also, how should I determine the number of
Our application has over 200 concurrent processes, each of which regularly reads and writes to the database. Using session-level, I would expect the number of pooled connections to be around the number of concurrent processes working on the DB at a given time, but I don't really know how to translate that to transaction-level pooling.
Thanks very much! Let me know if more information is necessary and I will gladly oblige.