Re: Speeding up GIST index creation for tsvectors

Поиск
Список
Период
Сортировка
От Pavel Borisov
Тема Re: Speeding up GIST index creation for tsvectors
Дата
Msg-id CALT9ZEFh5SXFYpus9EDDHWqoQwWKow81CzP9fQF+8Zv-6ULn3w@mail.gmail.com
обсуждение исходный текст
Ответ на Speeding up GIST index creation for tsvectors  (Amit Khandekar <amitdkhan.pg@gmail.com>)
Ответы Re: Speeding up GIST index creation for tsvectors  (Amit Khandekar <amitdkhan.pg@gmail.com>)
Список pgsql-hackers
Hi, Amit!
It's really cool to hear about another GiST improvement proposal. I'd like to connect recently committed GiST ordered build discussion here [1] and further improvement proposed [2]

I've tested feature [1] and got 2.5-3 times speed improvement which is much better I believe. There is an ongoing activity [2] to build support for different data types for GiST. Maybe you will consider it interesting to join.

BTW you may have heard about Gin and Rum [3] indexes which suit text search much, much better (and faster) than GiST. The idea to process data in bigger chunks is good. Still optimize index structure, minimizing disc pages access, etc. seems better in many cases.

Thank you for your proposal! 


--
Best regards,
Pavel Borisov

Postgres Professional: http://postgrespro.com

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: On login trigger: take three
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: On login trigger: take three