Search Postgresql Archives

Re: Something Weird Going on with VACUUM ANALYZE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx

______________________________________________

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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux