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 20080225122822.3fe6e355@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  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Mon, 25 Feb 2008 12:17:10 -0800
Jeff Davis <pgsql@j-davis.com> wrote:


> > I would personally rather keep it simple, hard core, and data
> > shoving as possible without any issue with scheduling etc..
> > 
> 
> Just a thought. After it's actually implemented it won't be hard to
> see if it's a win.

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.

Sincerely,

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)

iD8DBQFHwyToATb/zqfZUUQRAsDzAJ0cZEujQIW1SQ9Wd1nd1jWRVWy09ACgpryh
SJENqCnmwKoSMF5fSHBRtsg=
=hVeo
-----END PGP SIGNATURE-----

pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Strange behavior with leap dates and centuries BC
Next
From: "Dave Page"
Date:
Subject: Re: libpq.rc make rule