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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
