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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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