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

From Alvaro Herrera
Subject Re: ERROR: failed to build any 8-way joins
Date
Msg-id 20070215152525.GI4682@alvh.no-ip.org
Whole thread Raw
In response to ERROR: failed to build any 8-way joins  (Mario Weilguni <mweilguni@sime.com>)
Responses Re: ERROR: failed to build any 8-way joins  (Mario Weilguni <mweilguni@sime.com>)
List pgsql-hackers
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
difficultto 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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Plan for compressed varlena headers
Next
From: Mario Weilguni
Date:
Subject: Re: ERROR: failed to build any 8-way joins