Re: long sql "in" clause crashes server process (8.0 Release)
"Merlin Moncure" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
> > I'm suspicious that either the stack depth detection code doesn't work > > at all on Windows, or the default setting of max_stack_depth is in > fact > > more than the default physical stack size on Windows. Can anyone > check? > > > > regards, tom lane > > C:\msys\1.0\local\pgsql\bin>"c:\Program Files\Microsoft Visual > Studio\VC98\Bin"\dumpbin /headers pos > tmaster.exe | grep stack > 200000 size of stack reserve > 1000 size of stack commit clarification: those #s are in hex. So that's about 2mb of stack as I read it. Merlin ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings