From: | "Jim Nasby" <jnasby(at)pervasive(dot)com> |
---|---|
To: | "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | <pgsql-hackers(at)postgresql(dot)org>, "Greg Stark" <gsstark(at)mit(dot)edu>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: TODO questions |
Date: | 2005-08-24 20:51:46 |
Message-ID: | D1D2D51E3BE3FC4E98598248901F7594027E5526@ausmail2k4.aus.pervasive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Wednesday, August 24, 2005 3:40 PM
> To: Robert Treat
> Cc: pgsql-hackers(at)postgresql(dot)org; Jim Nasby; Greg Stark; Tom Lane
> Subject: Re: [HACKERS] TODO questions
>
>
> Robert Treat wrote:
> > I've always been of the impression that this idea just wont
> work. For
> > example, if I set shared_buffers to some number, start my
> database, then
> > comment the line out and "reload" my conf file, it just
> isnt going to reset
> > to the default. (Or at least to make it do so requires a
> *lot* more work than
> > just modifing the guc / conf file mechanisms).
>
> True, but you can't modify shared_buffers anyway unless you
> restart, so
> people should realize that.
Which is why I think it would be best to get as close as we can to the configuration that you'd get during a restart and warn about everything else. So, for example, if you're runing with a non-default shared_buffers and you comment shared_buffers out and do a reload, you should get a warning that shared_buffers has changed from xxx -> yyy but that change won't take effect until the server is restarted. That way there's absolutely no confusion.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2005-08-24 21:50:50 | Win32 Thread safetyness |
Previous Message | Bruce Momjian | 2005-08-24 20:39:40 | Re: TODO questions |