Re: pg_stat_all_tables column value reseting problem.

> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-
> owner(at)postgresql(dot)org] On Behalf Of leslie samuel
> Sent: Friday, March 18, 2011 1:17 AM
> To: pgsql-admin(at)postgresql(dot)org
> 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.