Re: Insert Performance with WAL and Fsync - Mailing list pgsql-general

From Mike Schroepfer
Subject Re: Insert Performance with WAL and Fsync
Date
Msg-id 50D1DD22A3646047A6282C10311585123D0715@mail01.raplix.com
Whole thread Raw
In response to Insert Performance with WAL and Fsync  (Mike Schroepfer <mike@raplix.com>)
List pgsql-general
> > 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

pgsql-general by date:

Previous
From: "Jelan"
Date:
Subject: Re: URGENT: pg_dump & Postgres 7.2b4
Next
From: Jean-Michel POURE
Date:
Subject: Home Location Registry (HLR) and VLR databases