A few years ago someone said postgres windows can't set working_mem above about 2 GB (www.postgresql.org/message-id/17895.1315869622@xxxxxxxxxxxxx -- 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
