Re: Speeding up GIST index creation for tsvectors - Mailing list pgsql-hackers

From Pavel Borisov
Subject Re: Speeding up GIST index creation for tsvectors
Date
Msg-id CALT9ZEFh5SXFYpus9EDDHWqoQwWKow81CzP9fQF+8Zv-6ULn3w@mail.gmail.com
Whole thread Raw
In response to Speeding up GIST index creation for tsvectors  (Amit Khandekar <amitdkhan.pg@gmail.com>)
Responses Re: Speeding up GIST index creation for tsvectors
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: On login trigger: take three
Next
From: Konstantin Knizhnik
Date:
Subject: Re: On login trigger: take three