Re: Amazon High I/O instances

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Amazon High I/O instances
Дата
Msg-id 24475703.qrxd6m0HjB@skynet.simkin.ca
обсуждение исходный текст
Ответ на Re: Amazon High I/O instances  (Andrew Hannon <ahannon@fiksu.com>)
Ответы Re: Amazon High I/O instances  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
On Wednesday, August 22, 2012 04:10:01 PM Andrew Hannon wrote:
> Just looking into High IO instances for a DB deployment. In order to get
> past 1TB, we are looking at RAID-0. I have heard
> (http://hackerne.ws/item?id=4266119) there might be a problem if TRIM isn't
> supported. Does anyone know if it is and has anyone used RAID-0 on these
> instances? (Linux of course…)

Just use LVM striping. If it turns out to be an issue; that seems to be mostly
conjecture.

I note that the SSDs are only instance storage. The data will be gone when the
instance goes away. I have used instance storage in replicated setups but it
always feels rather fragile unless your data really is transient or you can
maintain 2 replicas.

Their other new service, provisioned IOPS for EBS, might be more useful for a
persistent database. Although not nearly SSD speeds, of course.


В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Database Bloat
Следующее
От: Scott Briggs
Дата:
Сообщение: Migrating from 8.3 to 9.1 - date/time storage types do not match