Forcing more agressive index scans for BITMAP AND - Mailing list pgsql-performance

From Ow Mun Heng
Subject Forcing more agressive index scans for BITMAP AND
Date
Msg-id 1207280383.28172.26.camel@neuromancer.home.net
Whole thread Raw
Responses Re: Forcing more agressive index scans for BITMAP AND  (Matthew <matthew@flymine.org>)
List pgsql-performance
just wondering if there's a special tweak i can do to force more usage
of indexes to do BITMAP ands?

I have a table like

A int
B int
C int
D int
E int
F int
g int

where A/B/C/D/E are indexes

There's ~20millions rows in the table.

Query are something like this.

select * from table
where A=X
and B = Y
and C = Z
and D = AA
and E = BB

the query plan will only pick 2 indexes to do the bitmap.
I'm not sure how to tweak the config for it to use more indexes.

Box is a celeron 1.7 w/ 768MB ram with shared buffers at 250MB and
effective cache size 350MB



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Query plan excluding index on view
Next
From: Matthew
Date:
Subject: Re: Forcing more agressive index scans for BITMAP AND