Re: Why won't it index scan?

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