changing sort_mem on the fly?

From: Lonni J Friedman <netllama(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: changing sort_mem on the fly?
Date: 2005-01-27 22:57:22
Message-ID: 7c1574a905012714573b41fdbb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2005-01-27 23:26:13 Re: convert mdb files to pg?
Previous Message Tom Lane 2005-01-27 22:50:55 Re: GiST index not used for ORDER BY?