Re: index skipped in favor of seq scan.

ryan(dot)a(dot)roemmich(at)mail(dot)sprint(dot)com writes:
> Does the planner make the choice based on a percentage?

Essentially (actually, it's a nonlinear cost model, so "percentage" is
too simplistic).

It sounds like the only solution available to you until 7.2 comes out
is to use a sledgehammer:

set enable_seqscan to off;

See the documentation.

regards, tom lane