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 EB47E534B9 for ; Sat, 26 Mar 2005 03:21:14 +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 37832-03 for ; Sat, 26 Mar 2005 03:21:13 +0000 (GMT) Received: from r163ip.btv.lv (r163ip.btv.lv [217.198.224.163]) by svr1.postgresql.org (Postfix) with ESMTP id 3B5625341B for ; Sat, 26 Mar 2005 03:21:12 +0000 (GMT) Received: from p4 (pIV.homenet [192.168.88.4]) by r163ip.btv.lv (8.12.9/8.12.6) with ESMTP id j2Q3LGmv009749 for ; Sat, 26 Mar 2005 05:21:16 +0200 (EET) (envelope-from postgres@bilteks.com) From: "Alexander Kirpa" To: pgsql-performance@postgresql.org Date: Sat, 26 Mar 2005 05:21:25 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: How to improve db performance with $7K? Message-ID: <4244F155.6661.82A056DE@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) 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: 200503/591 X-Sequence-Number: 11296 1. Buy for empty PCI-X Slot - 1 or dual channel SCSI-320 hardware RAID controller, like MegaRAID SCSI 320-2X (don't forget check driver for your OS) plus battery backup plus (optional) expand RAM to Maximum 256MB - approx $1K 2. Buy new MAXTOR drives - Atlas 15K II (4x36.7GB) - approx 4x$400. 3. SCSI 320 Cable set. 4. Old drives (2) use for OS (optional DB log) files in RAID1 mode, possible over one channel of MegaRAID. 5. New drives (4+) in RAID10 mode for DB 6. Start tuning Postres + OS: more shared RAM etc. Best regards, Alexander Kirpa