X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8822E9DCCA4 for ; Thu, 16 Mar 2006 16:41:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12319-04 for ; Thu, 16 Mar 2006 16:41:59 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from elasmtp-kukur.atl.sa.earthlink.net (elasmtp-kukur.atl.sa.earthlink.net [209.86.89.65]) by postgresql.org (Postfix) with ESMTP id D44FB9DCC92 for ; Thu, 16 Mar 2006 16:41:55 -0400 (AST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=dk20050327; d=earthlink.net; b=eg5lg0cUJho3z9dRPl1TKCUyX1Cr+DFRJWISB2DbBRZhJV+Gob1DfXffEGW6xZib; h=Received:Message-ID:Date:From:Reply-To:To:Subject:Mime-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:X-ELNK-Trace:X-Originating-IP; Received: from [209.86.224.36] (helo=elwamui-hybrid.atl.sa.earthlink.net) by elasmtp-kukur.atl.sa.earthlink.net with asmtp (Exim 4.34) id 1FJzIA-0004GY-DY; Thu, 16 Mar 2006 15:41:54 -0500 Message-ID: <31340165.1142541714303.JavaMail.root@elwamui-hybrid.atl.sa.earthlink.net> Date: Thu, 16 Mar 2006 15:41:54 -0500 (EST) From: Ron Peacetree Reply-To: Ron Peacetree To: Jim Nasby , pgsql-performance@postgresql.org Subject: Re: 1 TB of memory Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: EarthLink Zoo Mail 1.0 X-ELNK-Trace: acd68a6551193be5d780f4a490ca69563f9fea00a6dd62bc7a10d64eb189336022e297989df5de45350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 209.86.224.36 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200603/256 X-Sequence-Number: 17693 The US Dept of Homeland Security has at least two =10=TB SSDs. Rumor is they are being used for Carnivore or an offshoot/descendent of Carnivore. Good luck getting them to give you benchmark data. You need >deep< pockets to afford >= 1TB of SSD. (...and as the example shows, perhaps more money than sense.) Ron -----Original Message----- >From: Jim Nasby >Sent: Mar 16, 2006 1:33 PM >To: pgsql-performance@postgresql.org >Subject: [PERFORM] 1 TB of memory > >PostgreSQL tuned to the max and still too slow? Database too big to >fit into memory? Here's the solution! http://www.superssd.com/ >products/tera-ramsan/ > >Anyone purchasing one will be expected to post benchmarks! :) >-- >Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com >Pervasive Software http://pervasive.com work: 512-231-6117 >vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend