Re: Why is this query touching 4gb of buffers?

hubert depesz lubaczewski <depesz@depesz.com> writes:
> On Fri, Oct 24, 2025 at 08:54:06AM -0400, Tom Lane wrote:
>> The first execution probably had to set hint bits on a whole lot
>> of recently-deleted rows.

> But why it doesn't happen/help on secondary?

IIRC, secondaries aren't authorized to update hint bits for
themselves, they have to wait for the primary to do it and then
propagate the new data.  There might also be some question of
what the oldest open transaction is ...

            regards, tom lane