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 8856F3A5CAB for ; Wed, 12 Jan 2005 12:45:03 +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 12715-05 for ; Wed, 12 Jan 2005 12:44:53 +0000 (GMT) Received: from linuxworld.com.au (unknown [203.34.46.50]) by svr1.postgresql.org (Postfix) with ESMTP id 6DA063A5C7D for ; Wed, 12 Jan 2005 12:44:54 +0000 (GMT) Received: from linuxworld.com.au (IDENT:swm@localhost.localdomain [127.0.0.1]) by linuxworld.com.au (8.13.2/8.13.2) with ESMTP id j0CCitGR006739; Wed, 12 Jan 2005 23:44:55 +1100 Received: from localhost (swm@localhost) by linuxworld.com.au (8.13.2/8.13.2/Submit) with ESMTP id j0CCitrf006736; Wed, 12 Jan 2005 23:44:55 +1100 X-Authentication-Warning: linuxworld.com.au: swm owned process doing -bs Date: Wed, 12 Jan 2005 23:44:55 +1100 (EST) From: Gavin Sherry X-X-Sender: swm@linuxworld.com.au To: amrit@health2.moph.go.th Cc: PGsql-performance Subject: Re: Increasing RAM for more than 4 Gb. using postgresql In-Reply-To: <1105501768.41e49e484d779@webmail.moph.go.th> Message-ID: References: <1105501768.41e49e484d779@webmail.moph.go.th> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/148 X-Sequence-Number: 9838 On Wed, 12 Jan 2005 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 ? 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. So, try 7.4 before the memory upgrade. If you still have performance issues, try optimising your queries. As I mentioned before, you can join the #postgresql channel on irc.freenode.net and we can assist. Gavin > Amrit > Thailand Gavin