B-tree index with sorting question

From: bricklen <bricklen(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: B-tree index with sorting question
Date: 2010-12-29 00:58:27
Message-ID: AANLkTi=fciRs8-7c5YWZTxXk5-MQu=LZjrwOiuA5a1Ji@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tsutomu Nakajima 2010-12-29 01:11:04 Re: did freese in creating a database cluster
Previous Message Tom Lane 2010-12-29 00:23:21 Re: Min/Max for partitioned tables