On 05/25/2013 09:56 AM, Gurjeet Singh wrote:
> When Postgres encounters a long list of AND/OR chains, it errors out at
> check_stack_depth() after a limit of few thousand. At around 10,000
> elements, the recursion at assign_expr_collations() causes the error. But
> at a little higher element count, around 15,000, the recursion check errors
> out a little earlier, in the stack around transformAExprAnd(). The test
> queries were generated using the attached test.sh script.
***15,000***? I'd say that someone has an application design issue.
Fixing the stack overflow is a good thing, but that query is never going
to return ...
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com