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 8937D3A5CB4 for ; Wed, 12 Jan 2005 14:46:06 +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 25607-03 for ; Wed, 12 Jan 2005 14:45:50 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id E53E93A5CD4 for ; Wed, 12 Jan 2005 14:45:46 +0000 (GMT) Received: (qmail 840 invoked from network); 12 Jan 2005 14:48:34 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 12 Jan 2005 14:48:34 -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 32368-25 for ; Wed, 12 Jan 2005 21:48:33 +0700 (ICT) Received: (qmail 832 invoked from network); 12 Jan 2005 14:48:33 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 12 Jan 2005 14:48:33 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Wed, 12 Jan 2005 21:48:33 +0700 Message-ID: <1105541313.41e538c110c38@webmail.moph.go.th> Date: Wed, 12 Jan 2005 21:48:33 +0700 From: amrit@health2.moph.go.th To: Gavin Sherry Cc: PGsql-performance Subject: Re: Increasing RAM for more than 4 Gb. using postgresql References: <1105501768.41e49e484d779@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=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/149 X-Sequence-Number: 9839 > 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. Yes , of course I must try to upgrade PGsql to 7.4 and may be OS to FC 2-3 too. My server products are intel based [mainboard , CPU ,Case , Power supply ,RAID Network card] dual Xeon 32 bit 3.0 Ghz which I consulted Thai intel supervisor and they told me that increasing the ram for more than 4 Gb. may be possible depending on the OS. I ask the programmer who wrote that huge query and they told me that it was the query generated by Delphi 6.0 component and not written by themselve. Amrit Thailand