Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id BB8DE2E0234 for ; Thu, 24 Jan 2008 10:27:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 67518-01 for ; Thu, 24 Jan 2008 10:26:46 -0400 (AST) Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id 8B8A52E01CB for ; Thu, 24 Jan 2008 10:26:51 -0400 (AST) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) id 1JI32V-0004BS-VU; Thu, 24 Jan 2008 15:26:47 +0100 Received: from fweimer by bfk.de with local id 1JI32W-0006Ss-LA; Thu, 24 Jan 2008 15:26:48 +0100 To: Matthew Cc: pgsql-performance@postgresql.org Subject: Re: Making the most of memory? References: <4796BE84.9030803@centriccrm.com> <47979C15.3040406@burntmail.com> <4797A8B3.5040605@janestcapital.com> From: Florian Weimer Date: Thu, 24 Jan 2008 15:26:46 +0100 In-Reply-To: (matthew@flymine.org's message of "Thu, 24 Jan 2008 14:15:19 +0000 (GMT)") Message-ID: <82tzl39u55.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/213 X-Sequence-Number: 28452 > So, that web site seems to list products starting at about 32GB in a > separate rack-mounted box with redundant everything. I'd be more > interested in just putting the WAL on an SSD device, so 500MB or 1GB > would be quite sufficient. Can anyone point me towards such a device? A dedicated RAID controller with battery-backed cache of ssuficient size and two mirrored disks should not perform that bad, and has the advantage of easy availability. --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99