4 ms·

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 b

by Jonnax 6y 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?

ximeng 6y ago
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.
barbegal 6y ago
Well what are the issues you are currently having with Postgres 10? It doesn't sound like there is any compelling reason.
- Jonnax 6y ago
  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.
  - deleted 6y ago
    [deleted]
  - rrdharan 6y ago
    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 ;)
    - Jonnax 6y ago
      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.
amitkapila 6y ago
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/ https://www.postgresql.org/docs/release/ for the latest releases and what is fixed in each minor release.
hans_castorp 6y ago
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)

by Jonnax 6y 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?

ximeng 6y ago

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.

barbegal 6y ago

Well what are the issues you are currently having with Postgres 10? It doesn't sound like there is any compelling reason.

Jonnax 6y ago
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.
- deleted 6y ago
  [deleted]
- rrdharan 6y ago
  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 ;)
  - Jonnax 6y ago
    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.

amitkapila 6y ago

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/ https://www.postgresql.org/docs/release/ for the latest releases and what is fixed in each minor release.

hans_castorp 6y ago

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)