From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: RAM Based Disk Drive? |
Date: | 2006-10-31 20:34:10 |
Message-ID: | 4547B342.3000106@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 10/31/06 13:48, Merlin Moncure wrote:
> On 10/31/06, Adam <adam(at)spatialsystems(dot)org> wrote:
>>
>>
>> I recently saw a Hard Disk Drive that is really 4GB of RAM with and SATA
>> 1.5Gb/s serial interface. It's basically a hard disk drive that uses
>> RAM.
>> It also has a battery backup, so if you loose power, you don't loose your
>> data.
>>
>> Has anyone tried using this, and if so was there a noticeable performance
>> increase?
>
> you are talking about the gigabyte i-ram. in the database world, you
> can achieve same thing (actually better) by sticking those ram sticks
> directly on the motherboard assuming you are in a 64 bit environment
> and the motherboard is decent.
>
> the main advantage of the iram that i see is faster boot times (big
> woop). call me when they have a version that does 256gb :-)
OLTP rates are *much* higher with SSDs. (Even with lots of system
RAM, you *still* have to write the data back to the disk, and that
takes time.) But that's only if you've got a small db that needs
*really* high tps rates.
I'd rather spend my money on enough system RAM to keep the active
portion of my DB in the OS cache.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
iD8DBQFFR7NCS9HxQb37XmcRArbfAJ4kLD4488yY/w/iCr66gamukWtO0wCgob05
1DvyBrP4zI2Un8oO9FEaOc0=
=oOuz
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Ben | 2006-10-31 20:49:58 | Re: postgresql and reiserfs |
Previous Message | Lenorovitz, Joel | 2006-10-31 20:20:48 | Trouble with plpgsql generic trigger function using special variables |