Re: COPY v. java performance comparison

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Rob Sargent <robjsargent(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: COPY v. java performance comparison
Date: 2014-04-03 17:57:16
Message-ID: 533DA0FC.50105@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2014-04-03 18:14:56 Re: [ANNOUNCE] == PostgreSQL Weekly News - April 01 2014 ==
Previous Message David Johnston 2014-04-03 17:28:35 Re: window function help