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@xxxxxxxxxx> 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@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
