Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Дата
Msg-id 3679.1382632126@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index  (Rémi Cura <remi.cura@gmail.com>)
Ответы Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index  (Rémi Cura <remi.cura@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: maillists0@gmail.com
Дата:
Сообщение: Re: Replication and fsync
Следующее
От: Rémi Cura
Дата:
Сообщение: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index