Re: [HACKERS] Resetting cluster-wide statistics

2009-04-09 Thread Bruce Momjian
Greg Smith wrote: > On Mon, 23 Mar 2009, Tom Lane wrote: > > > We used to have the stats_reset_on_server_start thingy, which covered > > that case. When we removed it on the grounds that you could do the > > same less klugily with pg_stat_reset(), nobody complained about > > cluster-wide stats...

Re: [HACKERS] Resetting cluster-wide statistics

2009-03-23 Thread Greg Smith
On Mon, 23 Mar 2009, Tom Lane wrote: We used to have the stats_reset_on_server_start thingy, which covered that case. When we removed it on the grounds that you could do the same less klugily with pg_stat_reset(), nobody complained about cluster-wide stats... Not exactly sure of the sequence

Re: [HACKERS] Resetting cluster-wide statistics

2009-03-23 Thread Tom Lane
Greg Smith writes: > I'm curious why something resetting the cluster-wide stats isn't > available already. We used to have the stats_reset_on_server_start thingy, which covered that case. When we removed it on the grounds that you could do the same less klugily with pg_stat_reset(), nobody comp

[HACKERS] Resetting cluster-wide statistics

2009-03-23 Thread Greg Smith
There are a few statistics that are only kept on a per-cluster basis, such as those reported in pg_stat_database and pg_stat_bgwriter. Since pg_stat_reset only resets per-database counts, it doesn't touch those. I'd like to have a function that resets those. Maybe iterates over all the datab