MIME-Version: 1.0
References: <CA+RPunpqzys-rqsH9Xia8KWJ2+mR=V_TXe4Ca+JDV7bvmym8TQ@mail.gmail.com>
 <61b05ae722c2b21cd63d98544c55ecc0e35aa887.camel@cybertec.at>
In-Reply-To: <61b05ae722c2b21cd63d98544c55ecc0e35aa887.camel@cybertec.at>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 12 Jun 2025 09:29:48 -0400
Message-ID: <CANzqJaBUw_N9+rtdb88Fbhdw4T8m=1_52Xfwa988+0bP4retJQ@mail.gmail.com>
Subject: Re: db maintanance problem VACUUM FULL
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000248b7c06375fedd3"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBUw_N9%2Brtdb88Fbhdw4T8m%3D1_52Xfwa988%2B0bP4retJQ%40mail.gmail.com>
Precedence: bulk

--000000000000248b7c06375fedd3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Jun 12, 2025 at 9:24=E2=80=AFAM 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 th=
e
> 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.

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

--000000000000248b7c06375fedd3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Thu, Jun 12, 2025 at 9:24=E2=80=AFAM L=
aurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">laurenz.albe@cy=
bertec.at</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_contain=
er"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left:1px solid rgb(204,204,204);padding-left:1ex">On Thu, 2025-06-12 at=
 15:14 +0200, Pavol Sekeres wrote:<br>
&gt; We recently updated our production database to PostgreSQL 12.22 from t=
he 9.6.24 version.<br>
&gt; We didn&#39;t want to make a big jump.<br>
<br>
But you should have.=C2=A0 v12 is out of support.<br></blockquote><div><br>=
</div><div>The dreaded Software Compatibility Matrix often restricts how bi=
g of a jump is possible when upgrading databases (and even Python).</div><d=
iv>=C2=A0</div><div>Multi-phase upgrades spanning months are quite common.<=
/div><div></div></div><div><br></div><span class=3D"gmail_signature_prefix"=
>-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">=
Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m=
 still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div=
></div></div>

--000000000000248b7c06375fedd3--