Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5DB181337C3F for ; Tue, 26 Apr 2011 12:20:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 09791-03-8 for ; Tue, 26 Apr 2011 15:20:42 +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 CFFFF1337C08 for ; Tue, 26 Apr 2011 12:15:46 -0300 (ADT) Received: by wwc33 with SMTP id 33so716805wwc.19 for ; Tue, 26 Apr 2011 08:15:45 -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=hqtZUEnPVMEweuYhHFPPg0Hxqx68thIGLmlTfZGwck0=; b=vgO+C2b0J+8Zu2BiqMSpRFWsk2klTLCkxBHLKVPUghrd/oidA9vD15kjkyT1ZhypAB samDXm+5Hu/CoYIi+beR6RxY+uKfoCQiR4ZClUAx5P5pGAdmKJrePw+a8BWJjm4g1UuK IsNDYO2HILk0iDSncrBxWFgoGDyBCUH6vyOUc= 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=w1Pp6C4+ujlul2oteO3+GzMWqE74IcEuTdW2FypgqHQdREthvzunv9kWbFjjEk0L2Q FAKqQF2pB+4uYtHA97Nz78ib0g/awjrV2UVKKUuVyJQLe0sIkoRqWX+KUQ72uHVUwfcp bYOrgZfYSJ+/RI6BnYMgMvajXrnnZL2r3RzMU= Received: by 10.216.177.4 with SMTP id c4mr2193642wem.3.1303830945408; Tue, 26 Apr 2011 08:15:45 -0700 (PDT) Received: from [192.168.0.196] ([95.60.213.7]) by mx.google.com with ESMTPS id p5sm3912566wbg.11.2011.04.26.08.15.44 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 26 Apr 2011 08:15:44 -0700 (PDT) From: Joel Reymont Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: tuning on ec2 Date: Tue, 26 Apr 2011 16:15:42 +0100 Message-Id: <229BF7C0-E7AB-43CB-BD7D-B8EECEF60430@gmail.com> 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: 201104/355 X-Sequence-Number: 43417 I'm running pgsql on an m1.large EC2 instance with 7.5gb available = memory.=20 The free command shows 7gb of free+cached. My understand from the docs = is that I should dedicate 1.75gb to shared_buffers (25%) and set = effective_cache_size to 7gb.=20 Is this correct? I'm running 64-bit Ubuntu 10.10, e.g.=20 Linux ... 2.6.35-28-virtual #50-Ubuntu SMP Fri Mar 18 19:16:26 UTC 2011 = x86_64 GNU/Linux Thanks, Joel = --------------------------------------------------------------------------= - for hire: mac osx device driver ninja, kernel extensions and usb = drivers = ---------------------+------------+---------------------------------------= http://wagerlabs.com | @wagerlabs | = http://www.linkedin.com/in/joelreymont = ---------------------+------------+---------------------------------------=