Re: Slow left outer join

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Alexander Staubo <alex(at)purefiction(dot)net>, PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slow left outer join
Date: 2006-11-27 01:40:37
Message-ID: 20061127014037.1119.qmail@web31803.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> The outer join seems unnecessarily slow. Is there anything I can do
> to speed it up?
>
> PostgreSQL 8.1.3 on OS X (MacPorts).

This is just a guess on my part, but would it help if you preformed the inner join first to filter
out the most of the unwated rows that then preform the outer join with what is left over?

But just double check that results are as you expect.

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-11-27 01:45:48 Re: Slow left outer join
Previous Message Alexander Staubo 2006-11-27 01:31:39 Slow left outer join