Re: Shared memory usage in PostgreSQL 9.1 - Mailing list pgsql-general

From Christoph Zwerschke
Subject Re: Shared memory usage in PostgreSQL 9.1
Date
Msg-id 4EDB8FB2.3050501@online.de
Whole thread Raw
In response to Re: Shared memory usage in PostgreSQL 9.1  (sfrost@snowman.net)
List pgsql-general
Am 04.12.2011 15:17, schrieb sfrost@snowman.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

pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Shared memory usage in PostgreSQL 9.1
Next
From: Tom Lane
Date:
Subject: Re: Shared memory usage in PostgreSQL 9.1