This article is the first in the series about the upcoming PostgreSQL 18 release. Let us take a look at the features introduced in the July CommitFest. Planner: Hash Right Semi Join support Planner: materializing an internal row set for parallel nested loop join Planner support functions for generate_series EXPLAIN (analyze): statistics for Parallel Bitmap Heap Scan node workers Functions min and max for composite types Parameter names for regexp* functions Debug mode in pgbench pg_get_backen...
