Postgres Pro
Downloads
Home   >   mailing lists

Re: Left Join Performance vs Inner Join Performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Left Join Performance vs Inner Join Performance
Date
Msg-id 8321.1136954300@sss.pgh.pa.us
Whole thread Raw
In response to Left Join Performance vs Inner Join Performance  ("Dave Dutcher" <dave@tridecap.com>)
List pgsql-performance
Tree view 
"Dave Dutcher" <dave@tridecap.com> writes:
> I have an inner join query that runs fast, but I when I change to a left
> join the query runs 96 times slower.

This looks like an issue that is fixed in the latest set of releases,
namely that OUTER JOIN ON conditions that reference only the inner
side of the join weren't getting pushed down into indexquals.  See
thread here:
http://archives.postgresql.org/pgsql-performance/2005-12/msg00134.php
and patches in this and the following messages:
http://archives.postgresql.org/pgsql-committers/2005-12/msg00105.php

            regards, tom lane

pgsql-performance by date:

Previous
From: David Lang
Date:
Subject: Re: How to handle a large DB and simultaneous accesses?
Next
From: Robert Creager
Date:
Subject: Re: Index isn't used during a join.