Re: clustering by partial indexes

Tom Lane wrote:
> "Keith C. Perry" <netadmin(at)vcsn(dot)com> writes:
> > Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> >> "Keith C. Perry" <netadmin(at)vcsn(dot)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.

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.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073