Re: Benchmark: Dell/Perc 6, 8 disk RAID 10

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Дата
Msg-id 20080312225554.52f6275b@commandprompt.com
обсуждение исходный текст
Ответ на Benchmark: Dell/Perc 6, 8 disk RAID 10  (Craig James <craig_james@emolecules.com>)
Ответы Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 12 Mar 2008 21:55:18 -0700
Craig James <craig_james@emolecules.com> wrote:


> Diffs from original configuration:
> 
> max_connections = 1000
> shared_buffers = 400MB
> work_mem = 256MB
> max_fsm_pages = 1000000
> max_fsm_relations = 5000
> wal_buffers = 256kB
> effective_cache_size = 4GB

I didn't see which OS but I assume linux. I didn't see postgresql so I
assume 8.3.

wal_sync_method = open_sync
checkpoint_segments = 30
shared_buffers = 2000MB
asyncrhonous_commit = off (sp?)

Try again.

Thanks this is useful stuff!

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 political pundit | Mocker of Dolphins

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

iD8DBQFH2MHsATb/zqfZUUQRAqqtAJsEa8RkJbpqY2FAYSrNVHhvTK/GBgCfYzYD
9myRDV7AYXq+Iht7rIZVZcc=
=PLpQ
-----END PGP SIGNATURE-----

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Repeated execution of identical subqueries