btree_gist improvements in PostgreSQL
Performance

btree_gist improvements in PostgreSQL 18

The btree_gist improvements in PostgreSQL 18 are one of the most practical performance wins shipping in this release for teams that depend on exclusion constraints, composite indexes, and nearest-neighbour search. The btree_gist extension lives in [...]
Understanding Locks in PostgreSQL
DBA

UUIDv7 and Time-Based Partitioning in PostgreSQL 18

UUIDv7 and Time-Based Partitioning in PostgreSQL 18: A Complete Guide Introduction: The UUID Evolution That Changes Everything PostgreSQL 18 introduces native support for UUIDv7, a game-changing identifier format that solves one of the database world’s […]