Re: GIN improvements

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: GIN improvements
Дата
Msg-id 484E67AD.7020500@sigaev.ru
обсуждение исходный текст
Ответ на Re: GIN improvements  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-patches
> Right now this is not a problem because there is no insert_cleanup
> function for btree, but I wonder if we should clean it up.
Look at gistbulkdelete and gistvacuumcleanup, first function wants to send a
bool flag to second one and they use GiSTBulkDelete structure instead of usual
IndexBulkDeleteResult. When it will be needed btree may use the same method.

>
> FWIW there's a typo in catalogs.sgml (finction -> function)
Thank you, will fix.

> What's the use of the FASTUPDATE parameter?  Is there a case when a user
> is interested in turning it off?

Yeah - when time of search is much-much more important (or crucial)  than
insertion time. Or table stores read-only values.

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

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

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: Re: GIN improvements
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Tentative patch for making DROP put dependency info in DETAIL