pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Alessandro Depase <alessandro.depase@libero.it>
To: Richard Huxton <dev@archonet.com>
To: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: failed to build any 5-way joins
Date: Tue, 16 Dec 2003 17:23:41 +0100
Message-ID: <019601c3c3f0$f8c1e590$0200a8c0@dedalus1> (raw)
References: <001e01c3c3ca$4c0c4af0$0200a8c0@dedalus1>
<200312161430.47119.peter_e@gmx.net>
<000f01c3c3ea$1294efa0$0200a8c0@dedalus1>
<200312161612.02303.dev@archonet.com>
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" <dev@archonet.com>
To: "Alessandro Depase" <alessandro.depase@libero.it>; "Peter Eisentraut"
<peter_e@gmx.net>; <pgsql-sql@postgresql.org>
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
>
>
view thread (8+ messages) latest in thread
Message-ID: <019601c3c3f0$f8c1e590$0200a8c0@dedalus1> Permalink: ../019601c3c3f0$f8c1e590$0200a8c0@dedalus1/ Also on: postgresql.org/message-id/019601c3c3f0$f8c1e590$0200a8c0@dedalus1 ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-sql@postgresql.org Cc: alessandro.depase@libero.it, dev@archonet.com, peter_e@gmx.net Subject: Re: failed to build any 5-way joins In-Reply-To: <019601c3c3f0$f8c1e590$0200a8c0@dedalus1> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox