Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-08 Thread David Boreham
On 4/8/2013 3:15 AM, Vincent Veyron wrote: Could someone explain to me the point of using an AWS instance in the case of the OP, whose site is apparently very busy, versus renting a bare metal server in a datacenter? I am the OP, but I can't provide a complete answer, since personally (e.g. a

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-08 Thread Ben Chobot
On Apr 8, 2013, at 2:15 AM, Vincent Veyron wrote: > Could someone explain to me the point of using an AWS instance in the > case of the OP, whose site is apparently very busy, versus renting a > bare metal server in a datacenter? Well, at least in my experience, you don't go to AWS because the da

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-08 Thread Vincent Veyron
Le dimanche 07 avril 2013 à 11:19 -0700, Ben Chobot a écrit : > > Overall I won't say that you can get amazing DB performance inside > AWS, but you can certainly get reasonable performance with enough > PIOPs volumes and memory, and while the on-demand cost is absurd > compared to what you can bu

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread Tomas Vondra
On 7.4.2013 19:43, David Boreham wrote: > > I thanks very much for your detailed response. A few answers below inline: > > On 4/7/2013 9:38 AM, Tomas Vondra wrote: >> As for the performance, AFAIK the EBS volumes always had, and probably >> will have, a 32 MB/s limit. Thanks to caching, built int

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread Ben Chobot
On Apr 6, 2013, at 6:51 PM, David Boreham wrote: > First I need to say that I'm asking this question on behalf of "a friend", > who asked me what I thought on the subject -- I host all the databases > important to me and my livelihood, on physical machines I own outright. That > said, I'm curi

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread David Boreham
I thanks very much for your detailed response. A few answers below inline: On 4/7/2013 9:38 AM, Tomas Vondra wrote: As for the performance, AFAIK the EBS volumes always had, and probably will have, a 32 MB/s limit. Thanks to caching, built into the EBS, the performance may seem much better ini

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-07 Thread Tomas Vondra
Hi David, On 7.4.2013 03:51, David Boreham wrote: > > First I need to say that I'm asking this question on behalf of "a > friend", who asked me what I thought on the subject -- I host all the > databases important to me and my livelihood, on physical machines I own > outright. That said, I'm curi

[GENERAL] Hosting PG on AWS in 2013

2013-04-06 Thread David Boreham
First I need to say that I'm asking this question on behalf of "a friend", who asked me what I thought on the subject -- I host all the databases important to me and my livelihood, on physical machines I own outright. That said, I'm curious as to the current thinking on a) whether it is wise,