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

From Lonni J Friedman
Subject Re: changing sort_mem on the fly?
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: changing sort_mem on the fly?  ("Jonel Rienton" <[email protected]>)
List pgsql-general
OK, but does that actually work to change sort_mem for all future connections?


On Thu, 27 Jan 2005 19:25:51 -0600, Jonel Rienton <[email protected]> wrote:
> I usually use pg_ctl reload instead of kill
>
> On Thu, 27 Jan 2005 14:57:22 -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?



--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    [email protected]
LlamaLand                       http://netllama.linux-sxs.org

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Problem with the copy command need help
Next
From: Lonni J Friedman
Date:
Subject: Re: changing sort_mem on the fly?