On Mon, Sep 24, 2012 at 3:05 PM, Johnny Tan <johnnydtan(at)gmail(dot)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.
In response to
pgsql-admin by date
|Next:||From: Johnny Tan||Date: 2012-09-24 13:32:23|
|Subject: Re: changes to postgresql.conf|
|Previous:||From: Bruce Momjian||Date: 2012-09-24 13:08:20|
|Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed|