Re: Help with postgresql memory issue - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Help with postgresql memory issue
Date
Msg-id dcc563d10911021421sc8046fal1d75beca5619a10d@mail.gmail.com
Whole thread Raw
In response to Re: Help with postgresql memory issue  (Brooks Lyrette <brooks.lyrette@gmail.com>)
Responses Re: Help with postgresql memory issue
List pgsql-general
On Mon, Nov 2, 2009 at 1:11 PM, Brooks Lyrette <brooks.lyrette@gmail.com> wrote:
> 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?

pgsql doesn't swap, the OS swaps, when it runs out of memory.  Since
pgsql is limited to 1G, the OS has no reason to swap.

Can you simply remove the cap from this instance?  It doesn't seem to
be doing anything useful.

pgsql-general by date:

Previous
From: Raimon Fernandez
Date:
Subject: Re: Cancelling Requests Frontend/Backend Protocol TCP/IP
Next
From: Viktor Rosenfeld
Date:
Subject: R-Trees in PostgreSQL