Re: changing work_mem

From: "Plugge, Joe R(dot)" <JRPlugge(at)west(dot)com>
To: "dbhandary(at)iii(dot)com" <dbhandary(at)iii(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: changing work_mem
Date: 2011-06-13 16:52:21
Message-ID: BD69807DAE0CE44CA00A8338D0FDD08302FD00685F@oma00cexmbx03.corp.westworlds.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Yes,

In your session ....

set work_mem='4000MB';do rest of sql after .....

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Dinesh Bhandary
Sent: Monday, June 13, 2011 11:29 AM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] changing work_mem

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

--
Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Ernst 2011-06-13 16:58:29 Re: changing work_mem
Previous Message Dinesh Bhandary 2011-06-13 16:29:06 changing work_mem