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

From Neil Conway
Subject Re: join over 12 tables takes 3 secs to plan
Date
Msg-id 1455.24.112.166.30.1041541894.squirrel@mailbox.samurai.com
Whole thread Raw
In response to Re: join over 12 tables takes 3 secs to plan  (Hilmar Lapp <hlapp@gmx.net>)
List pgsql-performance
Hilmar Lapp said:
> 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?

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/runtime-config.html
lists the available options.

I'd think that GEQO_EFFORT, GEQO_GENERATIONS, and GEQO_POOL_SIZE would be
the parameters that would effect performance the most.

Cheers,

Neil



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