> -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin- > owner@xxxxxxxxxxxxxx] On Behalf Of leslie samuel > Sent: Friday, March 18, 2011 1:17 AM > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: pg_stat_all_tables column value reseting problem. > > Thanks for ur reply Ragu.. > > Yes, I have executed this select pg_stat_reset(); as a root user. > It has reseted the values. > > But last time ( when I was posted this query) I didn't executed it. > But values were rested automatically. > > I would like to know, > > => Whether postgres automatically running this select > pg_stat_reset(); > statement ? > => If it runs Which scenario its executing this statement and what > is the > interval time between each execution ? > > Please let me know.. > Thanks.. > If you stop/restart the database in immediate mode, or if it crashes the stats will be reset. What mode did you use for shutdown? Brad. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
