Re: [GENERAL] Reallife szenario for GEQO

2004-01-13 Thread Bernd Helmle
Tom Lane wrote: Bernd Helmle <[EMAIL PROTECTED]> writes: But what means "enough tables"? GEQO_THRESHOLD or more. You can set that anywhere you like (I think the default is 11 or 12, which is about where the standard exhaustive-search planner becomes painfully slow). regards, tom lane Thank

[GENERAL] Reallife szenario for GEQO

2004-01-13 Thread Bernd Helmle
I am currently searching some resources, why and where the PostgreSQL GEQO-Engine improves large join queries. The theoretical background is clear, but i need some real life szenarios, where the GEQO-Engine beats other solutions. Have anyone made such a comparison, or have experiences which sze