Re: [PATCHES] Index creation takes for ever

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCHES] Index creation takes for ever
Дата
Msg-id 15324.1070254626@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [PATCHES] Index creation takes for ever  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [PATCHES] Index creation takes for ever  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> If qsort is to blame, then maybe this patch could help.  It sorts
>> equal key values on item pointer.  And if it doesn't help index
>> creation speed, at least the resulting index has better correlation.

> I will try to apply it within the next 48 hours.

I think this is a *very* dubious idea.  It introduces a low-level
implementation dependency into our sort behavior on the strength of no
more than an unfounded speculation that some platform's broken qsort
might run faster.  Even if the speculation were proven true, I'd be
hesistant to apply it.

            regards, tom lane

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] ISO 8601 "Time Intervals" of the "format with
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] Index creation takes for ever