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