Re: Sort performance on large tables

Поиск
Список
Период
Сортировка
От Charlie Savage
Тема Re: Sort performance on large tables
Дата
Msg-id dkrddq$22bd$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Sort performance on large tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Its an int4.

Charlie

Tom Lane wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sort performance on large tables
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Sort performance on large tables