[check_postgres] Changes to last_autovacuum check

[Josh Berkus]

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