Re: long sql "in" clause crashes server process (8.0 Release)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: long sql "in" clause crashes server process (8.0 Release)
Date: 2005-01-26 21:59:19
Message-ID: 20518.1106776759@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

"Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
> On MingW, you add:
> -Wl,--stack=4194304
> to get 4Mb stack. At least the value increases in the header.

> And I can confirm that doing this fixes the problem and turns it into
> the error message about stack size. (But won't things crash again if I
> increase that one? Or will it increase the stack manually then?)

> Patch attached.

Applied. Some googling confirmed that cygwin uses this switch too,
so I added it in that makefile branch as well. The references I found
suggested a slightly different syntax: -Wl,--stack,4194304. It's
likely that the "=" variant works fine on cygwin too, but just for
paranoia's sake I followed the references.

regards, tom lane

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Merlin Moncure 2005-01-27 17:38:58 why postgresql does not run as local sysetm.
Previous Message Tom Lane 2005-01-26 19:47:16 Re: Opening stdin/stdout in binary mode on Windows