Re: Why is this query touching 4gb of buffers? - Mailing list pgsql-general

From Tom Lane
Subject Re: Why is this query touching 4gb of buffers?
Date
Msg-id 1755687.1761310871@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why is this query touching 4gb of buffers?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Why is this query touching 4gb of buffers?
List pgsql-general
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



pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication)
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Why is this query touching 4gb of buffers?