Re: changing sort_mem on the fly?
От | Jim C. Nasby |
---|---|
Тема | Re: changing sort_mem on the fly? |
Дата | |
Msg-id | 20050128002321.GP67721@decibel.org обсуждение исходный текст |
Ответ на | changing sort_mem on the fly? (Lonni J Friedman <netllama@gmail.com>) |
Ответы |
Re: changing sort_mem on the fly?
Re: changing sort_mem on the fly? |
Список | pgsql-general |
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. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"
В списке pgsql-general по дате отправления: