| From: | "Andrew Snow" <andrew(at)modulus(dot)org> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | RE: GEQO status? |
| Date: | 2000-12-27 11:59:08 |
| Message-ID: | JEEGIJPOJIGGIIHGKOKOOEBCCHAA.andrew@modulus.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mlw | 2000-12-27 13:46:15 | Re: PHP and PostgreSQL |
| Previous Message | Chih-Chang Hsieh | 2000-12-27 11:55:47 | About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING" |