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 A6FF63A504F for ; Tue, 11 Jan 2005 10:24:38 +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 60183-10 for ; Tue, 11 Jan 2005 10:24:25 +0000 (GMT) Received: from svarog.thaico.si (p0f.net [193.77.154.190]) by svr1.postgresql.org (Postfix) with ESMTP id 9849A3A575E for ; Tue, 11 Jan 2005 10:24:26 +0000 (GMT) Received: from lunik.p0f.net ([192.168.50.128]) by svarog.thaico.si with esmtp (Exim 3.32 #1 (Debian)) id 1CoJCK-0001UM-00 for ; Tue, 11 Jan 2005 11:24:24 +0100 Received: from lunik.p0f.net (localhost [127.0.0.1]) by lunik.p0f.net (8.12.10/8.12.10) with ESMTP id j0BATLSw004140 for ; Tue, 11 Jan 2005 11:29:21 +0100 Received: (from gregab@localhost) by lunik.p0f.net (8.12.10/8.12.10/Submit) id j0BATLAN004139 for pgsql-performance@postgresql.org; Tue, 11 Jan 2005 11:29:21 +0100 Date: Tue, 11 Jan 2005 11:29:20 +0100 From: Grega Bremec To: pgsql-performance@postgresql.org Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL? Message-ID: <20050111102920.GA1165@lunik.p0f.net> References: <59b2d39b05011018421680264b@mail.gmail.com> <41E3569A.4030102@commandprompt.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="3V7upXqbjpZ4EhLz" Content-Disposition: inline In-Reply-To: <41E3569A.4030102@commandprompt.com> User-Agent: Mutt/1.4.1i Organization: p0f X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.232 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_IN_NJABL_DUL X-Spam-Level: * X-Archive-Number: 200501/128 X-Sequence-Number: 9818 --3V7upXqbjpZ4EhLz Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable =2E..and on Mon, Jan 10, 2005 at 08:31:22PM -0800, Joshua D. Drake used the= keyboard: >=20 > > > >RAID controllers tend to use i960 or StrongARM CPUs that run at speeds > >that _aren't_ all that impressive. With software RAID, you can take > >advantage of the _enormous_ increases in the speed of the main CPU. > > > >I don't know so much about FreeBSD's handling of this, but on Linux, > >there's pretty strong indication that _SOFTWARE_ RAID is faster than > >hardware RAID. > >=20 > > > Unless something has changed though, you can't run raid 10 > with linux software raid and raid 5 sucks for heavy writes. >=20 > J Hello, Joshua. Things have changed. :) =46rom 2.6.10's drivers/md/Kconfig: config MD_RAID10 tristate "RAID-10 (mirrored striping) mode (EXPERIMENTAL)" depends on BLK_DEV_MD && EXPERIMENTAL ---help--- RAID-10 provides a combination of striping (RAID-0) and mirroring (RAID-1) with easier configuration and more flexable layout. Unlike RAID-0, but like RAID-1, RAID-10 requires all devices to be the same size (or atleast, only as much as the smallest device will be used). RAID-10 provides a variety of layouts that provide different leve= ls of redundancy and performance. RAID-10 requires mdadm-1.7.0 or later, available at: ftp://ftp.kernel.org/pub/linux/utils/raid/mdadm/ There is a problem, however, that may render software RAID non-viable though. According to one of my benchmarks, it makes up for an up to 10% increase in system time consumed under full loads, so if the original poster's application is going to be CPU-bound, which might be the case, as he is looking for a machine that's strong on the CPU side, that may be the "too much" bit. Of course, if Opteron is being chosen for the increase in the amount of memory it can address, this is not the issue. HTH, --=20 Grega Bremec gregab at p0f dot net --3V7upXqbjpZ4EhLz Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFB46qAfu4IwuB3+XoRAnbjAJ96ArUF8i1A+6eYg/ZR1EJOsuFS/QCffs+t aacgdcKXFNqO1XfMLRljkOA= =o0l8 -----END PGP SIGNATURE----- --3V7upXqbjpZ4EhLz--