On Wed, Oct 3, 2012 at 10:09 AM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: > On Tue, Oct 2, 2012 at 10:38 AM, Hugo <Nabble> <hugo.tech@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
