X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 48BD7D1D8FC for ; Tue, 25 Nov 2003 01:17:05 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 88267-10 for ; Mon, 24 Nov 2003 21:16:39 -0400 (AST) Received: from smtp.istop.com (dci.doncaster.on.ca [66.11.168.194]) by svr1.postgresql.org (Postfix) with ESMTP id 31F89D1CAD1 for ; Mon, 24 Nov 2003 21:16:36 -0400 (AST) Received: from stark.dyndns.tv (gsstark.mtl.istop.com [66.11.160.162]) by smtp.istop.com (Postfix) with ESMTP id 478D93695B; Mon, 24 Nov 2003 20:16:28 -0500 (EST) Received: from localhost ([127.0.0.1] helo=stark.dyndns.tv ident=foobar) by stark.dyndns.tv with smtp (Exim 3.36 #1 (Debian)) id 1AORoZ-0001Dr-00; Mon, 24 Nov 2003 20:16:27 -0500 To: William Yu Cc: pgsql-performance@postgresql.org Subject: Re: Maximum Possible Insert Performance? References: <200311240925.58070.josh@agliodbs.com> <200311241004.37969.josh@agliodbs.com> In-Reply-To: From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 24 Nov 2003 20:16:27 -0500 Message-ID: <87brr11c44.fsf@stark.dyndns.tv> Lines: 17 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/232 X-Sequence-Number: 4792 William Yu writes: > > You're right, though, mirroring a solid state drive is pretty pointless; if > > power fails, both mirrors are dead. > > Actually no. Solid state memory is non-volatile. They retain data even without > power. Note that flash ram only has a finite number of write cycles before it fails. On the other hand that might not be so bad for WAL which writes sequentially, you can easily calculate how close you are to the maximum. For things like heap storage or swap it's awful as you can get hot spots that get written to thousands of times before the rest of the space is used. -- greg