Re: Any Plans for cross database queries on the same server? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Any Plans for cross database queries on the same server?
Date
Msg-id 20070204215955.GB377@svana.org
Whole thread Raw
In response to Re: Any Plans for cross database queries on the same server?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
On Wed, Jan 31, 2007 at 10:37:34AM -0800, Jeff Davis wrote:
> I know this is off-topic for this list, but is there a place I can get
> some details about linux OOM killer, and the conditions that cause this
> OS hang when you turn off the OOM killer? I'd like to really know what's
> happening, and also know more about the OS hanging condition that you're
> talking about. I'd also like to know how safe the "safe" settings really
> are ( vm.overcommmit_memory=2 and vm.oom-kill=0? ).

The most important fact about overcommit is that if off, the system
won't let you allocate more memory than swap plus a percentage of real
memory. If you use it, make sure you allocate plenty of swap, or you'll
find you get out of memory errors long before ou're actually out of
memory.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Jorge Godoy
Date:
Subject: Re: ERROR: missing cache data for cache id 27
Next
From: Tomas Vondra
Date:
Subject: partitioning / rules - strange behavior