Re: lazy_scan_heap() should release lock on buffer before vacuuming FSM

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: lazy_scan_heap() should release lock on buffer before vacuuming FSM
Дата
Msg-id CA+Tgmob6uBXWOaE52BS2g6P9ypmsAib+HHa8wmqm0PAe213a9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: lazy_scan_heap() should release lock on buffer before vacuuming FSM  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Thu, Nov 16, 2023 at 3:49 PM Andres Freund <andres@anarazel.de> wrote:
> I think the main reason it's not all that bad, even when hitting this path, is
> that one stall every 8GB just isn't that much and that the stalls aren't that
> long - the leaf page fsm updates don't use the strategy, so they're still
> somewhat likely to be in s_b, and there's "just" ~2MB of FMS to read. I tried
> to reproduce it here, and it was a few ms, even though I dropped filesystem
> caches in a loop.

So just fix it in master then. If it turns out later there are worse
scenarios, you can back-patch then.

--
Robert Haas
EDB: http://www.enterprisedb.com



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

Предыдущее
От: Daniel Gustafsson
Дата:
Сообщение: Adding deprecation notices to pgcrypto documentation
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks