Re: [HACKERS] Updated 6.5 HISTORY

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 t14
from t0 ,t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14
where t1.a_id = t0.a_t1_id and t2.a_id=t0.a_t2_id and 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 and
t11.a_id=t0.a_t11_id and t12.a_id=t0.a_t12_id and 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83