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  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Autovacuum in postgres.
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: requested shared memory size overflows size_t