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 BEC6AD1CB08 for ; Mon, 24 Nov 2003 18:06:07 +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 78108-09 for ; Mon, 24 Nov 2003 14:05:36 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id C3689D1C96C for ; Mon, 24 Nov 2003 14:05:35 -0400 (AST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3970123; Mon, 24 Nov 2003 10:06:23 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: William Yu , pgsql-performance@postgresql.org Subject: Re: Maximum Possible Insert Performance? Date: Mon, 24 Nov 2003 10:04:37 -0800 User-Agent: KMail/1.4.3 References: <200311240925.58070.josh@agliodbs.com> In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200311241004.37969.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/214 X-Sequence-Number: 4774 William, > The SanDisks do seem a bit pokey at 16MBps. On the otherhand, you could > get 4 of these suckers, put them in a mega-RAID-0 stripe for 64MBps. You > shouldn't need to do mirroring with a solid state drive. I wouldn't count on RAID0 improving the speed of SANDisk's much. How are you connecting to them? USB? USB doesn't support fast parallel data access. Now, if it turns out that 256MB ramdisks are less than 1/5 the cost of 1GB ramdisks, then that's worth considering. You're right, though, mirroring a solid state drive is pretty pointless; if power fails, both mirrors are dead. As I said before, though, we're all very interested in this test. Using a ramdisk for WAL has been discussed on this list numerous times but not attempted by anyone who published their results. All that aside, though, I think you should also experiment with the Background Writer patch recently discussed on Hackers, as it may give you a performance boost as well. -- Josh Berkus Aglio Database Solutions San Francisco