Re: Postgresql Sort cost Poor performance?

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Postgresql Sort cost Poor performance?
Дата
Msg-id 87d0m6uj5u.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Postgresql Sort cost Poor performance?  ("tank.zhang" <6220104@qq.com>)
Ответы Re: Postgresql Sort cost Poor performance?  ("tank.zhang" <6220104@qq.com>)
Re: Postgresql Sort cost Poor performance?  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список pgsql-performance
>>>>> "tank" == tank zhang <6220104@qq.com> writes:

 tank>  smtoc        | character varying(50)       |           |          | 
 tank>          Sort Key: smtoc

What is the output of  SHOW lc_collate;

One of the most common reasons for slow sorting is that you're sorting a
text/varchar field in a locale other than C. The slowdown for using
other locales varies according to the data, the locale, and the
operating system, but 8-20x slowdowns are very common, 50-100x slowdowns
are not unusual, and there have been reports of even worse cases with
unusual script combinations.

-- 
Andrew (irc:RhodiumToad)



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

Предыдущее
От: "tank.zhang"
Дата:
Сообщение: Postgresql Sort cost Poor performance?
Следующее
От: "tank.zhang"
Дата:
Сообщение: Re: Postgresql Sort cost Poor performance?