Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 6270F1337BD1 for ; Sat, 23 Apr 2011 16:24:13 -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 50603-05 for ; Sat, 23 Apr 2011 19:24:06 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yx0-f174.google.com (mail-yx0-f174.google.com [209.85.213.174]) by mail.postgresql.org (Postfix) with ESMTP id 4619C1337B93 for ; Sat, 23 Apr 2011 16:24:06 -0300 (ADT) Received: by yxs7 with SMTP id 7so356137yxs.19 for ; Sat, 23 Apr 2011 12:24:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:references:in-reply-to:mime-version :content-transfer-encoding:content-type:message-id:cc:x-mailer:from :subject:date:to; bh=rBpzXvNdbLm8kYRxgeAsbTOVynZHIoblQcJcnpv3QQg=; b=uBI4NlTalQACM8eQhKhrXGlYgspWXFneliCuVefGYhJgHtsSiQ/UAcF5yrVYDlnr5F d0A0lxMj0jU3ibPQSMFlyq4QNwM64dTWTStgUZ6cQIEtQnJg8MLkJ/eaiYE+/LhoVbW7 vaEHM91QDCvC7ph7THkfNuSxeWOdo9ZpVU7mQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=references:in-reply-to:mime-version:content-transfer-encoding :content-type:message-id:cc:x-mailer:from:subject:date:to; b=G6NKOxHpREqOvD/2BWhusvtRC8CX0AdhBaCoCXNXtePlfzDvau16LbupisLAeg5W7Q oKQmVugPwSqLau1pqRBVAtcBeFGWwjBk2MnkdA1/wTT3kronFuKKLoS2hpxcWsqmJ0pw MBMx840/MMYbd0vdccktbiETVQlmsJ2MCi3MQ= Received: by 10.236.106.195 with SMTP id m43mr2476556yhg.202.1303586645657; Sat, 23 Apr 2011 12:24:05 -0700 (PDT) Received: from [10.4.195.72] ([198.228.194.51]) by mx.google.com with ESMTPS id c38sm4009612anc.18.2011.04.23.12.23.50 (version=TLSv1/SSLv3 cipher=OTHER); Sat, 23 Apr 2011 12:24:05 -0700 (PDT) References: In-Reply-To: Mime-Version: 1.0 (iPhone Mail 8A293) Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Message-Id: Cc: David Rees , "pgsql-performance@postgresql.org" X-Mailer: iPhone Mail (8A293) From: Robert Haas Subject: Re: oom_killer Date: Sat, 23 Apr 2011 15:24:28 -0400 To: Tory M Blue X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.897 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, MIME_QP_LONG_LINE=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201104/333 X-Sequence-Number: 43395 On Apr 22, 2011, at 2:22 PM, Tory M Blue wrote: > Thanks David and I have and in fact I do see spikes that would cause > my system to run out of memory, but one thing I'm struggling with is > my system always runs at the limit. It's the nature of linux to take > all the memory and manage it.=20 One thing to watch is the size of the filesystem cache. Generally as the sys= tem comes under memory pressure you will see the cache shrink. Not sure what= is happening on your system, but typically when it gets down to some minima= l size, that's when the swapping starts. ...Robert=