Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id DA411B5DEF2 for ; Wed, 8 Jun 2011 06:36:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 22087-02-2 for ; Wed, 8 Jun 2011 09:36:36 +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 60F11B5DEC0 for ; Wed, 8 Jun 2011 06:36:34 -0300 (ADT) Received: from symstream.com (unknown [192.168.0.254]) by mail2.symstream.com (Postfix) with SMTP id F42066AD08 for ; Wed, 8 Jun 2011 19:36:32 +1000 (EST) Received: (qmail 13854 invoked by uid 453); 8 Jun 2011 09:36:32 -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; Wed, 08 Jun 2011 19:36:32 +1000 From: anthony.shipman@symstream.com To: pgsql-performance@postgresql.org Subject: Re: strange query plan with LIMIT Date: Wed, 8 Jun 2011 19:36:31 +1000 User-Agent: KMail/1.9.4 Cc: Pavel Stehule , Claudio Freire References: <201106071802.08272.anthony.shipman@symstream.com> <201106081834.07263.anthony.shipman@symstream.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201106081936.32003.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/60 X-Sequence-Number: 43993 On Wednesday 08 June 2011 18:39, Pavel Stehule wrote: > if you use FOR statement, there should be a problem in using a > implicit cursor - try to set a GUC cursor_tuple_fraction to 1.0. Alas this is mammoth replicator, equivalent to PG 8.3 and it doesn't have that parameter. -- Anthony Shipman | It's caches all the way Anthony.Shipman@symstream.com | down.