Re: SLRUs in the main buffer pool - Page Header definitions

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: SLRUs in the main buffer pool - Page Header definitions
Дата
Msg-id Y/z1Zo0IHW8QNYUw@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: SLRUs in the main buffer pool - Page Header definitions  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: SLRUs in the main buffer pool - Page Header definitions  ("Bagga, Rishu" <bagrishu@amazon.com>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump versus hash partitioning
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Non-superuser subscription owners