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 <[EMAIL PROTECTED]> > To: Tom Lane <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED], pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: [HACKERS] Index creation takes for ever > > Tom Lane wrote: > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
