1.
Today I tried my test script (many tables joining) and got a crash.
It works several days before. CPU usage shows only 5% loading during this test.
what postgres is doing ? Hmm, just rerun the test and it works :-)
OK, one more again and it crashed. Again - works. Again - crashed, crashed,
crashed. Very unstable situation.
I attached perl script to generate date set and sql commands
mkjoindata.pl | psql test
2.
Does anybody tried sqlbench, posted by
Edmund ? I tried several times on Linux box, FreeBSD box with current cvs
and it never finished. RAM usage during the test was about 11-13 Mb
and CPU usage was extremly low - 5-9% only !
Regards,
Oleg
select t0.a,t1.a as t1,t2.a as t2,t3.a as t3,t4.a as t4,t5.a as t5,t6.a as t6,t7
.a as t7,t8.a as t8,t9.a as t9,t10.a as t10,t11.a as t11,t12.a as t12,t13.a as t
13,t14.a as t14from t0 ,t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14where t1.a_id = t0.a_t1_id and
t2.a_id=t0.a_t2_idand t3.a_id=t0.a_t3_id and t4
.a_id=t0.a_t4_id and t5.a_id=t0.a_t5_id and t6.a_id=t0.a_t6_id and t7.a_id=t0.a_
t7_id and t8.a_id=t0.a_t8_id and t9.a_id=t0.a_t9_id and t10.a_id=t0.a_t10_id andt11.a_id=t0.a_t11_id and
t12.a_id=t0.a_t12_idand t13.a_id=t0.a_t13_id and t14.
a_id=t0.a_t14_id ;
pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is impossible. Terminating.
_____________________________________________________________
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
