Re: ERROR: failed to build any 8-way joins - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: ERROR: failed to build any 8-way joins
Date
Msg-id 200702151638.54224.mweilguni@sime.com
Whole thread Raw
In response to Re: ERROR: failed to build any 8-way joins  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Thanks for the info. Is there a fix for 8.1 branch, the production system is 
still 8.1.

RegardsMario Weilguni


Am Donnerstag, 15. Februar 2007 16:25 schrieb Alvaro Herrera:
> Mario Weilguni wrote:
> > Interesting: remove any of the above where conditions solves  the problem
> > go away, e.g. removing "and bei.id=10157309".
> >
> > Testet with 8.2.1 and 8.1.4, same effect on both systems. Because of the
> > large number of tables involved it's difficult to find a self contained
> > patch, but if necessary I'll give it a try. I could give 8.2.3 a try, but
> > I doubt this will help.
>
> I think a similar problem was fixed after 8.2.3 was released, so you may
> want to check out the REL8_2_STABLE branch.


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ERROR: failed to build any 8-way joins
Next
From: Tom Lane
Date:
Subject: Re: Plan for compressed varlena headers