Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3D6F6B5DC46 for ; Thu, 9 Jun 2011 03:16:38 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 33086-02 for ; Thu, 9 Jun 2011 06:16:30 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail2.symstream.com (2.102.96.58.static.exetel.com.au [58.96.102.2]) by mail.postgresql.org (Postfix) with ESMTP id D7DAFB5DC45 for ; Thu, 9 Jun 2011 03:16:29 -0300 (ADT) Received: from symstream.com (unknown [192.168.0.254]) by mail2.symstream.com (Postfix) with SMTP id 005066ACE0 for ; Thu, 9 Jun 2011 16:16:27 +1000 (EST) Received: (qmail 21909 invoked by uid 453); 9 Jun 2011 06:16:27 -0000 X-Virus-Checked: Checked by ClamAV on symstream.com Received: from Unknown (HELO ajs-desktop.symstream.com) (192.168.0.22) by symstream.com (qpsmtpd/0.40) with ESMTP; Thu, 09 Jun 2011 16:16:27 +1000 From: anthony.shipman@symstream.com To: pgsql-performance@postgresql.org Subject: Re: strange query plan with LIMIT Date: Thu, 9 Jun 2011 16:16:26 +1000 User-Agent: KMail/1.9.4 Cc: tv@fuzzy.cz References: <201106071802.08272.anthony.shipman@symstream.com> <201106091604.42186.anthony.shipman@symstream.com> In-Reply-To: <201106091604.42186.anthony.shipman@symstream.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201106091616.26929.anthony.shipman@symstream.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/91 X-Sequence-Number: 44024 On Thursday 09 June 2011 16:04, anthony.shipman@symstream.com wrote: > I must be doing something really wrong to get this to happen: Yes I did. Ignore that. -- Anthony Shipman | flailover systems: When one goes down it Anthony.Shipman@symstream.com | flails about until the other goes down too.