Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id DFEB72EBA7B for ; Thu, 24 Nov 2011 16:30:37 -0400 (AST) Received: from exprod7og111.obsmtp.com ([64.18.2.175]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RTfwJ-0005k0-VO for pgsql-docs@postgresql.org; Thu, 24 Nov 2011 20:30:37 +0000 Received: from mail-bw0-f45.google.com ([209.85.214.45]) (using TLSv1) by exprod7ob111.postini.com ([64.18.6.12]) with SMTP ID DSNKTs6pXRChlOeHQozzeZGABjhoMgdj5kX4@postini.com; Thu, 24 Nov 2011 12:30:35 PST Received: by bkbzu5 with SMTP id zu5so3884687bkb.32 for ; Thu, 24 Nov 2011 12:30:20 -0800 (PST) Received: by 10.204.29.8 with SMTP id o8mr30068123bkc.48.1322166619916; Thu, 24 Nov 2011 12:30:19 -0800 (PST) Received: from [192.168.1.100] (dsl-hkibrasgw2-ff6cc300-200.dhcp.inet.fi. [88.195.108.200]) by mx.google.com with ESMTPS id c12sm26355902fam.1.2011.11.24.12.30.17 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 24 Nov 2011 12:30:18 -0800 (PST) Message-ID: <4ECEA958.8050703@enterprisedb.com> Date: Thu, 24 Nov 2011 22:30:16 +0200 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.2.23) Gecko/20111010 Icedove/3.1.15 MIME-Version: 1.0 To: Naoya Anzai CC: pgsql-docs@postgresql.org, Akio Iwaasa Subject: Re: Abount max_stack_depth's default value References: <50CCAA8EE67154anzai-naoya@mxu.nes.nec.co.jp> In-Reply-To: <50CCAA8EE67154anzai-naoya@mxu.nes.nec.co.jp> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 201111/21 X-Sequence-Number: 7096 On 24.11.2011 11:53, Naoya Anzai wrote: > Hi, > > On http://www.postgresql.org/docs/9.1/interactive/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY > max_stack_depth's default setting was wrote it is two megabytes. But,I think that this explanation is not true. > In my environment, When "`ulimit -s` - 512KB" value is less than 2MB, this value is set up as a default value. > And I also notice that If "ulimit -s" value is "unlimited", then "100KB" is set up on the PostgreSQL 9.0 and less. > So,I think that you should write that max_stack_depth's default setting depends on stack size when it is less than 2.5MB, > and "100KB" is set up on the PostgreSQL 9.0 and less when stack size is unlimited. Well, the doc section does say: "On platforms where PostgreSQL can determine the kernel limit, the server will not allow this variable to be set to an unsafe value. " though I agree it's a bit vague. It doesn't explicitly say that on such platforms, the default value will be chosen automatically. Want to suggest how to phrase that section in the docs? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com