On Thu, 07 Feb 2008 21:04:44 -0500 Tom Lane <[EMAIL PROTECTED]> wrote:
> "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. 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
signature.asc
Description: PGP signature