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/