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 EFBEA3A3D1E for ; Tue, 4 Jan 2005 11:01:43 +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 53529-08 for ; Tue, 4 Jan 2005 11:01:24 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id D64FC3A3C4D for ; Tue, 4 Jan 2005 11:01:24 +0000 (GMT) Received: (qmail 16203 invoked from network); 4 Jan 2005 09:31:48 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 4 Jan 2005 09:31:48 -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 14896-23 for ; Tue, 4 Jan 2005 16:31:48 +0700 (ICT) Received: (qmail 16196 invoked from network); 4 Jan 2005 09:31:47 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 4 Jan 2005 09:31:47 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Tue, 4 Jan 2005 16:31:47 +0700 Message-ID: <1104831107.41da6283add0c@webmail.moph.go.th> Date: Tue, 4 Jan 2005 16:31:47 +0700 From: amrit@health2.moph.go.th To: PGsql-performance Cc: ""@, ""@, ""@ Subject: Re: Low Performance for big hospital server .. 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=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/37 X-Sequence-Number: 9727 Today is the first official day of this weeks and the system run better in serveral points but there are still some points that need to be corrected. Some queries or some tables are very slow. I think the queries inside the programe need to be rewrite. Now I put the sort mem to a little bit bigger: sort mem = 16384 increase the sort mem makes no effect on the slow point eventhough there is little connnection. shared_buffers = 27853 effective cache = 120000 I will put more ram but someone said RH 9.0 had poor recognition on the Ram above 4 Gb? Should I close the hyperthreading ? Would it make any differnce between open and close the hyperthreading? Thanks for any comment Amrit Thailand