Re: Clarification on some settings - Mailing list pgsql-performance

From Greg Copeland
Subject Re: Clarification on some settings
Date
Msg-id 1084480091.2227.20.camel@shrew.copelandconsulting.net
Whole thread Raw
In response to Re: Clarification on some settings  (Doug Y <dylists@ptd.net>)
List pgsql-performance
On Thu, 2004-05-13 at 14:42, Doug Y wrote:


> We don't seem to be swapping much:
>

Linux aggressively swaps.  If you have any process in memory which is
sleeping a lot, Linux may actively attempt to page it out.  This is true
even when you are not low on memory.  Just because you see some swap
space being used, does not mean that your actively running processes are
causing your system to swap.

I didn't catch what kernel version you are running, so I'm tossing this
out there.  Depending on the kernel (I believe 2.6+, but there may be
something like it in older kernels) that you are running, you can
attempt to tune this buy setting a value of 0-100 in
/proc/sys/vm/swappiness.  The higher the number, the more aggressive the
kernel will attempt to swap.  Some misc. kernel patches attempt to
dynamically tune this parameter.

For a dedicated DB server, a higher number will probably be better.
This is because it should result in the most cache being available to
the system.  This, of course means, you may have to wait an tad bit long
when you ssh into the system, assuming sshd was swapped out.  I think
you get the idea.


> Swap: 1052248K av,    1092K used, 1051156K free                 1465112K cached
>
> looks like at some point it did swap a little, but from running vmstat, I
> can't seem to catch it actively swapping.
>

Chances are, you have some dormant process which is partially or
completely paged out.

For an interesting read on Linux and swapping, you can find out more
here:  http://kerneltrap.org/node/view/3080.

Cheers!

--
Greg Copeland, Owner
greg@copelandconsulting.net
Copeland Computer Consulting
940.206.8004



pgsql-performance by date:

Previous
From: Doug Y
Date:
Subject: Re: Clarification on some settings
Next
From: James Thornton
Date:
Subject: Re: Quad processor options - summary