Re: Overriding the optimizer - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: Overriding the optimizer
Date
Msg-id 20051216055511.GA18354@wolff.to
Whole thread Raw
In response to Re: Overriding the optimizer  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
On Thu, Dec 15, 2005 at 21:41:06 -0800,
  "Craig A. James" <cjames@modgraph-usa.com> 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.

pgsql-performance by date:

Previous
From: Kevin Brown
Date:
Subject: Re: Overriding the optimizer
Next
From: Simon Riggs
Date:
Subject: Re: How much expensive are row level statistics?