Re: [HACKERS] 6.5 cvs: can't drop table

> Oleg Bartunov <oleg@sai.msu.su> writes:
> > today I did some tests with current 6.5 from cvs and multiple joins.
> > I did unpredictable server crashes, i.e. sometimes query works
> > sometimes crashes.
> 
> I have a theory about why the results are random: the GEQO planner
> deliberately uses random numbers to generate plans, so you don't
> always get the same plan out of it.  Whatever bug you are seeing
> occurs only for a particular plan path.  (I haven't had any luck
> repeating your crash here, so the bug may be platform-specific.)
> 
> It bothers me that the GEQO results are not reliably reproducible
> across platforms; that complicates debugging.  I have been thinking
> about suggesting that we ought to change GEQO to use a fixed random
> seed value by default, with the variable random seed being available
> only as a *non default* option.  Comments anyone?

I would leave the random alone.  There may be some advantages to having
it random.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026