autovacuum benchmarking ...

From: AmitKumar Jain <amitjain(at)synechron(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: autovacuum benchmarking ...
Date: 2008-12-03 22:34:52
Message-ID: 4937098C.4060605@synechron.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team

1. Can we know the how much time will take ongoing vacuum process in DB?
2. Any benchmarking tool for vacuum process.
3. Can we know what exact operations has been done by Vacuum process.
4. I studied that only VACUUM process doesnot lock the table but due to
it insertion in table gets very slow. when i killed vacuum daemon
insertion get faster is it bug in 8.3.3

I know I should not ask all these questions in one go but i need
urgently its answer as vacuum process is just screwing my production
database. I would thankful for any suggestion on above question...

Thanks in advance.
Regards
Amit

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message news 2008-12-04 00:10:45 Problem solving e decision making
Previous Message Vladimir Rusinov 2008-12-03 20:03:47 slow slow query log