Re: requested shared memory size overflows size_t

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Wilcox" <hungrytom(at)googlemail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: requested shared memory size overflows size_t
Date: 2010-06-02 20:52:49
Message-ID: 4C067E510200002500031DC2@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Wilcox <hungrytom(at)googlemail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Stephen Frost 2010-06-02 20:59:57 Re: requested shared memory size overflows size_t
Previous Message Jori Jovanovich 2010-06-02 20:28:54 SELECT ignoring index even though ORDER BY and LIMIT present