Re: vacuumdb ERROR: out of memory

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
Cc: David Kerr <dmk(at)mr-paradox(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: vacuumdb ERROR: out of memory
Date: 2010-02-09 20:55:39
Message-ID: 4B71CBCB.9090208@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2010-02-09 20:56:00 Re: SSL connection lost after long-lasting copy command
Previous Message Alex Thurlow 2010-02-09 20:18:30 Re: Best way to handle multi-billion row read-only table?