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

From Tom Lane
Subject Re: [PATCHES] Index creation takes for ever
Date
Msg-id 15324.1070254626@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] Index creation takes for ever  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [PATCHES] Index creation takes for ever  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] ISO 8601 "Time Intervals" of the "format with
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Index creation takes for ever