Re: GIN fast insert
От | Robert Haas |
---|---|
Тема | Re: GIN fast insert |
Дата | |
Msg-id | 603c8f070902110705w259bcf59u2724aefa8d6c7ce7@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: GIN fast insert (Teodor Sigaev <teodor@sigaev.ru>) |
Ответы |
Re: GIN fast insert
|
Список | pgsql-hackers |
> 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... > - set big work_mem > - populate table with GIN index (by needed number of insertion) > - prepare query which will return a lot of results (possibly, with > seqscan=off because cost of scan of pending list grows fast) > - 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? ...Robert
В списке pgsql-hackers по дате отправления: