Re^3 : Solaris Performance - 64 bit puzzle - Mailing list pgsql-general

From Mark kirkwood
Subject Re^3 : Solaris Performance - 64 bit puzzle
Date
Msg-id 1023267010.1278.16.camel@spikey.slithery.org
Whole thread Raw
Responses Re: Re^3 : Solaris Performance - 64 bit puzzle  (Andrew Sullivan <andrew@libertyrms.info>)
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: View vs. Statement Query Plan
Next
From: Curt Sampson
Date:
Subject: Re: View vs. Statement Query Plan