Re: [GENERAL] Fast join

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.