X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4FFC83A6362 for ; Fri, 28 Jan 2005 16:17:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67212-01 for ; Fri, 28 Jan 2005 16:17:14 +0000 (GMT) Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by svr1.postgresql.org (Postfix) with ESMTP id 15D003A632C for ; Fri, 28 Jan 2005 16:17:12 +0000 (GMT) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id j0SGIEMR028317; Fri, 28 Jan 2005 10:18:14 -0600 Date: Fri, 28 Jan 2005 10:17:24 -0600 From: Frank Wiles To: alex@neteconomist.com Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL clustering VS MySQL clustering Message-Id: <20050128101724.6777241d.frank@wiles.org> In-Reply-To: <33c6269f0501280759d309de3@mail.gmail.com> References: <330532b6050120104246597d2a@mail.gmail.com> <000001c4ff51$c0e985e0$e883f40a@br.gedasgrp> <20050128153138.GB9076@phlogiston.dyndns.org> <33c6269f0501280759d309de3@mail.gmail.com> X-Mailer: Sylpheed version 0.9.10 (GTK+ 1.2.10; i386-redhat-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/579 X-Sequence-Number: 10269 On Fri, 28 Jan 2005 10:59:58 -0500 Alex Turner wrote: > At this point I will interject a couple of benchmark numbers based on > a new system we just configured as food for thought. > > System A (old system): > Compaq Proliant Dual Pentium III 933 with Smart Array 5300, one RAID > 1, one 3 Disk RAID 5 on 10k RPM drives, 2GB PC133 RAM. Original > Price: $6500 > > System B (new system): > Self Built Dual Opteron 242 with 2x3ware 9500S-8MI SATA, one RAID 1 > (OS), one 4 drive RAID 10 (pg_xlog), one 6 drive RAID 10 (data) on 10k > RPM Raptors, 4GB PC3200 RAM. Current price $7200 > > System A for our large insert job: 125 minutes > System B for our large insert job: 10 minutes. > > There is no logical way there should be a 12x performance difference > between these two systems, maybe 2x or even 4x, but not 12x > > Bad controler cards/configuration will seriously ruin your day. 3ware > escalade cards are very well supported on linux, and work excellently. > Compaq smart array cards are not. Bonnie++ benchmarks show a 9MB/sec > write, 29MB/sec read on the RAID 5, but a 172MB/sec write on the > 6xRAID 10, and 66MB/sec write on the RAID 1 on the 3ware. > > With the right configuration you can get very serious throughput. The > new system is processing over 2500 insert transactions per second. We > don't need more RAM with this config. The disks are fast enough. > 2500 transaction/second is pretty damn fast. I agree that badly supported or configured cards can ruin your performance. However, don't you think moving pg_xlog onto a separate RAID and increasing your number of spindles from 3 to 6 on the data RAID would also have a significant impact on performance, no matter what card was used? I'm not sure you can give all the credit to the card on this one. --------------------------------- Frank Wiles http://www.wiles.org ---------------------------------