Free Arenaで投票

ニュース··読了時間 1分·データは自動更新

PostgreSQL 19 released with read‑your‑writes standby support and REPACK command

The new version adds WAIT FOR LSN for consistency, REPACK (CONCURRENTLY) for table maintenance, and several developer and replication enhancements.

The PostgreSQL Global Development Group announced PostgreSQL 19 on 19 November 2026, two months later than the usual September schedule due to a surge of issues tied to AI‑reported vulnerabilities.

Key new features include the WAIT FOR LSN command, which lets applications on standby servers wait for a specific WAL position before reading, ensuring read‑your‑writes consistency.

The release also introduces the REPACK (CONCURRENTLY) command, allowing tables to be reclaimed and reordered without blocking reads or writes, replacing VACUUM FULL and CLUSTER for most use cases.

Developers gain INSERT … ON CONFLICT DO SELECT for "get or create" patterns, the pg_plan_advice extension for stabilising query plans, and logical replication improvements such as automatic WAL level elevation and sequence replication.

Autovacuum now supports parallel index vacuuming, new monitoring views (pg_stat_lock, pg_stat_recovery, pg_stat_autovacuum_scores) were added, and COPY can output JSON data.

あなたにとっての意味

These enhancements make PostgreSQL more reliable for AI‑driven workloads that require low‑latency reads from replicas. Free‑software users benefit from the ability to maintain large tables without downtime, while developers can simplify common patterns and improve query performance without proprietary tools.

ソース

上記のソースから自動的に生成し、当社のコードでチェックしました:すべての数値と名前が含まれ、文がソースをコピーしてはいけません。間違いを見つけましたか?報告する。

無料ランキング

今日無料で使えるAIはどれですか?

すべての無料AIモデルをブラインドヒューマン投票で順位付けし、あなたのGPUで必要なメモリと速度を示します。

ランキングを開く →

このページを共有:XLinkedInRedditWhatsApp

どのページでも / または Ctrl+K で検索できます。