X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CE286D1B8AD for ; Thu, 28 Aug 2003 16:31:16 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 47404-04 for ; Thu, 28 Aug 2003 13:30:46 -0300 (ADT) Received: from wight.ymogen.net (unknown [217.27.240.153]) by svr1.postgresql.org (Postfix) with SMTP id B6529D1B8A9 for ; Thu, 28 Aug 2003 13:30:44 -0300 (ADT) Received: (qmail 25853 invoked from network); 28 Aug 2003 16:29:36 -0000 Received: from unknown (HELO solent) (213.165.136.12) by wight.ymogen.net with SMTP; 28 Aug 2003 16:29:36 -0000 From: "Matt Clark" To: "Vivek Khera" , Subject: Re: Hardware recommendations to scale to silly load Date: Thu, 28 Aug 2003 17:29:39 +0100 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/421 X-Sequence-Number: 3237 > Just how big do you expect your DB to grow? For a 1GB disk-space > database, I'd probably just splurge for an SSD hooked up either via > SCSI or FibreChannel. Heck, up to about 5Gb or so it is not that > expensive (about $25k) and adding another 5Gb should set you back > probably another $20k. I use an SSD from Imperial Technology > ( http://www.imperialtech.com/ ) for mail spools. My database is way > to big for my budget to put in SSD. I may well be able to split some tables that aren't used in joins into a separate DB, and could well use an SSD for those. In fact two of the inserts per user interaction could be split off, and they're not financially important tables, so fsync=false could be enabled for those, in which case an SSD might be overkill... The whole thing will definitely *not* fit in an SSD for a sensible price, but the WAL might well!