From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Paul Turton <no-2(at)uber-force(dot)co(dot)uk> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Hard max_stack_depth / WIN32_STACK_RLIMIT PostgreSQL Windows Query |
Date: | 2024-01-05 15:26:01 |
Message-ID: | 948271.1704468361@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Paul Turton <no-2(at)uber-force(dot)co(dot)uk> writes:
> Looking at the source code it appears that the maximum stack limit is hard coded as 4194304 bytes for Windows builds. My query is why this number was picked? Is it to do with the maximum size the Windows Kernel will allow? Could I just increase the number and re-compile, or would that break other things?
A bit of "git blame" archaeology says that that traces back to
commit bf7737a938827608ce79586efe55c642c1a4a7d3
Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Date: Wed Jan 26 21:55:26 2005 +0000
On Windows, set the postmaster executable's stack size to 4MB, so that
it agrees with the default value of max_stack_depth.
So yeah, you could probably increase it in a custom build. However,
I question a bit why you think you need to. IME hardly anyone ever
fools with max_stack_depth, on any platform.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2024-01-06 08:36:59 | Re: Filled Postgres server as Docker image |
Previous Message | Paul Turton | 2024-01-05 12:07:14 | Hard max_stack_depth / WIN32_STACK_RLIMIT PostgreSQL Windows Query |