Ed L. wrote:
Can someone help me understand why the 8.1.2 query below is using a seq scan instead of an index scan?
Because the planner thinks a sequential scan would be faster than an index scan - in many situations, this is the case. See the FAQ:
http://www.postgresql.org/docs/faqs.FAQ.html#item4.6 - John Burger MITRE ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
