Re: [PATCHES] GIN improvements

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: [PATCHES] GIN improvements
Дата
Msg-id 493541F5.2020401@enterprisedb.com
обсуждение исходный текст
Ответ на Re: [PATCHES] GIN improvements  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: [PATCHES] GIN improvements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Teodor Sigaev wrote:
> - Falling back to regular insert will take long time for update of whole 
> table - and that was one of reasons of that patch. Users forget to drop 
> GIN index before a global update and query runs forever.

If *that* is a use case we're interested in, the incoming tuples could 
be accumulated in backend-private memory, and inserted into the index at 
commit. That would be a lot simpler, with no need to worry about 
concurrent inserts or vacuums.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [BUG] lo_open() makes a warning/falls to an assertion
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [BUG] lo_open() makes a warning/falls to an assertion