Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9A74C6310AC for ; Tue, 6 Jan 2009 23:46:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23303-05 for ; Tue, 6 Jan 2009 23:46:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f19.google.com (mail-bw0-f19.google.com [209.85.218.19]) by mail.postgresql.org (Postfix) with ESMTP id 4279062DBE4 for ; Tue, 6 Jan 2009 23:46:25 -0400 (AST) Received: by bwz12 with SMTP id 12so22339161bwz.19 for ; Tue, 06 Jan 2009 19:46:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:sender :to:subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references :x-google-sender-auth; bh=Ee0TnW5YwIdpHeuh96vElQ42Q0KXxvv5l1nGO9Da9lI=; b=BQ2G9K1n9DO2S+oKuFw3glC25toxSmSdsCO4RM+kT0LkRH3x3CT599mRUFdV7hxz61 3K3gWo4LzNWNqCcXVj+2TIfbw25quLp68IIxcqGFp5iy5cCff+kBeLIylcIy35p2/fCA uF22HsWJgC6O5zpDG8+/d3Pzqy37RznyILpg0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references:x-google-sender-auth; b=Pz+wSJ6WWDDzixq5H2Q5mH7MfNH0jc7gMhsHmZGBag7Fvi3Rst+mXnaju/licrkCtJ pz/h5cTEOAuZ59nnrLrRIu3fvQng0OY8v2IprF6qBBcV2AwH10BTWa9iCpqTa9G+0bHQ 4Nw7BCFbSelBmPp5QxCvVPiDMil4pZu2Gz46A= Received: by 10.223.108.71 with SMTP id e7mr5359866fap.33.1231299982600; Tue, 06 Jan 2009 19:46:22 -0800 (PST) Received: by 10.223.114.198 with HTTP; Tue, 6 Jan 2009 19:46:22 -0800 (PST) Message-ID: <7d10d2df0901061946g4e55fe42g99cb7d7c166b17ab@mail.gmail.com> Date: Wed, 7 Jan 2009 04:46:22 +0100 From: "Frank Joerdens" To: "Tom Lane" Subject: Re: Memory Allocation (8 GB shared buffer limit on Ubuntu Hardy) Cc: "Ryan Hansen" , pgsql-performance@postgresql.org, "Nic Ferrier" , "Mike Rogers" , "Karl Tilbury" In-Reply-To: <15854.1231294993@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7d10d2df0901061820v29755576p75a92bd1282f34c2@mail.gmail.com> <15854.1231294993@sss.pgh.pa.us> X-Google-Sender-Auth: 074f6f591871ddc3 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: 200901/21 X-Sequence-Number: 32300 On Wed, Jan 7, 2009 at 3:23 AM, Tom Lane wrote: > "Frank Joerdens" writes: >> then I take the request size value from the error and do >> echo 8810725376 > /proc/sys/kernel/shmmax >> and get the same error again. > > What about shmall? Yes that works, it was set to root@db04:~# cat /proc/sys/kernel/shmall 2097152 root@db04:~# getconf PAGE_SIZE 4096 which is 2097152 * 4096 = 85899345920 (presumably a Ubuntu default), i.e. slightly less than the required shmmax, which explains why 7 GB works but 8 doesn't. 8810725376 / 4096 = 2151056 would appear to be right, and indeed after doing root@db04:~# echo 2151056 > /proc/sys/kernel/shmall it works. Thanks! Frank