Re: bitmap heap scanning - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: bitmap heap scanning
Date
Msg-id dcc563d10803241916lcf3b446gfab42584df3b5525@mail.gmail.com
Whole thread Raw
In response to bitmap heap scanning  ("petchimuthu lingam" <spmlingam@gmail.com>)
List pgsql-admin
On Mon, Mar 24, 2008 at 4:13 AM, petchimuthu lingam <spmlingam@gmail.com> wrote:
> How to enable bitmap heap scanning, my query is not using the scanning, i am
> using postgresql 8.1 version.
> i have enabled the option in the postgresql.conf, but still it is not using.

It's likely enabled, but the query planner thinks that another method
of doing things.  What does explain analyze select ... say about your
query plan?

pgsql-admin by date:

Previous
From: "Tena Sakai"
Date:
Subject: Re: it refuses to go down...
Next
From: "sathiya psql"
Date:
Subject: postgresql is slow with larger table even it is in RAM