> I've had no problems really until about 8-12 tables joined when you might
> tickle a bug in some versions of postgres which cause bogus plans to be
> generated.
I've had queries with over 25 joins and self-joins with no problems
whatsoever.
On Fri, 10 Nov 2000, Najm Hashmi wrote:
> I am facing a dilemma at my work, I am using postgres first time. For
> some reason, my co-workers think that in Postgres joins i.e.
> simple joins of two or three tables are so bad that their cost is
> exponential. They believe that postgres simply ta
I am facing a dilemma at my work, I am using postgres first time. For
some reason, my co-workers think that in Postgres joins i.e.
simple joins of two or three tables are so bad that their cost is
exponential. They believe that postgres simply takes Cartesian product
of joining table in order t