| From: | Hilmar Lapp <hlapp(at)gmx(dot)net> |
|---|---|
| To: | "Neil Conway" <neilc(at)samurai(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: join over 12 tables takes 3 secs to plan |
| Date: | 2003-01-02 21:08:24 |
| Message-ID: | 54E69E80-1E96-11D7-9244-000393B4BFF6@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc 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
-------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2003-01-02 21:11:34 | Re: join over 12 tables takes 3 secs to plan |
| Previous Message | Hilmar Lapp | 2003-01-02 21:03:54 | Re: join over 12 tables takes 3 secs to plan |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Neil Conway | 2003-01-02 21:11:34 | Re: join over 12 tables takes 3 secs to plan |
| Previous Message | Hilmar Lapp | 2003-01-02 21:03:54 | Re: join over 12 tables takes 3 secs to plan |