Postgres Pro
Downloads
Home   >   mailing lists

Re: Plan for outer joins - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Plan for outer joins
Date
Msg-id 20060911100545.GC16564@svana.org
Whole thread Raw
In response to Plan for outer joins  (Alban Hertroys <alban@magproductions.nl>)
Responses Re: Plan for outer joins
List pgsql-general
Tree view 
On Mon, Sep 11, 2006 at 11:58:56AM +0200, Alban Hertroys wrote:
> Hi,
>
> I was tuning a join on a few tables for a SELECT COUNT(*) query, when I
> realized that the content of the second table didn't actually matter to
> the count. So, I figured a LEFT OUTER JOIN would be faster, but...
> apparently it's not.

Well, it would matter if the outer side of the join could return more
than one row. You may know that won't happen, but the database may not.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: [ADMIN] Problem with lo_export() and lo_import() from remote machine.
Next
From: "Marco Bizzarri"
Date:
Subject: Re: [ADMIN] Problem with lo_export() and lo_import() from remote machine.