Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 23B011337B68 for ; Thu, 11 Nov 2010 17:28:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 25998-08 for ; Thu, 11 Nov 2010 21:28:22 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mh5.mail.rice.edu (mh5.mail.rice.edu [128.42.199.32]) by mail.postgresql.org (Postfix) with ESMTP id A79ED1337B4A for ; Thu, 11 Nov 2010 17:28:21 -0400 (AST) Received: from mh5.mail.rice.edu (localhost.localdomain [127.0.0.1]) by mh5.mail.rice.edu (Postfix) with ESMTP id 301BF28F734; Thu, 11 Nov 2010 15:28:21 -0600 (CST) X-Virus-Scanned: by amavis-2.6.4 at mh5.mail.rice.edu, auth channel Received: from mh5.mail.rice.edu ([127.0.0.1]) by mh5.mail.rice.edu (mh5.mail.rice.edu [127.0.0.1]) (amavis, port 10026) with ESMTP id 9qJtnT4aWD40; Thu, 11 Nov 2010 15:28:21 -0600 (CST) X-SMTP-Auth: no X-SMTP-Auth: no Received: from aart.is.rice.edu (aart.is.rice.edu [168.7.56.48]) by mh5.mail.rice.edu (Postfix) with ESMTP id F043E28F709; Thu, 11 Nov 2010 15:28:20 -0600 (CST) Received: by aart.is.rice.edu (Postfix, from userid 18612) id 467232D5A6; Thu, 11 Nov 2010 15:28:20 -0600 (CST) Date: Thu, 11 Nov 2010 15:28:19 -0600 From: Kenneth Marshall To: gnuoytr@rcn.com Cc: pgsql-performance@postgresql.org Subject: Re: anti-join chosen even when slower than old plan Message-ID: <20101111212819.GF14016@aart.is.rice.edu> References: <4CDACBBF020000250003755B@gw.wicourts.gov> <4CDB7BAA.7020506@vmsinfo.com> <4CDBB0A40200002500037571@gw.wicourts.gov> <18450.1289499783@sss.pgh.pa.us> <19088.1289501929@sss.pgh.pa.us> <19796.1289504156@sss.pgh.pa.us> <20101111155625.AQO09772@ms14.lnh.mail.rcn.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20101111155625.AQO09772@ms14.lnh.mail.rcn.net> User-Agent: Mutt/1.5.16 (2007-06-09) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/174 X-Sequence-Number: 41198 On Thu, Nov 11, 2010 at 03:56:25PM -0500, gnuoytr@rcn.com wrote: > On a thread some time ago, on a similar subject, I opined that I missed the ability to assign tables to tablespaces and buffers to tablespaces, thus having the ability to isolate needed tables (perhaps a One True Lookup Table, for example; or a Customer table) to memory without fear of eviction. > > I was sounding beaten about the face and breast. It really is an "Enterprise" way of handling the situation. > > regards, > Robert > ALTER TABLE can be used to change the tablespace of a table and/or index. Cheers, Ken