Re: [HACKERS] [BUGS] GEQO Triggers Server Crash

2002-12-10 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Can we free only the plans we want to free in geqo? I don't mind having > a different free method in geqo vs. the rest of the optimizer. GEQO calls "the rest of the optimizer", and the space that we're worried about is almost all allocated in "the rest

Re: [HACKERS] [BUGS] GEQO Triggers Server Crash

2002-12-10 Thread Bruce Momjian
Can we free only the plans we want to free in geqo? I don't mind having a different free method in geqo vs. the rest of the optimizer. --- Tom Lane wrote: > Kris Jurka <[EMAIL PROTECTED]> writes: > > [ GEQO doesn't work any

Re: [BUGS] GEQO Triggers Server Crash

2002-12-06 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > [ GEQO doesn't work anymore in CVS tip ] Ugh. The proximate cause of this is the code I added recently to cache repeated calculations of the best inner indexscan for a given inner relation with potential outer relations. Since geqo_eval() releases all mem

[BUGS] GEQO Triggers Server Crash

2002-12-05 Thread Kris Jurka
The following script crashes 7.4devel. SET geqo_threshold=2; CREATE TABLE t1 (a int primary key); CREATE TABLE t2 (a int); SELECT * FROM t1,t2 WHERE t1.a=t2.a; #0 0x0811001c in best_inner_indexscan (root=, rel=, outer_relids=, jointype=) at indxpath.c:1421 1421if (samese