Re: B-tree index with sorting question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: B-tree index with sorting question
Дата
Msg-id 13526.1293585766@sss.pgh.pa.us
обсуждение исходный текст
Ответ на B-tree index with sorting question  (bricklen <bricklen@gmail.com>)
Ответы Re: B-tree index with sorting question  (Bricklen <bricklen@gmail.com>)
Список pgsql-general
bricklen <bricklen@gmail.com> writes:
> In the docs at http://www.postgresql.org/docs/9.0/static/sql-createindex.html,
> I see that you can build indexes that include ordering.
> Eg. create index t_col_idx on t (col DESC NULLS LAST);

> Does that mean that the initial creation of the index acts like the
> CLUSTER command?

No, it just changes the order that the index keeps its entries in.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tsutomu Nakajima
Дата:
Сообщение: Re: did freese in creating a database cluster
Следующее
От: "Bob Pawley"
Дата:
Сообщение: Re: Restore problem