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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

  From Date Subject
Next Message Vivek Khera 2003-08-28 14:38:54 Re: Hardware recommendations to scale to silly load
Previous Message Shridhar Daithankar 2003-08-28 14:23:13 Re: Hardware recommendations to scale to silly load

Browse pgsql-patches by date

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