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

From Bruce Momjian
Subject Re: Index creation takes for ever
Date
Msg-id 200309072226.h87MQ0s24301@candle.pha.pa.us
Whole thread Raw
In response to Re: Index creation takes for ever  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-hackers
Manfred Koizar wrote:
> On Sun, 7 Sep 2003 11:43:42 -0400 (EDT), Bruce Momjian
> <pgman@candle.pha.pa.us> wrote:
> >I assume this completes this TODO:
> >
> >    * Order duplicate index entries by tid for faster heap lookups
>
> I don't think so, because the patch does nothing to keep the sort
> order once the index is initially created.

As Tom mentioned, we might not want to keep the tid's in order after the
index is created because he wants the most recent tid's first, so the
expired ones migrate to the end.

Seems this patch does what we want currently because it only affects the
initial index structure.

> > If you want to post it now, [...]
>
> I did already post it.  It's only the last page or so of the original
> message.  The link in that message points to a testing aid which is
> not part of what I would like to see committed.

OK, in 7.5 queue:

    http:/momjian.postgresql.org/cgi-bin/pgpatches2

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-hackers by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: pg_id and pg_encoding
Next
From: Greg Stark
Date:
Subject: Re: [GENERAL] Needed function IF(expr, expr, expr)