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