Bruce Momjian wrote:
>
> > Hello all!
> > during preliminary tests, a problem concerning joins. The problem
> > is that joins are too slow. Consider that sequence of commands
> > given at the command prompt of psql (strange duplicates of NOTICEs are
> > removed):
>
> Are you using 6.5? If not, upgrade. The optimizer is much smarter in
> 6.5.
:)
The last and the latest! 6.5 I mean.
>
> Also, if a join does most of the table, it is faster do not use indexes,
> and just sort on the backend.
>
The problem is - when you want just a small part of the table(s) and
you have indices to facilitate qualifications, Postgres doesn't
use 'em ! This is a question of Life and Death - i.e. to use or
not to use Postgres.
--
Leon.