pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Cramer <pg@fastcrypt.com>
To: amrit@health2.moph.go.th
Cc: Frank Wiles <frank@wiles.org>
Cc: PGsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Low Performance for big hospital server ..
Date: Wed, 05 Jan 2005 13:21:59 -0500
Message-ID: <41DC3047.2030806@fastcrypt.com> (raw)
In-Reply-To: <1104939342.41dc094ecb1cf@webmail.moph.go.th>
References: <1104831107.41da6283add0c@webmail.moph.go.th>
	<20050104094657.540232d7.frank@wiles.org>
	<1104939342.41dc094ecb1cf@webmail.moph.go.th>

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

view thread (38+ messages)  latest in thread

Message-ID: <41DC3047.2030806@fastcrypt.com>
Permalink:  ../41DC3047.2030806@fastcrypt.com/
Also on:    postgresql.org/message-id/41DC3047.2030806@fastcrypt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pg@fastcrypt.com, amrit@health2.moph.go.th, frank@wiles.org
  Subject: Re: Low Performance for big hospital server ..
  In-Reply-To: <41DC3047.2030806@fastcrypt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox