pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Pirtea Calin <pcalin@rdsor.ro>
To: pgsql-general@postgresql.org
Subject: Re: Yet another indexing issue.
Date: Fri, 22 Mar 2002 16:37:31 +0200
Message-ID: <a7ffpa$29sh$1@jupiter.hub.org> (raw)
References: <20020319155803.G37657-100000@megazone23.bigpanda.com>

> > Where would one find set enable_seqscan=off; in the docs?
>
> To be honest I'm not sure where it's mentioned.  It's a big tool that
> lets you make some gross changes to the optimizer's planning (sets the
> cost of sequence scan very very high).
>
I found this in Admin.pdf
3.4.1. Planner and Optimizer Tuning
page 37/38
ENABLE_SEQSCAN (boolean)
    Enables or disables the query planner's use of sequential scan plan
types. It's not possible to
suppress sequential scans entirely, but turning this variable off
discourages the planner from using
one if there is any other method available. The default is on. This is
mostly useful to debug the
query planner.

--
Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@rdsor.ro




view thread (6+ messages)  latest in thread

Message-ID: <a7ffpa$29sh$1@jupiter.hub.org>
Permalink:  ../a7ffpa$29sh$1@jupiter.hub.org/
Also on:    postgresql.org/message-id/a7ffpa$29sh$1@jupiter.hub.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: pcalin@rdsor.ro, pgsql-general@postgresql.org
  Subject: Re: Yet another indexing issue.
  In-Reply-To: <a7ffpa$29sh$1@jupiter.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox