Re: I got bit by that darn GEQO setting again...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Mascari <mascarm(at)mascari(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: I got bit by that darn GEQO setting again...
Date: 2004-01-17 17:14:31
Message-ID: 16554.1074359671@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Mike Mascari <mascarm(at)mascari(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-01-17 17:20:36 Re: How should I get started?
Previous Message Joshua D. Drake 2004-01-17 17:06:08 Re: How should I get started?