Re: bad function lets postgres crash - Mailing list pgsql-general

From Tom Lane
Subject Re: bad function lets postgres crash
Date
Msg-id 16686.1183514849@sss.pgh.pa.us
Whole thread Raw
In response to bad function lets postgres crash  (Clemens Schwaighofer <cs@tequila.co.jp>)
List pgsql-general
Clemens Schwaighofer <cs@tequila.co.jp> writes:
> both servers are debian packages 8.1.9-1, but on the one that crashed I
> increased the stack depth to 8192. Could it be that postgres ran out of
> memory and terminated itself?

Increasing the stack depth parameter to more than what the kernel really
allows *will* cause crashes, whenever the kernel's limit is exceeded.
Check the ulimit settings the postmaster was started under.

Since (I think) 8.2 we have some code in there that tries to prevent
setting max_stack_depth higher than is safe; but older versions assume
you know what you're doing.

            regards, tom lane

pgsql-general by date:

Previous
From: Clemens Schwaighofer
Date:
Subject: bad function lets postgres crash
Next
From: Berend Tober
Date:
Subject: Re: How do I aggregate data from multiple rows into a delimited list?