pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
bitmap heap scanning
2+ messages / 2 participants
[nested] [flat]

* bitmap heap scanning
@ 2008-03-24 10:13  petchimuthu lingam <spmlingam@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: petchimuthu lingam @ 2008-03-24 10:13 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: bitmap heap scanning
@ 2008-03-25 02:16  Scott Marlowe <scott.marlowe@gmail.com>
  parent: petchimuthu lingam <spmlingam@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2008-03-25 02:16 UTC (permalink / raw)
  To: petchimuthu lingam <spmlingam@gmail.com>; +Cc: 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?



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-03-25 02:16 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-24 10:13 bitmap heap scanning petchimuthu lingam <spmlingam@gmail.com>
2008-03-25 02:16 ` Scott Marlowe <scott.marlowe@gmail.com>

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