Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WagOa-0005CQ-Iw for pgsql-performance@arkaria.postgresql.org; Thu, 17 Apr 2014 07:06:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WagOZ-0003FJ-OZ for pgsql-performance@arkaria.postgresql.org; Thu, 17 Apr 2014 07:06:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WagOY-0003FC-Fu for pgsql-performance@postgresql.org; Thu, 17 Apr 2014 07:06:02 +0000 Received: from nm44.bullet.mail.ne1.yahoo.com ([98.138.120.51]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WagOU-0006Q3-SX for pgsql-performance@postgresql.org; Thu, 17 Apr 2014 07:06:02 +0000 Received: from [127.0.0.1] by nm44.bullet.mail.ne1.yahoo.com with NNFMP; 17 Apr 2014 07:05:56 -0000 Received: from [98.138.100.114] by nm44.bullet.mail.ne1.yahoo.com with NNFMP; 17 Apr 2014 07:05:43 -0000 Received: from [106.10.166.116] by tm105.bullet.mail.ne1.yahoo.com with NNFMP; 17 Apr 2014 07:05:43 -0000 Received: from [106.10.151.123] by tm5.bullet.mail.sg3.yahoo.com with NNFMP; 17 Apr 2014 07:05:43 -0000 Received: from [127.0.0.1] by omp1005.mail.sg3.yahoo.com with NNFMP; 17 Apr 2014 07:05:43 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 530773.78618.bm@omp1005.mail.sg3.yahoo.com Received: (qmail 57420 invoked by uid 60001); 17 Apr 2014 07:05:43 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s1024; t=1397718343; bh=tpBfAHj/Ub6cOgmebv5onNYWJfrBvg2xpavLCsYItdg=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=LdfAS7hyiq0laTrKsuhQZct9SHNt2amDP53dPiNQ3odEH3mEWelPPoBbHYt5AxLhGtBmrPHR8sqlgrs5YFEAHKGRXXkeQypdiGHXE4mAjWNYAtjdYjIrNcbmc/VRSNoG3ZhRUU36UQqgB+PUEHscOMyriaJzZyehFi/TsKrDsvo= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=BfhM1ZRZDMbB33UlfLm6CY5/54uGE6zihTWj1G7R7QEwooRO3sxy9xQyARomB5NpqudGES5DUnPIpAFA+o6E2F5McaLj6GLRJCWVK+Z8lb49FjsDJ1qi8N+ORwT/SeHPy+W9/UqOASGZvw8ofNioTH8Mg/D3FXvdAQ073ZwERIg=; X-YMail-OSG: 6DgGDEAVM1mUDIMx5dtmZDVHxe6hdUwSnbe_tOuceMogBz8 tIszKqamBI_dWGEG2tQ0IQSBQ.wiG4EpCgGRUnenAsvhqwcitO15fmNHk9Ay 3nRJ3BrlwaMt7_e9n.WiZvb5lRQ9jkLZ.yxH8rXH6w6ZHXzVpT.K1c7Gcwsi LT6GC.yafBVC5T7g884nDqETaEomTvUwCY3WZF_xymQWplLPR_naTWnY7ndR Yle19RdeRndayEKZXAtw1bE.efseJTrjwafuk8i1ECMqAJ3uRmP.p_3iyRCW Zky6hd4xly024TuBvOrWo0ZbQPtBkQcOiGKkwWy5OM8HBj1OljKzqb7SSKs1 VNU2JW8nBwWcF.A6PL._Ggb_3n_oG2j6B3bYkUPnSQfm6T32K2FAu6zA.sMU WWeXeFjHRNW0IYZyMOyAD3WW_cKgQgAqDvgG7GWI20AHHNlf5YuiMODHRw8F jsWftBhuL1BvzzIuxtaf14oLDhMJ0AG67.JC.AXL1JGY4KoENKSej0pD5tg5 NEfvPo4cpP3eBDWoWvPOHh6J3DXcCD_1AZGDKHQyI8sSmGwexmCts Received: from [58.68.120.162] by web193504.mail.sg3.yahoo.com via HTTP; Thu, 17 Apr 2014 15:05:43 SGT X-Rocket-MIMEInfo: 002.001, T24gV2VkbmVzZGF5LCAxNiBBcHJpbCAyMDE0IDEwOjA1IFBNLCBOaWNrIEV1YmFuayA8bmlja2V1YmFua0BnbWFpbC5jb20.IHdyb3RlOgoKCgo.QW11bDogdGhhbmtzIGZvciB0aGUgZm9sbG93dXAhIFVuZm9ydHVuYXRlbHksIHNldHRpbmcgbG9jYWxseSBmYWNlcyB0aGUgc2FtZSBsaW1pdGF0aW9uwqAKPmFzIHNldHRpbmcgdGhpbmdzIGluIHRoZSBjb25maWcgZmlsZSAtLcKgCj5JIGdldCBhbiAiRVJST1I6IDMwNzIwMDAgaXMgb3V0c2lkZSB0aGUgdmFsaWQgcmFuZ2UgZm9yIHBhcmFtZXRlciAid29ya18BMAEBAQE- X-Mailer: YahooMailWebService/0.8.185.657 References: <1397636979325-5800216.post@n5.nabble.com> Message-ID: <1397718343.88782.YahooMailNeo@web193504.mail.sg3.yahoo.com> Date: Thu, 17 Apr 2014 15:05:43 +0800 (SGT) From: amul sul Reply-To: amul sul Subject: Re: Workaround for working_mem max value in windows? To: Nick Eubank Cc: "pgsql-performance@postgresql.org" , "Martin.French@romaxtech.com" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On Wednesday, 16 April 2014 10:05 PM, Nick Eubank wr= ote: >Amul: thanks for the followup! Unfortunately, setting locally faces the sa= me limitation=A0 >as setting things in the config file --=A0 >I get an "ERROR: 3072000 is outside the valid range for parameter "work_me= m" (64 .. 2097151) >SQL state: 22023" problem if I set above ~1.9gb. :( yes, you can set work_mem upto 2047MB. Regards, Amul Sul=A0 --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance