Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 843B91337999 for ; Fri, 29 Apr 2011 11:45:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 15465-05 for ; Fri, 29 Apr 2011 14:45:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp03.lnh.mail.rcn.net (smtp03.lnh.mail.rcn.net [207.172.157.103]) by mail.postgresql.org (Postfix) with ESMTP id 742891337BEF for ; Fri, 29 Apr 2011 11:45:13 -0300 (ADT) Received: from ms14.lnh.mail.rcn.net ([208.58.56.82]) by smtp02.lnh.mail.rcn.net with ESMTP; 29 Apr 2011 10:45:14 -0400 Received: (from ms14.lnh.mail.rcn.net [64.148.9.74]) by ms14.lnh.mail.rcn.net (MOS 4.2.3-GA) with HTTP/1.1 id BKZ45774 (AUTH gnuoytr@rcn.com); Fri, 29 Apr 2011 10:45:13 -0400 (EDT) From: Subject: Re: FUSION-IO io cards To: pgsql-performance@postgresql.org X-Mailer: Mirapoint Webmail Direct 4.2.3-GA MIME-Version: 1.0 In-Reply-To: References: Message-Id: <201104291445.061769@ms14.lnh.mail.rcn.net> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Date: Fri, 29 Apr 2011 10:45:13 -0400 (EDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201104/409 X-Sequence-Number: 43471 Fusion SSDs install on PCIe slots, so are limited by slot count. None, = so far as I recall, are bootable (although Fusion has been promising tha= t for more than a year). If you've a BCNF schema of moderate size, then= any SSD as primary store is a good option; Fusion's are just even faste= r. If you've got the typical flatfile bloated schema, then while SSD wi= ll be faster (if you've got the $$$), PCIe is not likely to have suffici= ent capacity. SSD is the reason to refactor to a Dr. Coddian schema. = Few have taken the opportunity. regards, Robert ---- Original = message ---- >Date: Fri, 29 Apr 2011 10:24:48 -0400 >From: pgsql-perfo= rmance-owner@postgresql.org (on behalf of Mark Steben ) >Subject: [PERFORM] FUSION-IO io cards = >To: pgsql-performance@postgresql.org > > Hi, > Had a recent conv= ersation with a tech from this > company called FUSION-IO. They sell > =A0io cards designed to replace conventional disks.=A0 > The card= s can be up to 3 TB in size and apparently > are installed in closer = proximity to the CPU than > the disks are.=A0 They claim > perform= ance boosts several times better than the > spinning disks. > > J= ust wondering if anyone has had any experience with > this company an= d these > cards.=A0 We're currently at postgres 8.3.11.=A0 > > An= y insights / recommendations appreciated.=A0 thank > you, > > -- > > Mark Steben > Database Administrator > @utoRevenue=A0 |=A0 = Autobase=A0 |=A0 AVV > The CRM division of Dominion Dealer Solutions > 95D Ashley Avenue > West Springfield, =A0MA=A0 01089 > t: 413.= 327.3045 > f: 413.732.1824 > w: www.autorevenue.com