Re: Why not try for a HOT update, even when PageIsFull()?

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Why not try for a HOT update, even when PageIsFull()?
Дата
Msg-id CAH2-Wz=1oCXbEbdYqHg3=fuvsnem8bsrnU_YejhSOoiHENE3fQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why not try for a HOT update, even when PageIsFull()?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: Why not try for a HOT update, even when PageIsFull()?  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
On Fri, Nov 19, 2021 at 11:51 AM Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Hmm, I don't have any memory of introducing this; and if you look at the
> thread, you'll notice that it got there between the first patch I posted
> and the second one, without any mention of the reason.  I probably got
> that code from the WARM patch series at some point, thinking that it was
> an obvious optimization; but I'm fairly certain that we didn't run any
> tailored micro-benchmark to justify it.

I suspected that it was something like that. I agree that it's
unlikely that we'll be able to do another HOT update for as long as
the page has PD_PAGE_FULL set. But that's not saying much; it's also
unlikely that heap_update will find that PD_PAGE_FULL is set to begin
with. And, the chances of successfully applying HOT again are workload
dependent.

> I certainly do not object to removing it.

I'd like to do so soon. I'll wait a few more days, in case Pavan objects.

Thanks
-- 
Peter Geoghegan



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Windows: Wrong error message at connection termination
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: logical decoding and replication of sequences