Re: [GENERAL] B-tree index with sorting question

2010-12-29 Thread bricklen
On Tue, Dec 28, 2010 at 11:04 PM, Guillaume Lelarge wrote: > Le 29/12/2010 05:28, Bricklen a écrit : >> On 2010-12-28, at 5:22 PM, Tom Lane wrote: >> >>> bricklen writes: In the docs at http://www.postgresql.org/docs/9.0/static/sql-createindex.html, I see that you can build index

Re: [GENERAL] B-tree index with sorting question

2010-12-28 Thread Guillaume Lelarge
Le 29/12/2010 05:28, Bricklen a écrit : > On 2010-12-28, at 5:22 PM, Tom Lane wrote: > >> bricklen 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

Re: [GENERAL] B-tree index with sorting question

2010-12-28 Thread Bricklen
On 2010-12-28, at 5:22 PM, Tom Lane wrote: > bricklen 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 i

Re: [GENERAL] B-tree index with sorting question

2010-12-28 Thread Tom Lane
bricklen 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 comm