Re: Selecting across Multiple Tables

Tielman J de Villiers <tjdevil(at)bondnet(dot)co(dot)za> writes:

> The main issue however is why postgres 7.1 works fine (and quick) on "WHERE"
> statements such as
>
> >Where 1.id = (select last_value from sequence) and
> > 2.id = (select last_value from sequence) and
> > 3.id = (select last_value from sequence) and
> > 4.id = (select last_value from sequence) and
>
> While postgres 6.2 drops dead on it, and works slow on "WHERE" such as
> >Where 1.id = (select last_value from sequence) and
> > 2.id = 1.id and
> > 3.id = 1.id and
> > 4.id = 1.id and
> > 5.id = 1.id and

I would say the answer is that 7.1 has at least 2 years' worth of
improvement and optimization over 6.5.2. There is no reason to be
running 6.X in this day and age, and a lot of reasons not to be.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863