Re: clustering by partial indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: clustering by partial indexes
Date
Msg-id 15803.1131551259@sss.pgh.pa.us
Whole thread Raw
In response to Re: clustering by partial indexes  ("Keith C. Perry" <netadmin@vcsn.com>)
Responses Re: clustering by partial indexes
List pgsql-general
"Keith C. Perry" <netadmin@vcsn.com> writes:
> Quoting Tom Lane <tgl@sss.pgh.pa.us>:
>> "Keith C. Perry" <netadmin@vcsn.com> writes:
>>> This might have been discussed before but I wanted to know if clustering
>>> tables by partial indexes will be availble in a later release of pgSQL?
>>
>> What in the world would it mean to do that?

> I'm not sure I understand your question.

CLUSTER says "order the table according to the order of the entries in
this index".  A partial index doesn't define an ordering for the whole
table, only the rows that have entries in that index.  So it doesn't
seem to me that you are asking for something that has a well defined
meaning.

            regards, tom lane

pgsql-general by date:

Previous
From: "Cristian Prieto"
Date:
Subject: Re: [HACKERS] Troubles with array_ref
Next
From: "Evandro's mailing lists (Please, don't send personal messages to this address)"
Date:
Subject: Re: Beyond the 1600 columns limit on windows