Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Chris ErnstDate: 2011-06-13 16:58:29
Subject: Re: changing work_mem
Previous:From: Dinesh BhandaryDate: 2011-06-13 16:29:06
Subject: changing work_mem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group