Re: vacuumdb ERROR: out of memory

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: vacuumdb ERROR: out of memory
Дата
Msg-id 4B71CBCB.9090208@hogranch.com
обсуждение исходный текст
Ответ на Re: vacuumdb ERROR: out of memory  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: vacuumdb ERROR: out of memory  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
Guillaume Lelarge wrote:
>> is this a 64bit postgres build?
>>
>> if not, you're probably running out of virtual address space in the 32
>> bit user space, which is limited to like 2gb.
>>
>>
>
> IIRC, the virtual address space in 32bit platforms is 4GB.
>

it is, but within that 4gb, the kernel uses the top 1gb, so there's 3gb
left for user program space in each process.  shared memory, runtime
libraries, etc all hve to come out of this 3gb user space





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

Предыдущее
От: Alex Thurlow
Дата:
Сообщение: Re: Best way to handle multi-billion row read-only table?
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: SSL connection lost after long-lasting copy command