PostgreSQL 17 significantly expands its SQL/JSON capabilities, ... Optimization of queries using the IN clause with B-tree indexes. These are PostgreSQL's standard index type.

“PostgreSQL 17 will automatically optimize the execution queries with ‘IN’ clauses that use a B-tree index.” How PostgreSQL 17 will help enterprises and their database operations ...

PostgreSQL, while slightly slower in basic operations, excels in write-heavy workloads and complex queries thanks to advanced features including MVCC, parallel query execution and indexing options.