From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Updated 6.5 HISTORY |
Date: | 1999-05-25 00:26:53 |
Message-ID: | 1680.927592013@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> 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.
Oh dear ... can you provide a backtrace from one of the crashes?
> 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 !
It ran through to completion for me, but took hours. (Unfortunately
I only have access to one machine that has 700Mb of free disk space,
and I mustn't shut off the data collection task that is its primary load.
So I'm stuck with taking a long time to try the sqlbench stuff...
it does seem to work, but I can't say much about performance...)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-05-25 00:30:42 | Re: [HACKERS] Problem in S_LOCK? |
Previous Message | Tom Lane | 1999-05-25 00:20:04 | Re: [HACKERS] strange behavior of UPDATE |