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
