> 8.2 patch is here, if you need it now:
> http://archives.postgresql.org/pgsql-committers/2008-01/msg00164.php
Thanks. I have applied this patch and everything works fine.
Regards,
Oleg
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmast
I wrote:
> The most expedient way to fix it seems to be to make
> has_legal_joinclause consider, not the set of all relations anywhere
> in the query, but just members of the current initial_rels list.
8.2 patch is here, if you need it now:
http://archives.postgresql.org/pgsql-committers/2008-01/m
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> 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
[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 quer
Oleg Kharin wrote:
The following bug has been logged online:
Bug reference: 3865
Logged by: Oleg Kharin
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.6
Operating system: CentOS 5.1 x86 64-bit
Description:ERROR: failed to build any 8-way joins
Details:
A
The following bug has been logged online:
Bug reference: 3865
Logged by: Oleg Kharin
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.6
Operating system: CentOS 5.1 x86 64-bit
Description:ERROR: failed to build any 8-way joins
Details:
After PostgreSQL 8.2.5
