On Thu, Nov 18, 2004 at 04:17:31AM +0100, Palle Girgensohn wrote: > Does the same arguments apply for linking with libc_r (pthreads)? > > It is needed by plpython, at least on FreeBSD 4.10 (probably all versions).
There are problem with libc_r on FreeBSD: due to initializing of red zone for initial thread's stack, postgresql stack gets limited to just 1M. There are patch in queue for increasing initial stack to 8/32/xxxM, but official reaction was: "create new thread with right stack size and use it for main loop" ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster