Postgres Pro
Downloads
Home   >   mailing lists

Re: changing work_mem - Mailing list pgsql-admin

From Chris Ernst
Subject Re: changing work_mem
Date
Msg-id 4DF641B5.5060409@zvelo.com
Whole thread Raw
In response to changing work_mem  (Dinesh Bhandary <dbhandary@iii.com>)
List pgsql-admin
Tree view 
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
>

pgsql-admin by date:

Previous
From: "Plugge, Joe R."
Date:
Subject: Re: changing work_mem
Next
From: Tim
Date:
Subject: tsvector limitations