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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



Wed, 26 May 1999 12:25:43 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
6.5 cvs: weird crashes 