Re: COPY v. java performance comparison - Mailing list pgsql-general

From Andy Colson
Subject Re: COPY v. java performance comparison
Date
Msg-id 533DA0FC.50105@squeakycode.net
Whole thread Raw
In response to Re: COPY v. java performance comparison  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: COPY v. java performance comparison  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
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



pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: window function help
Next
From: Dev Kumkar
Date:
Subject: Re: [ANNOUNCE] == PostgreSQL Weekly News - April 01 2014 ==