On Thu, 27 Jan 2005 20:05:19 -0600, Jim C. Nasby <decibel@xxxxxxxxxxx> wrote: > 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@xxxxxxxxxxx> 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. excellent, that worked! thanks! -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ L. Friedman netllama@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
