From: steve@outtalimits.com.au
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Postgres && Swap
Date: Thu, 18 Sep 2008 08:28:36 +1000
Message-ID: <2f860102cfbbc11cfa67fe892b19417d@127.0.0.1> (raw)
In-Reply-To: <dcc563d10809162346l18140d4y92b4679f0b3f2f9e@mail.gmail.com>
References: <fc3c4427bfc0022dfbcec135dac9e964@127.0.0.1>
<dcc563d10809162346l18140d4y92b4679f0b3f2f9e@mail.gmail.com>
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.marlowe@gmail.com> wrote:
> On Tue, Sep 16, 2008 at 11:30 PM, <steve@outtalimits.com.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: steve@outtalimits.com.au, scott.marlowe@gmail.com
Subject: Re: Postgres && Swap
In-Reply-To: <2f860102cfbbc11cfa67fe892b19417d@127.0.0.1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox