check_postgres icon indicating copy to clipboard operation
check_postgres copied to clipboard

get rid of "No matching tables have ever been vacuumed" UNKNOWN result

Open petere opened this issue 9 years ago • 1 comments

I think it's reasonable to have some kind of general check that all tables have been vacuumed or analyzed within X days. But if a database has zero tables, then the last_vacuum/last_analyze checks return UNKNOWN. This is annoying, because it breaks the ability to have this check applied uniformly without having to figure out what exactly is in the database. Having no tables in a database is not an error, and there are other checks that can be applied if one wishes to check what tables are in a database.

petere avatar Jul 29 '15 18:07 petere

please see also: https://mail.endcrypt.com/pipermail/check_postgres/2009-April/000329.html

maletin avatar Sep 07 '15 08:09 maletin