Re: Fix pg_stat_reset_single_table_counters function - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Fix pg_stat_reset_single_table_counters function
Date
Msg-id 20230812191207.aerskqox7aoan3ud@awork3.anarazel.de
Whole thread Raw
In response to Re: Fix pg_stat_reset_single_table_counters function  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: Fix pg_stat_reset_single_table_counters function
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION }
Next
From: Andres Freund
Date:
Subject: Re: Performance degradation on concurrent COPY into a single relation in PG16.