> -----Original Message----- > From: [email protected] [mailto:pgsql-admin- > [email protected]] On Behalf Of leslie samuel > Sent: Friday, March 18, 2011 1:17 AM > To: [email protected] > Subject: Re: [ADMIN] 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
