From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Kasia Tuszynska <ktuszynska@esri.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: ubuntu swap space
Date: Tue, 12 Apr 2011 10:24:25 -0500
Message-ID: <4DA42859020000250003C6F3@gw.wicourts.gov> (raw)
In-Reply-To: <232B5217AD58584C87019E8933556D110227AF1D70@redmx2.esri.com>
References: <232B5217AD58584C87019E8933556D110227AF1D70@redmx2.esri.com>
Kasia Tuszynska <ktuszynska@esri.com> wrote:
> We are configuring Postgres on Ubuntu
> Nothing but Postgres will be running on the machine. I have read
> that we should assign twice the available RAM to swap, that seems
> like a lot.
I remember years ago reading that if swap space was twice RAM, that
Linux could use a different algorithm for swapping, which was
generally expected to be faster. I don't know whether that is still
true.
> Would Postgres ever use so much space?
It could, in certain conditions, but you would probably not like the
performance. You're best off avoiding overcommitting memory to that
extent.
> Any recommendations or best practices?
I would follow the general recommendations for the OS, and worry
about tuning PostgreSQL memory usage so that you don't drive
anything significant into swap space. On our production systems we
generally see a very small amount swapped out fairly early which
doesn't grow and is never swapped back in. I suspect it is
OS-related code which we're not using.
-Kevin
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: Kevin.Grittner@wicourts.gov, ktuszynska@esri.com
Subject: Re: ubuntu swap space
In-Reply-To: <4DA42859020000250003C6F3@gw.wicourts.gov>
* 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