pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Schroeder <kschroeder@mirageworks.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Swapping on Solaris
Date: Wed, 19 Jan 2005 11:08:51 -0600
Message-ID: <019701c4fe49$8c72d4a0$0200a8c0@WORKSTATION> (raw)
References: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION>
	<41EE0F05.9080901@coretech.co.nz>
	<41EE65FC.2000909@rentec.com>
	<00d601c4fe33$89682eb0$0200a8c0@WORKSTATION>
	<41EE7D19.4060503@rentec.com>
	<014801c4fe3d$2a2478f0$0200a8c0@WORKSTATION>
	<41EE9315.2010707@rentec.com>

I think it's probably just reserving them.  I can't think of anything else. 
Also, when I run swap activity with sar I don't see any activity, which also 
points to reserved swap space, not used swap space.

swap -s reports

total: 358336k bytes allocated + 181144k reserved = 539480k used, 2988840k 
available

Kevin

----- Original Message ----- 
From: "Alan Stange" <stange@rentec.com>
To: "Kevin Schroeder" <kschroeder@mirageworks.com>
Cc: <pgsql-performance@postgresql.org>
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris


> Kevin Schroeder wrote:
>
>> I may be asking the question the wrong way, but when I start up 
>> PostgreSQL swap is what gets used the most of.  I've got 1282MB free RAM 
>> right now and and 515MB swap in use.  Granted, swap file usage probably 
>> wouldn't be zero, but I would guess that it should be a lot lower so 
>> something must be keeping PostgreSQL from using the free RAM that my 
>> system is reporting.  For example, one of my postgres processes is 201M 
>> in size but on 72M is resident in RAM.  That extra 130M is available in 
>> RAM, according to top, but postgres isn't using it.
>
> The test you're doing doesn't measure what you think you're measuring.
>
> First, what else is running on the machine?    Note that some shared 
> memory allocations do reserve backing pages in swap, even though the pages 
> aren't currently in use.  Perhaps this is what you're measuring? 
>  "swap -s" has better numbers than top.
>
> You'd be better by trying a reboot then starting pgsql and seeing what 
> memory is used.
>
> Just because you start a process and see the swap number increase doesn't 
> mean that the new process is in swap.  It means some anonymous pages had 
> to be evicted to swap to make room for the new process or some pages had 
> to be reserved in swap for future use.   Typically a new process won't be 
> paged out unless something else is causing enormous memory pressure...
>
> -- Alan
>
>
> 




view thread (22+ messages)  latest in thread

Message-ID: <019701c4fe49$8c72d4a0$0200a8c0@WORKSTATION>
Permalink:  ../019701c4fe49$8c72d4a0$0200a8c0@WORKSTATION/
Also on:    postgresql.org/message-id/019701c4fe49$8c72d4a0$0200a8c0@WORKSTATION

 · 

reply

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-performance@postgresql.org
  Cc: kschroeder@mirageworks.com
  Subject: Re: Swapping on Solaris
  In-Reply-To: <019701c4fe49$8c72d4a0$0200a8c0@WORKSTATION>

* 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