| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2009-03-21 00:45:28 | Re: Proposal of tunable fix for scalability of 8.4 |
| Previous Message | Tom Lane | 2009-03-21 00:37:20 | Re: Need help with one query |