Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: requested shared memory size overflows size_t
Date
Msg-id 4C067E510200002500031DC2@gw.wicourts.gov
Whole thread Raw
In response to Re: requested shared memory size overflows size_t  (Tom Wilcox <hungrytom@googlemail.com>)
Responses Re: requested shared memory size overflows size_t  (Stephen Frost <sfrost@snowman.net>)
List pgsql-performance
Tree view 
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.

-Kevin

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Autovacuum in postgres.
Next
From: Stephen Frost
Date:
Subject: Re: requested shared memory size overflows size_t