[check_postgres] Changes to last_autovacuum check
Josh Berkus
josh at agliodbs.com
Thu Jan 27 01:15:46 UTC 2011
On 1/22/11 3:51 PM, Josh Berkus wrote:
> All,
>
> I was looking at last_autovacuum (and last_autoanalyze) and trying to
> improve it; the current check seems to cause a lot of false positives by
> reporting tables which haven't been updated in quite some time. Here's
> my first stab at a query for "table has not been autovacuumed"; rather
> than depending on time, it checks for tables whose ratio of dead rows is
> more than 2X what autovacuum is supposed to tolerate:
... so, any feedback on this?
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
More information about the Check_postgres
mailing list