Thirteen performance measurements on PostgreSQL 18.6

An analysis of thirteen small measurements on PostgreSQL 18 explores performance characteristics across various features like partial indexes, BRIN indexes, INCLUDE clauses, unlogged tables, and sorting behaviors. The findings highlight specific performance impacts, such as how unlogged tables eliminate WAL overhead and how different work_mem settings affect sorting methods. Open article →