Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGCYM-0004lU-GL for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 17:34:42 +0000 Received: from cerberus.pinpointresearch.com ([66.7.238.130] helo=polaris.pinpointresearch.com) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TGCYK-0006ts-NE for pgsql-admin@postgresql.org; Mon, 24 Sep 2012 17:34:41 +0000 Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 8609BE00EC84; Mon, 24 Sep 2012 10:34:38 -0700 (PDT) Message-ID: <506099AE.3060101@pinpointresearch.com> Date: Mon, 24 Sep 2012 10:34:38 -0700 From: Steve Crawford User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120827 Thunderbird/15.0 MIME-Version: 1.0 To: Johnny Tan CC: pgsql-admin@postgresql.org Subject: Re: changes to postgresql.conf References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.7 (--) X-Archive-Number: 201209/135 X-Sequence-Number: 40076 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