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@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx