From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Amazon High I/O instances |
Date: | 2012-08-23 15:37:44 |
Message-ID: | CAHyXU0wZjEkKuBOG4RyFH1C22MO6NLoctPuu0fG9y80ahM_Dfw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Aug 22, 2012 at 4:12 PM, Alan Hodgson <ahodgson(at)simkin(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Sachin Srivastava | 2012-08-23 15:40:50 | Re: Cannot Run EnterpriseDB Postgresql Installation |
Previous Message | Merlin Moncure | 2012-08-23 15:17:12 | Re: Performance implications of numeric? |