Hacker News new | ask | show | jobs
by Jonnax 2234 days ago
So I'm running a single Postgres 10 instance for a small project that probably hits about 200 queries a day at most.

I haven't upgraded but would it actually be worth the effort?

4 comments

I think it's worth the effort just to make sure you keep familiar with the process for upgrading (including making appropriate backups). It's pretty quick and easy to upgrade and makes sure you're on top of deployment for your project.
No real advantage especially with a mostly idle system.

But it's a good idea to keep up with the versions anyway. The upgrade processes isn't really complicated and if you can afford a downtime not really challenging.

In my experience it's typically easier to migrate from version x to x+1, rather than waiting a long time and then migrate from x to x+5 (or similar big jumps).

But regardless of the strategy for major version upgrades (10 -> 11 -> 12) you should at least keep up with the minor updates (10.1 -> 10.12)

Even if you don't want to upgrade to major version as you don't need additional features, it is advisable to upgrade to latest minor version of PG-10. See docs https://www.postgresql.org/docs/release/ for the latest releases and what is fixed in each minor release.
Well what are the issues you are currently having with Postgres 10? It doesn't sound like there is any compelling reason.
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.

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 ;)

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.