-----Original Message----- From: Matthew Wakeling [mailto:matthew@xxxxxxxxxxx] 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). I don't dis-agree there, but for multiple field indexes, the sequence has to be followed. If queries hit those exact sequence, then we're good to go, if not, then it's wasted and not used to it's full capability. Effective_concurrency you say.. Hmm... gotta goggle that -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
