Skip site navigation (1) Skip section navigation (2)

Re: B-tree index with sorting question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: B-tree index with sorting question
Date: 2010-12-29 01:22:46
Message-ID: 13526.1293585766@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
bricklen <bricklen(at)gmail(dot)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

In response to

Responses

pgsql-general by date

Next:From: Bob PawleyDate: 2010-12-29 01:58:51
Subject: Re: Restore problem
Previous:From: Tsutomu NakajimaDate: 2010-12-29 01:11:04
Subject: Re: did freese in creating a database cluster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group