Re: not all pg_stat_database fields reset after pg_stat_reset()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tv(at)fuzzy(dot)cz
Cc: pgsql-bugs(at)postgresql(dot)org, "Magnus Hagander" <magnus(at)hagander(dot)net>
Subject: Re: not all pg_stat_database fields reset after pg_stat_reset()
Date: 2010-12-11 18:03:01
Message-ID: 12949.1292090581@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

tv(at)fuzzy(dot)cz writes:
>> However, I disagree with resetting last_autovac_time ... that's not a
>> counter, so there's no particularly good reason to discard its value.

> Oh yeah, I see. Haven't realized that when writing the patch.

... on the other hand, the reset operation is discarding the per-table
last-vacuum times, so maybe discarding the database-level value too is
more consistent. Not sure.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2010-12-11 21:58:47 Re: not all pg_stat_database fields reset after pg_stat_reset()
Previous Message tv 2010-12-11 17:58:50 Re: not all pg_stat_database fields reset after pg_stat_reset()