Re: clustering by partial indexes

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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