6.5 cvs: weird crashes
От | Oleg Bartunov |
---|---|
Тема | 6.5 cvs: weird crashes |
Дата | |
Msg-id | Pine.GSO.3.96.SK.990526120455.15463H-100000@ra обсуждение исходный текст |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: