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 F0D043A4157 for ; Wed, 5 Jan 2005 07:27:39 +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 93635-03 for ; Wed, 5 Jan 2005 07:27:14 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 86BC53A18D2 for ; Wed, 5 Jan 2005 07:27:13 +0000 (GMT) Received: (qmail 25136 invoked from network); 5 Jan 2005 05:07:17 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 5 Jan 2005 05:07:17 -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 24977-02 for ; Wed, 5 Jan 2005 12:07:14 +0700 (ICT) Received: (qmail 25079 invoked from network); 5 Jan 2005 05:07:13 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 5 Jan 2005 05:07:13 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Wed, 5 Jan 2005 12:07:13 +0700 Message-ID: <1104901633.41db76016e568@webmail.moph.go.th> Date: Wed, 5 Jan 2005 12:07:13 +0700 From: amrit@health2.moph.go.th To: Gavin Sherry Cc: PGsql-performance Subject: Re: Low Performance for big hospital server .. References: <1104831107.41da6283add0c@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/49 X-Sequence-Number: 9739 > > I will put more ram but someone said RH 9.0 had poor recognition on the Ram > > above 4 Gb? > > I think they were refering to 32 bit architectures, not distributions as > such. Sorry for wrong reason , then should I increase more RAM than 4 Gb. on 32 bit Arche.? > > Should I close the hyperthreading ? Would it make any differnce between > open and > > close the hyperthreading? > > Thanks for any comment > > In my experience, the largest performance increases come from intensive > analysis and optimisation of queries. Look at the output of EXPLAIN > ANALYZE for the queries your application is generating and see if they can > be tuned in anyway. More often than not, they can. So what you mean is that the result is the same whether close or open hyperthreading ? Will it be any harm if I open it ? The main point shiuld be adjustment the query , right. > Feel free to ask for assistence on irc at irc.freenode.net #postgresql. > People there help optimise queries all day ;-). How could I contact with those people ;=> which url ? Thanks again. Amrit Thailand