Re^3 : Solaris Performance - 64 bit puzzle

Поиск
Список
Период
Сортировка
От Mark kirkwood
Тема Re^3 : Solaris Performance - 64 bit puzzle
Дата
Msg-id 1023267010.1278.16.camel@spikey.slithery.org
обсуждение исходный текст
Ответы Re: Re^3 : Solaris Performance - 64 bit puzzle  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-general
>What I'm now puzzled about is why just exercising the right kind of
>sort didn't exhibit the slowdown.

I wonder if the size of your sorted dataset ( i.e. all 1000000 rows) is
the reason - too big to fit into sort_mem, so that temporary files are
needed. The resulting file management *may* have obscured the difference
in sort speed - although that does not explain how your resuts were
consistently *faster* for the Solaris qsort.

regards

Mark


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: View vs. Statement Query Plan
Следующее
От: Curt Sampson
Дата:
Сообщение: Re: View vs. Statement Query Plan