Re: Something Weird Going on with VACUUM ANALYZE

On 09/18/2013 02:32 AM, Albe Laurenz wrote:

> What happens if you run VACUUM (VERBOSE, ANALYZE) manually?
> Are the statistics updated?
> Are there any warnings?

It looks like running it manually worked fine, but I only ran it on
specific tables that showed up in the list of un-analyzed.

I see no errors, no warnings, no problems of any kind in the verbose log
I save every day. According to the database, everything is fine.

> No idea about this.
> Is there a lot of load on the system?

According to sar, it's a desert. There's a ton of disk IO caused by the
VACUUM ANALYZE, but that's it. The IO map is... very odd, though. It
looks like the vacuum IO didn't start until 3:20 instead of 3:00,
possibly because some lock was preventing it from starting. That might
explain that delay from the log, but not the fact it vacuumed for 17
minutes and neglected to analyze, instead of 55 minutes while doing both.

Logs show no unexpected or unusual behavior, either. And of course, the
vacuumdb ran fine this morning. If it comes up again, I'll dig further,
but I can't find any reason why our database stopped analyzing itself
for four days.

Thanks for the attempt though. :)

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-676-8870
sthomas(at)optionshouse(dot)com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email