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();
=> If it runs Which scenario its executing this statement and what is the
interval time between each execution ?
Please let me know..
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-stat-all-tables-column-value-reseting-problem-tp3767851p3933652.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
In response to
pgsql-admin by date
|Next:||From: Devrim GÜNDÜZ||Date: 2011-03-18 07:21:44|
|Subject: Re: Memory limits and PostgreSQL 8.4 - Over 63 GB of
memory for DB?|
|Previous:||From: agfk||Date: 2011-03-17 17:03:18|
|Subject: Re: Postgres Crash|