Re: join over 12 tables takes 3 secs to plan

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: join over 12 tables takes 3 secs to plan
Дата
Msg-id 1455.24.112.166.30.1041541894.squirrel@mailbox.samurai.com
обсуждение исходный текст
Ответ на Re: join over 12 tables takes 3 secs to plan  (Hilmar Lapp <hlapp@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Hilmar Lapp
Дата:
Сообщение: Re: join over 12 tables takes 3 secs to plan
Следующее
От: "Neil Conway"
Дата:
Сообщение: Re: join over 12 tables takes 3 secs to plan