Re: db maintanance problem VACUUM FULL - Mailing list pgsql-general

From Ron Johnson
Subject Re: db maintanance problem VACUUM FULL
Date
Msg-id CANzqJaBUw_N9+rtdb88Fbhdw4T8m=1_52Xfwa988+0bP4retJQ@mail.gmail.com
Whole thread Raw
In response to db maintanance problem VACUUM FULL  (Pavol Sekeres <pavol.sekeres8@gmail.com>)
List pgsql-general
On Thu, Jun 12, 2025 at 9:24 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Thu, 2025-06-12 at 15:14 +0200, Pavol Sekeres wrote:
> We recently updated our production database to PostgreSQL 12.22 from the 9.6.24 version.
> We didn't want to make a big jump.

But you should have.  v12 is out of support.

The dreaded Software Compatibility Matrix often restricts how big of a jump is possible when upgrading databases (and even Python).
 
Multi-phase upgrades spanning months are quite common.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: db maintanance problem VACUUM FULL
Next
From: Rachel Roch
Date:
Subject: Re: pg_restore ERROR: permission denied to change default privileges