Re: join over 12 tables takes 3 secs to plan

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