Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7BEF0634931 for ; Fri, 20 Mar 2009 16:02:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 56658-01-10 for ; Fri, 20 Mar 2009 16:02:15 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f174.google.com (mail-fx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 07D2E6357A8 for ; Fri, 20 Mar 2009 16:01:11 -0300 (ADT) Received: by fxm22 with SMTP id 22so1520567fxm.19 for ; Fri, 20 Mar 2009 12:01:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:sender:received:in-reply-to :references:date:x-google-sender-auth:message-id:subject:from:to:cc :content-type:content-transfer-encoding; bh=hcYquBn2KQNvZDbeW5qUA4yj2OWowflJhyTX+1LJHJU=; b=t5BCiHwvCRc9KzIutFKUaF0vVSLAEGXeFssbCT+cXR3E7gab7p7VbR8+N7d2UgWUuD B8BfOGb8gtKPP1PBfAsI2Nt9WmDRBhSCYGfdNjrW2gE1UqzizRIN+YMWemvPg40nXKDM vYtRYyeNOnLWaNR0ctb71i6qKavnxrT2/kL1M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type :content-transfer-encoding; b=flgoqbqm2tpKeK1gV/DkkxhM69PPF2eoirAFeLWZpqXhr/amy74txK+z9oR8wfKFqm J3iaADIAKLxzdjFUJmfeW0j51UIC2MgT1iODMGmE0qtx8Ba3GCiaW8kaHKBIQ3ZmAJ5j vzJYH82MyyIz5rO3/E4rLA3YzITIYGrwqezlM= MIME-Version: 1.0 Received: by 10.223.108.15 with SMTP id d15mr3518619fap.62.1237575665187; Fri, 20 Mar 2009 12:01:05 -0700 (PDT) In-Reply-To: <8a1bfe660903121432k153f7c8u3f86c1ae4b7f1551@mail.gmail.com> References: <7d10d2df0903111227g2e40e742g5992cba5158dd4d2@mail.gmail.com> <3401.1236804370@sss.pgh.pa.us> <7d10d2df0903111542o53abb3dbvfc405a597e4c9fa8@mail.gmail.com> <8a1bfe660903121432k153f7c8u3f86c1ae4b7f1551@mail.gmail.com> Date: Fri, 20 Mar 2009 19:01:05 +0000 X-Google-Sender-Auth: 42368324d48f36b9 Message-ID: <7d10d2df0903201201x470bdbb9gfdee702a4157f31b@mail.gmail.com> Subject: Re: Full statement logging problematic on larger machines? From: Frank Joerdens To: Laurent Laborde Cc: 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=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/297 X-Sequence-Number: 33219 On Thu, Mar 12, 2009 at 9:32 PM, Laurent Laborde wrot= e: > On Wed, Mar 11, 2009 at 11:42 PM, Frank Joerdens wrot= e: >> >> effective_cache_size =A0 =A0 =A0 =A0 =A0 =A0=3D 4GB > > Only 4GB with 64GB of ram ? I'd been overly cautious lately with config changes as it's been difficult to argue for downtime and associated service risk. Changed it to 48 GB now since it doesn't require a restart which I'd missed. Thanks for spotting! Regards, Frank