Re: Workaround for working_mem max value in windows?

From: amulsul <sul_amul(at)yahoo(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Workaround for working_mem max value in windows?
Date: 2014-04-16 08:29:39
Message-ID: 1397636979325-5800216.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>Anyone found a work around?

Wouldn't it helpful, setting it in your session?

set work_mem='2000MB';
set maintenance_work_mem='2000MB';

do rest of sql after .....

Regards,
Amul Sul

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Workaround-for-working-mem-max-value-in-windows-tp5800170p5800216.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message sheishere b 2014-04-16 13:05:16 Queries very slow after data size increases
Previous Message Martin French 2014-04-16 06:42:32 Re: Workaround for working_mem max value in windows?