Re: requested shared memory size overflows size_t - Mailing list pgsql-performance

* 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