Re: High cpu usage after many inserts

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

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

> Oh yeah, what OS is this? Version and all that.
>

I should probably clarify that the high cpu only exists while the jmeter
tests are running, once the tests are finished the cpu returns to 0% (this
isnt a production server yet, so no other queries other than my tests)
I have not yet tried other SQL queries to see if they are affected, i
suspect it may only be related to the two forum tables the test focuses on
but I may be incorrect - the database is filling up with data again now so I
can test this tomorrow.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message raf 2009-02-23 07:55:26 problems with win32 enterprisedb 8.3.6 ssl=on
Previous Message Jordan Tomkinson 2009-02-23 07:36:55 Re: High cpu usage after many inserts