Re: Using AWS ephemeral SSD storage for production database workload?

2018-01-29 Thread Pritam Barhate
Thanks Ben and Sam for sharing your experience. On Jan 30, 2018 8:52 AM, "Ben Chobot" wrote: > > > On Jan 29, 2018, at 8:05 PM, Sam Gendler > wrote: > > > > Why not use EBS storage, but don’t use provisioned iops SSDs (io1) for > the ebs volume. Just use the default storage type (gp2) and live

Re: Using AWS ephemeral SSD storage for production database workload?

2018-01-29 Thread Pritam Barhate
Thank you, Paul and Steven, for the information. @Paul: Thanks for the link. Planning to read through most of fdr's comments on Hacker News. @Steven: > Q: Why not just use RDS? > It'll be simpler. Already using it for multiple deployments. I am primarily a programmer. But now want to get out o

Re: Using AWS ephemeral SSD storage for production database workload?

2018-01-29 Thread Pritam Barhate
27;s experience. Thanks for all the information. Pritam. On Mon, Jan 29, 2018 at 11:02 PM, Tomas Vondra wrote: > > > On 01/29/2018 05:41 PM, Pritam Barhate wrote: > > Hi everyone, > > > > As you may know, EBS volumes though durable are very costly when you > >

Using AWS ephemeral SSD storage for production database workload?

2018-01-29 Thread Pritam Barhate
Hi everyone, As you may know, EBS volumes though durable are very costly when you need provisioned IOPS. As opposed to this AWS instance attached ephemeral SSD is very fast but isn't durable. I have come across some ideas on the Internet where people hinted at running production PostgreSQL worklo