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.
In response to
pgsql-performance by date
|Next:||From: Frank Joerdens||Date: 2009-03-20 19:47:29|
|Subject: Re: Full statement logging problematic on larger machines?|
|Previous:||From: Robert Haas||Date: 2009-03-20 19:04:57|
|Subject: Re: Need help with one query|