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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to