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 C342F3A1A78 for ; Wed, 5 Jan 2005 18:25:04 +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 14669-03 for ; Wed, 5 Jan 2005 18:24:44 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id 33F7A3A4187 for ; Wed, 5 Jan 2005 18:22:12 +0000 (GMT) Received: (qmail 19374 invoked from network); 5 Jan 2005 18:21:42 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 5 Jan 2005 18:21:42 -0000 Message-ID: <41DC3047.2030806@fastcrypt.com> Date: Wed, 05 Jan 2005 13:21:59 -0500 From: Dave Cramer Reply-To: pg@fastcrypt.com Organization: Postgres International User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: amrit@health2.moph.go.th Cc: Frank Wiles , PGsql-performance Subject: Re: Low Performance for big hospital server .. References: <1104831107.41da6283add0c@webmail.moph.go.th> <20050104094657.540232d7.frank@wiles.org> <1104939342.41dc094ecb1cf@webmail.moph.go.th> In-Reply-To: <1104939342.41dc094ecb1cf@webmail.moph.go.th> Content-Type: multipart/alternative; boundary="------------080003020207080106010107" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.057 tagged_above=0 required=5 tests=AWL, HTML_30_40, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: X-Archive-Number: 200501/52 X-Sequence-Number: 9742 This is a multi-part message in MIME format. --------------080003020207080106010107 Content-Type: text/plain; charset=TIS-620; format=flowed Content-Transfer-Encoding: 7bit Amrit, can you post explain so we can see what it does ? Dave amrit@health2.moph.go.th wrote: >>>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]. > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend > > > > -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561 --------------080003020207080106010107 Content-Type: text/html; charset=TIS-620 Content-Transfer-Encoding: 7bit Amrit,

can you post

explain <your slow update query>

so we can see what it does ?

Dave

amrit@health2.moph.go.th wrote:
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].

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


  

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
--------------080003020207080106010107--