Re: Covering GiST indexes - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: Covering GiST indexes
Date
Msg-id 469e47f3-80fe-a0a7-3d2b-9471cf1424ab@sigaev.ru
Whole thread Raw
In response to Covering GiST indexes  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Covering GiST indexes  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
Re: Covering GiST indexes  (Andrey Borodin <x4mmm@yandex-team.ru>)
List pgsql-hackers
Interesting work. I don't have a time now to learn deep your patch, so, add it 
to next commitfest, pls. First of all I'd like to see more tests in patch, not 
only CREATE INDEX.


Andrey Borodin wrote:
> Hi, hackers!
> 
> Looks like we finally have covering indexes! And that's cool!
> 
> So I decided to create a thread to discuss covering GiST indexes.
> Here's a prototype patch implementing this functionality.
> It is quite small (+80 -30) and lacks tests and docs. But it creates a context.
> 
> I have two concerns.
> First one is about INDEX_AM_RESERVED_BIT.
> B-tree uses it as a base for prefix truncation (I'm not quite sure why it is usually called suffix truncation, but
thisis a matter for other thread).
 
> GiST , probably, will not use [pre\su]fix truncation. But I'd like to use that 13th bit to implement intra-page
indexing- a way to improve search within gist page. See [0,1]
 
> 
> Second, currently including indexes do not allow same attributes in both keys and include parts.
> # create index on x using gist(c) include (c);
> ERROR:  included columns must not intersect with key columns
> 
> But it makes sense for example for geometries like PostGIS. Index keys are truncated to small MBRs while having whole
complexgeometry right in an index could be handy.
 
> 
> Any feedback will be appreciated.
> 
> Best regards, Andrey Borodin.
> 
> 
> [0] https://www.postgresql.org/message-id/7780A07B-4D04-41E2-B228-166B41D07EEE%40yandex-team.ru
> [1] https://www.postgresql.org/message-id/CAJEAwVE0rrr+OBT-P0gDCtXbVDkBBG_WcXwCBK=GHo4fewu3Yg@mail.gmail.com
>   
> 

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


pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: psql leaks memory on query cancellation
Next
From: Aleksander Alekseev
Date:
Subject: Re: Covering GiST indexes