Re: [GENERAL] Fast join

> Hello all!
>
> I assume this is a developer's list, isn't it? Because the
> address hackers-request(at)postgreSQL(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026