public inbox for [email protected]  
help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: David Rowley <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: Ron Johnson <[email protected]>
Cc: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Date: Fri, 24 Oct 2025 19:00:05 -0400
Message-ID: <CAKFQuwYrmUin6Xo0FwxPiSGeON5rX60R8hGd9+A9PqzUg704Mw@mail.gmail.com> (raw)
In-Reply-To: <CAApHDvo5pLSwD4JVxW8t94Vc88djKrrSyrL-GbQJ=hb2NVT5zg@mail.gmail.com>
References: <CAJ4rSwspyYBppQS701C=BVFX2yrP1JErgDCZXbC15BQh2zAS1Q@mail.gmail.com>
	<CAKAnmmK47O_rYDB4iPe=K3QiqzJcCnnxCoYs_40Q1YWb=x0nDg@mail.gmail.com>
	<CAJ4rSwvsRJhwfuem0vsws1WwRZPN8Ju2Nw0e0Oc2j7n=MXUhMg@mail.gmail.com>
	<[email protected]>
	<CAKAnmmLDfgYRX8oC6S7jKZyovv6wy72Twq6-hx315GKTowMjew@mail.gmail.com>
	<[email protected]>
	<CANzqJaBq3hcAUXhSi5ar0=Gw0QxqfmD_E47dxHAex9_D3Yv-WA@mail.gmail.com>
	<[email protected]>
	<CAApHDvo5pLSwD4JVxW8t94Vc88djKrrSyrL-GbQJ=hb2NVT5zg@mail.gmail.com>

On Friday, October 24, 2025, David Rowley <[email protected]> wrote:

> On Sat, 25 Oct 2025 at 04:51, Adrian Klaver <[email protected]>
> wrote:
> >
> > On 10/24/25 08:00, Ron Johnson wrote:
> > > On Fri, Oct 24, 2025 at 10:54 AM Adrian Klaver
> > > <[email protected] <mailto:[email protected]>> wrote:
> >
> > > "Never trust a .0 release with important data" is just as true in 2025
> > > as it was in 1985.
> > >
> > > That's a chicken and egg problem, though, isn't it?
> >
> > There is nothing stopping you from setting up a test instance and
> > kicking the tires on a new release to see if your setup will work
> > correctly.
>
> I'd say it's exactly that attitude that causes people to think .0
> should be avoided. Beta versions are meant for test instances. It'd be
> good if people encouraged their use more often rather than pushing
> people to defer til GA.
>

I’d say it’s negativity bias that causes this.  Remembering the times
serious bugs were discovered in .0-.2 releases strongly leans one to avoid
.0-.2 releases.  Counteracting that bias with data seems needed.  Yes, it
would be great if more people tested betas; but there is no way for users
to have any idea of how much or how effective such efforts have been for a
given release.

If someone comes here asking for advice I’m going to be conservative.  The
ones who are going to be pushing the envelope or doing beta testing are not
asking for this kind of advice.  They do it likely to benefit from new
features and some subset does it to be the canary for the community because
they can handle the rare negative outcome.

David J.


view thread (21+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
  In-Reply-To: <CAKFQuwYrmUin6Xo0FwxPiSGeON5rX60R8hGd9+A9PqzUg704Mw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox