Re: Index creation takes for ever - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index creation takes for ever
Date
Msg-id 12266.1062950256@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index creation takes for ever  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [PATCHES] Index creation takes for ever
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I assume this completes this TODO:
>     * Order duplicate index entries by tid for faster heap lookups

I don't know why that TODO entry exists, but I think the idea is
counterproductive.  The existing btree code will tend to put newer
versions of a row earlier (because it puts a new entry in front of any
with duplicate keys), which usually reduces the time spent skipping dead
rows.  Forcing tid ordering will cost us more in dead-row skipping than
it's likely to save elsewhere.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_id and pg_encoding
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Index creation takes for ever