Re: Help with postgresql memory issue
| От | Brooks Lyrette |
|---|---|
| Тема | Re: Help with postgresql memory issue |
| Дата | |
| Msg-id | 37BFBE84-BB26-4A0E-B318-6B1361BDA987@gmail.com обсуждение исходный текст |
| Ответ на | Re: Help with postgresql memory issue (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Help with postgresql memory issue
|
| Список | pgsql-general |
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@gregsmith.com> writes:On Wed, 28 Oct 2009, Tom Lane wrote:What's the platform exactly? Is it possible that the postmaster isbeing launched under very restrictive ulimit settings?Now that Brooks mentioned this being run inside of a Solaris zone, seemslike this might be running into some memory upper limit controlled by thezone 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
В списке pgsql-general по дате отправления: