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 12:46:09
Message-ID: 29413.1062420369@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:
> it took 69 minutes to finish, 75% of this time was devoted to create 2
> indexes on varchar(2) with value being 'O', 'N' or null;
> I wonder if it's a configuration matter.

I still say it's either strcoll or qsort's fault. Try swapping in our
own version of qsort to see if the behavior changes.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mendola Gaetano 2003-09-01 14:19:58 Re: Is it a memory leak in PostgreSQL 7.4beta?
Previous Message Tom Lane 2003-09-01 12:43:35 Re: Is it a memory leak in PostgreSQL 7.4beta?

Browse pgsql-patches by date

  From Date Subject
Next Message ohp 2003-09-01 19:59:11 Re: Index creation takes for ever
Previous Message ohp 2003-09-01 11:57:11 Re: Index creation takes for ever