Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index - Mailing list pgsql-general

From Rémi Cura
Subject Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Date
Msg-id CAJvUf_skFs8ZCm+3eFLXJ+D5YCFXbELVg8Es2CQV9JXQR=qmXA@mail.gmail.com
Whole thread Raw
In response to Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
List pgsql-general
Ok,
thank you Tom for this precise answer !

I don't understand how the CLUSTER .. USING index command work then.
It is supposed to rewrite on disk following index order. Does it do nothing for GIST index?

Cheers,
Rémi-C


2013/10/24 Tom Lane <tgl@sss.pgh.pa.us>
Rémi Cura <remi.cura@gmail.com> writes:
> I'm interested in the tree structure inherent to the gist indexing.
> I was thinking to retrieve it from order of index.

How?  A SQL query would have no idea where the index page boundaries were
in the sequence of retrieved tuples.

> Do you know how I could access it directly?

I don't think there's any way to do that without modifying the GiST code.
What you really care about here is the contents of the upper index levels,
which is something that's not exposed at all outside the index AM.

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Next
From: Tom Lane
Date:
Subject: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index