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 that 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 faster. If you've got the typical flatfile bloated schema, then while SSD will be faster (if you've got the $$$), PCIe is not likely to have sufficient 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-performance-owner@xxxxxxxxxxxxxx (on behalf of Mark Steben <mark.steben@xxxxxxxxxxxxxxx>) >Subject: FUSION-IO io cards >To: pgsql-performance@xxxxxxxxxxxxxx > > Hi, > Had a recent conversation with a tech from this > company called FUSION-IO. They sell > io cards designed to replace conventional disks. > The cards can be up to 3 TB in size and apparently > are installed in closer proximity to the CPU than > the disks are. They claim > performance boosts several times better than the > spinning disks. > > Just wondering if anyone has had any experience with > this company and these > cards. We're currently at postgres 8.3.11. > > Any insights / recommendations appreciated. thank > you, > > -- > > Mark Steben > Database Administrator > @utoRevenue | Autobase | AVV > The CRM division of Dominion Dealer Solutions > 95D Ashley Avenue > West Springfield, MA 01089 > t: 413.327.3045 > f: 413.732.1824 > w: www.autorevenue.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
