[GENERAL] pg_stat_reset not resetting all stats

2008-12-12 Thread Brad Nicholson 
Is there a reason that pg_stat_reset doesn't reset the stats in
pg_stat_bgwriter and pg_stat_database?  PG 8.3 (obviously).

The call to pg_stat_reset works, as my other stats tables are clear.
-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] pg_stat_reset not resetting all stats

2008-12-12 Thread Tom Lane 
Brad Nicholson bnich...@ca.afilias.info writes:
 Is there a reason that pg_stat_reset doesn't reset the stats in
 pg_stat_bgwriter and pg_stat_database?  PG 8.3 (obviously).

It is only supposed to reset counters associated with the current
database.  Those counts are cluster-wide.

regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general