Re: 8.3 / 8.2.6 restore comparison - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.3 / 8.2.6 restore comparison
Date
Msg-id 20603.1202436284@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
"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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: Re: 8.3 / 8.2.6 restore comparison
Next
From: "Joshua D. Drake"
Date:
Subject: Re: 8.3 / 8.2.6 restore comparison