Martijn van Oosterhout wrote:
The classic issue is what encoding are the databases. Anything other than C and like won't use indexes.
Unless you use text_pattern_ops. See http://www.postgresql.org/docs/7.4/static/indexes-opclass.html
I think this needs to be in the faq.
---------------------------(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
