From: Scott Marlowe <smarlowe@g2switchworks.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Luke Lonergan <llonergan@greenplum.com>
Cc: Jim C. Nasby <jnasby@pervasive.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: 1 TB of memory
Date: Fri, 17 Mar 2006 16:07:08 -0600
Message-ID: <1142633228.1141.7.camel@state.g2switchworks.com> (raw)
In-Reply-To: <b42b73150603171328y940b0e5q3027fd46f6331ad7@mail.gmail.com>
References: <20060317173653.GC15742@pervasive.com>
<C0408037.1F6D6%llonergan@greenplum.com>
<b42b73150603171328y940b0e5q3027fd46f6331ad7@mail.gmail.com>
On Fri, 2006-03-17 at 15:28, Merlin Moncure wrote:
> On 3/17/06, Luke Lonergan <llonergan@greenplum.com> wrote:
> > > Now what happens as soon as you start doing random I/O? :)
> > If you are accessing 3 rows at a time from among billions, the problem you
> > have is mostly access time - so an SSD might be very good for some OLTP
> > applications. However - the idea of putting Terabytes of data into an SSD
> > through a thin straw of a channel is silly.
>
> I'll 'byte' on this..right now the price for gigabyte of ddr ram is
> hovering around 60$/gigabyte. If you conveniently leave aside the
> problem of making ddr ram fault tolerant vs making disks tolerant, you
> are getting 10 orders of magnitude faster seek time and unlimited
> bandwidth...at least from the physical device. While SANs are getting
> cheaper they are still fairly expensive at 1-5$/gigabyte depending on
> various factors. You can do the same tricks on SSD storage as with
> disks.
>
> SSD storage is 1-2k$/gigabyte currently, but I think there is huge
> room to maneuver price-wise after the major players recoup their
> investments and market forces kick in. IMO this process is already in
> play and the next cycle of hardware upgrades in the enterprise will be
> updating critical servers with SSD storage. Im guessing by as early
> 2010 a significant percentage of enterpise storage will be SSD of some
> flavor.
Now I'm envisioning building something with commodity 1U servers hold 4
to 16 gigs ram, and interconnected with 1g or 10g ethernet.
Open Source SSD via iSCSI with commodity hardware... hmmm. sounds like
a useful project.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smarlowe@g2switchworks.com, mmoncure@gmail.com, llonergan@greenplum.com, jnasby@pervasive.com
Subject: Re: 1 TB of memory
In-Reply-To: <1142633228.1141.7.camel@state.g2switchworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox