Re: Help with postgresql memory issue

Thanks for all the help guys.

So this is what I get from all this. My solaris zone will cap me at
around 900M-1000M RSS memory. Therefore using the math from a pervious
reply I can only have about 23 connections to my database without
maxing out the machines memory?

This seems a little low, won't postgres start swapping to disk once
the available RAM is used up?

You'll have to excuse me if this seems like a newbie question.

Thanks again,
Brooks L.

On 28-Oct-09, at 5:56 PM, Tom Lane wrote:

> Greg Smith <gsmith(at)gregsmith(dot)com> writes:
>> On Wed, 28 Oct 2009, Tom Lane wrote:
>>> What's the platform exactly? Is it possible that the postmaster is
>>> being launched under very restrictive ulimit settings?
>
>> Now that Brooks mentioned this being run inside of a Solaris zone,
>> seems
>> like this might be running into some memory upper limit controlled
>> by the
>> zone configuration.
>
> A bit of quick googling confirmed that there is (or can be) a per-zone
> memory cap. I'll bet Greg has nailed it. The docs I found claim that
> the cap management code is smart enough to count shared memory only
> once, which would eliminate the most obvious way in which the cap
> might
> be way off; but it still sounds like checking into that configuration
> setting is job #1.
>
> regards, tom lane