Re: [HACKERS] Index creation takes for ever

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org, ohp(at)pyrenet(dot)fr, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Index creation takes for ever
Date: 2003-09-07 22:26:00
Message-ID: 200309072226.h87MQ0s24301@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Manfred Koizar wrote:
> On Sun, 7 Sep 2003 11:43:42 -0400 (EDT), Bruce Momjian
> <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2003-09-07 23:00:03 Re: [GENERAL] Needed function IF(expr, expr, expr)
Previous Message Oliver Elphick 2003-09-07 21:56:11 Re: pg_id and pg_encoding

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-09-07 22:28:30 Re: WIN32_CONSOLE usage
Previous Message Andreas Pflug 2003-09-07 21:34:45 Re: Unixware 713 probs