Re: Cannot allocate memory for output buffer

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Cannot allocate memory for output buffer
Дата
Msg-id 20091128164203.GA10880@svana.org
обсуждение исходный текст
Ответ на Re: Cannot allocate memory for output buffer  (Peter Erickson <redlamb@redlamb.net>)
Список pgsql-general
On Fri, Nov 27, 2009 at 05:55:30PM -0500, Peter Erickson wrote:
> Thanks. Out of curiosity, if memory exhaustion was the problem, any idea
> why the task manager would show that I'm only using 1.2GB of the 3GB of
> memory?

Note that what usually kills you first on 32-bit systems is that you
want 250MB of *contiguous* memory. Depending on how the program is
started and if you have memory map randomization, it becomes entirely
possible to have more than 1GB free, yet no blocks big enough to hold
250MB together.

64-bit systems don't suffer from this problem, the address space is so
large it's just not an issue.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Вложения

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

Предыдущее
От: Filip Rembiałkowski
Дата:
Сообщение: postgres log file mode
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strange "bug" in dump ?