Re: Odd off-by-one dirty buffers and checkpoint buffers written - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Odd off-by-one dirty buffers and checkpoint buffers written
Date
Msg-id CAKFQuwYYjXEEvmj0ZJNTyHVvUWwOf_Y8CU5RhS+-M6+qFG105Q@mail.gmail.com
Whole thread Raw
In response to Re: Odd off-by-one dirty buffers and checkpoint buffers written  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-hackers
On Wed, Apr 20, 2022 at 1:03 AM Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote:

The reason for the 2 hits of Xact SLRU is that once for visibility
(MVCC) check and another for commit.

 
Makes sense.  Thanks.  Now, is the lack of such a detail when looking at pg_stat_slru (for this and the other 6 named caches) an omission by intent or just no one has taken the time to write up what the different caches are holding?  I would think a brief sentence for each followed by a link to the main section describing the feature would be decent content to add to the introduction for the view in 28.2.21.

Also, is "other" ever expected to be something besides all zeros?

Thanks!

David J.

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Bad estimate with partial index
Next
From: "bucoo@sohu.com"
Date:
Subject: Re: Re: fix cost subqueryscan wrong parallel cost