Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID - Mailing list pgsql-general

From Matt Brock
Subject Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Date
Msg-id CA0B71EF-9A18-4B93-9098-ABE2055DCB47@mattbrock.co.uk
Whole thread Raw
In response to Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (David Boreham <david_list@boreham.org>)
Responses Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
List pgsql-general
On 10 May 2013, at 16:25, David Boreham <david_list@boreham.org> wrote:

> I've never looked at SLC drives in the past few years and don't know anyone who uses them these days.

Because SLCs are still more expensive? Because MLCs are now almost as good as SLCs for performance/endurance?

I should point out that this database will be the backend for a high-transaction gaming site with very heavy database
usageincluding a lot of writes. Disk IO on the database server has always been our bottleneck so far.  

Also, the database is kept comparatively very small - about 25 GB currently, and it will grow to perhaps 50 GB this
yearas a result of new content and traffic coming in. 

So whilst MLCs might be almost as good as SLCs now, the price difference for us is so insignificant that if we can
stillget a small improvement with SLCs then we might as well do so. 

> Could you post some specific drive models please ? HP probably doesn't make the drives, and it really helps to know
whatdevices you're using since they are not nearly as generic in behavior and features as magnetic drives. 

I've asked our HP dealer for this information since unfortunately it doesn't appear to be available on the HP website -
hopefullyit will be forthcoming at some point. 

Matt.




pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: authentication/privileges
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID