On Mon, Sep 24, 2012 at 3:05 PM, Johnny Tan <johnnydtan@gmail.com> wrote:
> I need to make changes to these settings in postgresql.conf:
> * effective_cache_size
> * shared_buffers
> * work_mem
> * maintenance_work_mem
>
> On a live, production server, can I simply do a "reload" and get those
> values in, or do I need to do a stop/start?
For shared_buffers, you need a stop/start. For the other three, a
reload is enough.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/