Tagged Questions
4
votes
0answers
70 views
Does PgBouncer create a separate pool for every database config entry?
If I set up a pgbouncer.ini config file with several database entries, does pgBouncer create a separate pool for each one? I would think so, but have not been able to confirm this.
For example, ...
2
votes
0answers
72 views
How to properly configure pgBouncer transaction level pooling?
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 max_connections and ...
1
vote
2answers
441 views
Too many TIME_WAIT connections in PostgreSQL
I am using PostgreSQL 9.0 on Centos 5.7 Final.
At any given there are around 1,500-2,200 connections open for PostgreSQL on port 5432 which are in TIME_WAIT state.
I have a feeling this is not good.
...