From: amrit@health2.moph.go.th
To: PGsql-performance <pgsql-performance@postgresql.org>
Cc: @
Cc: @
Cc: @
Subject: Re: Low Performance for big hospital server ..
Date: Tue, 4 Jan 2005 16:31:47 +0700
Message-ID: <1104831107.41da6283add0c@webmail.moph.go.th> (raw)
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
I will put more ram but someone said RH 9.0 had poor recognition on the Ram
above 4 Gb?
Should I close the hyperthreading ? Would it make any differnce between open and
close the hyperthreading?
Thanks for any comment
Amrit
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, @
Subject: Re: Low Performance for big hospital server ..
In-Reply-To: <1104831107.41da6283add0c@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