Re: changing work_mem

From: Chris Ernst <cernst(at)zvelo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: changing work_mem
Date: 2011-06-13 16:58:29
Message-ID: 4DF641B5.5060409@zvelo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-06-13 17:00:52 Re: changing work_mem
Previous Message Plugge, Joe R. 2011-06-13 16:52:21 Re: changing work_mem