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 по дате отправления:

Предыдущее
От: Kevin Grittner
Дата:
Сообщение: Re: Something Weird Going on with VACUUM ANALYZE
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: reading cvs logs with pgadmin queries