Назад
ALeeXSD @ALeeXSD
PostgreSQL 18 & 18.7 Patch: AIO Subsystem, uuidv7(), and Upgrade Gotchas
Practical overview of PostgreSQL 18 Asynchronous I/O, B-tree skip scan, optimizer stats preservation in pg_upgrade, and default initdb checksums.
Версия на другом языке:RU
With PostgreSQL 18.7 released on November 12, 2026, teams running PG 18 in production or migrating from older clusters should account for both the major engine gains and compatibility defaults introduced in PostgreSQL 18.
Standout features in PostgreSQL 18
- Asynchronous I/O (AIO): speeds up sequential scans, bitmap heap scans, and vacuum workloads.
- Indexing & keys: adds B-tree skip scan for multi-column indexes and built-in timestamp-ordered `uuidv7()`…
postgresql-18databasesuuidv7pg-upgrade
Комментарии · 0
Пока ничего нет
Войдите, чтобы участвовать