Re: GIN fast insert

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: GIN fast insert
Дата
Msg-id 49931D32.5090101@sigaev.ru
обсуждение исходный текст
Ответ на Re: GIN fast insert  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: GIN fast insert
Список pgsql-hackers
Robert Haas wrote:
>> I believe that user could get GIN's error about work_mem only intentionally:
>> - turn off autovacuum
> Meanwhile, in the other thread, we're having a discussion about people
> wanting to do exactly this on a database-wide basis during peak load
> hours...
>> - decrease work_mem for at least ten times
>> - execute query
> Why would the new work_mem need to be 10x smaller than the old work mem?

That is is way to get GIN's error emitted. Work_mem should be decreased 
to catch a chance to get lossy tidbitmap.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: A deprecation policy
Следующее
От: Gianni Ciolli
Дата:
Сообщение: Re: HotStandby vs. flatfile updates