On Thu, 14 May 2009, Ow Mun Heng wrote:
Shouldn't BITMAP indexes come into play?

Does having one index w/ 3 parameters being better than 3 index w/ 3
different parameters be better for BITMAP index seeks?

I'll let someone correct me if I'm wrong, but using a single index that exactly covers your search is always going to be better than munging together results from several indexes, even if the planner decides to turn it into a bitmap index scan (which will be more likely in PG8.4 with effective_concurrency set).

Matthew

--
I don't want the truth. I want something I can tell parliament!
                                             -- Rt. Hon. Jim Hacker MP

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

Reply via email to