Skip site navigation (1) Skip section navigation (2)

Re: Need help with one query

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Anne Rosset <arosset(at)collab(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Richard Huxton <dev(at)archonet(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Need help with one query
Date: 2009-03-21 00:37:52
Message-ID: 603c8f070903201737u7543a26w62f265d2352318f5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.
> Thanks,
> Anne

Can you please send ALL your non-commented postgresql.conf lines?

...Robert

In response to

pgsql-performance by date

Next:From: Robert HaasDate: 2009-03-21 00:45:28
Subject: Re: Proposal of tunable fix for scalability of 8.4
Previous:From: Tom LaneDate: 2009-03-21 00:37:20
Subject: Re: Need help with one query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group