Re: Something Weird Going on with VACUUM ANALYZE
| От | Shaun Thomas |
|---|---|
| Тема | Re: Something Weird Going on with VACUUM ANALYZE |
| Дата | |
| Msg-id | 523B007B.5090604@optionshouse.com обсуждение исходный текст |
| Ответ на | Re: Something Weird Going on with VACUUM ANALYZE (Kevin Grittner <kgrittn@ymail.com>) |
| Список | 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 по дате отправления: