Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EF3439F9977 for ; Fri, 21 Sep 2007 08:36:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 44270-08 for ; Fri, 21 Sep 2007 08:36:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outmail128171.authsmtp.com (outmail128171.authsmtp.com [62.13.128.171]) by postgresql.org (Postfix) with ESMTP id AEE4A9F970F for ; Fri, 21 Sep 2007 08:36:01 -0300 (ADT) Received: from outmail128185.authsmtp.co.uk (outmail128185.authsmtp.co.uk [62.13.128.185]) by punt2.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l8LBZwlN038776; Fri, 21 Sep 2007 12:35:59 +0100 (BST) Received: from [192.168.0.3] (85-211-21-1.dyn.gotadsl.co.uk [85.211.21.1]) (authenticated bits=0) by mail.authsmtp.com (8.13.8/8.13.8/Kp) with ESMTP id l8LBZvOm075710; Fri, 21 Sep 2007 12:35:57 +0100 (BST) Subject: Re: Searching for the cause of a bad plan From: Simon Riggs To: Csaba Nagy Cc: postgres performance list In-Reply-To: <1190374166.4661.194.camel@PCD12478> References: <1190369024.4661.173.camel@PCD12478> <1190372365.4202.14.camel@ebony.site> <1190374166.4661.194.camel@PCD12478> Content-Type: text/plain Date: Fri, 21 Sep 2007 12:34:38 +0100 Message-Id: <1190374478.4202.20.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-Server-Quench: d23d4315-6836-11dc-b86a-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagRbflxB HGQLW1NEUV97WmZ/ bg0fZQBDYEtPQQdr TklWQFdNFEs0CWBz bFhhDxl1cgJHeDB4 Yk8sCnJYCEB5dENg REZXE3AHZDMzdTIX VhFFdwNVcQtPKhxC bQMuGhFYa3VsBg8C MSgJGgV5BjhWMi9V QwcCZVwVWw4XHjN0 TBkfBjhnGkNNTm05 JhBuMloVGi42 X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:752/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system! X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/359 X-Sequence-Number: 26904 On Fri, 2007-09-21 at 13:29 +0200, Csaba Nagy wrote: > > Can you plans with/without LIMIT and with/without cursor, for both b1 > > and b2? > > The limit is unfortunately absolutely needed part of the query Understood, but not why I asked... -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com