pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: Hywel Carver <hywel@skillerwhale.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Konstantin Knizhnik <knizhnik@garret.ru>
Subject: Re: Removing unneeded self joins
Date: Thu, 1 Jul 2021 08:20:24 +0300
Message-ID: <1b4b177a-ef90-d3b9-59b2-5cec182f0efb@postgrespro.ru> (raw)
In-Reply-To: <b17c18d9fd379ce2355c355cdb44787a452961ec.camel@cybertec.at>
References: <64486b0b-0404-e39e-322d-0801154901f3@postgrespro.ru>
	<21e15759-dba5-2d2b-dd03-06943ad40378@postgrespro.ru>
	<161553990603.28624.7702383984090736980.pgcf@coridan.postgresql.org>
	<2a6e540a-4c9f-9402-2e02-71e35fcd4dd1@postgrespro.ru>
	<b17c18d9fd379ce2355c355cdb44787a452961ec.camel@cybertec.at>

On 30/6/21 18:55, Laurenz Albe wrote:
> On Wed, 2021-06-30 at 14:21 +0300, Andrey Lepikhov wrote:
>> I think, here we could ask more general question: do we want to remove a
>> 'IS NOT NULL' clause from the clause list if the rest of the list
>> implicitly implies it?
> Generally I have the impression that we are not too keen on spending
> planning time on optimizing cases that can be trivially improved by rewriting
> the query.
Thank you, It's strong argument.
Such feature would look better as a part of an enterprise edition.

-- 
regards,
Andrey Lepikhov
Postgres Professional

view thread (247+ messages)  latest in thread

Message-ID: <1b4b177a-ef90-d3b9-59b2-5cec182f0efb@postgrespro.ru>
Permalink:  ../1b4b177a-ef90-d3b9-59b2-5cec182f0efb@postgrespro.ru/
Also on:    postgresql.org/message-id/1b4b177a-ef90-d3b9-59b2-5cec182f0efb@postgrespro.ru

copy link · copy postgr.es

reply

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-hackers@postgresql.org
  Cc: a.lepikhov@postgrespro.ru, laurenz.albe@cybertec.at, hywel@skillerwhale.com, pgsql-hackers@lists.postgresql.org, knizhnik@garret.ru
  Subject: Re: Removing unneeded self joins
  In-Reply-To: <1b4b177a-ef90-d3b9-59b2-5cec182f0efb@postgrespro.ru>

* 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