Re: lots of values for IN() clause - Mailing list pgsql-general

From Richard Huxton
Subject Re: lots of values for IN() clause
Date
Msg-id 454A175C.5090202@archonet.com
Whole thread Raw
In response to lots of values for IN() clause  (Markus Schiltknecht <markus@bluegap.ch>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: lots of values for IN() clause
Next
From: Andreas Kretschmer
Date:
Subject: Re: pg_dump question