Re: [ADMIN] pg_stat_all_tables column value reseting problem.

2011-03-19 Thread leslie samuel
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

Re: [ADMIN] pg_stat_all_tables column value reseting problem.

2011-03-17 Thread leslie samuel
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

[ADMIN] pg_stat_all_tables column value reseting problem.

2011-03-16 Thread leslie samuel
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