pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedAbount max_stack_depth's default value
2+ messages / 2 participants
[nested] [flat]
* Abount max_stack_depth's default value
@ 2011-11-24 09:53 Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>
0 siblings, 1 reply; 2+ messages in thread
From: Naoya Anzai @ 2011-11-24 09:53 UTC (permalink / raw)
To: pgsql-docs; +Cc: Akio Iwaasa <iwaasa@mxs.nes.nec.co.jp>
Hi,
On http://www.postgresql.org/docs/9.1/interactive/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-...
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.
Regards.
---
Naoya Anzai
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Abount max_stack_depth's default value
@ 2011-11-24 20:30 Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
parent: Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>
0 siblings, 0 replies; 2+ messages in thread
From: Heikki Linnakangas @ 2011-11-24 20:30 UTC (permalink / raw)
To: Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>; +Cc: pgsql-docs@postgresql.org, Akio Iwaasa <iwaasa@mxs.nes.nec.co.jp>
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-...
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-11-24 20:30 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-11-24 09:53 Abount max_stack_depth's default value Naoya Anzai <anzai-naoya@mxu.nes.nec.co.jp>
2011-11-24 20:30 ` Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox