pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedchanging work_mem
5+ messages / 5 participants
[nested] [flat]
* changing work_mem
@ 2011-06-13 16:29 Dinesh Bhandary <dbhandary@iii.com>
0 siblings, 4 replies; 5+ messages in thread
From: Dinesh Bhandary @ 2011-06-13 16:29 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing work_mem
@ 2011-06-13 16:52 Plugge, Joe R. <JRPlugge@west.com>
parent: Dinesh Bhandary <dbhandary@iii.com>
3 siblings, 0 replies; 5+ messages in thread
From: Plugge, Joe R. @ 2011-06-13 16:52 UTC (permalink / raw)
To: dbhandary@iii.com <dbhandary@iii.com>; pgsql-admin
Yes,
In your session ....
set work_mem='4000MB';do rest of sql after .....
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Dinesh Bhandary
Sent: Monday, June 13, 2011 11:29 AM
To: pgsql-admin@postgresql.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@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing work_mem
@ 2011-06-13 16:58 Chris Ernst <cernst@zvelo.com>
parent: Dinesh Bhandary <dbhandary@iii.com>
3 siblings, 0 replies; 5+ messages in thread
From: Chris Ernst @ 2011-06-13 16:58 UTC (permalink / raw)
To: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing work_mem
@ 2011-06-13 17:00 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Dinesh Bhandary <dbhandary@iii.com>
3 siblings, 0 replies; 5+ messages in thread
From: Kevin Grittner @ 2011-06-13 17:00 UTC (permalink / raw)
To: dbhandary@iii.com; pgsql-admin
Dinesh Bhandary <dbhandary@iii.com> wrote:
> Is there a way to change work_mem for a session in postgres
> without restarting a database? Please let me know.
SET work_mem
http://www.postgresql.org/docs/9.0/interactive/sql-set.html
-Kevin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: changing work_mem
@ 2011-06-13 19:50 Scott Marlowe <scott.marlowe@gmail.com>
parent: Dinesh Bhandary <dbhandary@iii.com>
3 siblings, 0 replies; 5+ messages in thread
From: Scott Marlowe @ 2011-06-13 19:50 UTC (permalink / raw)
To: dbhandary@iii.com; +Cc: pgsql-admin
On Mon, Jun 13, 2011 at 10:29 AM, Dinesh Bhandary <dbhandary@iii.com> wrote:
> Hi All -
>
> Is there a way to change work_mem for a session in postgres without
> restarting a database? Please let me know.
In addition the standard set work_mem='512MB'; listed above, you can
make such changes sticky for a user or a database:
alter user bubba set work_mem='1000MB';
alter database reports set work_mem='256MB';
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-06-13 19:50 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-06-13 16:29 changing work_mem Dinesh Bhandary <dbhandary@iii.com>
2011-06-13 16:52 ` Plugge, Joe R. <JRPlugge@west.com>
2011-06-13 16:58 ` Chris Ernst <cernst@zvelo.com>
2011-06-13 17:00 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-06-13 19:50 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox