Horton

Re: NOT IN subquery optimization

Finnerty, Jim <jfinnert@amazon.com>

View thread View on postgr.es
From: Jim Finnerty <jfinnert@amazon.com>
To: pgsql-hackers@postgresql.org
Date: 2019-02-26T14:07:42Z
Lists: pgsql-hackers 
The problem is that the special optimization that was proposed for the case
where the subquery has no WHERE clause isn't valid when the subquery returns
no rows.  That additional optimization needs to be removed, and preferably
replaced with some sort of efficient run-time test.





-----
Jim Finnerty, AWS, Amazon Aurora PostgreSQL
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

Commits

  1. Check we don't misoptimize a NOT IN where the subquery returns no rows.