Re: [ADMIN] changes to postgresql.conf

2012-09-24 Thread Steve Crawford
On 09/24/2012 06:05 AM, Johnny Tan 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? To

Re: [ADMIN] changes to postgresql.conf

2012-09-24 Thread Johnny Tan
On Sep 24, 2012 9:20 AM, "Magnus Hagander" wrote: > > For shared_buffers, you need a stop/start. For the other three, a > reload is enough. Thank you.

Re: [ADMIN] changes to postgresql.conf

2012-09-24 Thread Magnus Hagander
On Mon, Sep 24, 2012 at 3:05 PM, Johnny Tan 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 t

[ADMIN] changes to postgresql.conf

2012-09-24 Thread Johnny Tan
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? -- Sent via pgsql-admin mailing list (pgsql-a