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?