On Mon, Sep 24, 2012 at 3:05 PM, Johnny Tan <johnnyd...@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/ -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
