Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8434E9F9E4B for ; Fri, 31 Aug 2007 12:03:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 83628-06 for ; Fri, 31 Aug 2007 12:03:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 717599F9C85 for ; Fri, 31 Aug 2007 12:03:25 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-220-104-109.bk9-dsl.surnet.cl [201.220.104.109]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l7VF3NDJ019776; Fri, 31 Aug 2007 08:03:24 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id A02C947C5F; Fri, 31 Aug 2007 11:03:21 -0400 (CLT) Date: Fri, 31 Aug 2007 11:03:21 -0400 From: Alvaro Herrera To: Aleksandr Vinokurov Cc: Tom Lane , pgsql-sql@postgresql.org Subject: Re: Incomprehensible dogged sort in Merge Join Message-ID: <20070831150321.GA8046@alvh.no-ip.org> References: <46D82318.3070700@gmail.com> <24061.1188571419@sss.pgh.pa.us> <46D82B86.6060600@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <46D82B86.6060600@gmail.com> User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.91.1/4110/Thu Aug 30 16:49:40 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 31 Aug 2007 08:03:24 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/264 X-Sequence-Number: 29202 Aleksandr Vinokurov escribió: > Tom Lane wrote: >> When criticizing planner deficiencies, it's considered polite to use >> something that's less than two major releases back ;-) > > Sorry, it was blown out from my head at the end of composing: my version is > 8.0.1, not so old, IMHO. It _is_ quite old, yes. Try 8.2 at the very least, but in some cases you're going to get "current CVS HEAD does it better", so if you want to suggest improvements to the planner you should be really looking into that. -- Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC "No reniegues de lo que alguna vez creíste"