From: | "Alessandro Depase" <alessandro(dot)depase(at)libero(dot)it> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: failed to build any 5-way joins |
Date: | 2003-12-16 16:23:41 |
Message-ID: | 019601c3c3f0$f8c1e590$0200a8c0@dedalus1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)archonet(dot)com>
To: "Alessandro Depase" <alessandro(dot)depase(at)libero(dot)it>; "Peter Eisentraut"
<peter_e(at)gmx(dot)net>; <pgsql-sql(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jonas Lindholm | 2003-12-16 18:55:24 | Problem with functions. |
Previous Message | Richard Huxton | 2003-12-16 16:12:02 | Re: failed to build any 5-way joins |