Re: Inserting 8MB bytea: just 25% of disk perf used?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Inserting 8MB bytea: just 25% of disk perf used?
Дата
Msg-id 4B5577CF020000250002E746@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Inserting 8MB bytea: just 25% of disk perf used?  ("fkater@googlemail.com" <fkater@googlemail.com>)
Список pgsql-performance
"fkater@googlemail.com" <fkater@googlemail.com> wrote:
> Scott Carey:
>
>> You are CPU bound.
>>
>> 30% of 4 cores is greater than 25%.  25% is one core fully
>> used.
>
> I have measured the cores separately. Some of them reached
> 30%. I am not CPU bound here.

If you have numbers like that when running one big query, or a
stream of queries one-at-a-time, you are CPU bound.  A single
request only uses one CPU at a time although it could switch among a
number of them, if the OS doesn't make an effort to keep each
process with the same CPU.

-Kevin

В списке pgsql-performance по дате отправления: