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 A704E3A1993 for ; Sun, 16 Jan 2005 12:00:47 +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 26647-07 for ; Sun, 16 Jan 2005 12:00:40 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 402303A19BC for ; Sun, 16 Jan 2005 12:00:41 +0000 (GMT) Received: (qmail 14098 invoked from network); 16 Jan 2005 01:03:27 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 16 Jan 2005 01:03:27 -0000 Received: from webmail.moph.go.th ([127.0.0.1]) by localhost (webmail.moph.go.th [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 13750-47 for ; Sun, 16 Jan 2005 08:03:24 +0700 (ICT) Received: (qmail 13719 invoked from network); 16 Jan 2005 01:02:47 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 16 Jan 2005 01:02:47 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Sun, 16 Jan 2005 08:02:46 +0700 Message-ID: <1105837366.41e9bd36c7de9@webmail.moph.go.th> Date: Sun, 16 Jan 2005 08:02:46 +0700 From: amrit@health2.moph.go.th To: William Yu Cc: PGsql-performance Subject: Re: Increasing RAM for more than 4 Gb. using postgresql References: <1105501768.41e49e484d779@webmail.moph.go.th> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=TIS-620 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 203.157.100.42 X-Virus-Scanned: by amavisd-new at moph.go.th X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/199 X-Sequence-Number: 9889 > 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. I set shammax = [root@data3 /]# cat < /proc/sys/kernel/shmmax 4000000000 shmall = [root@data3 /]# cat < /proc/sys/kernel/shmall 134217728 Is that ok for 4 Gb. mechine? > 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. > How could I chang this hitting? Thanks Amrit Thailand