Postgres Pro
Downloads
Home   >   mailing lists

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 3778.1382632812@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  (Rémi Cura <remi.cura@gmail.com>)
List pgsql-general
Tree view 
=?UTF-8?Q?R=C3=A9mi_Cura?= <remi.cura@gmail.com> writes:
> 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?

Nobody has ever demonstrated that CLUSTER has any value for anything
except btree indexes.  It seems likely to me that it'd actually be
counterproductive for indexes like GiST, which depend on data arriving in
random order for the highest index levels to end up well-distributed.

            regards, tom lane

pgsql-general by date:

Previous
From: Rémi Cura
Date:
Subject: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Next
From: Jeff Janes
Date:
Subject: Re: PostgreSQL Point In Time Recovery