On Fri, Mar 20, 2009 at 4:29 PM, Anne Rosset <arosset@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
