X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6332E52A0E for ; Fri, 8 Jul 2005 11:07:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31283-06 for ; Fri, 8 Jul 2005 14:06:59 +0000 (GMT) Received: from gatekeeper.look.ca (gamma1.look.ca [207.136.80.8]) by svr1.postgresql.org (Postfix) with ESMTP id 023CC52815 for ; Fri, 8 Jul 2005 11:06:57 -0300 (ADT) Received: from 216-154-13-109.dsl.look.ca ([216.154.13.109]) by gatekeeper.look.ca with esmtp (Exim 4.20) id 1DqtVN-0006ld-2d; Fri, 08 Jul 2005 14:07:01 +0000 From: Rod Taylor To: Chris Browne Cc: pgsql-performance@postgresql.org In-Reply-To: <60zmsykm9q.fsf@dba2.int.libertyrms.com> References: <42CDD7B8.6050109@stuartbishop.net> <60zmsykm9q.fsf@dba2.int.libertyrms.com> Date: Fri, 08 Jul 2005 10:03:48 -0400 Message-Id: <1120831428.24708.228.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 FreeBSD GNOME Team Port X-SA-Exim-Mail-From: pg@rbt.ca Subject: Re: Mount database on RAM disk? Content-Type: text/plain Content-Transfer-Encoding: 7bit X-SA-Exim-Version: 3.1 (built Tue Feb 24 05:09:27 GMT 2004) X-SA-Exim-Scanned: Yes X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/83 X-Sequence-Number: 13324 > If I could get and deploy some SSD (Solid State Disk) devices that > would make this sort of thing *actually safe,* I'd expect that to be a > pretty fabulous improvement, at least for write-heavy database > activity. Not nearly as much as you would expect. For the price of the SSD and a SCSI controller capable of keeping up to the SSD along with your regular storage with enough throughput to keep up to structure IO, you can purchase a pretty good mid-range SAN which will be just as capable and much more versatile. --