| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | Kevin Grittner <kgrittn(at)ymail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Something Weird Going on with VACUUM ANALYZE |
| Date: | 2013-09-19 13:47:39 |
| Message-ID: | 523B007B.5090604@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-09-19 14:14:42 | Re: reading cvs logs with pgadmin queries |
| Previous Message | Kevin Grittner | 2013-09-19 13:42:15 | Re: Something Weird Going on with VACUUM ANALYZE |