[check_postgres] problem with last_analyze and last_vacuum checks

Jeff Frost jeff at frostconsultingllc.com
Fri Jul 10 16:35:50 UTC 2009


Greg Sabino Mullane wrote:
> On 04/08/2009 06:30 PM, Jeff Frost wrote:
>   
>> I'm having an issue with the last_analyze and last_vacuum checks.  It
>> seems if you specify a perflimit, then it complains that no matching
>> tables are found.  If you run the script like so to grab the sql:
>>     
> ...
>   
>> So, the --perflimit 3 is causing a problem.  It seems we should either
>> process the excluded tables in the query or remove the limit and process
>> the limit programmatically.
>>     
>
> Thanks for the report. I just committed a quick fix for this. Please
> git-pull and mail back if it does not work better now.
>
>   
Thanks Greg!  It'll take me a little while to remember where I was
running into the problem so I can test the fix.  More later.

-- 
Jeff Frost, Owner 	<jeff at frostconsultingllc.com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 916-647-6411	FAX: 916-405-4032

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090710/fc7beab0/attachment.html 


More information about the Check_postgres mailing list