Re: clustering by partial indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: clustering by partial indexes
Дата
Msg-id 15803.1131551259@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: clustering by partial indexes  ("Keith C. Perry" <netadmin@vcsn.com>)
Ответы Re: clustering by partial indexes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Cristian Prieto"
Дата:
Сообщение: Re: [HACKERS] Troubles with array_ref
Следующее
От: "Evandro's mailing lists (Please, don't send personal messages to this address)"
Дата:
Сообщение: Re: Beyond the 1600 columns limit on windows