Re: High cpu usage after many inserts

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: High cpu usage after many inserts
Дата
Msg-id dcc563d10902222303l3bf9c368u9b531b2fdd429ea8@mail.gmail.com
обсуждение исходный текст
Ответ на High cpu usage after many inserts  (Jordan Tomkinson <jordan@moodle.com>)
Ответы Re: High cpu usage after many inserts  (Jordan Tomkinson <jordan@moodle.com>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: High cpu usage after many inserts
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: High cpu usage after many inserts