From: | Lonni J Friedman <netllama(at)gmail(dot)com> |
---|---|
To: | "Jim C(dot) Nasby" <decibel(at)decibel(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: changing sort_mem on the fly? |
Date: | 2005-01-28 02:14:35 |
Message-ID: | 7c1574a905012718147bc6b2c8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 27 Jan 2005 20:05:19 -0600, Jim C. Nasby <decibel(at)decibel(dot)org> wrote:
> On Thu, Jan 27, 2005 at 05:52:41PM -0800, Lonni J Friedman wrote:
> > On Thu, 27 Jan 2005 18:23:21 -0600, Jim C. Nasby <decibel(at)decibel(dot)org> wrote:
> > > 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.
> >
> > I need to do it for all future connections, not just one.
>
> 'm guessing pg_ctl reload would take effect on all new connections. Try
> it, and see what psql -c 'show sort_mem' says.
excellent, that worked! thanks!
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman netllama(at)gmail(dot)com
LlamaLand http://netllama.linux-sxs.org
From | Date | Subject | |
---|---|---|---|
Next Message | Alonso Garca | 2005-01-28 02:17:43 | How to read sql commans from file resolved |
Previous Message | Jim C. Nasby | 2005-01-28 02:05:19 | Re: changing sort_mem on the fly? |