Re: left outer join terrible slow compared to inner join

> Actually, I was about to post some problems we have with large left
> outer joins as well we've discovered in a porting project from
> NT/SQL Server -> Linux/Postgres.
>
> We have a particular query that is rather large, left outer joining
> across several tables.  Under SQL Server, with identical data and
> schema, this particular query takes 2 seconds.
>
> Under PostgreSQL, this same query takes 90 seconds -- that's right,
> 90 seconds.  45x longer than SQL Server.  This was quite a shock to
> us (we'd not seen such a performance deficit between the two dbs
> until this) and could, in fact, force us away from Postgres.
>
> I'd be happy to forward the explain to anyone who'd care to look at
> it...

Post an EXPLAIN ANALYZE of the query...

-sc

--
Sean Chittenden