Re: High cpu usage after many inserts

On Mon, Feb 23, 2009 at 4:03 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson <jordan(at)moodle(dot)com>
> wrote:
> > Hi list,
> >
> > We are running postgresql 8.3.5 and are trying to stress test our LMS.
> > The problem is when our stress tester (Jmeter) inserts around 10,000 rows
> > (in 3 hours) over 2 tables (5000 rows each table) the CPU of the sql
> server
> > hits 100% over all 4 cores for all future inserts.
>
> And just to clarify, this is user / system CPU usage, not IO wait, right?
>

I am unable to post the jmeter file as it contains sensitive user/pass
details, but they simply login to a forum and create a new forum post, then
logout.
SQL wise this performs several SELECT's and 3 INSERT'S over 3 different
tables.

How does one create an SQL test case?
LMS is Learning Management System, in this case Moodle (moodle.org)

Yes this is user space CPU usage.

Running iostat -k 2 shows:
Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn
sda 31.50 0.00 456.00 0 912

so not alot of disk writes.