Re: changing sort_mem on the fly?

OK, but does that actually work to change sort_mem for all future connections?

On Thu, 27 Jan 2005 19:25:51 -0600, Jonel Rienton <jonel(at)road14(dot)com> wrote:
> I usually use pg_ctl reload instead of kill
>
> On Thu, 27 Jan 2005 14:57:22 -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?

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org