Skip site navigation (1) Skip section navigation (2)

Re: Postgres && Swap

From: <steve(at)outtalimits(dot)com(dot)au>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres && Swap
Date: 2008-09-17 22:28:36
Message-ID: 2f860102cfbbc11cfa67fe892b19417d@127.0.0.1 (view raw or flat)
Thread:
Lists: pgsql-admin
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"
<scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Tue, Sep 16, 2008 at 11:30 PM,  <steve(at)outtalimits(dot)com(dot)au> 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.

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-09-18 00:40:19
Subject: Re: Postgres && Swap
Previous:From: Melissa PetersonDate: 2008-09-17 21:41:13
Subject: Re: unable to backup database -- psql not up to date

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group