Re: join and query planner

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Dario Pudlo <dariop(at)unitech(dot)com(dot)ar>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: join and query planner
Date: 2005-07-12 14:35:52
Message-ID: 20050712143552.GA32711@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jul 06, 2005 at 18:54:02 -0300,
Dario Pudlo <dariop(at)unitech(dot)com(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Yves Vindevogel 2005-07-12 16:21:57 Projecting currentdb to more users
Previous Message Simon Riggs 2005-07-12 07:45:38 Re: cost-based vacuum