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: (view raw, whole thread or download thread mbox)
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,
>>> 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.


In response to


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-2017 The PostgreSQL Global Development Group