Postgres Pro
Downloads
Home   >   mailing lists

changing sort_mem on the fly? - Mailing list pgsql-general

From Lonni J Friedman
Subject changing sort_mem on the fly?
Date
Msg-id 7c1574a905012714573b41fdbb@mail.gmail.com
Whole thread Raw
Responses Re: changing sort_mem on the fly?  ("Jim C. Nasby" <decibel@decibel.org>)
Re: changing sort_mem on the fly?  ("Jonel Rienton" <jonel@road14.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: GiST index not used for ORDER BY?
Next
From: Stephen Frost
Date:
Subject: Re: convert mdb files to pg?