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 D4E8ED1DA67 for ; Thu, 28 Aug 2003 14:39:50 +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 26183-01 for ; Thu, 28 Aug 2003 11:39:22 -0300 (ADT) Received: from lorax.kciLink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id B758FD1DA5B for ; Thu, 28 Aug 2003 11:39:10 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id 30D8C3E24 for ; Thu, 28 Aug 2003 10:39:05 -0400 (EDT) Received: from lorax.kciLink.com ([127.0.0.1]) by localhost (lorax.kciLink.com [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 83540-03 for ; Thu, 28 Aug 2003 10:38:54 -0400 (EDT) Received: from lorax.kciLink.com (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id A33323E07 for ; Thu, 28 Aug 2003 10:38:54 -0400 (EDT) Received: (from news@localhost) by lorax.kciLink.com (8.12.8p1/8.12.8/Submit) id h7SEcsw0095679 for pgsql-performance@postgresql.org; Thu, 28 Aug 2003 10:38:54 -0400 (EDT) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: Hardware recommendations to scale to silly load Date: Thu, 28 Aug 2003 10:38:54 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 23 Message-ID: References: NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kciLink.com 1062081534 70958 216.194.193.105 (28 Aug 2003 14:38:54 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Thu, 28 Aug 2003 14:38:54 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Portable Code, berkeley-unix) Cancel-Lock: sha1:MSU5ZEGWMrhK+vkcq+fG/5pfm3c= X-Virus-Scanned: by amavisd-new at kciLink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/415 X-Sequence-Number: 3231 sm> On 27 Aug 2003, matt wrote: >> My app is likely to come under some serious load in the next 6 months, >> but the increase will be broadly predictable, so there is time to throw >> hardware at the problem. >> >> Currently I have a ~1GB DB, with the largest (and most commonly accessed >> and updated) two tables having 150,000 and 50,000 rows. 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. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/