Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0EEAF6506FA for ; Tue, 2 Sep 2008 13:47:57 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 25408-01-9 for ; Tue, 2 Sep 2008 13:47:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128171.authsmtp.com (outmail128171.authsmtp.com [62.13.128.171]) by postgresql.org (Postfix) with ESMTP id 9DC24650701 for ; Tue, 2 Sep 2008 13:09:31 -0300 (ADT) Received: from punt9.authsmtp.com (punt9.authsmtp.com [62.13.128.70]) by punt2.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m82G9T2E072787 for ; Tue, 2 Sep 2008 17:09:29 +0100 (BST) Received: from mail-c189.authsmtp.com (mail-c189.authsmtp.com [62.13.128.71]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m82G9TQg094565; Tue, 2 Sep 2008 17:09:29 +0100 (BST) Received: from [192.168.0.2] (85-211-229-97.dyn.gotadsl.co.uk [85.211.229.97]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m82G9RVq005289; Tue, 2 Sep 2008 17:09:27 +0100 (BST) Subject: Re: WIP Join Removal From: Simon Riggs To: Gregory Stark Cc: Tom Lane , Heikki Linnakangas , List pgsql-patches In-Reply-To: <87k5dusfgc.fsf@oxford.xeocode.com> References: <1220176372.4371.118.camel@ebony.2ndQuadrant> <48BC4127.30706@enterprisedb.com> <1220348487.4371.307.camel@ebony.2ndQuadrant> <14377.1220369736@sss.pgh.pa.us> <87k5dusfgc.fsf@oxford.xeocode.com> Content-Type: text/plain Date: Tue, 02 Sep 2008 17:17:19 +0100 Message-Id: <1220372239.4371.459.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 851c9cfd-7909-11dd-bc7a-001f29070be2 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksachtFaAdbflxB HGQLW1xEUVt7WWp/ aQIfZQBDYEtPQQdo WVZARU1QEQdtHhxP WxYcJRAQEURGeHty bU8sX3NeWwpycEcu Sx0CQXABbGdpdWEe BBRFJVBTIR5Kfh4T aFl/U3NfNGdJBC9q VzASB3gTOjRZYB5Y RwYTJFZ6 X-Authentic-SMTP: 61633235383639.kestrel.dmpriest.net.uk:1186/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-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/23 X-Sequence-Number: 7038 On Tue, 2008-09-02 at 17:03 +0100, Gregory Stark wrote: > Tom Lane writes: > > > Simon Riggs writes: > >> On Mon, 2008-09-01 at 22:23 +0300, Heikki Linnakangas wrote: > >>> Did plan invalidation make it safe to rely on the presence of a unique > >>> index for planning decisions? > > > >> My understanding was "Yes" and this case was the specific reason I > >> originally wanted to pursue plan invalidation back in 2006. > > It may be worth considering what other cases... On other patches, yes. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support