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 70D6AD1D453 for ; Mon, 24 Nov 2003 17:51:42 +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 76764-06 for ; Mon, 24 Nov 2003 13:51:11 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 73A87D1B50A for ; Mon, 24 Nov 2003 13:51:10 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id hAOHp9Nu007323 for ; Mon, 24 Nov 2003 17:51:09 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hAOHjOdR006303 for pgsql-performance@postgresql.org; Mon, 24 Nov 2003 17:45:24 GMT From: William Yu X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Maximum Possible Insert Performance? Date: Mon, 24 Nov 2003 09:45:22 -0800 Organization: Hub.Org Networking Services Lines: 22 Message-ID: References: <3FC19C2C.4050704@myrealbox.com> <200311240925.58070.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en-us, en In-Reply-To: <200311240925.58070.josh@agliodbs.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/212 X-Sequence-Number: 4772 Josh Berkus wrote: > William, > > >>When my current job batch is done, I'll save a copy of the dir and give >>the WAL on ramdrive a test. And perhaps even buy a Sandisk at the local >>store and run that through the hooper. > > > We'll be interested in the results. The Sandisk won't be much of a > performance test; last I checked, their access speed was about 1/2 that of a > fast SCSI drive. But it could be a feasability test for the more expensive > RAMdrive approach. > 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. Time to Google up some more solid state drive vendors.