[check_postgres] todo items : analyze, vacuum

Greg Sabino Mullane greg at endpoint.com
Thu Jul 9 20:08:03 UTC 2009


> * Check every table has been vacuum|analyze at least once. (no NULL)
> 
> * Check at least one table has been vacuumed|analyzed since X hours/days/...
> 
> 
> We can perfectly do that with a new function for the two latest items.
> But I sugest to rewrite the main function to  handle more case *and* to filter 
> in the query, not by parsing the results. The behavior will change a bit as we 
> can not output a specific message when exclusion rules took effect.
> 
> Some preference ?

I would lean towards adding switches to the existing functions, and
noting in the docs that certain switches may affect the output - which
is a valid behavior.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090709/143f6db3/attachment.bin 


More information about the Check_postgres mailing list