Re: question about efficiency

> Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
>> It's basically converted it into a three way join.
>
> More to the point, an *unconstrained* join between "claimsum2001
> as claimsum2001" and the intended joined table.  The reason it
> ran for so long was it was generating a huge number of rows ---
> as many as would be in the cross product.

Would it be possible to have some sort of configurable limit on this:

max_result_set_size = 10,000,000
max_result_set_action = ignore | debug | warn | error

The planner knows how many rows it's expecting to return, and a warning
message would show up unconstrained queries like this.

- Richard Huxton