Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 49F8E632593 for ; Mon, 22 Feb 2010 22:21:53 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89381-03 for ; Tue, 23 Feb 2010 02:21:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f223.google.com (mail-fx0-f223.google.com [209.85.220.223]) by mail.postgresql.org (Postfix) with ESMTP id 869B263249C for ; Mon, 22 Feb 2010 22:21:42 -0400 (AST) Received: by fxm23 with SMTP id 23so3187076fxm.3 for ; Mon, 22 Feb 2010 18:21:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=LpxK0gna/9/sbBSgKOavrxtxHmM8nQg5vySjOJ3avhE=; b=d4F+GEYy1HqpqR0CcH/zyJrd6NfGqCtRO7DIoFfH94sgmoeRkFegSA933FGdNmreCm l6qpCsmI5QNAc1O2D15PLdWlnJXhmntJF0lTKw1NlRVeCjzF5xv5YeO6ZrdDj7jXLDHi rK+pdwWgtPgoq5Ffk4xFqCSi94G5/ghB2pIME= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=h8aJlVqY/2W5qxxRsK7K4rDC4wNkyCuNZkDgX7JxknfrWPhaVs4xiKIhO9B0c3kSQ3 H1Czr4QFJF+iOHrXHVzm16pwe50d7YPeq2ypSgEsGjBRAS8a669Mv8RXXsTk54e+0PYI X1o5zF1lvf+oNDfzJ0VgBh1cLDpwplWQKhFrA= MIME-Version: 1.0 Received: by 10.216.88.139 with SMTP id a11mr1200411wef.74.1266891700445; Mon, 22 Feb 2010 18:21:40 -0800 (PST) In-Reply-To: <4B8331D5.7000802@2ndquadrant.com> References: <201002211410.o1LEAht05941@momjian.us> <4B814920.1040204@cheapcomplexdevices.com> <4B82187A.7060604@2ndquadrant.com> <4B822DFF.50501@tweakers.net> <4B8329A3.4040003@2ndquadrant.com> <4B832B3E.9080207@mark.mielke.cc> <4B8331D5.7000802@2ndquadrant.com> Date: Mon, 22 Feb 2010 19:21:40 -0700 Message-ID: Subject: Re: SSD + RAID From: Scott Marlowe To: Greg Smith Cc: Mark Mielke , Arjen van der Meijden , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/311 X-Sequence-Number: 37732 On Mon, Feb 22, 2010 at 6:39 PM, Greg Smith wrote: > Mark Mielke wrote: >> >> I had read the above when posted, and then looked up SRAM. SRAM seems to >> suggest it will hold the data even after power loss, but only for a peri= od >> of time. As long as power can restore within a few minutes, it seemed li= ke >> this would be ok? > > The normal type of RAM everyone uses is DRAM, which requires constrant > "refresh" cycles to keep it working and is pretty power hungry as a resul= t. > =A0Power gone, data gone an instant later. Actually, oddly enough, per bit stored dram is much lower power usage than sram, because it only has something like 2 transistors per bit, while sram needs something like 4 or 5 (it's been a couple decades since I took the classes on each). Even with the constant refresh, dram has a lower power draw than sram.