Workaround for working_mem max value in windows?

Поиск
Список
Период
Сортировка
От Nick Eubank
Тема Workaround for working_mem max value in windows?
Дата
Msg-id CAFWQgO=fgsniCMvNiReVdcBc9+hB6N0b8SFVCY9xOjQpP=GSmQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Workaround for working_mem max value in windows?  (Martin French <Martin.French@romaxtech.com>)
Re: Workaround for working_mem max value in windows?  (amulsul <sul_amul@yahoo.co.in>)
Re: Workaround for working_mem max value in windows?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения
Hi all,

A few years ago someone said postgres windows can't set working_mem above about 2 GB (www.postgresql.org/message-id/17895.1315869622@sss.pgh.pa.us -- seems to be same for maintenance_working_mem ). Im finding limit still present.

 I'm doing single user, single connection data intensive queries and would like to set a higher value on windows to better use 16gb built in ram (don't control platform, so can't jump to Linux). 

Anyone found a work around?

Thanks!

Nick

В списке pgsql-performance по дате отправления:

Предыдущее
От: Matheus de Oliveira
Дата:
Сообщение: Re: Testing strategies
Следующее
От: Martin French
Дата:
Сообщение: Re: Workaround for working_mem max value in windows?