On Fri, Mar 20, 2009 at 4:29 PM, Anne Rosset <arosset(at)collab(dot)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.
Can you please send ALL your non-commented postgresql.conf lines?
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2009-03-21 00:45:28|
|Subject: Re: Proposal of tunable fix for scalability of 8.4|
|Previous:||From: Tom Lane||Date: 2009-03-21 00:37:20|
|Subject: Re: Need help with one query |