Re: Dubious server log messages after pg_upgrade

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Dubious server log messages after pg_upgrade
Date: 2025-03-16 23:39:49
Message-ID: Z9dhRaF52WgZ82s5@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sungwoo Chang 2025-03-16 23:54:23 Re: dsm_registry: Add detach and destroy features
Previous Message Peter Smith 2025-03-16 23:38:19 Re: TOAST versus toast