Re: [GENERAL] Fast join

> Hello all!
>
> I assume this is a developer's list, isn't it? Because the
> address hackers-request@postgreSQL.org mentioned in PostgreSQL FAQ
> doesn't work.
>
> Ok. Let me begin with the beginning. We are a group of developers
> of an free accounting system here in Russia. We want to use Postgres
> as our database server. It is cool, but we encountered a problem
> 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.

Also, if a join does most of the table, it is faster do not use indexes,
and just sort on the backend.

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