Gareth Boden <[EMAIL PROTECTED]> writes: > Bizarrely, it came down to an infinite recursion in a plpgsql function > we were using which exhausted memory and crashed the db server. Is > there any way of limiting stack depth/having some sort of monitor on > these functions to prevent this behaviour in future?
There's been some talk of this, but the sticking point has been to figure out a reasonably portable way to measure and enforce stack usage... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend