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
pgsql-general by date
|Next:||From: Bob Pawley||Date: 2010-12-29 01:58:51|
|Subject: Re: Restore problem|
|Previous:||From: Tsutomu Nakajima||Date: 2010-12-29 01:11:04|
|Subject: Re: did freese in creating a database cluster|