Re: Solved? Re: 8.2.4 signal 11 with large transaction - Mailing list pgsql-general

From Andrew - Supernews
Subject Re: Solved? Re: 8.2.4 signal 11 with large transaction
Date
Msg-id slrnfa2mor.31cl.andrew+nonews@atlantis.supernews.net
Whole thread Raw
In response to 8.2.4 signal 11 with large transaction  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-general
On 2007-07-20, Bill Moran <wmoran@collaborativefusion.com> wrote:
> It just occurred to me that there's another wildcard in this one.
> The 8.1 system I tested was on FreeBSD 5.5, while both 8.2 systems
> were running on FreeBSD 6.2.  I wonder if FreeBSD has changed
> which signal gets sent on memory exhaustion?

Neither 5.x nor 6.x send any sort of signal simply because maxdsize was
reached; the only effect of reaching maxdsize is that further memory
allocations fail.

I'd guess that the most likely cause for a sig11 under those circumstances
is a stack overflow resulting from recursive errors...

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Foreign key constraint question
Next
From: "Hiroshi Saito"
Date:
Subject: Re: psql-odbc configure error