Re: Swapping - Mailing list pgsql-performance

From Tobias Brox
Subject Re: Swapping
Date
Msg-id 20050831193317.GD5736@tobias.lan
Whole thread Raw
In response to Re: Swapping  (Tobias Brox <tobias@nordicbet.com>)
List pgsql-performance
[Tobias Brox - Wed at 09:22:17PM +0200]
> I'd trust linux to handle swap/cache sensibly.  Eventually, become involved
> with kernel hacking ;-)

Of course, there are also some files in /proc/sys/vm that you may want to
peek into, for tuning the swapping.  Particularly, at later 2.6-kernels (I'm
running 2.6.12) you have the file /proc/sys/vm/swappiness, where the number
should be some percentage.  I'm not completely sure how it works, but I
suppose that the higher you set it, the more likely it is to swap out
memory not beeing used.  I think the default setting is probably sane, but
you may want to google a bit about it.

--
Notice of Confidentiality: This email is sent unencrypted over the network,
and may be stored on several email servers; it can be read by third parties
as easy as a postcard.  Do not rely on email for confidential information.

pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: Swapping
Next
From: Richard Huxton
Date:
Subject: Re: Big question on insert performance/using COPY FROM