Re: SLRUs in the main buffer pool - Page Header definitions - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: SLRUs in the main buffer pool - Page Header definitions
Date
Msg-id Y/z1Zo0IHW8QNYUw@tamriel.snowman.net
Whole thread Raw
In response to Re: SLRUs in the main buffer pool - Page Header definitions  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: SLRUs in the main buffer pool - Page Header definitions
List pgsql-hackers
Greetings,

* Robert Haas (robertmhaas@gmail.com) wrote:
> On Mon, Feb 27, 2023 at 8:56 AM Heikki Linnakangas <hlinnaka@iki.fi> wrote:
> > I'm not sure if I like that or not. I think we should clean up and
> > finish the other patches that this builds on first, and then decide if
> > we want to use the standard page header for the SLRUs or not. And if we
> > decide that we want the SLRU pages to have a page header, clean this up
> > or rewrite it from scratch.
>
> I'm not entirely sure either, but I think the idea has some potential.
> If SLRU pages have headers, that means that they have LSNs, and
> perhaps then we could use those LSNs to figure out when they're safe
> to write to disk, instead of ad-hoc mechanisms. See SlruSharedData's
> group_lsn field.

I agree that it's got potential and seems like the right direction to go
in.  That would also allow for checksums for SLRUs and possibly support
for encryption which leverages the LSN and for a dynamic page feature
area which could allow for an extended checksum or perhaps authenticated
encryption with additonal authenticated data.

Thanks,

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump versus hash partitioning
Next
From: Jeff Davis
Date:
Subject: Re: Non-superuser subscription owners