Skip site navigation (1) Skip section navigation (2)

Re: amazon ec2

From: Shaun Thomas <sthomas(at)peak6(dot)com>
To: Joel Reymont <joelr1(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: amazon ec2
Date: 2011-05-04 14:04:18
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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.

Shaun Thomas
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 LaneDate: 2011-05-04 14:12:49
Subject: Re: row estimate very wrong for array type
Previous:From: Denis de BernardyDate: 2011-05-04 13:40:50
Subject: row estimate very wrong for array type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group