X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 46AAF475AD4 for ; Tue, 18 Feb 2003 18:51:27 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 9CD6A475AAC for ; Tue, 18 Feb 2003 18:51:26 -0500 (EST) Received: from [216.135.165.74] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 4.0.2) with HTTP id 2846264; Tue, 18 Feb 2003 15:51:32 -0800 From: "Josh Berkus" Subject: Re: Data write speed To: Kevin Brown , pgsql-performance@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.4.0.2 Date: Tue, 18 Feb 2003 15:51:32 -0800 Message-ID: In-Reply-To: <20030218222722.GC1847@filer> MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/122 X-Sequence-Number: 1178 Kevin, > That does seem low. What rate do you get with software RAID (of the > same type, of course) to the same disks (might have to be through a > standard SCSI controller to be meaningful) with roughly the same > disks/channel distribution? Unfortunately, I can't do this without blowing away all of my current software setup. I noticed the performance problem *after* installing Linux, PostgreSQL, Apache, PHP, pam_auth, NIS, and my database .... and, of course, customized builds of the above. =20 > The Adaptec 2200S has a 100MHz CPU. That's pretty weak. The typical > modern desktop system has a factor of 20 more CPU power than that. A > software RAID setup would have no trouble blowing the 2200S out of > the > water, especially if the OS is able to make use of features such as > tagged queueing. >=20 > Since the 2200S has a JBOD mode, you might consider testing a > software > RAID setup across that, just to see how much of a difference doing > the > RAID calculations on the host system makes. This isn't something I can do without blowing away my current software setup, hey? -Josh