Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID

Поиск
Список
Период
Сортировка
От Matt Brock
Тема Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID
Дата
Msg-id CA0B71EF-9A18-4B93-9098-ABE2055DCB47@mattbrock.co.uk
обсуждение исходный текст
Ответ на Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (David Boreham <david_list@boreham.org>)
Ответы Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (David Boreham <david_list@boreham.org>)
Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID  (David Boreham <david_list@boreham.org>)
Список 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 по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: authentication/privileges
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Deploying PostgreSQL on CentOS with SSD and Hardware RAID