Re: [GENERAL] Fast join

> > 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.

As I remember, your qualification was x > 10.  That may not be
restrictive enough to make an index faster.
--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026