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