From: | Alessandro Baretta <a(dot)baretta(at)barettadeit(dot)com> |
---|---|
To: | Ottó Havasvölgyi <havasvolgyi(dot)otto(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Throwing unnecessary joins away |
Date: | 2006-01-12 12:35:07 |
Message-ID: | 43C64CFB.9030504@barettadeit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Ottó Havasvölgyi wrote:
> Hi all,
>
> Is PostgreSQL able to throw unnecessary joins?
> For example I have two tables, and I join then with their primary keys,
> say type of bigint . In this case if I don't reference to one of the
> tables anywhere except the join condition, then the join can be eliminated.
> Or if I do a "table1 left join table2 (table1.referer=table2.id)" (N :
> 1 relationship), and I don't reference table2 anywhere else, then it is
> unnecessary.
It cannot possibly remove "unnecessary joins", simply because the join
influences whether a tuple in the referenced table gets selected and how many times.
Alex
--
*********************************************************************
http://www.barettadeit.com/
Baretta DE&IT
A division of Baretta SRL
tel. +39 02 370 111 55
fax. +39 02 370 111 54
Our technology:
The Application System/Xcaml (AS/Xcaml)
<http://www.asxcaml.org/>
The FreerP Project
<http://www.freerp.org/>
From | Date | Subject | |
---|---|---|---|
Next Message | Ottó Havasvölgyi | 2006-01-12 13:41:30 | Re: Throwing unnecessary joins away |
Previous Message | Ottó Havasvölgyi | 2006-01-12 12:18:58 | Throwing unnecessary joins away |