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@road14.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@gmail.com
LlamaLand                       http://netllama.linux-sxs.org