Re: Sort time

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Sort time
Дата
Msg-id 20021118034829.P48668-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Re: Sort time  (pginfo <pginfo@t1.unisoftbg.com>)
Список pgsql-performance
On Mon, 18 Nov 2002, pginfo wrote:

> I think that we need to work around the non us sorting and compare.
> It is not possible to be so slow (all the functions are executed in memory
> and in java and by oracle and by ms all this is working very fast).

I get similar results from the unix sort command, (8 sec elapsed for C
locale, 25 sec for en_US) on my redhat 8 machine (and I forced the buffer
size high enough to not get any temp files afaict).

I'm not sure what platform Tom was using for his test, but maybe someone
could try this on a non x86/linux machine and see what they get (I don't
have access to one).


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

Предыдущее
От: pginfo
Дата:
Сообщение: Re: Sort time
Следующее
От: Nikk Anderson
Дата:
Сообщение: selects from large tables