Re: Something Weird Going on with VACUUM ANALYZE - Mailing list pgsql-general

From Shaun Thomas
Subject Re: Something Weird Going on with VACUUM ANALYZE
Date
Msg-id 523B007B.5090604@optionshouse.com
Whole thread Raw
In response to Re: Something Weird Going on with VACUUM ANALYZE  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
On 09/19/2013 08:42 AM, Kevin Grittner wrote:

> The fix accidentally introduced some messages which are confusing,
> and caused the statistics from autovacuum to fail to be generated
> more often than had previously been the case.  These problems should
> be fixed in the next minor release.  Until then, if you have a
> workload which triggers these issues, the workaround is to schedule
> ANALYZE jobs.

Thanks Kevin, that explanation totally makes sense. I can switch to a
separate VACUUM and ANALYZE step to avoid this until the fix comes through.

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

______________________________________________

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


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Something Weird Going on with VACUUM ANALYZE
Next
From: Adrian Klaver
Date:
Subject: Re: reading cvs logs with pgadmin queries