Re: Synchronous replication + Fusion-io = waste of money OR significant performance boost? (compared to normal SATA-based SSD-disks)?

From: Ondrej Ivanič <ondrej(dot)ivanic(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: dennis jenkins <dennis(dot)jenkins(dot)75(at)gmail(dot)com>
Subject: Re: Synchronous replication + Fusion-io = waste of money OR significant performance boost? (compared to normal SATA-based SSD-disks)?
Date: 2012-03-08 22:59:22
Message-ID: CAM6mieL2wXWadKO1kdG0Mp9xpCp62t5rOo6YRcW6BuxRsHchMQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On 9 March 2012 02:23, dennis jenkins <dennis(dot)jenkins(dot)75(at)gmail(dot)com> wrote:
> I've also looked at the Fusion-IO products.  They are not standard
> flash drives.  They don't appear as SATA devices.  They contains an
> FPGA that maps the flash directly to the PCI bus.  The kernel-mode
> drivers blits data to/from them via DMA, not a SATA or SAS drive (that
> would limit transfer rates to 6Gb/s).
>
> But, I don't have any in-hand to test with yet... :(  But the
> kool-aide looks tasty :)

I think they are good investment but we wasn't able to use them because:
- iodrive was small (1.2TB only) and not very scalable in long term --
not enough PCIE slots
- iodrive duo/octal needs more power and cooling than we had
You can workaround both by upgrading server (two of them, HA) but you
just delay the situation when you can't insert new card (no slots or
power available).

Performance wise, we were able to reduce query time
- from few seconds to instant (500ms and better)
- any query exceeding 300sec (apache timeout) finished under minute

--
Ondrej Ivanic
(ondrej(dot)ivanic(at)gmail(dot)com)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ondrej Ivanič 2012-03-09 00:01:47 Re: how to return the last inserted identity column value
Previous Message Simon Riggs 2012-03-08 22:05:14 Re: Call for Google Summer of Code (GSoC) 2012: Project ideas?