Benchmark: Dell/Perc 6, 8 disk RAID 10
От | Craig James |
---|---|
Тема | Benchmark: Dell/Perc 6, 8 disk RAID 10 |
Дата | |
Msg-id | 47D8B3B6.3010606@emolecules.com обсуждение исходный текст |
Ответ на | Re: count * performance issue (Craig James <craig_james@emolecules.com>) |
Ответы |
Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 |
Список | pgsql-performance |
I just received a new server and thought benchmarks would be interesting. I think this looks pretty good, but maybe thereare some suggestions about the configuration file. This is a web app, a mix of read/write, where writes tend to be"insert into ... (select ...)" where the resulting insert is on the order of 100 to 10K rows of two integers. An externalprocess also uses a LOT of CPU power along with each query. Thanks, Craig Configuration: Dell 2950 8 CPU (Intel 2GHz Xeon) 8 GB memory Dell Perc 6i with battery-backed cache RAID 10 of 8x 146GB SAS 10K 2.5" disks Everything (OS, WAL and databases) are on the one RAID array. 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 Bonnie output (slightly reformatted) ------------------------------------------------------------------------------ Delete files in random order...done. Version 1.03 ------Sequential Output------ --Sequential Input- --Random- -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks-- Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP 16G 64205 99 234252 38 112924 26 65275 98 293852 24 940.3 1 ------Sequential Create------ --------Random Create-------- -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete-- files /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP /sec %CP 16 12203 95 +++++ +++ 19469 94 12297 95 +++++ +++ 15578 82 www.xxx.com,16G,64205,99,234252,38,112924,26,65275,98,293852,24,940.3,1,16,12203,95,+++++,+++,19469,94,12297,95,+++++,+++,15578,82 ------------------------------------------------------------------------------ $ pgbench -c 10 -t 10000 -v test -U test starting vacuum...end. starting vacuum accounts...end. transaction type: TPC-B (sort of) scaling factor: 1 number of clients: 10 number of transactions per client: 10000 number of transactions actually processed: 100000/100000 tps = 2786.377933 (including connections establishing) tps = 2787.888209 (excluding connections establishing)
В списке pgsql-performance по дате отправления: