Re: Out of memory condition

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Out of memory condition
Дата
Msg-id 29097.1418330778@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Out of memory condition  (Carlos Henrique Reimer <carlos.reimer@opendb.com.br>)
Список pgsql-general
Carlos Henrique Reimer <carlos.reimer@opendb.com.br> writes:
> Extracted ulimits values from postmaster pid and they look as expected:

> [root@00002-NfseNet ~]# cat /proc/2992/limits
> Limit                     Soft Limit           Hard Limit
> Units
> Max address space         1024000000           unlimited
> bytes

So you've got a limit of 1GB on process address space ... that's
probably why it's burping on allocations of a couple hundred meg,
especially if you have a reasonably large shared_buffers setting.
You might as well be running a 32-bit build (in fact, a 32-bit
build could still do a lot better than that).

            regards, tom lane


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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Out of memory condition
Следующее
От: Robert DiFalco
Дата:
Сообщение: Re: Help Optimizing a Summary Query