Skip site navigation (1) Skip section navigation (2)

Re: Index creation takes for ever

From: ohp(at)pyrenet(dot)fr
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index creation takes for ever
Date: 2003-08-30 15:55:22
Message-ID: Pine.UW2.4.53.0308301753490.23215@server.pyrenet.fr (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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)

In response to

pgsql-hackers by date

Next:From: Dan LangilleDate: 2003-08-30 16:00:46
Subject: Re: [HACKERS] What goes into the security doc?
Previous:From: Bruce MomjianDate: 2003-08-30 15:54:33
Subject: Re: Bumping block size to 16K on FreeBSD...

pgsql-patches by date

Next:From: Guillaume LELARGEDate: 2003-08-30 16:43:07
Subject: Re: NLS: French .po files updated
Previous:From: Bruce MomjianDate: 2003-08-30 15:11:11
Subject: Re: Index creation takes for ever

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group