Re: join and query planner - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: join and query planner
Date
Msg-id 20050712143552.GA32711@wolff.to
Whole thread Raw
In response to join and query planner  ("Dario Pudlo" <dariop@unitech.com.ar>)
List pgsql-performance
On Wed, Jul 06, 2005 at 18:54:02 -0300,
  Dario Pudlo <dariop@unitech.com.ar> wrote:
> (first at all, sorry for my english)
> Hi.
>    - Does "left join" restrict the order in which the planner must join
> tables? I've read about join, but i'm not sure about left join...

The left join operator is not associative so in general the planner doesn't
have much flexibility to reorder left (or right) joins.

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: cost-based vacuum
Next
From: Yves Vindevogel
Date:
Subject: Projecting currentdb to more users