Re: COPY v. java performance comparison

On 4/3/2014 12:15 PM, Rob Sargent wrote:
> Is the java app cpu bound?
>>
>  > Also watch "vmstat 3" for a minute or two.  The last two numbers (wa
>  > & id) (some vmstat's have a steal, ignore that) will tell you if you
>  > are io bound.
>  >
>  > -Andy
>  >
>  >
> During COPY, with autovaccume off (server restarted, manual vacuum to
> get things going).  Immediately hit the "too frequently" gripe.
> checkpoint_segments still at 12.
>
> Not cpu bound, so waiting for IO, but surely one expects that?
>
> vmstat 3
<snip>



Did you watch top?  Is anything at 100%?

How many cpus are you running?  (well, cpus*cores I guess)

-Andy