Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Florian Weimer <fw(at)deneb(dot)enyo(dot)de>
Cc: Trevor Talbot <quension(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Laurent Duperval <lduperval(at)yahoo(dot)com>, 'PostgreSQL' <pgsql-general(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit
Date: 2007-10-22 18:52:33
Message-ID: 471CF171.6090101@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Florian Weimer wrote:
> * Magnus Hagander:
>
>> Oh, that's interesting. That's actually a sideeffect of us increasing
>> the stack size for the postgres.exe executable in order to work on other
>> things. By default, it burns 1MB/thread, but ours will do 4MB. Never
>> really thought of the problem that it'll run out of address space.
>> Unfortunately, that size can't be changed in the CreateThread() call -
>> only the initially committed size can be changed there.
>
> Windows XP supports the STACK_SIZE_PARAM_IS_A_RESERVATION flag, which
> apparently allows to reduce the reserved size. It might be better to do
> this the other way round, though (leave the reservation at its 1 MB
> default, and increase it only when necessary).

It does, but we still support windows 2000 as well. I think it's better
to use a different method altogether - one not using one thread per child.

//Magnus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-10-22 19:19:22 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Florian Weimer 2007-10-22 18:48:34 Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2007-10-22 18:53:44 Re: Feature Freeze date for 8.4
Previous Message Florian Weimer 2007-10-22 18:48:34 Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit