Re: Lack of use of indexes - Mailing list pgsql-general

From Doug McNaught
Subject Re: Lack of use of indexes
Date
Msg-id m365uph84m.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: Lack of use of indexes  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Don Isgitt <djisgitt@soundenergy.com> writes:

> Sequential scan is obviously not off; how do you turn it off? I tried
> enable_seqscan=off at the psql prompt, but it did not like that. Is
> that a postgresql.conf variable?

I think it's 'set enable_seqscan off' (or try '=off') at the prompt.
You can definitely change it on the floy.

-Doug

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: help in starting up / shutting down postgres as another
Next
From: Neil Conway
Date:
Subject: Re: EXECUTE problems