<ul><li>PostgreSQL 17 introduces improved handling of 'is null' and 'is not null' queries when columns have a 'not null' constraint.</li><li>Before PostgreSQL 17, there was overhead when evaluating 'is not null' queries even when it was redundant due to the 'not null' constraint.</li><li>PostgreSQL 17's optimizer is smarter and eliminates the need to evaluate 'is not null' queries when the 'not null' constraint is already in place.</li><li>Additionally, PostgreSQL 17 also improves handling of 'is null' queries by avoiding unnecessary parallel sequential scans.</li></ul>

Improved not null/null planning in PostgreSQL 17

Discover more