Re: Using Bitmap scan instead of Seq scan

From: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To: David Johnston <polobo(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using Bitmap scan instead of Seq scan
Date: 2011-02-14 18:06:37
Message-ID: AANLkTi=VdnDyD72gKtvveX1BW0QAmTqOXnzV1a2YhxVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 14, 2011 at 11:57 AM, David Johnston <polobo(at)yahoo(dot)com> wrote:

> You cannot ALWAYS do an indexed scan - sometimes the only option for the
> parser is to do a sequential scan (thus you can say "avoid unless you have
> to" but you can never truly disable sequential scanning).
>

Does this suggest that the config items "disable_seqscan" (and friends)
should be renamed to "avoid_seqscan" ?

--
Jon

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-02-14 18:54:01 Re: Using Bitmap scan instead of Seq scan
Previous Message David Johnston 2011-02-14 17:57:24 Re: Using Bitmap scan instead of Seq scan