Re: High cpu usage after many inserts
| От | Jordan Tomkinson |
|---|---|
| Тема | Re: High cpu usage after many inserts |
| Дата | |
| Msg-id | 6de2f13b0902230029k12c6290audd4fb74db862f44a@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: High cpu usage after many inserts (Scott Marlowe <scott.marlowe@gmail.com>) |
| Ответы |
Re: High cpu usage after many inserts
|
| Список | pgsql-general |
On Mon, Feb 23, 2009 at 5:20 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
Sorry, I had gotten the impression the CPU usage continued after theOn Mon, Feb 23, 2009 at 12:42 AM, Jordan Tomkinson <jordan@moodle.com> wrote:
>
>
> On Mon, Feb 23, 2009 at 4:29 PM, Scott Marlowe <scott.marlowe@gmail.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.
test. That it's 100% during the test is quite understandable. So
does it start lower than 4x100% Then climb during the tests? Is the
throughput dropping off over time?
As per the spreadsheet (http://spreadsheets.google.com/pub?key=pu_k0R6vNvOVP26TRZdtdYw) CPU usage is around 50% and starts climbing over 3 hours until we have just under 10,000 rows of data then stays at 99% for the duration of all future tests.
Once the rows are removed the tests start back down at 50% usage again.
В списке pgsql-general по дате отправления: