Re: 8.3 / 8.2.6 restore comparison

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: 8.3 / 8.2.6 restore comparison
Дата
Msg-id 20080225122822.3fe6e355@commandprompt.com
обсуждение исходный текст
Ответ на Re: 8.3 / 8.2.6 restore comparison  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: 8.3 / 8.2.6 restore comparison
Список 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 по дате отправления:

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: Strange behavior with leap dates and centuries BC
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: libpq.rc make rule