Tom,
I continue my research of irregular crashes I experienced with
current 6.5 and bih joins.
Initial data:
1. My Crash postgres scriptmkjoindata.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
crashesvery 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
