Re: Index creation takes for ever

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: ohp(at)pyrenet(dot)fr, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index creation takes for ever
Date: 2003-08-30 15:11:11
Message-ID: 200308301511.h7UFBBH04513@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane wrote:
> ohp(at)pyrenet(dot)fr writes:
> > This is on unixware 7 (both 7.3.4 and 7.4b)
>
> > I'm on the FR language (I'll re-initdb whith lang=C to see what happens)
>
> Okay. If you find it's still slow in C locale, the next thing to try
> would be forcing use of our own qsort, as we already do for Solaris.
> You'd need to tweak this bit in configure.in:
>
> # Solaris has a very slow qsort in certain cases, so we replace it.
> case $host_os in solaris*)
> AC_LIBOBJ(qsort) ;;
> esac
>
> I'm not sure why it's done that way though. 'Twould be better to let
> the per-platform template files determine it.

The macro has to be in the configure.in file, but we could flag whether
the macro should be used in the template file. I have avoided adding a
variable just for one platform because it just adds an extra level of
abstraction for little benefit.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-08-30 15:14:04 Re: Selecting random rows efficiently
Previous Message Tom Lane 2003-08-30 15:03:40 Re: SetVariable

Browse pgsql-patches by date

  From Date Subject
Next Message ohp 2003-08-30 15:55:22 Re: Index creation takes for ever
Previous Message Database Administrator 2003-08-29 20:59:46 7.4beta2 initdb Fix