Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D6B6B635885 for ; Tue, 13 Apr 2010 14:56:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 23202-01-4 for ; Tue, 13 Apr 2010 17:56:33 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231]) by mail.postgresql.org (Postfix) with ESMTP id 72F19635861 for ; Tue, 13 Apr 2010 14:56:34 -0300 (ADT) Received: from in01.mta.xmission.com ([166.70.13.51]) by out01.mta.xmission.com with esmtps (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1O1kLg-0008VI-VS; Tue, 13 Apr 2010 11:56:32 -0600 Received: from [208.187.158.94] (helo=[172.16.1.233]) by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1O1kLg-0000TN-Pw; Tue, 13 Apr 2010 11:56:32 -0600 Message-ID: <4BC4B0A1.2090604@gmail.com> Date: Tue, 13 Apr 2010 11:57:53 -0600 From: Rob Sargent User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.8) Gecko/20100228 SUSE/3.0.3-1.1.1 Thunderbird/3.0.3 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: [ADMIN] Getting the initdb parameter values References: <3A8C969225424C4D8E6BEE65ED8552DA0119F14C@XMB-BGL-41C.cisco.com> <1271163390.2285.84.camel@deimos> <3A8C969225424C4D8E6BEE65ED8552DA0119F18A@XMB-BGL-41C.cisco.com> In-Reply-To: <3A8C969225424C4D8E6BEE65ED8552DA0119F18A@XMB-BGL-41C.cisco.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ; ip=208.187.158.94; ; ; frm=robjsargent@gmail.com; ; ; spf=neutral X-SA-Exim-Connect-IP: 208.187.158.94 X-SA-Exim-Rcpt-To: pgsql-sql@postgresql.org, rsargent@amirsys.com X-SA-Exim-Mail-From: robjsargent@gmail.com X-SA-Exim-Scanned: No (on in01.mta.xmission.com); SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.947 tagged_above=-10 required=5 tests=AWL=-0.047, BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201004/49 X-Sequence-Number: 33976 As I read it, it doesn't matter what the value was originally, it's what's in postgresql.conf _now_ that matters. This is a resource allocation: I suspect there's no limit on how much of your (often precious) memory you wish to set aside for this. On 04/13/2010 07:01 AM, Satish Burnwal (sburnwal) wrote: > What you have mentioned is already there in postgresql.conf file. I want > to know whats the max value allowed ? Doc seems to be saying that max > allowed value is determined during initdb. How to get this max allowed > value ? >