Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 64D4B2E096D for ; Thu, 24 Jan 2008 10:01:41 -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 68638-02 for ; Thu, 24 Jan 2008 10:01:34 -0400 (AST) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.185]) by postgresql.org (Postfix) with ESMTP id 58CF72E0D9B for ; Thu, 24 Jan 2008 10:01:19 -0400 (AST) Received: by mu-out-0910.google.com with SMTP id w8so106477mue.1 for ; Thu, 24 Jan 2008 06:01:18 -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=YMqbkty1+HbDyBbQS6qFgsEQOeBDGjA2cY2pp/lBz5U=; b=rWQVR2kcGgaysGfOR8lee3Qvl4H/j7cbBoHSZYVZCsjHFoqNEWLSycS/c94numldRpcZaEHYmX4JlsBXMvphxKLnvRDLXSSMUSe054DTmZdVJUHy300Iu+migHtikDJuZ/3/gCDhFXPFomXLKwqwDoU8KfhQqWHjcLZp1m7bg3E= 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=P+3mlbwnDl6rAH8/JAyyaEmGz8GqYCt/zyK0m4/X+F5MyHf5Bhy1I3gJdANleJKr9mXuaQe2NAnAI5roMPUCW0DLZLAA23w/zY0e5IfMfxftv5nA1jGJaM8AETzceZfH16e/w4o0jAYNUaFiDr9TxmWPO1XnfzpbtNcuc9amJ5g= Received: by 10.78.162.4 with SMTP id k4mr824339hue.66.1201183277833; Thu, 24 Jan 2008 06:01:17 -0800 (PST) Received: by 10.78.18.2 with HTTP; Thu, 24 Jan 2008 06:01:17 -0800 (PST) Message-ID: Date: Thu, 24 Jan 2008 09:01:17 -0500 From: "Merlin Moncure" 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/211 X-Sequence-Number: 28450 On Jan 23, 2008 2:57 PM, Guy Rouillier wrote: > 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 > grade, that's about 300,000 writes, while on industrial grade it's about > 10 times that. That's fine for mp3 players and cameras; even wrong. at 1 million writes (which better flash drives can do) wear leveling, this can be disproved with a simple back of napkin calculation... the major problem with flash drives in the server space is actually random write performance...if random write performed as well as random read for flash ssd, you would be able to replace a stack of 15k sas drives with a single flash ssd in terms of iops. merlin