Re: Eagerly scan all-visible pages to amortize aggressive vacuum

Поиск
Список
Период
Сортировка
От Pavel Luzanov
Тема Re: Eagerly scan all-visible pages to amortize aggressive vacuum
Дата
Msg-id 5764012e-aa72-4c16-b18f-23f7253ad620@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Eagerly scan all-visible pages to amortize aggressive vacuum  (Melanie Plageman <melanieplageman@gmail.com>)
Список pgsql-hackers
On 31.07.2025 16:31, Melanie Plageman wrote:
If you eager scan and fail to freeze 3% of each
region, you'll have eager scanned and failed to freeze 3% of the
blocks in the table -- so the total cap is the same.
Oh my God! What a stupid mistake I made. I multiplied the number of regions by 3% :-)
Documenting it means exposing more about the algorithm than seems
useful or actionable to the user.

Of course, you are right.
Thank you very much for clarifications.
-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com

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