Search Postgresql Archives

Re: bad function lets postgres crash

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Clemens Schwaighofer <cs@xxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux