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

From Tom Lane
Subject Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Date
Msg-id 3679.1382632126@sss.pgh.pa.us
Whole thread Raw
In response to Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index  (Rémi Cura <remi.cura@gmail.com>)
Responses Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
List pgsql-general
=?UTF-8?Q?R=C3=A9mi_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: maillists0@gmail.com
Date:
Subject: Re: Replication and fsync
Next
From: Rémi Cura
Date:
Subject: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index