Re: Lack of use of indexes

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Don Isgitt <djisgitt(at)soundenergy(dot)com>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Lack of use of indexes
Date: 2002-11-22 16:38:49
Message-ID: m365uph84m.fsf@varsoon.wireboard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Don Isgitt <djisgitt(at)soundenergy(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2002-11-22 16:45:21 Re: EXECUTE problems
Previous Message scott.marlowe 2002-11-22 16:37:30 Re: help in starting up / shutting down postgres as another