Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> 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.
> I assume it would cluster the part of the table covered by the partial
> index, and the rest of the table would be in any order. It seems like
> reasonable behavior, though this is the first request I can remember.
But what is the point? You might as well cluster by a full index.
This is *not* trivial to implement, btw, so one request with no
justification should not be enough to get it on the TODO list.
regards, tom lane