Re: Amazon High I/O instances
От | Merlin Moncure |
---|---|
Тема | Re: Amazon High I/O instances |
Дата | |
Msg-id | CAHyXU0wZjEkKuBOG4RyFH1C22MO6NLoctPuu0fG9y80ahM_Dfw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Amazon High I/O instances (Alan Hodgson <ahodgson@simkin.ca>) |
Список | pgsql-general |
On Wed, Aug 22, 2012 at 4:12 PM, Alan Hodgson <ahodgson@simkin.ca> wrote: > 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. Yeah -- I should have mentioned that: you absolutely must run hs/sr or some other strategy that maintains your data. I guess you might as well turn off fsync, right? merlin
В списке pgsql-general по дате отправления: