Re: [GENERAL] Using the geqo

2009-07-16 Thread Ms swati chande
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

Re: [GENERAL] Using the GEQO

2009-07-16 Thread Andres Freund
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 th