On Wednesday, 16 April 2014 10:05 PM, Nick Eubank nickeub...@gmail.com wrote:
Amul: thanks for the followup! Unfortunately, setting locally faces the same
limitation
as setting things in the config file --
I get an ERROR: 3072000 is outside the valid range for parameter work_mem
(64 ..
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.1315869...@sss.pgh.pa.us
-- seems to be same for maintenance_working_mem ). Im finding
limit still present.
Setting work_mem higher than 2GB on a 16GB
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:
On Wed, Apr 16, 2014 at 1:29 AM, amulsul sul_a...@yahoo.co.in wrote:
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:
On 16 Apr 2014, at 17:35, Nick Eubank nickeub...@gmail.com wrote:
On Wed, Apr 16, 2014 at 1:29 AM, amulsul sul_a...@yahoo.co.in wrote:
Anyone found a work around?
Wouldn't it helpful, setting it in your session?
set work_mem='2000MB';
set maintenance_work_mem='2000MB';
do
On Tue, Apr 15, 2014 at 6:36 PM, Nick Eubank nickeub...@gmail.com wrote:
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.1315869...@sss.pgh.pa.us--
seems to be same for maintenance_working_mem ). Im finding
On Wednesday, April 16, 2014, Jeff Janes jeff.ja...@gmail.com wrote:
On Tue, Apr 15, 2014 at 6:36 PM, Nick Eubank
nickeub...@gmail.comjavascript:_e(%7B%7D,'cvml','nickeub...@gmail.com');
wrote:
Hi all,
A few years ago someone said postgres windows can't set working_mem above
about 2 GB
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.1315869...@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