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 E06F83A3DD4 for ; Mon, 17 Jan 2005 17:43:57 +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 30828-10 for ; Mon, 17 Jan 2005 17:43:52 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1A2493A3D88 for ; Mon, 17 Jan 2005 17:43:53 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 4AD39313CD; Mon, 17 Jan 2005 18:43:52 +0100 (MET) From: William Yu X-Newsgroups: pgsql.performance Subject: Re: Increasing RAM for more than 4 Gb. using postgresql Date: Mon, 17 Jan 2005 09:43:51 -0800 Organization: Hub.Org Networking Services Lines: 9 Message-ID: References: <1105501768.41e49e484d779@webmail.moph.go.th> <1105837366.41e9bd36c7de9@webmail.moph.go.th> Mime-Version: 1.0 Content-Type: text/plain; charset=TIS-620; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en In-Reply-To: <1105837366.41e9bd36c7de9@webmail.moph.go.th> 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/206 X-Sequence-Number: 9896 amrit@health2.moph.go.th wrote: >>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? Upgrade to 64-bit processors + 64-bit linux.