Re: Overriding the optimizer

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Overriding the optimizer
Date: 2005-12-16 05:55:11
Message-ID: 20051216055511.GA18354@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Dec 15, 2005 at 21:41:06 -0800,
"Craig A. James" <cjames(at)modgraph-usa(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Moritz Bayer 2005-12-16 13:15:58 Crashing DB or Server?
Previous Message Kevin Brown 2005-12-16 05:48:55 Re: Overriding the optimizer