Re: Index creation takes for ever

Thanks to evryone that help on this one.
I reinitdb --locale=C and reloaded everything today.
That did the trick.
However, is there a way to test that strcol is really the culprit?
On Sat, 30 Aug 2003, Bruce Momjian wrote:

> Date: Sat, 30 Aug 2003 11:11:11 -0400 (EDT)
> 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: [HACKERS] Index creation takes for ever
>
> 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.
>
>

--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
6, Chemin d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)