Re: BUG #18046: stats collection behaviour change is affecting the usability of information. - Mailing list pgsql-bugs

From Jobin Augustine
Subject Re: BUG #18046: stats collection behaviour change is affecting the usability of information.
Date
Msg-id CAEpZXffS+pwwMeTNK2pEQE+HJPvspO8k28swBAeLzUAunSVRVA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18046: stats collection behaviour change is affecting the usability of information.  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs




I think Horiguchi-san's approach is closer to what we would want.

Great. 

Unfortunately, the reset time for other variable-numbered stats entries
historically has behaved differently than what you're
desiring. E.g. pg_stat_replication_slots.stats_reset isn't set unless you have
reset the stats.

Conceptually, that's correct. But the Impact on users are different.
SQL statements around pg_stat_database are something every user (DBA) has in their arsenal for essential checks and troubleshooting.
The impact is big when their queries stopped working/giving wrong results from PostgeSQL 15 onwards.
 
I'm ok with changing the semantics to one behaviour,
Great. I believe everyone will appreciate a consistent behaviour
 
but I'm a bit hesitant
whacking this around further in a minor release...


Since this sudden undocumented behaviour change caught everyone by surprise,
and case this is a too big change for a "bug-fix",  is it possible to have a temporary fix for a minor version, fixing pg_stat_database alone?
 
Greetings,
Andres Freund

Regards,
Jobin Augustine

pgsql-bugs by date:

Previous
From: Alexander Pyhalov
Date:
Subject: Re: BUG #17695: Failed Assert in logical replication snapbuild.
Next
From: Thomas Munro
Date:
Subject: Re: BUG #17928: Standby fails to decode WAL on termination of primary