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

Re: B-tree index with sorting question

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Bricklen <bricklen(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: B-tree index with sorting question
Date: 2010-12-29 07:04:06
Message-ID: 4D1ADD66.2000809@lelarge.info (view raw or flat)
Thread:
Lists: pgsql-general
Le 29/12/2010 05:28, Bricklen a écrit :
> On 2010-12-28, at 5:22 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 
>> 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
> 
> And that holds true for all subsequents inserts too?

Yes, but still only the index entries.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

In response to

Responses

pgsql-general by date

Next:From: Jasen BettsDate: 2010-12-29 08:57:49
Subject: Re: DATA Location
Previous:From: Dmitriy IgrishinDate: 2010-12-29 06:58:53
Subject: Re: Concatenating several rows with a semicolon

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