Re^3 : Solaris Performance - 64 bit puzzle

From: Mark kirkwood <markir(at)slingshot(dot)co(dot)nz>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re^3 : Solaris Performance - 64 bit puzzle
Date: 2002-06-05 08:50:09
Message-ID: 1023267010.1278.16.camel@spikey.slithery.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Curt Sampson 2002-06-05 09:35:10 Re: View vs. Statement Query Plan
Previous Message Martijn van Oosterhout 2002-06-05 08:47:16 Re: View vs. Statement Query Plan