| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Moshe Jacobson <moshe(at)neadwerx(dot)com>, Postgres-Bugs <pgsql-bugs(at)postgresql(dot)org>, Robert Mowlavi <robert(at)neadwerx(dot)com>, Chris Autry <chris(at)neadwerx(dot)com> |
| Subject: | Re: LEFT JOINs not optimized away when not needed |
| Date: | 2014-07-09 16:07:35 |
| Message-ID: | CA+TgmoZ8HGpVjmnGv=UHd59b3N8KCpo-_yo1D7-GRxT8aaFsfg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Tue, Jul 8, 2014 at 5:40 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Moshe Jacobson <moshe(at)neadwerx(dot)com> writes:
>> On Tue, Jul 8, 2014 at 4:40 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> No. There is nothing about GROUP BY in the join removal logic.
>
>> OK. Thank you. Is this something that would make sense to add?
>
> Dunno. I don't recall any previous requests for such a thing, so I'd not
> be inclined to add it unless it can be done very cheaply (in terms of both
> code and runtime).
I thought this was exactly what was being discussed on the "Allowing
join removals for more join types" thread.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-07-09 16:54:05 | Re: LEFT JOINs not optimized away when not needed |
| Previous Message | Haribabu Kommi | 2014-07-09 13:21:30 | Re: [BUGS] BUG #9652: inet types don't support min/max |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2014-07-09 16:09:25 | Re: Pg_upgrade and toast tables bug discovered |
| Previous Message | Stephen Frost | 2014-07-09 15:45:48 | Re: RLS Design |