Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50251=pgsql-performance-ar@postgresql.org>)
 id 1V52XR-0003bB-2n
 for pgsql-performance@arkaria.postgresql.org; Thu, 01 Aug 2013 23:44:09 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M50251=pgsql-performance-ar@postgresql.org>)
 id 1V52XQ-0005tR-GU
 for pgsql-performance@arkaria.postgresql.org; Thu, 01 Aug 2013 23:44:08 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tgl@sss.pgh.pa.us>) id 1V52XP-0005tL-MS
 for pgsql-performance@postgresql.org; Thu, 01 Aug 2013 23:44:07 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tgl@sss.pgh.pa.us>) id 1V52XM-0004i3-9q
 for pgsql-performance@postgresql.org; Thu, 01 Aug 2013 23:44:07 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
 by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id r71Ni2l1004523;
 Thu, 1 Aug 2013 19:44:02 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: subselect requires offset 0 for good performance.
In-reply-to: 
 <CAOR=d=2Fq-TzwzRf92BOeeHGqhkPXVG5_zs+_aR690ZxPp3JAg@mail.gmail.com>
References: 
 <CAOR=d=2Fq-TzwzRf92BOeeHGqhkPXVG5_zs+_aR690ZxPp3JAg@mail.gmail.com>
Comments: In-reply-to Scott Marlowe <scott.marlowe@gmail.com>
 message dated "Thu, 01 Aug 2013 13:40:41 -0600"
Date: Thu, 01 Aug 2013 19:44:02 -0400
Message-ID: <4522.1375400642@sss.pgh.pa.us>
X-Pg-Spam-Score: -0.7 (/)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Scott Marlowe <scott.marlowe@gmail.com> writes:
> I am running 8.4.15 and can try 8.4.17 if some patch has been applied
> to it to address this issue. I just want to know should I

> A: upgrade to 8.4.17
> or
> B: create a self contained test case.

A quick look at the release notes shows no planner fixes in 8.4.16 or
8.4.17, so it would be rather surprising if (A) helps.

			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance