Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id BE710133798E for ; Tue, 3 May 2011 15:48:48 -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 23370-02 for ; Tue, 3 May 2011 18:48:40 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f50.google.com (mail-ww0-f50.google.com [74.125.82.50]) by mail.postgresql.org (Postfix) with ESMTP id 42B8613364DE for ; Tue, 3 May 2011 15:48:39 -0300 (ADT) Received: by wwc33 with SMTP id 33so385673wwc.19 for ; Tue, 03 May 2011 11:48:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:from:content-type:content-transfer-encoding :subject:date:message-id:to:mime-version:x-mailer; bh=hKsG6a2uojrwLI+jQ37DSziaK+uDK1p8qQV+mxq5ELs=; b=UArzN1jsCupnde7BP0XLVnSkH7QIMsTLsLamxo37Jqvc1uFVUD2hrav4zjXzWnio6f sNJvG6a39Dq5bmTWbiH5zrW2h9Do7OIaJD+Fey7uAFC8+PREKK/6Zu/nV/PXLoEDu9BR lr9P9K2/CPclwE237Rn4MsPE70/znphtWTnlI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:content-type:content-transfer-encoding:subject:date:message-id :to:mime-version:x-mailer; b=p/t0330jB5FDPCFy6hKiPfGKxjbEhtGYRYQuQYrhPjcGgvFTjcJor2SreIpNQFc769 WjvcZDzixeCh8F4x/trn1kmUkVVGHwNVxWmybBmYVG2OoSS919HrzFGARqrOmRzvzGyc +2T11FJ+gw+BUynao51/9ZysO/KXh+2cOKnV8= Received: by 10.216.64.16 with SMTP id b16mr200172wed.5.1304448519128; Tue, 03 May 2011 11:48:39 -0700 (PDT) Received: from [192.168.0.196] ([95.60.213.7]) by mx.google.com with ESMTPS id r80sm194293wei.39.2011.05.03.11.48.37 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 03 May 2011 11:48:37 -0700 (PDT) From: Joel Reymont Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: amazon ec2 Date: Tue, 3 May 2011 19:48:35 +0100 Message-Id: To: pgsql-performance@postgresql.org Mime-Version: 1.0 (Apple Message framework v1084) X-Mailer: Apple Mail (2.1084) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.335 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201105/28 X-Sequence-Number: 43537 What are the best practices for setting up PG 9.x on Amazon EC2 to get = the best performance? Thanks in advance, Joel = --------------------------------------------------------------------------= - for hire: mac osx device driver ninja, kernel extensions and usb = drivers = ---------------------+------------+---------------------------------------= http://wagerlabs.com | @wagerlabs | = http://www.linkedin.com/in/joelreymont = ---------------------+------------+---------------------------------------=