News for hackers. Stuff that matters.

A comment on Improved vacuum in PostgreSQL 13. Parent comment

Re:Improved vacuum in PostgreSQL 13 by barbegal on Tuesday May 12, 2020 @04:42AM (#23151807)
Well what are the issues you are currently having with Postgres 10? It doesn't sound like there is any compelling reason.
[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by Jonnax on Tuesday May 12, 2020 @04:58AM (#23151909)
Yeah. That's the question haha.

I've got pgBackrest set up for backups and pgBouncer for connection pooling set up so it's a case of wondering if there is some benefit to the newer versions for someone using it "casually"

Since it's require quite a bit of reconfig and testing.

[ Parent | on HN ]
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 ]