Re: ERROR: failed to build any 8-way joins

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ERROR: failed to build any 8-way joins
Date: 2007-02-15 15:38:54
Message-ID: 200702151638.54224.mweilguni@sime.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thanks for the info. Is there a fix for 8.1 branch, the production system is
still 8.1.

Regards
Mario 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-02-15 15:42:49 Re: Plan for compressed varlena headers
Previous Message Tom Lane 2007-02-15 15:37:26 Re: patch adding new regexp functions