Re: Index creation takes for ever - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index creation takes for ever
Date
Msg-id 29413.1062420369@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index creation takes for ever  (ohp@pyrenet.fr)
Responses Re: Index creation takes for ever  (ohp@pyrenet.fr)
Re: Index creation takes for ever  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-hackers
ohp@pyrenet.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is it a memory leak in PostgreSQL 7.4beta?
Next
From: "Mendola Gaetano"
Date:
Subject: Re: Is it a memory leak in PostgreSQL 7.4beta?