News for hackers. Stuff that matters.

A comment on Improved vacuum in PostgreSQL 13. Parent comment

Re:Improved vacuum in PostgreSQL 13 by rrdharan on Tuesday May 12, 2020 @10:33AM (#23154400)
Curious why you bothered with pgBouncer for 200 queries per day? Just future proofing?

EDIT: forgot, pgBouncer also allows you to do hitless restart/upgrade, which is useful at any query volume I suppose ;)

[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by Jonnax on Tuesday May 12, 2020 @11:10AM (#23154812)
Indeed.

Also the server the DB is on is RAM constrained. And Postgres making a process per connection brings it right down versus using pgBouncer to pool connections.

It seems complicated but it's actually quite simple.

[ Parent | on HN ]