bitmap heap scanning

------=_Part_8628_7000133.1206353617723
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

--
With Best Regards,
Petchimuthulingam S

------=_Part_8628_7000133.1206353617723
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

--
With Best Regards,

Petchimuthulingam S

------=_Part_8628_7000133.1206353617723--

Re: bitmap heap scanning

On Mon, Mar 24, 2008 at 4:13 AM, petchimuthu lingam 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?

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin