From: Stephen Frost <sfrost@snowman.net>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Tom Wilcox <hungrytom@googlemail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: requested shared memory size overflows size_t
Date: Wed, 2 Jun 2010 16:59:57 -0400
Message-ID: <20100602205957.GN21875@tamriel.snowman.net> (raw)
In-Reply-To: <4C067E510200002500031DC2@gw.wicourts.gov>
References: <4C063967.4070705@gmail.com>
<4C067E510200002500031DC2@gw.wicourts.gov>
* Kevin Grittner (Kevin.Grittner@wicourts.gov) wrote:
> Tom Wilcox <hungrytom@googlemail.com> wrote:
> > Is it possible to get postgres to make use of the available 96GB
> > RAM on a Windows 32-bit build?
>
> I would try setting shared_memory to somewhere between 200MB and 1GB
> and set effective_cache_size = 90GB or so. The default behavior of
> Windows was to use otherwise idle RAM for disk caching, last I
> checked, anyway.
Sure, but as explained on -general already, all that RAM will only ever
get used for disk cacheing. It won't be able to be used for sorts or
hash aggs or any other PG operations (PG would use at most
4GB-shared_buffers, or so).
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 196B) download
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: sfrost@snowman.net, Kevin.Grittner@wicourts.gov, hungrytom@googlemail.com
Subject: Re: requested shared memory size overflows size_t
In-Reply-To: <20100602205957.GN21875@tamriel.snowman.net>
* 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