X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1BB9A9DCCDF for ; Fri, 16 Dec 2005 01:50:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 18878-06 for ; Fri, 16 Dec 2005 01:50:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 961229DCCEC for ; Fri, 16 Dec 2005 01:50:15 -0400 (AST) Received: (qmail 22807 invoked by uid 500); 16 Dec 2005 05:55:11 -0000 Date: Thu, 15 Dec 2005 23:55:11 -0600 From: Bruno Wolff III To: "Craig A. James" Cc: pgsql-performance@postgresql.org Subject: Re: Overriding the optimizer Message-ID: <20051216055511.GA18354@wolff.to> Mail-Followup-To: Bruno Wolff III , "Craig A. James" , pgsql-performance@postgresql.org References: <7484.1134600423@sss.pgh.pa.us> <1134629567.14248.27.camel@firebolt> <200512150148.16125.blargity@gmail.com> <1134644526.14248.60.camel@firebolt> <43A1C40D.8040006@paradise.net.nz> <43A1F6DB.3080805@modgraph-usa.com> <43A226E7.7040508@paradise.net.nz> <43A22BE3.6020103@modgraph-usa.com> <20051216052025.GB691@filer> <43A25372.8090706@modgraph-usa.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <43A25372.8090706@modgraph-usa.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.012 required=5 tests=[AWL=0.012] X-Spam-Score: 0.012 X-Spam-Level: X-Archive-Number: 200512/390 X-Sequence-Number: 16211 On Thu, Dec 15, 2005 at 21:41:06 -0800, "Craig A. James" wrote: > > If I understand enable_seqscan, it's an all-or-nothing affair. Turning it > off turns it off for the whole database, right? The same is true of all of You can turn it off just for specific queries. However, it will apply to all joins within a query.