Re: High cpu usage after many inserts

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jordan Tomkinson <jordan(at)moodle(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: High cpu usage after many inserts
Date: 2009-02-23 07:03:20
Message-ID: dcc563d10902222303l3bf9c368u9b531b2fdd429ea8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-02-23 07:08:37 Re: High cpu usage after many inserts
Previous Message Scott Marlowe 2009-02-23 07:02:02 Re: High cpu usage after many inserts