Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 21E051337B93 for ; Tue, 3 May 2011 18:39:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 97852-08 for ; Tue, 3 May 2011 21:39:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp-4.01.com (smtp-4.01.com [38.102.63.183]) by mail.postgresql.org (Postfix) with ESMTP id 6BDBC1337B69 for ; Tue, 3 May 2011 18:39:29 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-4.01.com (Postfix) with ESMTP id 7EC205B895 for ; Tue, 3 May 2011 16:39:29 -0500 (CDT) Received: from smtp-4.01.com ([127.0.0.1]) by localhost (smtp-4.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id JZYed6ZmoM6h for ; Tue, 3 May 2011 16:39:29 -0500 (CDT) Received: by smtp-4.01.com (Postfix, from userid 99) id 6573D5B89E; Tue, 3 May 2011 16:39:29 -0500 (CDT) Received: from Sidney-Stratton.local (70-36-143-243.dsl.dynamic.sonic.net [70.36.143.243]) by smtp-4.01.com (Postfix) with ESMTPSA id 1965A5B89A for ; Tue, 3 May 2011 16:39:29 -0500 (CDT) Message-ID: <4DC0760B.4060501@agliodbs.com> Date: Tue, 03 May 2011 14:39:23 -0700 From: Josh Berkus Organization: PostgreSQL Experts Inc. User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: amazon ec2 References: In-Reply-To: X-Enigmail-Version: 1.1.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/35 X-Sequence-Number: 43544 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