Re: Slow left outer join - Mailing list pgsql-general

From Richard Broersma Jr
Subject Re: Slow left outer join
Date
Msg-id 20061127014037.1119.qmail@web31803.mail.mud.yahoo.com
Whole thread Raw
In response to Slow left outer join  (Alexander Staubo <alex@purefiction.net>)
List 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.

pgsql-general by date:

Previous
From: Alexander Staubo
Date:
Subject: Slow left outer join
Next
From: Tom Lane
Date:
Subject: Re: Slow left outer join