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

Поиск
Список
Период
Сортировка
Искать
От
Bagga, Rishu
Тема
Re: SLRUs in the main buffer pool - Page Header definitions
Дата
Msg-id
FA5F325C-8C44-4B1B-8584-3AB2C5027957@amazon.com
Ответ на
Список
Дерево обсуждения
SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions Shawn Debnath <clocksweep@gmail.com>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions Shawn Debnath <clocksweep@gmail.com>
Re: SLRUs in the main buffer pool - Page Header definitions Tom Lane <tgl@sss.pgh.pa.us>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Ian Lawrence Barwick <barwick@gmail.com>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions vignesh C <vignesh21@gmail.com>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Andres Freund <andres@anarazel.de>
Re: SLRUs in the main buffer pool - Page Header definitions Heikki Linnakangas <hlinnaka@iki.fi>
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 Stephen Frost <sfrost@snowman.net>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Stephen Frost <sfrost@snowman.net>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Nathan Bossart <nathandbossart@gmail.com>
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 Stephen Frost <sfrost@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 Stephen Frost <sfrost@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 Aleksander Alekseev <aleksander@timescale.com>
Re: SLRUs in the main buffer pool - Page Header definitions "Bagga, Rishu" <bagrishu@amazon.com>
Re: SLRUs in the main buffer pool - Page Header definitions Robert Haas <robertmhaas@gmail.com>
Hi Andres,


>When do we need to do so? We should never need to figure out whether an
>on-disk block is for an SLRU or something else, without also knowing >which
>relation / SLRU it is in.

You are correct that we wouldn’t need to rely on the pd_flag bit to determine page type for any access to a page where we come top down following the hierarchy. However, for the purpose of debugging “from the bottom up” it would be critical to know what type of page is being read in a system with multiple page header types.

On 6/23/22, 2:22 PM, "Andres Freund"  wrote:


    Hi,

    On 2022-06-23 20:25:21 +0000, Bagga, Rishu wrote:
    > >> 3. A flag to identify if the page is a relational or BufferedObject
    > >Why is this needed in the page header?
    >
    > Now that we are dealing with two different type of page headers, we need to
    > know how to interpret any given page. We need to use pd_flags to determine
    > this.

    When do we need to do so? We should never need to figure out whether an
    on-disk block is for an SLRU or something else, without also knowing which
    relation / SLRU it is in.

    Greetings,

    Andres Freund

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: fix crash with Python 3.11
От: Andres Freund
Дата:
FAQ