| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| 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 17:34:38 |
| Message-ID: | 506099AE.3060101@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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 expand on other responses, try "select * from pg_settings;" and see
http://www.postgresql.org/docs/current/static/view-pg-settings.html
Anything with a "context" of "postmaster" requires a restart so while
shared_buffers requires a restart the other three do not and, in fact,
can be set by a user on a per-connection basis.
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kasia Tuszynska | 2012-09-24 18:07:37 | Backup and Restore from 8.3.0 to 9.1.3 |
| Previous Message | Tom Lane | 2012-09-24 16:30:45 | Re: CPU causes 100% load in user space when ntp client runs and postgresql is under heavy load |