Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 486841337BD9 for ; Wed, 23 Mar 2011 17:29:28 -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 89449-04 for ; Wed, 23 Mar 2011 20:29:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148148.authsmtp.co.uk (outmail148148.authsmtp.co.uk [62.13.148.148]) by mail.postgresql.org (Postfix) with ESMTP id 582D01337B49 for ; Wed, 23 Mar 2011 17:29:20 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt5.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p2NKTJc9007840 for ; Wed, 23 Mar 2011 20:29:19 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p2NKTHJ7006985 for ; Wed, 23 Mar 2011 20:29:18 GMT Message-ID: <4D8A581D.5080704@agliodbs.com> Date: Wed, 23 Mar 2011 13:29:17 -0700 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: postgres performance list Subject: Re: Shouldn't we have a way to avoid "risky" plans? References: <4D8A29F2.9080105@agliodbs.com> In-Reply-To: X-Enigmail-Version: 0.97a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 3aa10592-558c-11e0-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkbIhBDJB8RWB5f NVxfJ1xYPXUEQkpF VCReGBUITgIzDi13 aBUsPEdCYEpPXhVo UEJLS1hTHEtuBQIJ BwAcVhxsdgRHZ3x1 Z0N9Xj4bXjoBET4H RU5UE2QOYClhaWYW HkMJJgJUdQpIYxpA YgNiVXJYYXgPZihp WldrZWpvYW1VeHQO Txc3IABacn4mJBAb fTU3VQ4vGlABSyN8 M1Q5JxYcFVgcekx6 LlIwEU4fexYMDQxS VwtXATRaNhNJXy4i CxgNNQAA X-Authentic-SMTP: 61633136333939.1015:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.6 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201103/292 X-Sequence-Number: 42971 On 3/23/11 10:35 AM, Claudio Freire wrote: > * consider plan bailout: execute a tempting plan, if it takes too > long or its effective cost raises well above the expected cost, bail > to a safer plan That would actually solve this particular case. It would still require us to have some definition of "safer" though. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com