Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5F8AE633A06 for ; Wed, 3 Feb 2010 16:41:09 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77247-02 for ; Wed, 3 Feb 2010 20:40:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f220.google.com (mail-fx0-f220.google.com [209.85.220.220]) by mail.postgresql.org (Postfix) with ESMTP id 8737D6333E5 for ; Wed, 3 Feb 2010 16:40:58 -0400 (AST) Received: by fxm20 with SMTP id 20so1768179fxm.21 for ; Wed, 03 Feb 2010 12:40:57 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=uVkhGNfcnENQERj69bBAni/XODsinRcACY4lw4yCfUY=; b=JOxV26f0v3u0+a/T9M/SFb/DRFDo43vwN6efhfRnxpZ7VU/DDHLRnQxRwgudmJe3RV nOa57LI7fz22yN15e2Dc/ZS9F+V+7SxDMn/DFEgltBXKoAk0VxjNcEZQhG5vSUzCYy7F Ne9VHSNYKB1YfVwLYlM5wQLoXx0zr73v/VlQ8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=AjUJFgZIiRFk+0fXMIUVU/1+drGAxBeOfBvsa07pyvkETZWheLgIczCoHkUr9uMv1R aauWF9vwqR2uLX8LukdQOKarp4JfBk44RvxtbV+cfb6wIBBdIleUvqupMj61Pc7MAWyG a33Kfm7X2ibf/1tdxt1lL19JzODsr+Wco/wJc= MIME-Version: 1.0 Received: by 10.239.186.1 with SMTP id e1mr7323hbh.169.1265229656180; Wed, 03 Feb 2010 12:40:56 -0800 (PST) In-Reply-To: <4B688F76.9010002@squeakycode.net> References: <4B6878DF.3000004@yahoo.com> <4B688F76.9010002@squeakycode.net> Date: Wed, 3 Feb 2010 15:40:56 -0500 Message-ID: <603c8f071002031240p2cd5ad38y691fcc8ecbbd4672@mail.gmail.com> Subject: Re: System overload / context switching / oom, 8.3 From: Robert Haas To: Andy Colson Cc: Rob , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/67 X-Sequence-Number: 37488 On Tue, Feb 2, 2010 at 3:47 PM, Andy Colson wrote: >> effective_cache_size =3D 5000MB > > I see your running a 32bit, but with bigmem support, but still, one proce= ss > is limited to 4gig. =A0You'd make better use of all that ram if you switc= hed > to 64bit. =A0And this cache, I think, would be limited to 4gig. Just to be clear, effective_cache_size does not allocate any memory of any kind, in any way, ever... ...Robert