Postgres Pro
Downloads
Home   >   mailing lists

Workaround for working_mem max value in windows? - Mailing list pgsql-performance

From Nick Eubank
Subject Workaround for working_mem max value in windows?
Date
Msg-id CAFWQgO=fgsniCMvNiReVdcBc9+hB6N0b8SFVCY9xOjQpP=GSmQ@mail.gmail.com
Whole thread Raw
Responses 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>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: Testing strategies
Next
From: Martin French
Date:
Subject: Re: Workaround for working_mem max value in windows?