Re: Sort performance on large tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Sort performance on large tables
Дата
Msg-id 9449.1131488781@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Sort performance on large tables  (Charlie Savage <cfis@interserv.com>)
Ответы Re: Sort performance on large tables  (Charlie Savage <cfis@interserv.com>)
Список pgsql-performance
Charlie Savage <cfis@interserv.com> writes:
> Thus the time decreased from 8486 seconds to 5279 seconds - which is a
> nice improvement.  However, that still leaves postgresql about 9 times
> slower.

BTW, what data type are you sorting, exactly?  If it's a string type,
what is your LC_COLLATE setting?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Charlie Savage
Дата:
Сообщение: Re: Sort performance on large tables
Следующее
От: Charlie Savage
Дата:
Сообщение: Re: Sort performance on large tables