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 B7C2E3A3DF0 for ; Mon, 17 Jan 2005 23:15:01 +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 79218-06 for ; Mon, 17 Jan 2005 23:14:48 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 0F01D3A3EF9 for ; Mon, 17 Jan 2005 23:14:48 +0000 (GMT) Received: (qmail 16512 invoked from network); 17 Jan 2005 23:17:30 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 17 Jan 2005 23:17:30 -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 14774-63 for ; Tue, 18 Jan 2005 06:17:29 +0700 (ICT) Received: (qmail 16503 invoked from network); 17 Jan 2005 23:17:29 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 17 Jan 2005 23:17:29 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Tue, 18 Jan 2005 06:17:29 +0700 Message-ID: <1106003849.41ec4789089f1@webmail.moph.go.th> Date: Tue, 18 Jan 2005 06:17:29 +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> <1105837366.41e9bd36c7de9@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=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/215 X-Sequence-Number: 9905 > >>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 change this hitting? > > Upgrade to 64-bit processors + 64-bit linux. Does the PAE help linux in handling the memory of more than 4 Gb limit in 32 bit archetech ? My intel server board could handle the mem of 12 Gb [according to intel spec.] and if I use Fedora C2 with PAE , will it useless for mem of more than >4Gb.? Any comment please? Amrit Thailand