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 376523A5983 for ; Wed, 12 Jan 2005 11:02:10 +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 97526-09 for ; Wed, 12 Jan 2005 11:01:59 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.207]) by svr1.postgresql.org (Postfix) with ESMTP id DC88E3A5C32 for ; Wed, 12 Jan 2005 11:02:01 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 67so316774wri for ; Wed, 12 Jan 2005 03:02:00 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=lDnBiZMq+w2H+eFw4NNyGWI7Ir4fxLllJfHZjZTHfCeaCM+ps+RWNzWpZLTwjerzMRhfOGiIhwcziyD4dvO7caTP++kRaD0iO/YqI8BGxckkqcHLsGri0us2z/liOXoderjfir8a4og3IGiKTx43TXaazTfBRKvidrqjPuzMfEc= Received: by 10.54.14.37 with SMTP id 37mr63823wrn; Wed, 12 Jan 2005 03:02:00 -0800 (PST) Received: by 10.54.4.50 with HTTP; Wed, 12 Jan 2005 03:02:00 -0800 (PST) Message-ID: <1eae200b050112030256483e37@mail.gmail.com> Date: Wed, 12 Jan 2005 12:02:00 +0100 From: Martin Tedjawardhana Reply-To: Martin Tedjawardhana To: "amrit@health2.moph.go.th" Subject: Re: Increasing RAM for more than 4 Gb. using postgresql Cc: PGsql-performance In-Reply-To: <1105501768.41e49e484d779@webmail.moph.go.th> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <1105501768.41e49e484d779@webmail.moph.go.th> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.082 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP, TO_ADDRESS_EQ_REAL X-Spam-Level: * X-Archive-Number: 200501/147 X-Sequence-Number: 9837 Is that 4GB limit a hardware limitation? If it is, then there is not much you can do except upgrading the server. If the server is capable of handling more than 4GB of ram then you can just upgrade the kernel and enable high memory support (up to 64GB of memory in kernel 2.6.9). There is no need to migrate your distro, but if you do I recommend upgrading your Pgsql too. Martin On Wed, 12 Jan 2005 10:49:28 +0700, amrit@health2.moph.go.th wrote: > I wonder if I would like to increase more RAM from 4 Gb. to 6 Gb. [which I hope > to increase more performance ] and I now I used RH 9 and Pgsql 7.3.2 ON DUAL > Xeon 3.0 server thay has the limtation of 4 Gb. ram, I should use which OS > between FC 2-3 or redhat EL 3 [which was claimed to support 64 Gb.ram] .May I > use FC 2 [which is freely downloaded] with 6 Gb. and PGsql 7.4 ? > Amrit > Thailand > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >