Re: Dubious server log messages after pg_upgrade - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Dubious server log messages after pg_upgrade
Date
Msg-id Z9dhRaF52WgZ82s5@paquier.xyz
Whole thread Raw
In response to Re: Dubious server log messages after pg_upgrade  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Sat, Mar 15, 2025 at 11:09:28AM +0900, Michael Paquier wrote:
> Let's remove it for this release.  Perhaps we will not even need this
> part if we are able to rebuild the most critical stats from WAL after
> a crash.  This itself needs more work, one point mentioned being to
> move some table stats at the level of its relfilenode(s) so as we
> could catch up on the data in the startup process when recovering.
> Note the bump of PGSTAT_FILE_FORMAT_ID that's required by removing
> this LSN.
>
> With all that said, please see the attached that I'm planning to do.

And just done that.

FWIW, I've had on my tablets the idea to refactor the pgstats code so
as it would be possible to read and/or write its data on disk through
a frontend.  This thread gives an extra reason to do so.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: TOAST versus toast
Next
From: Sungwoo Chang
Date:
Subject: Re: dsm_registry: Add detach and destroy features