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 6B643D1B387 for ; Tue, 20 Jul 2004 09:26:08 -0300 (ADT) 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 67001-01 for ; Tue, 20 Jul 2004 12:26:02 +0000 (GMT) Received: from mail.najdi.si (elfstone.noviforum.si [193.189.169.107]) by svr1.postgresql.org (Postfix) with ESMTP id 28BF5D1B386 for ; Tue, 20 Jul 2004 09:25:57 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by elfstone.noviforum.si (ESMTP) with ESMTP id D97571B91C; Tue, 20 Jul 2004 14:24:08 +0200 (CEST) Received: from elbereth.noviforum.si (elbereth.noviforum.si [192.168.2.26]) by elfstone.noviforum.si (ESMTP) with ESMTP id 9F92B1B916; Tue, 20 Jul 2004 14:24:08 +0200 (CEST) Received: from elbereth.noviforum.si (localhost [127.0.0.1]) by elbereth.noviforum.si (8.12.10/8.12.10) with ESMTP id i6KCNZWg017470; Tue, 20 Jul 2004 14:23:35 +0200 Received: (from gregab@localhost) by elbereth.noviforum.si (8.12.10/8.12.10/Submit) id i6KCNZrC017469; Tue, 20 Jul 2004 14:23:35 +0200 Date: Tue, 20 Jul 2004 14:23:35 +0200 From: Grega Bremec To: bsimon@loxane.com Cc: pgsql-performance@postgresql.org Subject: Re: NAS, SAN or any alternate solution ? Message-ID: <20040720122335.GD16410@elbereth.noviforum.si> References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="/3yNEOqWowh/8j+e" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2i Organization: Noviforum, Ltd., Software & Media X-Virus-Scanned: by Najdi.si X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/125 X-Sequence-Number: 7516 --/3yNEOqWowh/8j+e Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable ...and on Tue, Jul 20, 2004 at 09:52:56AM +0200, bsimon@loxane.com used the= keyboard: > Hi all, >=20 > I've been searching the list for a while but couldn't find any up-to-date= =20 > information relating to my problem. > We have a production server with postgresql on cygwin that currently deel= s=20 > with about 200 Gigs of data (1 big IDE drive). We plan to move to linux= =20 > for some reasons I don't have to explain. > Our aim is also to be able to increase our storage capacity up to=20 > approximately 1 or 2 terabytes and to speed up our production process. As= =20 > we are a small "microsoft addicted" company , we have some difficulties t= o=20 > choose the best configuration that would best meet our needs. > Our production process is based on transaction (mostly huge inserts) and= =20 > disk access is the main bottlle-neck. >=20 > Our main concern is hardware related : >=20 > Would NAS or SAN be good solutions ? (I've read that NAS uses NFS which= =20 > could slow down the transfer rate ??) > Has anyone ever tried one of these with postgresql ?=20 >=20 > I would appreciate any comments. > Thanks in advance. Hello Simon, We're testing 3ware Escalade 9000, which is a hardware-raid SATA controller with VERY good support for Linux (including direct access for S.M.A.R.T. applications, which is a serious problem with other RAID controllers), featuring RAID levels 0, 1, 10, 5, JBOD, up to 12 SATA channels (that's 3ware Escalade 9500S-12, they also come in 4- and 8-channel versions, up to four cards can be fitted into a system), up to 1GB battery-backed ECC RAM (128MB out-of-the-box) and most of all, excellent tuning guides that actually manage to exceed the scope of merely making you come up with good benchmark results for that controller in a specific test environment. Our preliminary tests show that a setup of four 250GB SATA Maxtors that aren't really qualified as fast drives, in RAID5 can deliver block writes of 50MB/s, rewrites at about 35MB/s and reads of approximately 180MB/s, which is rougly 2.5-times the performance of previous Escalades. You can find more info on Escalade 9000 series, benchmarks and other stuff here: http://www.3ware.com/products/serial_ata9000.asp http://www.3ware.com/products/benchmarks_sata.asp http://www.3ware.dk/fileadmin/3ware/documents/Benchmarks/Linux_kernel_2= .6_Benchmarking.pdf Oh, and not to forget - the price for a 3ware 9500S-12, the version we're testing ranges between EUR1000 and EUR1500, depending on the contract you have with the reseller and the intended use of the device. SATA disks are dirt-cheap nowadays, as has been mentioned before. I do agree on the reliability of cache-usage setting those drives report though, it may or may not be true. But one never knows that for sure with SCSI drives either. At least you can assert that proper controller cache sizing with drives that usually feature 8MB (!!!) cache, will mostly ensure that even the largest amount of data that could fit into a hard disk cache of the entire array (96MB) will still be available in the controller cache after a power failure, for it to be re-checked and ensured it is properly written. Hope this helps, --=20 Grega Bremec Senior Administrator Noviforum Ltd., Software & Media http://www.noviforum.si/ --/3yNEOqWowh/8j+e Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFA/Q7HDo/EMYD4+osRAvHwAJ4jVHn/BXzgebgCo+xHAh3/r3Z+AACeJKCR DnvCEwTap6rIRrCxH0bEf5g= =22vO -----END PGP SIGNATURE----- --/3yNEOqWowh/8j+e--