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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"fkater@xxxxxxxxxxxxxx" <fkater@xxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux