Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using of GeQo

Using of GeQo

From
"Froggy / Froggy Corp."
Date:
Hello (again),

    I read some documentation about tuning postgresql.conf but i didn't
find information clearly about how to use GeQo. It seems to help planner
but using a lot of CPU, and is usefull only for big join.
    Per default, geqo = true, but in which case, geqo is usefull and in
which case, i will lost a lot of CPU ?
    If someone have some documentation or help about that.

Thanks in advande,
regards,

Re: Using of GeQo

From
Bruce Momjian
Date:
Froggy / Froggy Corp. wrote:
> Hello (again),
>
>     I read some documentation about tuning postgresql.conf but i didn't
> find information clearly about how to use GeQo. It seems to help planner
> but using a lot of CPU, and is usefull only for big join.
>     Per default, geqo = true, but in which case, geqo is usefull and in
> which case, i will lost a lot of CPU ?
>     If someone have some documentation or help about that.

Have you read the GEQO section in the docs?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073