Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 896432E2FEE for ; Wed, 23 Jan 2008 14:45:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99516-04-4 for ; Wed, 23 Jan 2008 14:45:23 -0400 (AST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.229]) by postgresql.org (Postfix) with ESMTP id 59A5F2E0055 for ; Wed, 23 Jan 2008 14:44:40 -0400 (AST) Received: by nz-out-0506.google.com with SMTP id l8so1683097nzf.28 for ; Wed, 23 Jan 2008 10:44:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=m6TW0HH/NC6f/tO/BDqzOLhaKDwizf5Pf86mhMJJTpQ=; b=hUeopPtk+JWR8db7hVEvoOvSIWp9pdAHb7XalkWCKNu1fVaRs6zKf2MdC8VaNBsML5JMjuW62wcoovf2VP7RTViVB7YJI+2nPkgL0az0IBhQ8e4ahV9GG+fgq0bUZEZwOCDwPdnEUGXiwy9CRwMLSo4AC92MgZQjCVtbNZMJ9gI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ttR/32K6kWJgZk2a88BVIAxLXiNWSsP0wvcyaQoc/HOB22GxGQIpvUt2b/S4Xzd92/mlO3l6bCdcF2a5DGE967UhoKizMiY2VcfGdxfQ9oxldCwIkC2PgmsSWc8cQ9DJANQ0/HNHqjhxSMKkXarr5F/mUTHGaLr9EGy8hGDakD4= Received: by 10.115.58.1 with SMTP id l1mr4528304wak.110.1201113878508; Wed, 23 Jan 2008 10:44:38 -0800 (PST) Received: by 10.114.133.5 with HTTP; Wed, 23 Jan 2008 10:44:38 -0800 (PST) Message-ID: Date: Wed, 23 Jan 2008 12:44:38 -0600 From: "Scott Marlowe" To: "mike long" Subject: Re: Making the most of memory? Cc: "Joshua Fielek" , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4796BE84.9030803@centriccrm.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/198 X-Sequence-Number: 28437 On Jan 23, 2008 8:01 AM, mike long wrote: > Scott, > > What are your thoughts on using one of those big RAM appliances for > storing a Postgres database? I assume you're talking about solid state drives? They have their uses, but for most use cases, having plenty of RAM in your server will be a better way to spend your money. For certain high throughput, relatively small databases (i.e. transactional work) the SSD can be quite useful. For large reporting databases running into the terabyte range they're prohibitively expensive.