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 F2510DA22D; Wed, 5 Oct 2005 14:21:08 -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 29680-01; Wed, 5 Oct 2005 17:21:04 +0000 (GMT) Received: from pop-satin.atl.sa.earthlink.net (pop-satin.atl.sa.earthlink.net [207.69.195.63]) by svr1.postgresql.org (Postfix) with ESMTP id 29229DA16E; Wed, 5 Oct 2005 14:21:05 -0300 (ADT) Received: from elwamui-chisos.atl.sa.earthlink.net ([209.86.224.31]) by pop-satin.atl.sa.earthlink.net with esmtp (Exim 3.36 #10) id 1ENCwy-0005W0-00; Wed, 05 Oct 2005 13:21:04 -0400 Message-ID: <25154967.1128532864650.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net> Date: Wed, 5 Oct 2005 13:21:04 -0400 (EDT) From: Ron Peacetree Reply-To: Ron Peacetree To: jd@commandprompt.com, 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.258 required=5 tests=[AWL=-0.116, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200510/109 X-Sequence-Number: 14877 First I wanted to verify that pg's IO rates were inferior to The Competition. Now there's at least an indication that someone else has solved similar problems. Existence proofs make some things easier ;-) Is there any detailed programmer level architectual doc set for pg? I know "the best doc is the code", but the code in isolation is often the Slow Path to understanding with systems as complex as a DBMS IO layer. Ron -----Original Message----- From: "Joshua D. Drake" Sent: Oct 5, 2005 1:18 PM Subject: Re: [HACKERS] [PERFORM] A Better External Sort? The source is freely available for your perusal. Please feel free to point us in specific directions in the code where you may see some benefit. I am positive all of us that can, would put resources into fixing the issue had we a specific direction to attack. Sincerely, Joshua D. Drake