Re: Fix pg_stat_reset_single_table_counters function

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Fix pg_stat_reset_single_table_counters function
Дата
Msg-id 20230812191207.aerskqox7aoan3ud@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: Fix pg_stat_reset_single_table_counters function  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: Fix pg_stat_reset_single_table_counters function  (Masahiro Ikeda <ikedamsh@oss.nttdata.com>)
Список pgsql-hackers
Дерево обсуждения 
Hi,

On 2023-08-10 17:48:10 +0900, Masahiko Sawada wrote:
> Good catch! I've confirmed that the issue has been fixed by your patch.

Indeed.


> However, I'm not sure the added regression tests are stable since
> autovacuum workers may scan the pg_database and increment the
> statistics after resetting the stats.

What about updating the table and checking the update count is reset? That'd
not be reset by autovacuum.

Greetings,

Andres Freund

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Performance degradation on concurrent COPY into a single relation in PG16.