Re: changing sort_mem on the fly?

On Thu, Jan 27, 2005 at 05:52:41PM -0800, Lonni J Friedman wrote:
> On Thu, 27 Jan 2005 18:23:21 -0600, Jim C. Nasby <decibel(at)decibel(dot)org> wrote:
> > On Thu, Jan 27, 2005 at 02:57:22PM -0800, Lonni J Friedman wrote:
> > > Is there any way to increase sort_mem without having to perform a full
> > > restart of the DB? Will just doing a 'kill -HUP $PID" work as long as
> > > i've made the change in postgresql.conf first?
> > >
> > > As a side question, are the options that will take effect with a kill
> > > -HUP documented somewhere?
> >
> > 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.
>
> I need to do it for all future connections, not just one.

'm guessing pg_ctl reload would take effect on all new connections. Try
it, and see what psql -c 'show sort_mem' says.
--
Jim C. Nasby, Database Consultant decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"