Markus Schiltknecht wrote:
Hi,One of our PostgreSQL 8.1.5 databases constantly crashed on a certain query (backend SEGFAULTs). I've figured the crashes were caused by a very long IN() clause.
(Sorry for replying twice in a row)Could it be out-of-memory rather than a segfault you're seeing? That is, you've got max_stack_depth set high enough that you're exhausting system RAM (Or some other limit).
-- Richard Huxton Archonet Ltd
