Re: Help with postgresql memory issue

[Brooks Lyrette <brooks.lyrette@xxxxxxxxx>]

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@xxxxxxxxxxxxx> 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