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 119A53A5CB4 for ; Wed, 12 Jan 2005 12:40:20 +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 11153-10 for ; Wed, 12 Jan 2005 12:40:04 +0000 (GMT) Received: from linuxworld.com.au (unknown [203.34.46.50]) by svr1.postgresql.org (Postfix) with ESMTP id 0B4523A51E2 for ; Wed, 12 Jan 2005 12:40:06 +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 j0CCe3SX006700; Wed, 12 Jan 2005 23:40:03 +1100 Received: from localhost (swm@localhost) by linuxworld.com.au (8.13.2/8.13.2/Submit) with ESMTP id j0CCe3mj006697; Wed, 12 Jan 2005 23:40:03 +1100 Date: Wed, 12 Jan 2005 23:40:03 +1100 (EST) From: Gavin Sherry 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/178 X-Sequence-Number: 9868 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 ? > Amrit > Thailand 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