From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | amrit(at)health2(dot)moph(dot)go(dot)th |
Cc: | Frank Wiles <frank(at)wiles(dot)org>, PGsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Low Performance for big hospital server .. |
Date: | 2005-01-05 18:21:59 |
Message-ID: | 41DC3047.2030806@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Amrit,
can you post
explain <your slow update query>
so we can see what it does ?
Dave
amrit(at)health2(dot)moph(dot)go(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffrey Tenny | 2005-01-05 19:09:11 | Null integer columns |
Previous Message | amrit | 2005-01-05 15:35:42 | Re: Low Performance for big hospital server .. |