X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 167EB9FA217 for ; Mon, 28 Aug 2006 12:59:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 69330-09 for ; Mon, 28 Aug 2006 12:59:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id BF7E89FC4E1 for ; Mon, 28 Aug 2006 12:59:41 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 28 Aug 2006 15:59:39 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 28 Aug 2006 10:59:39 -0500 Subject: Re: Advice request: Postgresql setup for flash memories. From: Scott Marlowe To: Tom Lane Cc: Enrique =?ISO-8859-1?Q?Ariz=F3n?= , pgsql-admin@postgresql.org In-Reply-To: <12001.1156715116@sss.pgh.pa.us> References: <20060827210751.80779.qmail@web30402.mail.mud.yahoo.com> <12001.1156715116@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1156780779.10490.3.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 28 Aug 2006 10:59:39 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.078 tagged_above=0 required=5 tests=AWL, SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200608/309 X-Sequence-Number: 22852 On Sun, 2006-08-27 at 16:45, Tom Lane wrote: > =?iso-8859-1?q?Enrique=20Ariz=F3n?= writes: > > since flash memory hardware is dropping prices at > > high rate I was planning to test how Postgresql runs > > in such hardware. > > This is probably a bad idea, unless the number-of-write-cycles > limitation of flash memory has gone away while I wasn't looking. > PG is pretty piggy as far as rewriting disk pages goes, especially > for the WAL files. Note that most flash memory controllers randomize the accesses across the media to prevent / slow this problem. So, it's critical that IF one has a pg store on a flash device that it have a controller that spreads writes around. Without that, your flash memory will fail fairly soon.