X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8B49B11F60AE for ; Thu, 27 Apr 2006 04:55:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 67010-09 for ; Thu, 27 Apr 2006 04:55:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 8068111F60E3 for ; Thu, 27 Apr 2006 04:55:25 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k3R7tJHD080895 for ; Thu, 27 Apr 2006 04:55:19 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k3R7YFKn073100 for pgsql-admin@postgresql.org; Thu, 27 Apr 2006 04:34:15 -0300 (ADT) (envelope-from news) From: William Yu X-Newsgroups: pgsql.admin Subject: Re: New system recommendations Date: Thu, 27 Apr 2006 00:34:14 -0700 Organization: Hub.Org Networking Services Lines: 23 Message-ID: References: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 1.5 (X11/20051201) In-Reply-To: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local> To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/297 X-Sequence-Number: 21466 Benjamin Krajmalnik wrote: > We are currently inserting about 1 million rows per day, and will > increase to probably 5 million once it goes into full deployment. > > It is currently running on a 3GHz Xeon HT, 2GB RAM, dual 72GB disks > running RAID 1. This server is a 1U without only 2 drive bays, so I > have a potential issue with drive space. > > As a result, I will be moving the db server to a Dell 1650 with 3 146GB > SCSI drives running RAID 0. System is a dual processor, 1.2GHz, with > 4GB RAM. I'm assuming you've already optimized your code with all the necessary tricks for maximum insert/update performance because your disk upgrade plan is rather underwhelming. 3X the disk bandwidth (3dr-RAID0 versus 2dr-RAID1) won't even keep pace with your expected 5X increased volume. Anytime you do a system upgrade, you always have to plan to handle many times the current projected volume so you don't have to upgrade yet again next year. Go nuts -- get as many disks as you can afford. Get as much onboard cache as you can afford. If number of drive bays is an issue, I'd get a separate case/rackmount and run external scsi/sata cables to it.