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 AC9A9D1D8A9 for ; Mon, 24 Nov 2003 18:52:09 +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 99120-02 for ; Mon, 24 Nov 2003 14:51:39 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 66847D1D880 for ; Mon, 24 Nov 2003 14: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 hAOIpANu018836 for ; Mon, 24 Nov 2003 18:51:10 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id hAOINbCO013502 for pgsql-performance@postgresql.org; Mon, 24 Nov 2003 18:23:37 GMT From: William Yu X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Maximum Possible Insert Performance? Date: Mon, 24 Nov 2003 10:23:36 -0800 Organization: Hub.Org Networking Services Lines: 29 Message-ID: References: <200311240925.58070.josh@agliodbs.com> <200311241004.37969.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: <200311241004.37969.josh@agliodbs.com> To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/215 X-Sequence-Number: 4775 Josh Berkus wrote: > 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. You can get ATA SanDisks up to 2GB. Another vendor I checked out -- BitMicro -- has solid state drives for SATA, SCSI and FiberChannel. I'd definitely would not use USB SSDs -- USB performance would be so pokey to be useless. > Now, if it turns out that 256MB ramdisks are less than 1/5 the cost of 1GB > ramdisks, then that's worth considering. Looks like they're linear with size. SanDisk Flashdrive 1GB is about $1000 while 256MB is $250. > 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.