Re: GEQO status? - Mailing list pgsql-hackers

From Andrew Snow
Subject Re: GEQO status?
Date
Msg-id JEEGIJPOJIGGIIHGKOKOAEBFCHAA.als@fl.net.au
Whole thread Raw
In response to GEQO status?  (Ed Loehr <eloehr@austin.rr.com>)
List 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




pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: PHP and PostgreSQL
Next
From: Matthew
Date:
Subject: RE: PHP and PostgreSQL