pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Schroeder <kschroeder@mirageworks.com>
To: pgsql-performance@postgresql.org
Subject: Swapping on Solaris
Date: Tue, 18 Jan 2005 16:49:35 -0600
Message-ID: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION> (raw)

Hello,
    I'm running PostgreSQL on a Solaris 8 system with 2GB of RAM and I'm 
having some difficulty getting PostgreSQL to use the available RAM.  My RAM 
settings in postgresql.conf are

shared_buffers = 8192   # min 16, at least max_connections*2, 8KB each
sort_mem = 131072               # min 64, size in KB
vacuum_mem = 131072             # min 1024, size in KB

Ignoring the fact that the sort and vacuum numbers are really high, this is 
what Solaris shows me when running top:

Memory: 2048M real, 1376M free, 491M swap in use, 2955M swap free

For some reason I have 1.25GB of free RAM but PostgreSQL seems compelled to 
swap to the hard drive rather than use that RAM.  I have the shared buffers 
set as high as the Solaris kernel will let me.  I also know that Solaris 
will cache frequently used files in RAM, thereby lowering the amount of RAM 
available to an application, but my understanding is that Solaris will dump 
that cache if an application or the kernel itself requires it.

    The system has about 1,000 active email users using unix mailboxes which 
could what is keeping the database from exploiting as much RAM as available 
but my primary concern is to allow PostgreSQL to use as much RAM as it 
requires without swapping.

    What can I do to force the system to allow PostgreSQL to do this?

Regards,
Kevin Schroeder 




view thread (22+ messages)  latest in thread

Message-ID: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION>
Permalink:  ../042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION/
Also on:    postgresql.org/message-id/042a01c4fdaf$fbb3b860$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: <042a01c4fdaf$fbb3b860$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