On Thu, 21 Aug 2008, Tom Lane wrote:
> I think you need to raise from_collapse_limit and/or
> join_collapse_limit.
Ahah, that was it.. a much simpler solution than I was fearing.
I had already re-written the queries to get around it, but ran into
another snag with that method, so this was good t
[EMAIL PROTECTED] writes:
> One query works fast, returning results in under a second. If I insert
> one more join into the table however, it switches to nested-loops and
> takes minutes.
I think you need to raise from_collapse_limit and/or
join_collapse_limit.
regards,
I only have a few days of experience with postgres and it is working
great, but when I start building up test queries I ran into a problem I
don't understand.
One query works fast, returning results in under a second. If I insert
one more join into the table however, it switches to nested-loop