DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	b=hm5WfM+ZgPQd40OTLycRTi9ln/EzI7V5DaOABnPO433VHkVR5mNqdFbEnUq39q7c7g
	AeAFFht5YoNhPBIbuI0xZS5/Fl6Cw2wJRdh+Wd9IhJGFUZCeqZF0yhVRPEBN5QubaCOb
	4QGifCsd1lUGVZgdH1rOj6d9snL7FpfEmc09s=
Message-ID: <4C063967.4070705@gmail.com>
Date: Wed, 02 Jun 2010 11:58:47 +0100
From: Tom Wilcox <hungrytom@googlemail.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: requested shared memory size overflows size_t
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Sorry to revive an old thread but I have had this error whilst trying to 
configure my 32-bit build of postgres to run on a 64-bit Windows Server 
2008 machine with 96GB of RAM (that I would very much like to use with 
postgres).

I am getting:

2010-06-02 11:34:09 BSTFATAL:  requested shared memory size overflows size_t
2010-06-02 11:41:01 BSTFATAL:  could not create shared memory segment: 8
2010-06-02 11:41:01 BSTDETAIL:  Failed system call was MapViewOfFileEx.

which makes a lot of sense since I was setting shared_buffers (and 
effective_cache_size) to values like 60GB..

Is it possible to get postgres to make use of the available 96GB RAM on 
a Windows 32-bit build? Otherwise, how can I get it to work?

Im guessing my options are:

- Use the 64-bit Linux build (Not a viable option for me - unless from a 
VM - in which case recommendations?)
or
- Configure Windows and postgres properly (Preferred option - but I 
don't know what needs to be done here or if Im testing properly using 
Resource Monitor)

Thanks,
Tom