6.5 cvs: weird crashes

Tom,

I continue my research of irregular crashes I experienced with
current 6.5 and bih joins.
Initial data:
1. My Crash postgres script
mkjoindata.pl --joins 14 --rows 20 | psql test
2. Linux 2.0.36, 64Mb Ram, 200Mhz, egcs 1.12 release

Results:
1. No crashes if I compiled with -O0 -g options !
2. No crashes at home - it's the same computer/compiler but
different kernel - 2.2.9.
3. No crashes under FreeBSD -3.1 elf
4. It crashes much less if I separate creating table/indices and doing select !
a) mkjoindata.pl --joins 14 --rows 20 | psql test
sometimes crashes
b) save just select query into tt.sql and run many times psql test < tt.sql
crashes very rare

Could you explain so strange behaivour 4) ?
I was able to run big join with 40, 60 tables in reasonable time.

I could provide a backtrace but it's the same as I posted several times.

Regards,

Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83