Re: [HACKERS] Index creation takes for ever

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
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 17:16:24
Message-ID: iepmlvko7kj5a61e23gf2t23kj6rc7b0n5@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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.

> 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.

Servus
Manfred

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gaetano Mendola 2003-09-07 17:30:52 Re: pg_id and pg_encoding
Previous Message Mendola Gaetano 2003-09-07 16:54:23 mcxt.c

Browse pgsql-patches by date

  From Date Subject
Next Message Manfred Koizar 2003-09-07 17:35:55 Re: [HACKERS] Index creation takes for ever
Previous Message Mendola Gaetano 2003-09-07 16:54:23 mcxt.c