pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedbitmap heap scanning
2+ messages / 2 participants
[nested] [flat]
* bitmap heap scanning
@ 2008-03-24 10:13 petchimuthu lingam <spmlingam@gmail.com>
2008-03-25 02:16 ` Re: bitmap heap scanning Scott Marlowe <scott.marlowe@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-24 10:13 bitmap heap scanning petchimuthu lingam <spmlingam@gmail.com>
@ 2008-03-25 02:16 ` Scott Marlowe <scott.marlowe@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