On 04/23/2013 07:26 AM, S H wrote:
I am working on some legacy product. In which template1 vacuuming with Analyze is executed through cron job every one hour and some times it is taking lot of time. I want to know if there is any major update/insert in template1 at some time, so i wanted to monitor the number of insertions and deletions done in template1.
What version of Postgres are you using? If it is new enough autovacuum was created to deal with your situation.
-- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
