Re: 8.3 / 8.2.6 restore comparison

On Thu, 07 Feb 2008 21:04:44 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Joshua D. Drake" <jd(at)commandprompt(dot)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