Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 8C24FB5DC13 for ; Mon, 13 Jun 2011 14:06:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 64352-02-3 for ; Mon, 13 Jun 2011 17:06:45 +0000 (UTC) X-Greylist: delayed 00:07:57.056951 by SQLgrey-1.7.6 Received: from smtp142.dfw.emailsrvr.com (smtp142.dfw.emailsrvr.com [67.192.241.142]) by mail.postgresql.org (Postfix) with ESMTP id D96DDB5DC59 for ; Mon, 13 Jun 2011 14:06:31 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp14.relay.dfw1a.emailsrvr.com (SMTP Server) with ESMTP id DEE4129A681 for ; Mon, 13 Jun 2011 12:58:33 -0400 (EDT) X-Virus-Scanned: OK Received: by smtp14.relay.dfw1a.emailsrvr.com (Authenticated sender: cernst-AT-zvelo.com) with ESMTPSA id 850C529A67A for ; Mon, 13 Jun 2011 12:58:33 -0400 (EDT) Message-ID: <4DF641B5.5060409@zvelo.com> Date: Mon, 13 Jun 2011 10:58:29 -0600 From: Chris Ernst User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110516 Lightning/1.0b2 Thunderbird/3.1.10 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: changing work_mem References: <4DF63AD2.2050501@iii.com> In-Reply-To: <4DF63AD2.2050501@iii.com> X-Enigmail-Version: 1.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/62 X-Sequence-Number: 37688 SET work_mem='1GB'; (or whatever size makes sense) - Chris On 06/13/2011 10:29 AM, Dinesh Bhandary wrote: > Hi All - > > Is there a way to change work_mem for a session in postgres without > restarting a database? Please let me know. > > Thanks. > Dinesh >