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-09-01 20:03:17
Message-ID: 4466.1062446597@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:
> I've made some tests with your qsort and it DEFINITIVLY help
> ~3 mn instead of 69.

> However this is for 7.3.4 I've got no probs with 7.4b.
> Did something change in btree creation?

Hmm, I wouldn't have thought so, but perhaps we did change something
that would affect this. You might need to burrow down as far as seeing
exactly what qsort calls are being made in each version ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2003-09-01 20:05:57 Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)
Previous Message Tom Lane 2003-09-01 20:01:16 Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)

Browse pgsql-patches by date

  From Date Subject
Next Message Böjthe Zoltán 2003-09-02 13:05:50 Re: timetravel.c
Previous Message ohp 2003-09-01 19:59:11 Re: Index creation takes for ever