changing sort_mem on the fly?

Поиск
Список
Период
Сортировка
От Lonni J Friedman
Тема changing sort_mem on the fly?
Дата
Msg-id 7c1574a905012714573b41fdbb@mail.gmail.com
обсуждение исходный текст
Ответы Re: changing sort_mem on the fly?
Re: changing sort_mem on the fly?
Список pgsql-general
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@gmail.com
LlamaLand                       http://netllama.linux-sxs.org

В списке pgsql-general по дате отправления: