top | item 37434168

(no title)

Deadron | 2 years ago

To be clear pgbouncer does not add connections to postgres or remove the connection bottleneck. Its still there under the covers. If you are saturating your connections it will not be able to improve on throughput. It sounds like you need a different architecture to allow for queueing work. The approach pgbouncer takes may actually reduce performance overall as it will intermix work on the pg instance which, if you are already saturating the database, will slow down other operations overall.

discuss

order

dharmab|2 years ago

Yup, one of the things we're doing is moving parts of the system away from Postgres into queues.