Re: Index creation takes for ever

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Index creation takes for ever
Дата
Msg-id 200309072226.h87MQ0s24301@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Index creation takes for ever  (Manfred Koizar <mkoi-pg@aon.at>)
Список 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 по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: pg_id and pg_encoding
Следующее
От: Greg Stark
Дата:
Сообщение: Re: [GENERAL] Needed function IF(expr, expr, expr)