RE: GEQO status?
Andrew Snow <andrew@modulus.org>
From: "Andrew Snow" <andrew@modulus.org>
To: <pgsql-hackers@postgresql.org>
Date: 2000-12-27T11:59:08Z
Lists: pgsql-hackers
> I would set Seed per default. Even worse than a bad query path > is an unpredictable query path. I see no argument, that a random Seed > would buy us anything. This kindof bugs me -- if you leave it stuck at a preset value, it makes it possible to never delve into parts of solution space that have more optimal solutions than the default seed will ever find. Surely a random seed would make the solution better on average over a large number of queries. On the other hand, if the system as a whole is working well, it should not matter what the seed is. - Andrew