X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 42A473A4E7E for ; Thu, 13 Jan 2005 16:34:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65301-09 for ; Thu, 13 Jan 2005 16:34:15 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7C62B3A455F for ; Thu, 13 Jan 2005 16:34:14 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 8DFF331988; Thu, 13 Jan 2005 17:34:12 +0100 (MET) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: Increasing RAM for more than 4 Gb. using postgresql Date: Thu, 13 Jan 2005 08:32:49 -0800 Organization: Hub.Org Networking Services Lines: 14 Message-ID: References: <1105501768.41e49e484d779@webmail.moph.go.th> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.5) Gecko/20041217 X-Accept-Language: en-us, en In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200501/171 X-Sequence-Number: 9861 Gavin Sherry wrote: > There is no problem with free Linux distros handling > 4 GB of memory. The > problem is that 32 hardware must make use of some less than efficient > mechanisms to be able to address the memory. The theshold for using PAE is actually far lower than 4GB. 4GB is the total memory address space -- split that in half for 2GB for userspace, 2GB for kernel. The OS cache resides in kernel space -- after you take alway the memory allocation for devices, you're left with a window of roughly 900MB. Since the optimal state is to allocate a small amount of memory to Postgres and leave a huge chunk to the OS cache, this means you are already hitting the PAE penalty at 1.5GB of memory.