> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of leslie samuel
> Sent: Saturday, March 19, 2011 8:49 AM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] pg_stat_all_tables column value reseting
For stop/Restart the postmaster, I am using pg_ctlcluster --force command.
I have read about pg_ctlcluster in the net they are saying this below
things,
pg_ctlcluste With the --force option the "fast" mode is used which rolls
back all active transactions, disconnects clients immediately and thus
> -Original Message-
> From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-
> ow...@postgresql.org] On Behalf Of leslie samuel
> Sent: Friday, March 18, 2011 1:17 AM
> To: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] pg_stat_all_tables column value reseting pr
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
On Wed, Mar 16, 2011 at 1:28 PM, leslie samuel wrote:
> Dear friends,
>
>I would like to know the particular table's insert,update and delete
> record history.
> I have done some googling and got to know about pg_stat_all_tables and
> pg_stat_user_tables. These tables having this below field
Dear friends,
I would like to know the particular table's insert,update and delete
record history.
I have done some googling and got to know about pg_stat_all_tables and
pg_stat_user_tables. These tables having this below field , which has the
tables insert,update and delete history,
n_t
