Re: index/join madness - Mailing list pgsql-sql

From David Olbersen
Subject Re: index/join madness
Date
Msg-id Pine.LNX.4.31.0105230835410.20297-100000@bubbles.electricutopia.net
Whole thread Raw
In response to index/join madness  ("Michael Richards" <michael@fastmail.ca>)
List pgsql-sql
On Wed, 23 May 2001, Michael Richards wrote:

> Finally, I'm planning on moving this to 7.2 and converting all the
> joins to use outer joins. Will there be a significant penalty in
> performance running outer joins?

Why are you planning on using outer joins? Yes there is a performance penalty
because postgres will have to emit more tuples. Are you sure that you need to
use outer joins?

-- Dave



pgsql-sql by date:

Previous
From: jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
Subject: Re: index/join madness
Next
From: Stephan Szabo
Date:
Subject: Re: Select question