On Thu, 07 Feb 2008 21:04:44 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Joshua D. Drake" <jd@commandprompt.com> writes:
> > Following up with this... 22G in one hour, with xlogs on a different
> > partition. Just looking at we are averaging 3-5% IOWait, further we
> > are only writing ~ 2Megs a second.
>
> It might be interesting to capture some strace output and get a sense
> of what's actually being read and written. It seems to me that the
> bad I/O rate has to indicate that we're seeking all over the place.
> We should try to determine exactly what's being touched in what order.
Do you want counts or actual output?
Joshua D. Drake
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Have you searched our
> list archives?
>
> http://archives.postgresql.org
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit