Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 131B863297D for ; Thu, 27 May 2010 23:56:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 86438-06 for ; Fri, 28 May 2010 02:56:17 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 3E7CC632260 for ; Thu, 27 May 2010 23:56:17 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o4S2uCuP016318; Thu, 27 May 2010 22:56:13 -0400 (EDT) To: Scott Marlowe cc: Matthew Wakeling , pgsql-performance@postgresql.org Subject: Re: merge join killing performance In-reply-to: References: <21497.1274287983@sss.pgh.pa.us> <15062.1275009386@sss.pgh.pa.us> Comments: In-reply-to Scott Marlowe message dated "Thu, 27 May 2010 20:46:21 -0600" Date: Thu, 27 May 2010 22:56:12 -0400 Message-ID: <16317.1275015372@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/248 X-Sequence-Number: 38832 Scott Marlowe writes: > On Thu, May 27, 2010 at 7:16 PM, Tom Lane wrote: >> I've committed a patch for this, if you're interested in testing that >> it fixes your situation. > Cool, do we have a snapshot build somewhere or do I need to get all > the extra build bits like flex or yacc or bison or whatnot? There's a nightly snapshot tarball of HEAD on the ftp server. I don't believe there's any snapshots for back branches though. Alternatively, you could grab the latest release tarball for whichever branch you want and just apply that patch --- it should apply cleanly. regards, tom lane