Re: Still problems with memory swapping and server load - Mailing list pgsql-general

Hi,

-- Markus Wollny <Markus.Wollny@computec.de> wrote:

> Mem:  1029400K av, 1023264K used,    6136K free,       0K shrd,    7176K
> buff

you use still too much RAM, there are only 7 MB left for OS caching, this
is really not enough!


> shared_buffers = 32768

256 MB shared memory; this might OK, if you don't use other large
applications (e.g. a big mod_perl enabled Apache).


> sort_mem = 8192 (16384 or 32768 didn't help either)

Each sort can take up to 8 MB RAM; if you have some queries which needs
e.g. 3 big sorts and have 30 from this in parallel, this takes ~720 MB RAM.


Try to reduce a) memory consumption of other applications, b) Memory
consumption of postgres: if you have a lot of big sorts, try to reduce them
in your application or reduce sort_mem; also 20000 shared buffers is mostly
enough.

Also, sorting buffers on disk should be NOT an a RAID 5 array (slow(er)
writes).


With my experience, the BIOS should at least have 200 MB Cache on a 1 GB
Machine.


Ciao
  Alvar, Just my ideas ... :-)

--
// Unterschreiben!      http://www.odem.org/informationsfreiheit/
// Internet am Telefon: http://www.teletrust.info/
// Das freieste Medium? http://www.odem.org/insert_coin/
// Blaster:             http://www.assoziations-blaster.de/