pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gavin Sherry <swm@alcove.com.au>
To: amrit@health2.moph.go.th
Cc: PGsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Low Performance for big hospital server ..
Date: Tue, 4 Jan 2005 22:13:12 +1100 (EST)
Message-ID: <Pine.LNX.4.58.0501042209170.8934@linuxworld.com.au> (raw)
In-Reply-To: <1104831107.41da6283add0c@webmail.moph.go.th>
References: <1104831107.41da6283add0c@webmail.moph.go.th>

On Tue, 4 Jan 2005 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

Even though others have said otherwise, I've had good results from setting
sort_mem higher -- even if that is per query.

>
> I will put more ram but someone said RH 9.0 had poor recognition on the Ram
> above 4 Gb?

I think they were refering to 32 bit architectures, not distributions as
such.

> Should I close the hyperthreading ? Would it make any differnce between open and
> close the hyperthreading?
> Thanks for any comment

In my experience, the largest performance increases come from intensive
analysis and optimisation of queries. Look at the output of EXPLAIN
ANALYZE for the queries your application is generating and see if they can
be tuned in anyway. More often than not, they can.

Feel free to ask for assistence on irc at irc.freenode.net #postgresql.
People there help optimise queries all day ;-).

> Amrit
> Thailand

Gavin



view thread (38+ messages)  latest in thread

Message-ID: <Pine.LNX.4.58.0501042209170.8934@linuxworld.com.au>
Permalink:  ../Pine.LNX.4.58.0501042209170.8934@linuxworld.com.au/
Also on:    postgresql.org/message-id/Pine.LNX.4.58.0501042209170.8934@linuxworld.com.au

 · 

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: swm@alcove.com.au, amrit@health2.moph.go.th
  Subject: Re: Low Performance for big hospital server ..
  In-Reply-To: <Pine.LNX.4.58.0501042209170.8934@linuxworld.com.au>

* 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