On Mon, Feb 23, 2009 at 4:03 PM, Scott Marlowe <scott.marl...@gmail.com>wrote:
> On Sun, Feb 22, 2009 at 11:55 PM, Jordan Tomkinson <jor...@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? > 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.
