Re: Add shared buffer hits to pg_stat_io

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Add shared buffer hits to pg_stat_io
Дата
Msg-id 20230331023950.bur4pldkivshsdp7@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Add shared buffer hits to pg_stat_io  (Melanie Plageman <melanieplageman@gmail.com>)
Список pgsql-hackers
Hi,

On 2023-03-09 08:23:46 -0500, Melanie Plageman wrote:
> Good idea. v3 attached.

I committed this, after some small regression test changes. I was worried that
the query for testing buffer hits might silently change in the future, so I
added an EXPLAIN for the query. Also removed the need for the explicit RESETs
by using BEGIN; SET LOCAL ...; query; COMMIT;.

Thanks for the patch Melanie and the review Bertrand. I'm excited about
finally being able to compute meaningful cache hit ratios :)

Regards,

Andres



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Array initialisation notation in syscache.c
Следующее
От: Peter Smith
Дата:
Сообщение: Re: Data is copied twice when specifying both child and parent table in publication