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

From: Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>
To: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Eagerly scan all-visible pages to amortize aggressive vacuum
Date: 2025-07-31 14:05:19
Message-ID: 5764012e-aa72-4c16-b18f-23f7253ad620@postgrespro.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.
OhmyGod!Whata stupidmistakeI made. Imultipliedthe numberof regionsby3%:-)
> 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-07-31 14:06:02 Re: Convert varatt.h macros to static inline functions
Previous Message Peter Eisentraut 2025-07-31 14:02:35 Datum as struct