Re: Always bump PG_CONTROL_VERSION? - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: Always bump PG_CONTROL_VERSION?
Date
Msg-id 20210513021540.cdheuimioyr3jtgt@nol
Whole thread Raw
In response to Re: Always bump PG_CONTROL_VERSION?  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Thu, May 13, 2021 at 11:04:54AM +0900, Michael Paquier wrote:
> On Wed, May 12, 2021 at 01:30:27PM -0700, Andres Freund wrote:
> > That said, I don't think it's a good practice to use the control file
> > version as an identifier for the major version. Who knows, it might be
> > necessary to add an optional new format in a minor version at some point
> > or such crazyness. And then there's the beta stuff you'd mentioned, etc.
> 
> Yes, PG_VERSION, as you wrote upthread already, is already fine for
> the job, and FWIW, I have yet to see a case where being able to easily
> detect the minor version in a data folder matters.

Would it even make any sense?  It could be "has version X.Y ever started the
cluster", or "was it the last version that started the cluster", or something
else?

> And, I am of the opinion to not change the control file version if
> there is no need to do so.

+1



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Performance degradation of REFRESH MATERIALIZED VIEW
Next
From: Andres Freund
Date:
Subject: Re: Performance degradation of REFRESH MATERIALIZED VIEW