Re: GIN - Generalized Inverted iNdex. Try 3. - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: GIN - Generalized Inverted iNdex. Try 3.
Date
Msg-id 20060428142804.GC15566@svana.org
Whole thread Raw
In response to Re: GIN - Generalized Inverted iNdex. Try 3.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Apr 28, 2006 at 10:14:09AM -0400, Tom Lane wrote:
> Here I think it would be best to add an indclusterable column to pg_am.
> Actually, does clustering on *any* current index type except btree make
> sense?  None of them have semantically interesting index ordering
> AFAIR, so maybe we should just reject CLUSTER on all of 'em not only GIN.

It seems to me that amorderstrategy already handles this? It's
documented as:
 zero if the index offers no sort order, otherwise the strategy number of the strategy operator that describes the sort
order

ergo, if this is non-zero, CLUSTER uses that to sort, otherwise CLUSTER
is forbidden.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: GIN - Generalized Inverted iNdex. Try 3.
Next
From: Teodor Sigaev
Date:
Subject: Re: GIN - Generalized Inverted iNdex. Try 3.