Re: requested shared memory size overflows size_t

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: requested shared memory size overflows size_t
Дата
Msg-id 4C067E510200002500031DC2@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: requested shared memory size overflows size_t  (Tom Wilcox <hungrytom@googlemail.com>)
Ответы Re: requested shared memory size overflows size_t
Список pgsql-performance
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 по дате отправления: