Re: Any Plans for cross database queries on the same server?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Any Plans for cross database queries on the same server?
Дата
Msg-id 20070204215955.GB377@svana.org
обсуждение исходный текст
Ответ на Re: Any Plans for cross database queries on the same server?  (Jeff Davis <pgsql@j-davis.com>)
Список 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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Jorge Godoy
Дата:
Сообщение: Re: ERROR: missing cache data for cache id 27
Следующее
От: Tomas Vondra
Дата:
Сообщение: partitioning / rules - strange behavior