From: amrit@health2.moph.go.th
To: Frank Wiles <frank@wiles.org>
To: PGsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Low Performance for big hospital server ..
Date: Wed, 5 Jan 2005 22:35:42 +0700
Message-ID: <1104939342.41dc094ecb1cf@webmail.moph.go.th> (raw)
In-Reply-To: <20050104094657.540232d7.frank@wiles.org>
References: <1104831107.41da6283add0c@webmail.moph.go.th>
<20050104094657.540232d7.frank@wiles.org>
> > 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].
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: amrit@health2.moph.go.th, frank@wiles.org
Subject: Re: Low Performance for big hospital server ..
In-Reply-To: <1104939342.41dc094ecb1cf@webmail.moph.go.th>
* 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