Robert Haas <robertmhaas@xxxxxxxxx> writes: > On Fri, Mar 20, 2009 at 1:16 PM, Anne Rosset <arosset@xxxxxxxxxx> wrote: >> The db version is 8.2.4 > 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? Planner bug no doubt ... given how old the PG release is, I'm not particularly interested in probing into it now. If Anne can still reproduce this behavior on 8.2.something-recent, we should look closer. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
