On 5/3/11 11:48 AM, Joel Reymont wrote:
> What are the best practices for setting up PG 9.x on Amazon EC2 to get the best performance?
Yes. Don't use EC2.
There is no "best" performance on EC2. There's not even "good
performance". Basically, EC2 is the platform for when performance
doesn't matter.
Use a dedicated server, or use a better cloud host.
http://it.toolbox.com/blogs/database-soup/how-to-make-your-database-perform-well-on-amazon-ec2-45725
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com