* Tom Lane <[EMAIL PROTECTED]> [12.05.2005 23:09]:
> 1. Be sure that all the indexable WHERE conditions are passed to the
> indexscan as indexquals. This might be, say,
> WHERE a = 42 and b = 'foo'
If I have on-disk bitmap
ON (a, b, c)
will the planner pick an index scan for
WHERE a = 42 AND b = 'foo'
(i.e. only part of the index attributes are involved)? Any modifications
needed to achieve this functionality?
To my mind, bitmap scan even for 1 attribute of a multi-column index would be
a win, though I haven't tested this yet.
--
Victor Y. Yegorov
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
