pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres && Swap
4+ messages / 2 participants
[nested] [flat]
* Postgres && Swap
@ 2008-09-17 05:30 steve@outtalimits.com.au
0 siblings, 1 reply; 4+ messages in thread
From: steve@outtalimits.com.au @ 2008-09-17 05:30 UTC (permalink / raw)
To: pgsql-admin
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?
Cheers
Steve.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres && Swap
@ 2008-09-17 06:46 Scott Marlowe <scott.marlowe@gmail.com>
parent: steve@outtalimits.com.au
0 siblings, 1 reply; 4+ messages in thread
From: Scott Marlowe @ 2008-09-17 06:46 UTC (permalink / raw)
To: steve@outtalimits.com.au; +Cc: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres && Swap
@ 2008-09-17 22:28 steve@outtalimits.com.au
parent: Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: steve@outtalimits.com.au @ 2008-09-17 22:28 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: 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.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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgres && Swap
@ 2008-09-18 00:40 Scott Marlowe <scott.marlowe@gmail.com>
parent: steve@outtalimits.com.au
0 siblings, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2008-09-18 00:40 UTC (permalink / raw)
To: steve@outtalimits.com.au; +Cc: pgsql-admin
Well, there's plenty of negatives to not doing it. Like postgresql's
large shared_buffers getting swapped out to make more space for disk
buffers. So, pgsql goes to grab data from shared buffers and has to
wait for the OS to swap them back in.
On Wed, Sep 17, 2008 at 4:28 PM, <steve@outtalimits.com.au> wrote:
> 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.
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-09-18 00:40 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-17 05:30 Postgres && Swap steve@outtalimits.com.au
2008-09-17 06:46 ` Scott Marlowe <scott.marlowe@gmail.com>
2008-09-17 22:28 ` steve@outtalimits.com.au
2008-09-18 00:40 ` Scott Marlowe <scott.marlowe@gmail.com>
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