Hi,
I have a few queries on the use of the geqo.
1. Since the value of geqo_threshold is12, does the geqo get automatically
activated for queries with 12 or more joins?
2. Can the geqo threshold be set to a smaller value like 4 or 5?
3. How do we come to know whether the geqo has been used to
On Thursday 16 July 2009 09:02:53 Ms swati chande wrote:
1. Since the value of geqo_threshold is12, does the geqo get automatically
activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact
Thanks Andres, 1. Since the value of geqo_threshold is 12, does the geqo get
automatically
activated for queries with 12 or more joins?
No, not directly. It will get used for 12 joins with no predefined order.
This is a bit complicated by the fact that even a predefined order like:
a JOIN b
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