On 05/03/2011 01:48 PM, Joel Reymont wrote:
> What are the best practices for setting up PG 9.x on Amazon EC2 to
> get the best performance?
Use EC2 and other Amazon hosting for cloud-based client access only.
Their shared disk services are universally despised by basically
everyone who has tried to use it for database hosting.
The recommended pattern is to have the scalable cloud clients access
(and memcache) a remote DB at a colo or managed services host. EBS is a
nice idea, and probably fine for things like image or video hosting, but
database access, especially for OLTP databases, will just result in
wailing and gnashing of teeth.
Just ask anyone who got bit by the recent EBS failure that spanned
*several* availability zones. For all those clients who thought they
were safe by deploying across multiple ACs, it was a rather rude awakening.
The consensus seems to be that Amazon's cloud is fine... so long as you
stay far, far away from EBS. Apparently that needs a little more work.
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
for terms and conditions related to this email
In response to
- amazon ec2 at 2011-05-03 18:48:35 from Joel Reymont
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2011-05-04 14:12:49|
|Subject: Re: row estimate very wrong for array type |
|Previous:||From: Denis de Bernardy||Date: 2011-05-04 13:40:50|
|Subject: row estimate very wrong for array type|