Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
От | Justin |
---|---|
Тема | Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 |
Дата | |
Msg-id | 47DEBD7C.2060204@emproshunts.com обсуждение исходный текст |
Ответ на | Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 (Craig James <craig_james@emolecules.com>) |
Список | pgsql-performance |
> > Just out of curiosity: Last time I did research, the word seemed to be > that xfs was better than ext2 or ext3. Is that not true? Why use > ext2/3 at all if xfs is faster for Postgres? > > Criag Ext2 vs XFS on my setup there is difference in the performance between the two file systems but its not OMG let switch. XFS did better then Ext2 only one time, then Ext2 won out by small margin at best was 6%. the other test ran at 3 to 4% better than XFS performance. XFS has journaling so it should be safer. I think i may stick with XFS as it has journaling One thing i think is clear don't use ext3 it just kills performance by factors not small percents here is article i found on XFS http://linux-xfs.sgi.com/projects/xfs/papers/xfs_white/xfs_white_paper.html I hope this is helpful to people. I know the process has taught me new things, and thanks to those that helped me out. Before i throw this sever into production any one else want performance numbers. C:\Program Files\PostgreSQL\8.3\bin>pgbench -c 10 -t 40000 -v -h 192.168.1.9 -U postgres play Password: starting vacuum...end. starting vacuum accounts...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 10 number of transactions per client: 40000 number of transactions actually processed: 400000/400000 tps = 2181.512770 (including connections establishing) tps = 2187.107004 (excluding connections establishing) C:\Program Files\PostgreSQL\8.3\bin>pgbench -c 10 -t 40000 -v -h 192.168.1.9 -U postgres play Password: starting vacuum...end. starting vacuum accounts...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 10 number of transactions per client: 40000 number of transactions actually processed: 400000/400000 tps = 2248.365719 (including connections establishing) tps = 2254.308547 (excluding connections establishing) -----------Clients log increased to 40------------ C:\Program Files\PostgreSQL\8.3\bin>pgbench -c 40 -t 10000 -v -h 192.168.1.9 -U postgres play Password: starting vacuum...end. starting vacuum accounts...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 40 number of transactions per client: 10000 number of transactions actually processed: 400000/400000 tps = 2518.447629 (including connections establishing) tps = 2548.014141 (excluding connections establishing) C:\Program Files\PostgreSQL\8.3\bin>pgbench -c 40 -t 10000 -v -h 192.168.1.9 -U postgres play Password: starting vacuum...end. starting vacuum accounts...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 40 number of transactions per client: 10000 number of transactions actually processed: 400000/400000 tps = 2606.933139 (including connections establishing) tps = 2638.626859 (excluding connections establishing)
В списке pgsql-performance по дате отправления: