Postgres 18 Is Out: Try It on Neon
16 hours ago
- #Performance
- #Database
- #Postgres
- Postgres 18 is available in preview on Neon's Free plan.
- New B-tree skip scan optimization improves analytics and reporting workloads.
- Improved EXPLAIN output includes buffer usage and index lookups by default.
- Virtual generated columns now default, reducing on-disk size and speeding up operations.
- UUIDv7 support introduces timestamp-embedded UUIDs for better index performance.
- Expanded RETURNING clause allows capturing before-and-after values in a single statement.
- Temporal constraints ensure time ranges do not overlap incorrectly.
- OAuth authentication now supported for identity providers like Google and Azure AD.
- NOT NULL constraints can be marked as NOT VALID for safer schema migrations.
- Autovacuum maintenance configuration refined for insert-heavy workloads.
- Parallel GIN index builds speed up JSON and full-text-search indexing.
- Asynchronous I/O introduced for read operations, improving throughput.
- New pg_stat_io view provides detailed I/O activity breakdown.
- Postgres 18 includes contributions from Neon team members.