From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
---|---|
To: | Oleg Kharin <ok(at)uvadrev(dot)udmnet(dot)ru> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3865: ERROR: failed to build any 8-way joins |
Date: | 2008-01-10 07:48:37 |
Message-ID: | 4785CDD5.5070702@kaltenbrunner.cc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
[RESENDING because the attachments seems to have caused the mail to
disappear]
Oleg Kharin wrote:
> Hi, Stefan
Hi Oleg!
I have readded the list and the testcases to the CC so that others can
participate in the discussion too ...
>
> init826.sql builds necessary tables and indexes. The test query is in
> the file query826.sql.
I can confirm that this works on 8.2.5 but fails:
* on -HEAD
* on 8.2.6 (so we have a rather bad regression)
with a join_collaps_limit > 3 and < 10 - you could increase that on your
box but it is likely that other queries are affected in a different way
so it might not help at all.
the testcase from oleg is available on:
http://www.kaltenbrunner.cc/files/init826.sql (DDL)
http://www.kaltenbrunner.cc/files/query826.sql (Query)
Stefan
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Lorber | 2008-01-10 18:27:54 | BUG #3867: PQconnectdb(NULL) cores instead of errors. |
Previous Message | Alvaro Herrera | 2008-01-10 03:20:46 | Re: BUG #3860: xpath crashes backend when is querying xmlagg result |