Skip site navigation (1) Skip section navigation (2)

Re: bitmap heap scanning

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "petchimuthu lingam" <spmlingam(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: bitmap heap scanning
Date: 2008-03-25 02:16:37
Message-ID: dcc563d10803241916lcf3b446gfab42584df3b5525@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Mar 24, 2008 at 4:13 AM, petchimuthu lingam <spmlingam(at)gmail(dot)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?

In response to

pgsql-admin by date

Next:From: sathiya psqlDate: 2008-03-25 08:36:25
Subject: postgresql is slow with larger table even it is in RAM
Previous:From: Bruce MomjianDate: 2008-03-25 02:11:31
Subject: Re: postgresql in FreeBSD jails: proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group