Richard Ray wrote:
>
> When is enable_seqscan = off appropriate
Never(*)
It's not for normal usage, the various enable_xxx settings do let you
experiment with different options if you think the planner is making a
mistake.
(*) OK, sooner or later, if you have enough systems and enough
performance-critical queries then you might want to use it in
production. But only if you really know what you're doing and you've
exhausted you're other options.
-- Richard Huxton Archonet Ltd