Re: SSD + RAID

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Laszlo Nagy <gandalf(at)shopzeus(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SSD + RAID
Date: 2009-11-13 15:36:51
Message-ID: 4AFD7D13.7010001@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Laszlo Nagy wrote:
> * I need at least 32GB disk space. So DRAM based SSD is not a real
> option. I would have to buy 8x4GB memory, costs a fortune. And
> then it would still not have redundancy.

At 32GB database size, I'd seriously consider just buying a server with
a regular hard drive or a small RAID array for redundancy, and stuffing
16 or 32 GB of RAM into it to ensure everything is cached. That's tried
and tested technology.

I don't know how you came to the 32 GB figure, but keep in mind that
administration is a lot easier if you have plenty of extra disk space
for things like backups, dumps+restore, temporary files, upgrades etc.
So if you think you'd need 32 GB of disk space, I'm guessing that 16 GB
of RAM would be enough to hold all the hot data in cache. And if you
choose a server with enough DIMM slots, you can expand easily if needed.

Just my 2 cents, I'm not really an expert on hardware..

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

  • SSD + RAID at 2009-11-13 12:46:15 from Laszlo Nagy

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2009-11-13 15:59:03 Re: SSD + RAID
Previous Message Merlin Moncure 2009-11-13 15:29:43 Re: SSD + RAID