X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3B03FD1B55E for ; Tue, 16 Dec 2003 16:24:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 62956-07 for ; Tue, 16 Dec 2003 12:24:13 -0400 (AST) Received: from vsmtp3alice.tin.it (vsmtp3.tin.it [212.216.176.223]) by svr1.postgresql.org (Postfix) with ESMTP id 0E314D1B566 for ; Tue, 16 Dec 2003 12:24:13 -0400 (AST) Received: from dedalus1 (80.182.51.229) by vsmtp3alice.tin.it (7.0.019) id 3FCEEABF00116BBE; Tue, 16 Dec 2003 17:23:40 +0100 Message-ID: <019601c3c3f0$f8c1e590$0200a8c0@dedalus1> From: "Alessandro Depase" To: "Richard Huxton" , "Peter Eisentraut" , References: <001e01c3c3ca$4c0c4af0$0200a8c0@dedalus1> <200312161430.47119.peter_e@gmx.net> <000f01c3c3ea$1294efa0$0200a8c0@dedalus1> <200312161612.02303.dev@archonet.com> Subject: Re: failed to build any 5-way joins Date: Tue, 16 Dec 2003 17:23:41 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/122 X-Sequence-Number: 16288 The version declared by the cygwin setup is 7.4-1 (I don't know if the '-1' is the same that your '.1' or, for example, a progressive in the cygwin PostgreSQL build sequence). A 'select version()' answers with this information: PostgreSQL 7.4 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.3.1 (cygming special) Are there other ways to get a better insight? Alessandro Depase ----- Original Message ----- From: "Richard Huxton" To: "Alessandro Depase" ; "Peter Eisentraut" ; Sent: Tuesday, December 16, 2003 5:12 PM Subject: Re: [SQL] failed to build any 5-way joins > On Tuesday 16 December 2003 15:34, Alessandro Depase wrote: > > > People smarter than me are looking at this, but I can give you some quick > feedback. > > Version? In my previous message I told that I'm using 7.4-1 on cygwin > > distribution. What other info do you need? How can I get them? > > Are you sure it's 7.4.1? I wasn't aware that was publicly released yet. > > > All I can think more than this is that I use a Windows XP O.S. and that I > > got this error both using JDBC and using pgAdmin III (but it seems to me > > that this is an error client-independent). > > It certainly looks like a bug in PG itself, rather than client-related. I'd > agree with your guess that it's somewhere in the query rewriter. > > > The other problem, however, as I asked before, is: where can I find the > > documentation for this error (well, besides the source, of course)? are > > there known limits in joining tables? > > I'm not aware of any particular limits on joins. There's even a genetic > optimiser that kicks in when joins go above a certain number of tables > (default of 12 but configurable in 7.4 iirc?). > > -- > Richard Huxton > Archonet Ltd > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > >