Re: Problem with very big queries.

Panagiotis Papadakos <papadako(at)csd(dot)uoc(dot)gr> writes:
> I want to send to postgresql-8.0 a very big query,
> select * from table where lala IN (....)
> Inside IN there are almost 60000 values.

> Unfortunately, the server terminates with a singal 11 and I get
> to my console the following:

It shouldn't crash. I suspect you tried this, got

ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth".

and blindly followed the HINT without any regard for whether the value
you picked was actually safe on your platform. If you make
max_stack_depth bigger than what the kernel allows, you will indeed
get a crash; but that's not a bug it's pilot error.

More recent PG versions try to limit max_stack_depth to a safe value,
but 8.0 just believes what you tell it.

regards, tom lane