B-tree index with sorting question

Поиск
Список
Период
Сортировка
От bricklen
Тема B-tree index with sorting question
Дата
Msg-id AANLkTi=fciRs8-7c5YWZTxXk5-MQu=LZjrwOiuA5a1Ji@mail.gmail.com
обсуждение исходный текст
Ответы Re: B-tree index with sorting question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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? If so, what happens to subsequent inserts/updates of
the indexed attribute? Are those values then indexed in the order that
they are inserted -- which could be contrary to the ordering specified
in the index creation?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Min/Max for partitioned tables
Следующее
От: Tsutomu Nakajima
Дата:
Сообщение: Re: did freese in creating a database cluster