Re: index skipped in favor of seq scan. - Mailing list pgsql-general

ryan.a.roemmich@mail.sprint.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