Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D31C02E3966 for ; Wed, 23 Jan 2008 22:12:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 07386-08 for ; Wed, 23 Jan 2008 22:12:28 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by postgresql.org (Postfix) with ESMTP id 99BC62E1BF9 for ; Wed, 23 Jan 2008 21:45:08 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so70803waf.5 for ; Wed, 23 Jan 2008 17:45:07 -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=Tf4d1c/nc1iRk3E8y8+NDN6lw+YLB6xwsUTnqaGtdXY=; b=J02w54ii2Piw8mVPZV+NkvscNFInwPGoDVw0msBOkToyoVspxmyLhIWkr32nSnQiC4UxnPyJlmuaZeQ1q5Vj1pkGb39CfI2wAXs4HlMwdiuF52ed+gmODCO0fjqjO1NaaZNkfvplQATdv7//lus1kRjrjGI/wnPU1sQHYvD52r4= 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=onAcJGXPi7AM/Z5QAzpB93r/0SyglOPGU2++yDwFWdwRkxoI6ZAgK+NnxE0Y4Ga4Zd68LQr216TaYBrGg3YjYj5p+fx04GD7JAd3GZAXVD7cj3ePvObYRG4JEQfl1lK3HVBlcguglZ2yk5rNbBfjFwDfCL/Iv3LuGhzGCl+MHBU= Received: by 10.114.210.2 with SMTP id i2mr93536wag.36.1201139107250; Wed, 23 Jan 2008 17:45:07 -0800 (PST) Received: by 10.114.133.5 with HTTP; Wed, 23 Jan 2008 17:45:07 -0800 (PST) Message-ID: Date: Wed, 23 Jan 2008 19:45:07 -0600 From: "Scott Marlowe" To: "Guy Rouillier" Subject: Re: Making the most of memory? Cc: pgsql-performance@postgresql.org In-Reply-To: <47979C15.3040406@burntmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4796BE84.9030803@centriccrm.com> <47979C15.3040406@burntmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/208 X-Sequence-Number: 28447 On Jan 23, 2008 1:57 PM, Guy Rouillier wrote: > Scott Marlowe wrote: > > 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. > > Unless somebody has changes some physics recently, I'm not understanding > the recent discussions of SSD in the general press. Flash has a limited > number of writes before it becomes unreliable. On good quality consumer Actually, I was referring to all SSD systems, some of which are based on flash memory, some on DRAM, sometimes backed by hard drives. There's always a use case for a given piece of tech.