Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 34661632541 for ; Mon, 29 Mar 2010 16:41:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 40681-09 for ; Mon, 29 Mar 2010 19:41:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148095.authsmtp.com (outmail148095.authsmtp.com [62.13.148.95]) by mail.postgresql.org (Postfix) with ESMTP id 891D762DBD2 for ; Mon, 29 Mar 2010 16:41:08 -0300 (ADT) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt8.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2TJf6Wc014762; Mon, 29 Mar 2010 20:41:06 +0100 (BST) Received: from [192.168.0.2] (88-110-156-192.dynamic.dsl.as9105.com [88.110.156.192]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id o2TJf2uK058803; Mon, 29 Mar 2010 20:41:02 +0100 (BST) Subject: Re: enable_joinremoval From: Simon Riggs To: Alex Hunsaker Cc: Tom Lane , Robert Haas , pgsql-hackers@postgresql.org In-Reply-To: <34d269d41003291231w539d07f2i3ea0357c9030e03@mail.gmail.com> References: <1269851630.3684.3636.camel@ebony> <603c8f071003290637q14d431f7j90afabd6fd2ec952@mail.gmail.com> <12679.1269873374@sss.pgh.pa.us> <603c8f071003290820h3553d223le3b5228f789608f9@mail.gmail.com> <13795.1269876446@sss.pgh.pa.us> <603c8f071003290832u23130f2x84ffa459e312269c@mail.gmail.com> <14201.1269877615@sss.pgh.pa.us> <1269886675.3684.4064.camel@ebony> <34d269d41003291231w539d07f2i3ea0357c9030e03@mail.gmail.com> Content-Type: text/plain Date: Mon, 29 Mar 2010 20:41:01 +0100 Message-Id: <1269891661.3684.4246.camel@ebony> Mime-Version: 1.0 X-Mailer: Evolution 2.26.1 Content-Transfer-Encoding: 7bit X-Server-Quench: 0222b785-3b6b-11df-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdxZQATClZOTQEd DAteCiN5VAwpPBRK HVkIKg5MJUcNSQVJ NksachtFagxbYFhD HGQLWlREUl17XWJ/ awgfZQ1DY0tOQQRv VlZIS1BNEQ1vHhxP WRx6KE9wMn5GfXZ4 ZUUsW3dbWAp6d0R/ EElcEHAFN2EydWEe BBZFfwMGeR5Kfh1H bFR/BnsFYjBJBC9q VzwTFhsSEA9kHWxY RAgHKV8lQ0EKGCQx QhccFDFH X-Authentic-SMTP: 61633235383639.1015:706/Kp X-AuthFastPath: 255 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=-2.409 tagged_above=-10 required=5 tests=AWL=0.190, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/1175 X-Sequence-Number: 159951 On Mon, 2010-03-29 at 13:31 -0600, Alex Hunsaker wrote: > On Mon, Mar 29, 2010 at 12:17, Simon Riggs wrote: > > You're not addressing the original point. I have been asked how would > > users know which tables have been removed and whether there is a way of > > checking that. > > Uhh... they wont be in the explain output... Seems simple enough. That is exactly what I replied, though nobody felt that was a great answer. -- Simon Riggs www.2ndQuadrant.com