| From: | "Andrew Snow" <als(at)fl(dot)net(dot)au> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: GEQO status? |
| Date: | 2000-12-27 13:49:44 |
| Message-ID: | JEEGIJPOJIGGIIHGKOKOAEBFCHAA.als@fl.net.au |
| 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 | Matthew | 2000-12-27 13:54:59 | RE: [HACKERS] PHP and PostgreSQL |
| Previous Message | mlw | 2000-12-27 13:46:15 | Re: PHP and PostgreSQL |