Re: changing sort_mem on the fly? - Mailing list pgsql-general

From Michael Fuhr
Subject Re: changing sort_mem on the fly?
Date
Msg-id 20050128012305.GA48364@winnie.fuhr.org
Whole thread Raw
In response to Re: changing sort_mem on the fly?  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: changing sort_mem on the fly?  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-general
On Thu, Jan 27, 2005 at 06:23:21PM -0600, Jim C. Nasby wrote:
>
> If you just want to change it for one connection, you can do 'set
> sort_mem=newvalue;'. You might need to be an admin to do it, though.

Ordinary users can set sort_mem/work_mem, at least in 8.0.0 and
earlier.  Does setting that variable per session actually have an
effect, and if it does, does allowing ordinary users to set it
present a risk?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Pailloncy Jean-Gerard
Date:
Subject: Re: Extended unit
Next
From: "DBTools Software"
Date:
Subject: Re: convert mdb files to pg?