Re: Index creation takes for ever

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index creation takes for ever
Дата
Msg-id 29413.1062420369@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index creation takes for ever  (ohp@pyrenet.fr)
Ответы Re: Index creation takes for ever  (ohp@pyrenet.fr)
Re: Index creation takes for ever  (Manfred Koizar <mkoi-pg@aon.at>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Is it a memory leak in PostgreSQL 7.4beta?
Следующее
От: "Mendola Gaetano"
Дата:
Сообщение: Re: Is it a memory leak in PostgreSQL 7.4beta?