Re: Thousands of schemas and ANALYZE goes out of memory

On Wed, Oct 3, 2012 at 10:09 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Tue, Oct 2, 2012 at 10:38 AM, Hugo <Nabble> <hugo.tech@gmail.com> wrote:
>>> That might be the problem.  I think with 32 bits, you only 2GB of
>>> address space available to any given process, and you just allowed
>>> shared_buffers to grab all of it.
>>
>> The address space for 32 bits is 4Gb.
>
> I had thought the highest bit was not usable, but maybe that was just
> a Windows thing.

Losing the highest bit is common when something treats a number as
signed, but the <4GB memory issue isn't that. It's because other areas
of memory need to be addressable (devices claim certain areas), and
all that has to be factored into the total 4GB addressable space.
Usually you get >3GB, somewhere around the 3.5GB mark.

ChrisA