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

From Joshua D. Drake
Subject Re: 8.3 / 8.2.6 restore comparison
Date
Msg-id 20080225141116.231efb4e@commandprompt.com
Whole thread Raw
In response to Re: 8.3 / 8.2.6 restore comparison  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: 8.3 / 8.2.6 restore comparison  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 25 Feb 2008 14:05:58 -0800
Jeff Davis <pgsql@j-davis.com> wrote:

> > Yep :) but as a note:
> > 
> > I am currently testing on the data set that is giving us all these
> > issues. Previously we were pushing ~ 22G an hour over a single
> > thread. I am currently pushing ~ 28G every 16 minutes over 6
> > threads.
> > 
> > With 30-40% IO wait.
> 
> That begs the question: what about 12 threads?

That is exactly what Alvaro said :P, let me finish this one first.

Joshua D. Drake



- -- 
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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHwz0EATb/zqfZUUQRAo1HAJkB58g/gkCWPTqSqjNzrcxGZ4eiNACgi7Va
gZGMboxrPwV4euv67anSyfo=
=9S0a
-----END PGP SIGNATURE-----

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: 8.3 / 8.2.6 restore comparison
Next
From: "Dave Page"
Date:
Subject: Re: libpq.rc make rule