From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Throwing unnecessary joins away
Date: Thu, 12 Jan 2006 10:53:53 -0500
Message-ID: <5269.1137081233@sss.pgh.pa.us> (raw)
In-Reply-To: <34608c0c0601120541wd910da3s@mail.gmail.com>
References: <34608c0c0601120418n1af567b9n@mail.gmail.com>
<43C64CFB.9030504@barettadeit.com>
<34608c0c0601120541wd910da3s@mail.gmail.com>
=?ISO-8859-1?Q?Ott=F3_Havasv=F6lgyi?= <havasvolgyi.otto@gmail.com> writes:
> As far as I know SQL Server has some similar feature. It does not join
> if not necessary, more exactly: if the result would be the same if it
> joined the table.
I find it really really hard to believe that such cases arise often
enough to justify having the planner spend cycles checking for them.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, havasvolgyi.otto@gmail.com
Subject: Re: Throwing unnecessary joins away
In-Reply-To: <5269.1137081233@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox