Re: how to investigate GIN fast updates and cleanup cycles?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: how to investigate GIN fast updates and cleanup cycles?
Дата
Msg-id CAMkU=1yZKoMgxF4+P3MQBEehn8J=29FMb+FAocuhtTwS2BOUFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to investigate GIN fast updates and cleanup cycles?  (Steve Kehlet <steve.kehlet@gmail.com>)
Список pgsql-general
On Fri, Aug 28, 2015 at 11:06 AM, Steve Kehlet <steve.kehlet@gmail.com> wrote:
On Fri, Aug 28, 2015 at 10:42 AM Jeff Janes <jeff.janes@gmail.com> wrote:
 
 
Vacuum is overkill (and can be extremely slow to run a large gin index), you just need to get it to autoanalyze by changing the per-table setting of "autovacuum_vacuum_scale_factor" to zero and instead using

Did you mean autovacuum_analyze_scale_factor or does it not matter?


Yes, sorry.  Those long names make my eyes go bleary.

Cheers,

Jeff

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: how to investigate GIN fast updates and cleanup cycles?
Следующее
От: Dominik Czarnota
Дата:
Сообщение: Re: Does PLPythonU support COPY table FROM string?