iMasters

PostgreSQL 18 tem uuidv7 nativo para reduzir o index bloat do UUID aleatório

PostgreSQL 18 (set/2025) trouxe uuidv7() nativo: UUID ordenável por tempo que ataca o index bloat do v4 aleatório, direto no banco, sem depender do ORM.

17 Items to Check Before Upgrading to PostgreSQL 19—The One pg_upgrade --check Misses, and Inspection SQL (Measured on 18.6 and 19beta4)

The release notes for PostgreSQL 19 (scheduled for official release in October 2026) contain a section titled "Migration to ...