On Fri, Mar 20, 2009 at 4:29 PM, Anne Rosset <aros...@collab.net> wrote: > Alvaro Herrera wrote: >> 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? > Hi Alvaro: > It is turned off > geqo | off | Enables genetic query optimization. > Thanks, > Anne
Can you please send ALL your non-commented postgresql.conf lines? ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance