"Joshua D. Drake" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org