pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@coretech.co.nz>
To: amrit@health2.moph.go.th
Cc: pgsql-performance@postgresql.org
Subject: Re: Low Performance for big hospital server ..
Date: Sun, 02 Jan 2005 22:23:45 +1300
Message-ID: <41D7BDA1.7000109@coretech.co.nz> (raw)
In-Reply-To: <1104634472.41d762681b548@webmail.moph.go.th>
References: <1104634472.41d762681b548@webmail.moph.go.th>

amrit@health2.moph.go.th wrote:

>I try to adjust my server for a couple of weeks with some sucess but it still
>slow when the server has stress in the moring from many connection . I used
>postgresql 7.3.2-1 with RH 9 on a mechine of 2 Xeon 3.0 Ghz and ram of 4 Gb.
>Since 1 1/2 yr. when I started to use the database server after optimizing the
>postgresql.conf everything went fine until a couple of weeks ago , my database
>grew up to 3.5 Gb and there were more than 160 concurent connections.
>The server seemed to be slower in the rush hour peroid than before . There
>is some swap process too. My top and meminfo are shown here below:
>  
>
You might just be running low on ram - your sort_mem setting means that
160 connections need about 3.1G. Add to that the 256M for your
shared_buffers and there may not be much left for the os to use
effectively (this could explain the fact that some swap is being used).

Is reducing sort_mem an option ?

regards

Mark




view thread (38+ messages)  latest in thread

Message-ID: <41D7BDA1.7000109@coretech.co.nz>
Permalink:  ../41D7BDA1.7000109@coretech.co.nz/
Also on:    postgresql.org/message-id/41D7BDA1.7000109@coretech.co.nz

 · 

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: markir@coretech.co.nz, amrit@health2.moph.go.th
  Subject: Re: Low Performance for big hospital server ..
  In-Reply-To: <41D7BDA1.7000109@coretech.co.nz>

* 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