Re: Selecting across Multiple Tables

Tielman J de Villiers <tjdevil@bondnet.co.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