Re: Removing unneeded self joins - Mailing list pgsql-hackers

From Andrey Lepikhov
Subject Re: Removing unneeded self joins
Date
Msg-id e241df57-9dc7-d8fb-b870-68ecead56822@postgrespro.ru
Whole thread Raw
In response to Removing unneeded self joins  (Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>)
List pgsql-hackers
On 12/3/21 14:05, Hywel Carver wrote:
> I've built and tested this, and it seems to function correctly to me. One question I have is whether the added "IS
NOTNULL" filters can be omitted when they're unnecessary. Some of the resulting plans included an "IS NOT NULL" filter
ona non-nullable column. To be clear, this is still an improvement (to me) without that.
 

New version of the feature. Deeply refactored with main goal - to reduce 
the code size) and rebased on current master.

Here I didn't work on 'unnecessary IS NOT NULL filter'.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Attachment

pgsql-hackers by date:

Previous
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: [bug?] Missed parallel safety checks, and wrong parallel safety
Next
From: Pavel Stehule
Date:
Subject: Re: few ideas for pgbench