Sample Header Ad - 728x90

PostgreSQL: Database Layer Pooling v/s Application Layer pooling

0 votes
1 answer
167 views
I would like to have some recommendations about connection pooling in PostgreSQL. We already have connection pooling using Pgbouncer behind an Azure LB. The pgbouncer itself is working pretty much good and later we planning to change pooling method to transaction. However we recently found that the nodejs client lib has connection pooling using pg.pool routed to LB. Now we have two layer of pooling one at application layer and other one at the db. Is it a good practice to have multiple layer of pooling? Or just pgbouncer enough to handle this considering the transaction pooling method? What are the things to consider which layer of pooling best for our system?
Asked by goodfella (595 rep)
Mar 15, 2024, 01:57 AM
Last activity: Jul 13, 2025, 02:05 PM