Re: High cpu usage after many inserts - Mailing list pgsql-general

From Scott Marlowe
Subject Re: High cpu usage after many inserts
Date
Msg-id dcc563d10902222303l3bf9c368u9b531b2fdd429ea8@mail.gmail.com
Whole thread Raw
In response to High cpu usage after many inserts  (Jordan Tomkinson <jordan@moodle.com>)
Responses Re: High cpu usage after many inserts
List pgsql-general
On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson <jordan@moodle.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?

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: High cpu usage after many inserts
Next
From: Scott Marlowe
Date:
Subject: Re: High cpu usage after many inserts