Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"
Дата
Msg-id CA+t6e1=t7b-+E=GSUxQa-SVHmLUf8we0QTR6Gd0=rRkV6xaFSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ERROR: unrecognized parameter "autovacuum_analyze_scale_factor"  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-performance
Дерево обсуждения
'but then I don't have accurate statistics on my toasted table..

On Fri, Feb 15, 2019, 3:39 PM Alvaro Herrera <alvherre@2ndquadrant.com wrote:
On 2019-Feb-14, Mariel Cherkassky wrote:

> I meant the anaylze, if anaylze will run very often on the original table,
> arent there disadvantages for it ?

It'll waste time and resources pointlessly.  Don't do it -- it won't do
any good.


--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

В списке pgsql-performance по дате отправления:

Предыдущее
От: Benedict Holland
Дата:
Сообщение: Re: constraint exclusion with ineq condition (Re: server hardware tuning.)
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: constraint exclusion with ineq condition (Re: server hardwaretuning.)