Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C5E3C2E029F for ; Sun, 16 Mar 2008 02:20:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 75237-08 for ; Sun, 16 Mar 2008 02:20:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.emproshunts.com (mail.emproshunts.com [66.64.191.19]) by postgresql.org (Postfix) with ESMTP id DE4AB2E0280 for ; Sun, 16 Mar 2008 02:20:46 -0300 (ADT) Received: from [192.168.1.40] by mail.emproshunts.com (GMS 15.00.3626/KX5895.00.ca7cb0e7) with ESMTP id mojahaaa for pgsql-performance@postgresql.org; Sun, 16 Mar 2008 01:20:42 -0400 Message-ID: <47DCBBF9.1090401@emproshunts.com> Date: Sun, 16 Mar 2008 01:19:37 -0500 From: Justin User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Greg Smith CC: pgsql-performance@postgresql.org Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 References: <47D00DB2.7040007@emolecules.com> <18451.1204824562@sss.pgh.pa.us> <47D0AFC1.5070305@emolecules.com> <08115901408538@mail.emproshunts.com> <47D93A43.6020503@emolecules.com> <016301c8854e$851e06e0$3101a8c0@JDell> <47DA1866.3050500@krogh.cc> <47DA37E1.6050104@emproshunts.com> <47DA5852.30004@emproshunts.com> In-Reply-To: <47DA5852.30004@emproshunts.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [192.168.1.40] X-DNSBL: 0 X-AntiSpam: Checked for restricted content by Gordano's AntiSpam Software X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/329 X-Sequence-Number: 29283 I decided to reformat the raid 10 into ext2 to see if there was any real big difference in performance as some people have noted here is the test results please note the WAL files are still on the raid 0 set which is still in ext3 file system format. these test where run with the fsync as before. I made sure every thing was the same as with the first test. As you can see there is a 3 to 3.5 times increase in performance numbers just changing the file system With -S option set there is not change in performance numbers -------First Run 10 clients------ 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 = 2108.036891 (including connections establishing) tps = 2112.902970 (excluding connections establishing) -----Second Run 10 clients ----- 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 = 2316.114949 (including connections establishing) tps = 2321.990410 (excluding connections establishing) -----First Run 40 clients -------- 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 = 2675.585284 (including connections establishing) tps = 2706.707899 (excluding connections establishing) ---Second Run ---- 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 = 2600.560421 (including connections establishing) tps = 2629.952529 (excluding connections establishing) ---- Select Only Option ------ C:\Program Files\PostgreSQL\8.3\bin>pgbench -S -c 10 -t 40000 -v -h 192.168.1.9 -U postgres play Password: starting vacuum...end. starting vacuum accounts...end. transaction type: SELECT only scaling factor: 100 number of clients: 10 number of transactions per client: 40000 number of transactions actually processed: 400000/400000 tps = 18181.818182 (including connections establishing) tps = 18550.294486 (excluding connections establishing) C:\Program Files\PostgreSQL\8.3\bin>pgbench -S -c 40 -t 10000 -v -h 192.168.1.9 -U postgres play Password: starting vacuum...end. starting vacuum accounts...end. transaction type: SELECT only scaling factor: 100 number of clients: 40 number of transactions per client: 10000 number of transactions actually processed: 400000/400000 tps = 18991.548761 (including connections establishing) tps = 20729.684909 (excluding connections establishing)