Re: Odd off-by-one dirty buffers and checkpoint buffers written

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Odd off-by-one dirty buffers and checkpoint buffers written
Дата
Msg-id CAKFQuwYYjXEEvmj0ZJNTyHVvUWwOf_Y8CU5RhS+-M6+qFG105Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Odd off-by-one dirty buffers and checkpoint buffers written  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: Bad estimate with partial index
Следующее
От: "bucoo@sohu.com"
Дата:
Сообщение: Re: Re: fix cost subqueryscan wrong parallel cost