From: Bob Lunney <bob_lunney@yahoo.com>
To: pgsql-performance@postgresql.org, Tom Wilcox <hungrytom@googlemail.com>
Subject: Re: requested shared memory size overflows size_t
Date: Wed, 2 Jun 2010 18:26:56 -0700 (PDT)
Message-ID: <689977.86245.qm@web39708.mail.mud.yahoo.com> (raw)
In-Reply-To: <4C063967.4070705@gmail.com>
Tom,
A 32 bit build could only reference at most 4 Gb - certainly not 60 Gb. Also, Windows doesn't do well with large shared buffer sizes anyway. Try setting shared_buffers to 2 Gb and let the OS file system cache handle the rest.
Your other option, of course, is a nice 64-bit linux variant, which won't have this problem at all.
Good luck!
Bob Lunney
--- On Wed, 6/2/10, Tom Wilcox <hungrytom@googlemail.com> wrote:
> From: Tom Wilcox <hungrytom@googlemail.com>
> Subject: Re: [PERFORM] requested shared memory size overflows size_t
> To: pgsql-performance@postgresql.org
> Date: Wednesday, June 2, 2010, 6:58 AM
> 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
>
>
> -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bob_lunney@yahoo.com, hungrytom@googlemail.com
Subject: Re: requested shared memory size overflows size_t
In-Reply-To: <689977.86245.qm@web39708.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox