[EMAIL PROTECTED] (Josh Berkus) writes: >> > Lots of people have talked about it but I don't know anyone coding it. > > I would love to have bitmap indexes in Postgres, as would a lot of other > community members. However, they are far from trivial to code. Are you > offering to help?
I'm curious as to whether partial indexes might suffice as an alternative. There are doubtless cases where the optimizer won't use them where it would be plausible to do so; that suggests, to me, possibilities for enhancing the optimizer. -- let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];; http://www.ntlug.org/~cbbrowne/linuxxian.html A VAX is virtually a computer, but not quite. ---------------------------(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