Postgres Pro
Downloads
Home   >   mailing lists

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

From amulsul
Subject Re: Workaround for working_mem max value in windows?
Date
Msg-id 1397636979325-5800216.post@n5.nabble.com
Whole thread Raw
In response to Workaround for working_mem max value in windows?  (Nick Eubank <nickeubank@gmail.com>)
Responses Re: Workaround for working_mem max value in windows?
List pgsql-performance
Tree view 
>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.

pgsql-performance by date:

Previous
From: Martin French
Date:
Subject: Re: Workaround for working_mem max value in windows?
Next
From: sheishere b
Date:
Subject: Queries very slow after data size increases