Re: [HACKERS] Index creation takes for ever
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] Index creation takes for ever |
Дата | |
Msg-id | 200312010502.hB152s918672@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] Index creation takes for ever (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: [HACKERS] Index creation takes for ever
|
Список | pgsql-patches |
Tom Lane wrote: > 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. Roger --- patch removed. Thanks. -- 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-patches по дате отправления: