Re: Shared memory usage in PostgreSQL 9.1

From: Christoph Zwerschke <cito(at)online(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Shared memory usage in PostgreSQL 9.1
Date: 2011-12-04 15:20:18
Message-ID: 4EDB8FB2.3050501@online.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 04.12.2011 15:17, schrieb sfrost(at)snowman(dot)net:
> Didn't see this get answered... The long-and-short of that there aren't
> any negative consequences of having it higher, as I understand it
> anyway, except the risk of greedy apps. In some cases, shared memory
> can't be swapped out, which makes it a bit more risky than 'regular'
> memory getting sucked up by some app.

That's how I understand it as well. So the solution is to calculate an
upper limit for the shared memory usage very generously, since it
doesn't matter if the limit is set a couple of MBs too high.

-- Christoph

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-12-04 20:07:21 Re: BUG #6325: Useless Index updates
Previous Message Tomas Vondra 2011-12-04 14:33:47 Re: Shared memory usage in PostgreSQL 9.1