| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Manfred Koizar <mkoi-pg(at)aon(dot)at>, 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-12-01 04:57:06 |
| Message-ID: | 15324.1070254626@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-01 05:02:54 | Re: [HACKERS] Index creation takes for ever |
| Previous Message | Bruce Momjian | 2003-12-01 04:53:22 | Re: ISO 8601 'Time Intervals' of the 'format with time-unit |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-01 04:57:22 | Re: introduce "default_use_oids" |
| Previous Message | Bruce Momjian | 2003-12-01 04:55:30 | Re: WIP: unique hash indexes |