Workaround for working_mem max value in windows?

From: Nick Eubank <nickeubank(at)gmail(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Workaround for working_mem max value in windows?
Date: 2014-04-16 01:36:37
Message-ID: CAFWQgO=fgsniCMvNiReVdcBc9+hB6N0b8SFVCY9xOjQpP=GSmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Martin French 2014-04-16 06:42:32 Re: Workaround for working_mem max value in windows?
Previous Message Gavin Flower 2014-04-16 01:27:25 Re: Approach to Data Summary and Analysis