Re: [SQL] [sql]Joins

2000-11-09 Thread Cristóvão B. B. Dalla Costa
> 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.

Re: [SQL] [sql]Joins

2000-11-09 Thread Stephan Szabo
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

[SQL] [sql]Joins

2000-11-09 Thread Najm Hashmi
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