Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sun, 26 Nov 2006 17:40:37 -0800 (PST)
- Message-id: <20061127014037(dot)1119(dot)qmail(at)web31803(dot)mail(dot)mud(dot)yahoo(dot)com>
> 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.
- References:
- Slow left outer join
- From: Alexander Staubo
- Slow left outer join
- Prev by Date: Slow left outer join
- Next by Date: Re: Slow left outer join
- Previous by thread: Slow left outer join
- Next by thread: Re: Slow left outer join
- Indexes: