X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4BEE4D8695 for ; Wed, 31 Aug 2005 16:33:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26357-02 for ; Wed, 31 Aug 2005 19:33:35 +0000 (GMT) Received: from mail.nordicbet.com (mail.nordicbet.com [193.69.167.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2C949D84B4 for ; Wed, 31 Aug 2005 16:33:32 -0300 (ADT) Received: from [80.203.125.83] (helo=tobias.nordicbet.invalid) (Authenticated Sender=tobias@nordicbet.com) by mail.nordicbet.com with esmtpa (Exim 4.50 #1 (Debian)) id 1EAYIJ-0004y4-0k; Wed, 31 Aug 2005 21:30:56 +0200 Received: by tobias.nordicbet.invalid (Postfix, from userid 500) id 76AC5AAEA; Wed, 31 Aug 2005 21:33:17 +0200 (CEST) Date: Wed, 31 Aug 2005 21:33:17 +0200 From: Tobias Brox To: Tobias Brox Cc: Carlos Henrique Reimer , pgsql-performance@postgresql.org Subject: Re: Swapping Message-ID: <20050831193317.GD5736@tobias.lan> References: <20050831182515.89931.qmail@web53209.mail.yahoo.com> <20050831192217.GC5736@tobias.lan> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050831192217.GC5736@tobias.lan> Organization: Group Nordicbet User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200508/561 X-Sequence-Number: 14308 [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.