Re: changing sort_mem on the fly?

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?
>
> thanks!
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> L. Friedman netllama(at)gmail(dot)com
> LlamaLand http://netllama.linux-sxs.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate