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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
