Re: Help with postgresql memory issue

Поиск
Список
Период
Сортировка
Искать
От
Brooks Lyrette
Тема
Re: Help with postgresql memory issue
Дата
Msg-id
37BFBE84-BB26-4A0E-B318-6B1361BDA987@gmail.com
Ответ на
Список
Дерево обсуждения
Help with postgresql memory issue Brooks Lyrette <brooks.lyrette@gmail.com>
Re: Help with postgresql memory issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Help with postgresql memory issue Brooks Lyrette <brooks.lyrette@gmail.com>
Re: Help with postgresql memory issue Greg Stark <gsstark@mit.edu>
Re: Help with postgresql memory issue Greg Smith <gsmith@gregsmith.com>
Re: Help with postgresql memory issue Greg Smith <gsmith@gregsmith.com>
Re: Help with postgresql memory issue Tom Lane <tgl@sss.pgh.pa.us>
Re: Help with postgresql memory issue Brooks Lyrette <brooks.lyrette@gmail.com>
Re: Help with postgresql memory issue Scott Marlowe <scott.marlowe@gmail.com>
Re: Help with postgresql memory issue Brooks Lyrette <brooks.lyrette@gmail.com>
Re: Help with postgresql memory issue Scott Marlowe <scott.marlowe@gmail.com>
Re: Help with postgresql memory issue Thom Brown <thombrown@gmail.com>
Re: Help with postgresql memory issue Brooks Lyrette <brooks.lyrette@gmail.com>
Re: Help with postgresql memory issue Thom Brown <thombrown@gmail.com>
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 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

В списке pgsql-general по дате отправления
От: Raymond O'Donnell
Дата:
От: joeweder
Дата:
Сообщение: 8.4 initdb failure
FAQ