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/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
