Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 712599FB36B for ; Fri, 31 Aug 2007 12:09:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 93356-01-9 for ; Fri, 31 Aug 2007 12:08:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.232]) by postgresql.org (Postfix) with ESMTP id A95499FB37A for ; Fri, 31 Aug 2007 12:08:50 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so523312wri for ; Fri, 31 Aug 2007 08:08:49 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=ZD7dnbTaqYiXM4WzQD47R3WJOPahzzwD8FgRqCa2VvRtgdLt/m5mD08Dr38Q3RhqhOOFCXf535ZJZuFek2zsp6bxUy+4ykwMafH88Q0nSjGiweEDgE7WqKlT+0/INQhEn5mA4FYy9+/MXGzymDNQqS82839DjwPnKQJ4AM8r5O4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=rrae/dXyUIUKcWpNnW6RLk7SI+whLlfST/OMmj5NZW+HhcwQzafXI4T/HMq/zTLX+CcxAJZvFwcA0/60x/8FgTlovWp9a7jIq6XxeifgwY8tc2VhFHGFcnXZqI/Rz6I6+GItJKeWgSPttrHeyrktBVhREXfG5L04jO7A+RF4D+Q= Received: by 10.100.8.18 with SMTP id 18mr1662953anh.1188572929174; Fri, 31 Aug 2007 08:08:49 -0700 (PDT) Received: from ?10.0.0.75? ( [213.170.101.138]) by mx.google.com with ESMTPS id p39sm1365000ugd.2007.08.31.08.08.47 (version=SSLv3 cipher=RC4-MD5); Fri, 31 Aug 2007 08:08:48 -0700 (PDT) Message-ID: <46D82EFE.3030402@gmail.com> Date: Fri, 31 Aug 2007 19:08:46 +0400 From: Aleksandr Vinokurov User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Alvaro Herrera CC: Tom Lane , pgsql-sql@postgresql.org Subject: Re: Incomprehensible dogged sort in Merge Join References: <46D82318.3070700@gmail.com> <24061.1188571419@sss.pgh.pa.us> <46D82B86.6060600@gmail.com> <20070831150321.GA8046@alvh.no-ip.org> In-Reply-To: <20070831150321.GA8046@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/265 X-Sequence-Number: 29203 Alvaro Herrera wrote: > 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. > I understood my fault :) Guys, please forgive my dodge. Aleksandr.