On Tue, Dec 28, 2010 at 11:04 PM, Guillaume Lelarge <guillaume@xxxxxxxxxxxx> wrote: > Le 29/12/2010 05:28, Bricklen a Ãcrit : >> On 2010-12-28, at 5:22 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> >>> bricklen <bricklen@xxxxxxxxx> 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. > Great, thanks for the clarifications! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
