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

Re: Index creation takes for ever

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ohp(at)pyrenet(dot)fr
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Index creation takes for ever
Date: 2003-08-28 14:38:26
Message-ID: 16133.1062081506@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Vivek KheraDate: 2003-08-28 14:38:54
Subject: Re: Hardware recommendations to scale to silly load
Previous:From: Shridhar DaithankarDate: 2003-08-28 14:23:13
Subject: Re: Hardware recommendations to scale to silly load

pgsql-patches by date

Next:From: ohpDate: 2003-08-28 14:53:18
Subject: Re: Index creation takes for ever
Previous:From: ohpDate: 2003-08-28 14:19:06
Subject: Re: Index creation takes for ever

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