News for hackers. Stuff that matters.
Re:PgBouncer is useful, important, and fraught with peril by aidenn0 on Friday September 08, 2023 @11:41AM (#37435077)
I think it's an issue with a microservice setup. TFA suggests ~300 connections being optimal for Postgres and I've seen microservice setups which have more than 300 processes, which means even limiting each process to a single DB connection might not be enough.

But yeah, for less distributed applications, just have N worker threads and don't close the DB connection after each job.

There are no comments on this comment yet.