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 BE7FF3A4ADA for ; Wed, 5 Jan 2005 17:23: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 87548-08 for ; Wed, 5 Jan 2005 17:22:43 +0000 (GMT) Received: by svr1.postgresql.org (Postfix, from userid 1001) id 4756C3A5569; Wed, 5 Jan 2005 17:56: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 8EB183A4CD9 for ; Wed, 5 Jan 2005 16:26:22 +0000 (GMT) Received: (qmail 16773 invoked from network); 5 Jan 2005 15:35:46 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 5 Jan 2005 15:35:46 -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 13602-66 for ; Wed, 5 Jan 2005 22:35:45 +0700 (ICT) Received: (qmail 16765 invoked from network); 5 Jan 2005 15:35:45 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 5 Jan 2005 15:35:45 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Wed, 5 Jan 2005 22:35:42 +0700 Message-ID: <1104939342.41dc094ecb1cf@webmail.moph.go.th> Date: Wed, 5 Jan 2005 22:35:42 +0700 From: amrit@health2.moph.go.th To: Frank Wiles , PGsql-performance Subject: Re: Low Performance for big hospital server .. References: <1104831107.41da6283add0c@webmail.moph.go.th> <20050104094657.540232d7.frank@wiles.org> In-Reply-To: <20050104094657.540232d7.frank@wiles.org> 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/51 X-Sequence-Number: 9741 > > 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 > If I were you I would upgrade from RH 9 to Fedora Core 2 or 3 after > some initial testing. You'll see a huge improvement of speed on the > system as a whole. I would try turning hyperthreading off also. Now I turn hyperthreading off and readjust the conf . I found the bulb query that was : update one flag of the table [8 million records which I think not too much] .When I turned this query off everything went fine. I don't know whether update the data is much slower than insert [Postgresql 7.3.2] and how could we improve the update method? Thanks for many helps. Amrit Thailand NB. I would like to give my appreciation to all of the volunteers from many countries who combat with big disaster [Tsunamies] in my country [Thailand].