Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 142439FA280 for ; Tue, 5 Dec 2006 14:17:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 80096-01 for ; Tue, 5 Dec 2006 14:17:42 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 4923F9F9F49 for ; Tue, 5 Dec 2006 14:17:41 -0400 (AST) Received: from trofast.ipv6.sesse.net ([2001:700:300:1803:20e:cff:fe36:a766] helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1GrerK-0004qq-Gx for pgsql-performance@postgresql.org; Tue, 05 Dec 2006 19:17:38 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1GrerF-0002hh-00 for ; Tue, 05 Dec 2006 19:17:33 +0100 Date: Tue, 5 Dec 2006 19:17:33 +0100 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: Performance of ORDER BY Message-ID: <20061205181733.GA10309@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <4575A863.6040504@varianinc.com> <7090.1165341726@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <7090.1165341726@sss.pgh.pa.us> X-Operating-System: Linux 2.6.19 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/88 X-Sequence-Number: 22144 On Tue, Dec 05, 2006 at 01:02:06PM -0500, Tom Lane wrote: > In 8.0 that might be counterproductively high --- we have seen cases > where more sort_mem = slower with the older sorting code. I concur > with Luke's advice that you should update to 8.2 (not 8.1) to get the > improved sorting code. By the way, is the new sorting code any better for platforms that already have a decent qsort() (like Linux)? /* Steinar */ -- Homepage: http://www.sesse.net/