Category «Postgresql»

Increase number of files open for Pgbouncer

Pgbouncer is a lightweight connection pooler for Postgresql. It reduces the overhead of creating a new connection every time, instead it keeps a pool of connections open at all times which greatly reduces overhead. If you are doing a lot of connections per second, then Pgbouncer may complain that the open file limit has reached. …