From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | hackers(at)postgreSQL(dot)org |
Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us |
Subject: | 6.5 cvs: weird crashes |
Date: | 1999-05-26 08:25:43 |
Message-ID: | Pine.GSO.3.96.SK.990526120455.15463H-100000@ra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 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
From | Date | Subject | |
---|---|---|---|
Next Message | ZEUGSWETTER Andreas IZ5 | 1999-05-26 10:02:48 | AW: [HACKERS] Call for updates! |
Previous Message | ZEUGSWETTER Andreas IZ5 | 1999-05-26 07:58:44 | AW: AW: [HACKERS] create index updates nrows statistics |