Re: I got bit by that darn GEQO setting again... - Mailing list pgsql-general

From Tom Lane
Subject Re: I got bit by that darn GEQO setting again...
Date
Msg-id 16554.1074359671@sss.pgh.pa.us
Whole thread Raw
In response to Re: I got bit by that darn GEQO setting again...  (Mike Mascari <mascarm@mascari.com>)
Responses Re: I got bit by that darn GEQO setting again...  (Mike Mascari <mascarm@mascari.com>)
List pgsql-general
Mike Mascari <mascarm@mascari.com> writes:
> Tom Lane wrote:
>> Uh ... dare I ask whether you think it's too high?  Or too low?
>>
> Too low. In fact, after testing some of my queries which are a bit large
> (# of tables) in size, I usually just wind up turning it off.

Well, that's why it's configurable ;-).  But don't you find that it
takes a long time to plan the larger queries?  How many tables are
involved, exactly?

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: How should I get started?
Next
From: Tom Lane
Date:
Subject: Re: How should I get started?