Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 51DB0632581 for ; Fri, 3 Apr 2009 14:33:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 74516-01 for ; Fri, 3 Apr 2009 14:33:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by mail.postgresql.org (Postfix) with ESMTP id 13C7F6322C7 for ; Fri, 3 Apr 2009 14:33:36 -0300 (ADT) Received: from perhan.alvh.no-ip.org (200-126-99-132.bk7-dsl.surnet.cl [200.126.99.132]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id n33HeR0g030578 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 3 Apr 2009 10:40:30 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 7F8C87F8B; Fri, 3 Apr 2009 13:33:24 -0400 (CLT) Date: Fri, 3 Apr 2009 13:33:24 -0400 From: Alvaro Herrera To: Simon Riggs Cc: Tom Lane , Matthew Wakeling , pgsql-performance@postgresql.org Subject: Re: plpgsql arrays Message-ID: <20090403173324.GG23023@alvh.no-ip.org> References: <603c8f070904030647u1c92e13ew53612ac0011ed7c1@mail.gmail.com> <28595.1238767442@sss.pgh.pa.us> <1238779839.5444.220.camel@ebony.2ndQuadrant> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1238779839.5444.220.camel@ebony.2ndQuadrant> User-Agent: Mutt/1.5.18 (2008-05-17) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Fri, 03 Apr 2009 10:40:30 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.875 tagged_above=0 required=5 tests=AWL=-0.818, RCVD_IN_NJABL_PROXY=1.693 X-Spam-Level: X-Archive-Number: 200904/78 X-Sequence-Number: 33445 Simon Riggs wrote: > > On Fri, 2009-04-03 at 10:04 -0400, Tom Lane wrote: > > I don't actually believe that a standard merge join algorithm will work > > with an intransitive join condition ... > > I think it's a common enough problem that having a non-standard join > algorithm written for that case would be interesting indeed. +42 -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support