* Kevin Grittner (Kevin.Grittner@xxxxxxxxxxxx) wrote: > Tom Wilcox <hungrytom@xxxxxxxxxxxxxx> 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
Attachment:
signature.asc
Description: Digital signature
