Re: Query that took a lot of time in Postgresql when not using trim in order by

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query that took a lot of time in Postgresql when not using trim in order by
Дата
Msg-id 6979.1448819916@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Query that took a lot of time in Postgresql when not using trim in order by  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Список pgsql-performance
Дерево обсуждения 
"Peter J. Holzer" <hjp-pgsql@hjp.at> writes:
> Seems plausible. Also I'm wondering what CPU this is: 36 seconds for an
> in-memory sort of 900k rows seems slow to me.

I'm wondering if it's textual data in some locale whose strcoll() behavior
is exceptionally slow.

            regards, tom lane

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

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Query that took a lot of time in Postgresql when not using trim in order by
Следующее
От: Glyn Astill
Дата:
Сообщение: Re: Index scan cost calculation