Re: New WAL record to detect the checkpoint redo location

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: New WAL record to detect the checkpoint redo location
Дата
Msg-id
20231009232034.6yk552kmlner4pxt@awork3.anarazel.de
Ответ на
Список
Дерево обсуждения
New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Andres Freund <andres@anarazel.de>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Andres Freund <andres@anarazel.de>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Andres Freund <andres@anarazel.de>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Andres Freund <andres@anarazel.de>
Re: New WAL record to detect the checkpoint redo location Thomas Munro <thomas.munro@gmail.com>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Andres Freund <andres@anarazel.de>
Re: New WAL record to detect the checkpoint redo location Amit Kapila <amit.kapila16@gmail.com>
Re: New WAL record to detect the checkpoint redo location Robert Haas <robertmhaas@gmail.com>
Re: New WAL record to detect the checkpoint redo location Amit Kapila <amit.kapila16@gmail.com>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Re: New WAL record to detect the checkpoint redo location Dilip Kumar <dilipbalaut@gmail.com>
Re: New WAL record to detect the checkpoint redo location Michael Paquier <michael@paquier.xyz>
Hi,

On 2023-10-09 18:31:11 -0400, Robert Haas wrote:
> On Mon, Oct 9, 2023 at 4:47 PM Andres Freund  wrote:
> > I think we might be able to speed some of this up by pre-compute values so we
> > can implement things like bytesleft / UsableBytesInPage with shifts. IIRC we
> > already insist on power-of-two segment sizes, so instead of needing to divide
> > by a runtime value, we should be able to shift by a runtime value (and the
> > modulo should be a mask).
> 
> Huh, is there a general technique for this when dividing by a
> non-power-of-two?

There is, but I was just having a brainfart, forgetting that UsableBytesInPage
isn't itself a power of two. The general technique is used by compilers, but
doesn't iirc lend itself well to be done at runtime.

Greetings,

Andres Freund


В списке pgsql-hackers по дате отправления
От: Thomas Munro
Дата:
От: Bruce Momjian
Дата:
FAQ