X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 30081D9D71; Sat, 1 Oct 2005 13:39:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91732-10; Sat, 1 Oct 2005 16:39:01 +0000 (GMT) Received: from pop-knobcone.atl.sa.earthlink.net (pop-knobcone.atl.sa.earthlink.net [207.69.195.64]) by svr1.postgresql.org (Postfix) with ESMTP id 8E8C1D9D70; Sat, 1 Oct 2005 13:39:00 -0300 (ADT) Received: from elwamui-polski.atl.sa.earthlink.net ([209.86.224.45]) by pop-knobcone.atl.sa.earthlink.net with esmtp (Exim 3.36 #10) id 1ELkNz-0003CS-00; Sat, 01 Oct 2005 12:38:55 -0400 Message-ID: <31843561.1128184735397.JavaMail.root@elwamui-polski.atl.sa.earthlink.net> Date: Sat, 1 Oct 2005 12:38:55 -0400 (EDT) From: Ron Peacetree Reply-To: Ron Peacetree To: Andrew Dunstan , pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [HACKERS] A Better External Sort? Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Earthlink Zoo Mail 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.257 required=5 tests=[AWL=-0.117, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200510/8 X-Sequence-Number: 14776 As I posted earlier, I'm looking for code to base a prototype on now. I'll test it outside pg to make sure it is bug free and performs as promised before I hand it off to the core pg developers. Someone else is going to have to merge it into the pg code base since I don't know the code intimately enough to make changes this deep in the core functionality, nor is there enough time for me to do so if we are going to be timely enough get this into 8.2 (and no, I can't devote 24x7 to doing pg development unless someone is going to replace my current ways of paying my bills so that I can.) Ron -----Original Message----- From: Andrew Dunstan Sent: Oct 1, 2005 11:19 AM To: Ron Peacetree Subject: Re: [HACKERS] [PERFORM] A Better External Sort? Ron Peacetree wrote: >The good news is all this means it's easy to demonstrate that we can >improve the performance of our sorting functionality. > >Assuming we get the abyssmal physical IO performance fixed... >(because until we do, _nothing_ is going to help us as much) > > > I for one would be paying more attention if such a demonstration were forthcoming, in the form of a viable patch and some benchmark results. cheers andrew