Re: Insert Performance with WAL and Fsync

> > b.3) output of vmstat 5 during b.1:
>
> > procs memory page disk
> faults cpu
> > r b w swap free re mf pi po fr de sr s0 s1 s6 -- in
> sy cs us sy
> > id
> > 0 0 0 2140760 1820952 2 15 1 1 1 0 0 2 0 0 0 430
> 130 71 1 1
> > 99
> > 0 0 0 2093696 1690392 15 128 0 91 91 0 0 128 0 0 0 1232
> 1886 894 11 3
> > 86
>
> What are the "disk" numbers in this variant of vmstat? Given the low
> CPU usage, one would hope that your disk is going flat out ... but if
> 128 is page transfers per second, it's not very impressive...

here's iostat:
Its 184.8 io/s (8kpages) = 1.1mb/s - 92% busy. Not too impressive. I'm
following up too see if something is misconfigured.

device r/s w/s kr/s kw/s wait actv svc_t %w %b tin tout us
sy wt id
sd0 0.0 184.6 0.0 1145.3 0.0 1.7 9.0 0 92 0 116 13
3 20 64

Thanks again,

Mike