Re: join over 12 tables takes 3 secs to plan - Mailing list pgsql-performance

From Hilmar Lapp
Subject Re: join over 12 tables takes 3 secs to plan
Date
Msg-id 54E69E80-1E96-11D7-9244-000393B4BFF6@gmx.net
Whole thread Raw
In response to Re: join over 12 tables takes 3 secs to plan  ("Neil Conway" <neilc@samurai.com>)
Responses Re: join over 12 tables takes 3 secs to plan  ("Neil Conway" <neilc@samurai.com>)
List pgsql-performance
On Thursday, January 2, 2003, at 12:41  PM, Neil Conway wrote:

>
> Finally, there are a bunch of GEQO tuning parameters that you might
> want
> to play with. They should allow you to reduce the planning time a bit,
> in
> exchange for possibly generating an inferior plan.
>
>

Thanks for the tip. I have to admit that I have zero experience with
tuning GAs. If anyone could provide a starter which parameters are best
to start with? Or is it in the docs?

    -hilmar

--
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------


pgsql-performance by date:

Previous
From: Hilmar Lapp
Date:
Subject: Re: join over 12 tables takes 3 secs to plan
Next
From: "Neil Conway"
Date:
Subject: Re: join over 12 tables takes 3 secs to plan