Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 44DA264FCCA for ; Wed, 17 Sep 2008 19:28:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 58930-09 for ; Wed, 17 Sep 2008 19:28:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out2.iinet.net.au (outbound.icp-qv1-irony-out2.iinet.net.au [203.59.1.107]) by postgresql.org (Postfix) with ESMTP id 9580A64FCC0 for ; Wed, 17 Sep 2008 19:28:40 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AjQGAIoh0Uh8q5NR/2dsb2JhbACIH4QIhVaoGoFn X-IronPort-AV: E=Sophos;i="4.32,418,1217779200"; d="scan'208";a="372328945" Received: from unknown (HELO mail.outtalimits.com.au) ([124.171.147.81]) by outbound.icp-qv1-irony-out2.iinet.net.au with ESMTP; 18 Sep 2008 06:28:37 +0800 Received: from www.outtalimits.com.au (localhost [127.0.0.1]) by mail.outtalimits.com.au (Postfix) with ESMTP id 6C2BA2B6405C; Thu, 18 Sep 2008 08:28:36 +1000 (EST) MIME-Version: 1.0 Date: Thu, 18 Sep 2008 08:28:36 +1000 From: To: Scott Marlowe Cc: pgsql-admin@postgresql.org Subject: Re: Postgres && Swap In-Reply-To: References: Message-ID: <2f860102cfbbc11cfa67fe892b19417d@127.0.0.1> X-Sender: steve@outtalimits.com.au User-Agent: RoundCube Webmail/0.2a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200809/190 X-Sequence-Number: 30283 Is there any negative effects by doing this? The swappiness is sitting on the default 60 at the moment. On Wed, 17 Sep 2008 00:46:13 -0600, "Scott Marlowe" wrote: > On Tue, Sep 16, 2008 at 11:30 PM, wrote: >> Hi All >> >> >> I recently made a change to my Postgres Server and upped the > max_fsm_page >> size to 60000 >> Since then, Postgres has been using about 30-80MB of swap space. >> >> This box has 4GB of RAM. All up Postgres has not been allocated no more >> than 3G >> >> Is this swapping something to be worried about? > > I recommend turning swappiness down in linux that should stop pg from > getting prematurely swapped out like that.