Re: Workaround for working_mem max value in windows?

Поиск
Список
Период
Сортировка
Искать
От
amul sul
Тема
Re: Workaround for working_mem max value in windows?
Дата
Msg-id
1397718343.88782.YahooMailNeo@web193504.mail.sg3.yahoo.com
Ответ на
Список
Дерево обсуждения
Workaround for working_mem max value in windows? Nick Eubank <nickeubank@gmail.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? Nick Eubank <nickeubank@gmail.com>
Re: Workaround for working_mem max value in windows? amul sul <sul_amul@yahoo.co.in>
Re: Workaround for working_mem max value in windows? "Martin French" <Martin.French@romaxtech.com>
Re: Workaround for working_mem max value in windows? Jeff Janes <jeff.janes@gmail.com>
Re: Workaround for working_mem max value in windows? Nick Eubank <nickeubank@gmail.com>
Re: Workaround for working_mem max value in windows? Martin French <Martin.French@romaxtech.com>
On Wednesday, 16 April 2014 10:05 PM, Nick Eubank  wrote:



>Amul: thanks for the followup! Unfortunately, setting locally faces the same limitation 
>as setting things in the config file -- 
>I get an "ERROR: 3072000 is outside the valid range for parameter "work_mem" (64 .. 2097151)

>SQL state: 22023" problem if I set above ~1.9gb. :(


yes, you can set work_mem upto 2047MB.


Regards,
Amul Sul 

В списке pgsql-performance по дате отправления
От: Nick Eubank
Дата:
От: Franck Routier
Дата:
FAQ