Robert Haas escribió: > Something is wrong here. How can setting enable_seqscan to off result > in a plan with a far lower estimated cost than the original plan? If > the planner thought the non-seq-scan plan is cheaper, it would have > picked that one to begin with. GEQO? Anne, what's geqo_threshold set to? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance