Skip site navigation (1) Skip section navigation (2)

Re: changes to postgresql.conf

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Johnny Tan <johnnydtan(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: changes to postgresql.conf
Date: 2012-09-24 13:20:54
Message-ID: CABUevEwoUao=U651Q+=hfoyGDJK8jWkmXT11DutFk2jVuAwxpA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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.

-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


In response to

Responses

pgsql-admin by date

Next:From: Johnny TanDate: 2012-09-24 13:32:23
Subject: Re: changes to postgresql.conf
Previous:From: Bruce MomjianDate: 2012-09-24 13:08:20
Subject: Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group