跳到正文
hackernews100(postgresql.org)· linzhangrun·· 3 天前精選品質評分82

PostgreSQL 19 推出 REPACK,新增多項資料庫維護與複寫功能

PostgreSQL 19

重點導讀

資料庫表格需要整理和維護時,舊做法可能會擋住讀寫;升級新版也可能遇到相容性變更。

  • PostgreSQL 19 新增 REPACK,可整理表格並回收磁碟空間,使用 CONCURRENTLY 時仍能讓其他人讀寫。這版也加入平行自動清理,並改善外部索引鍵檢查和查詢速度。
  • 複寫方面則新增序列值同步,以及讓備用伺服器等待資料寫入或重播完成的 WAIT 指令。升級前要留意變更,例如移除了 RADIUS 支援,部分舊資料庫也需要先調整或重新匯入。

AI 伴隨問答

自備 Key 深度分析

針對這篇報導有疑問?可直接點選快捷問題或向 AI 追問背景脈絡與技術細節:

推薦理由

PostgreSQL 19 把免阻塞重整資料表、平行自動清理與複寫功能放進同一版更新,能看出資料庫維護和升級時有哪些新選擇。

正文 · 中文翻譯

譯文尚未完整,完整內容請切換至原文。

E.1. 版本 19 #

發布日期: 2026-11-19

E.1.1. 概覽 #

PostgreSQL 19 帶來許多新功能與改進,包括:

  • 新增 REPACK 指令,可回收磁碟空間並重新整理資料表內容,進而提升查詢效能。REPACK (CONCURRENTLY) 可在不阻擋資料表讀取與寫入的情況下重新整理資料表。

  • 用於控制查詢規劃器決策的擴充套件 pg_plan_advice,以及會根據查詢自動套用計畫建議的擴充套件 pg_stash_advice。

  • 多個領域的效能有所提升,包括自動調整 I/O 工作程式數量、加快外部索引鍵檢查,以及進一步最佳化規劃與執行程式。

  • 當 wal_level 設為 replica 時,現在無須重新啟動伺服器即可啟用邏輯複寫。

  • 邏輯複寫 序列值。

  • 透過新增的 WAIT 指令,支援備用伺服器上的「讀取自己的寫入」一致性。

  • 透過新的評分系統,支援平行處理資料表索引的自動清理,並可為自動清理排定優先順序。

下方各節將更詳細說明上述專案,以及 PostgreSQL 19 的其他新功能。

E.1.2. 升級至版本 19 #

若要從任何先前版本遷移資料,必須使用 pg_dumpall 傾印與還原,或使用 pg_upgrade,或透過邏輯複寫。遷移至新主要版本的一般資訊,請參閱第 18.6 節。

版本 19 有多項變更可能影響與先前版本的相容性。請留意下列不相容變更:

  • 新增伺服器變數 password_expiration_warning_threshold,用於警告密碼即將到期(Gilles Darold、Nathan Bossart)§

    預設警告期間為七天。

  • MD5 密碼驗證成功後發出警告(Nathan Bossart)§

    可透過伺服器變數 md5_password_warnings 停用警告。MD5 密碼已在 PostgreSQL 18 中標示為棄用。

  • 移除 RADIUS 支援(Thomas Munro)§

    PostgreSQL 僅支援透過 UDP 使用 RADIUS,這種方式有無法修補的安全性問題。

  • 強制資料庫伺服器中的 standard_conforming_strings 一律為 on(Tom Lane)§

    使用 PostgreSQL 19 之前版本的 pg_dump 或 pg_dumpall 建立的傾印檔,若使用 standard_conforming_strings = off,將無法正確載入 PostgreSQL 19 及後續版本的伺服器。使用者應以 PostgreSQL 19 或更新版本的這些應用程式建立傾印檔,或使用 standard_conforming_strings = on。

    使用者端應用程式仍支援與使用 standard_conforming_strings = off 的伺服器進行作業,以相容於舊版伺服器。伺服器變數 escape_string_warning 已移除,因為不再需要。

  • 禁止資料庫、角色與資料表空間名稱包含歸位字元與換行字元(Mahendra Singh Thalor)§

    pg_upgrade 也會禁止升級使用此類名稱的叢集。此變更旨在避免安全性問題。

  • 將 inet 與 cidr 資料型別的預設索引運運算元類別,從 btree_gist 改為 GiST(Tom Lane)§ §

    btree_gist inet/cidr 運運算元類別有錯誤,可能會排除應該回傳的資料列。pg_upgrade 將禁止升級含有 btree_gist inet/cidr 索引的叢集。

  • 禁止在 COPY FROM ... WHERE 中使用系統欄位 (Tom Lane) §

    這類欄位的值並未明確定義。

  • 變更不回傳資料列的 json_array() 呼叫,使其改為回傳空的 JSON 陣列 (Richard Guo) §

    先前這會回傳 NULL。

  • 讓交易將其 READ ONLY 和 DEFERRABLE 狀態傳遞至 postgres_fdw 工作階段 (Etsuro Fujita) §

    這代表 READ ONLY 交易無法再修改由 postgres_fdw 工作階段處理的資料列。

  • 將 max_locks_per_transaction 的預設值從 64 改為 128 (Heikki Linnakangas) §

    鎖定大小的配置方式已變更,因此現在必須將設定值加倍,才能達到先前版本相同的容量。

  • 移除伺服器變數 io_workers (Thomas Munro) §

    此變數已由四個新變數取代;請參閱 Section E.1.3.1.2。

  • 將 JIT 變更為預設停用 (Jelte Fennema-Nio) §

    先前 JIT 預設為啟用,並依據最佳化工具的成本評估決定是否啟用,但後來發現這項成本評估並不可靠。這項變更要求執行大量大型分析查詢的站臺手動啟用 JIT。

  • 變更 平行清理,讓領導程式與工作程式共用以成本為基礎的清理延遲上限 (Bharath Rupireddy) §

    先前每個工作程式只會依據自身產生的成本決定休眠時間,因此平行清理可能耗用 vacuum_cost_limit 設定預算的數倍。變更後,啟用平行工作程式及以成本為基礎的延遲設定時,VACUUM 的執行速度可能會比先前版本慢。

  • 將系統檢視 pg_stat_subscription_stats 中的欄位 sync_error_count 更名為 sync_table_error_count (Vignesh C) §

    這是必要的變更,因為現在會分別追蹤序列錯誤。

  • 將等待事件型別 BUFFERPIN 更名為 BUFFER,並將等待事件 BufferPin 更名為 BufferCleanup (Andres Freund) §

  • 移除等待事件 BufferContent,並新增更精確的等待事件 BufferShared、BufferShareExclusive 和 BufferExclusive (Andres Freund) §

  • 變更索引存取方法處理常式,改用靜態 IndexAmRoutines 結構,而非動態配置的結構 (Matthias van de Meent) §

  • 移除最佳化工具掛鉤 get_relation_info_hook,並新增位置更合適的掛鉤 build_simple_rel_hook (Robert Haas) §

  • 變更 psql 的 \crosstabview 指令,使其遵循 \pset null 設定 (Chao Li) §

  • 變更 全文檢索 和 pg_trgm,在剖析文字時使用資料庫的地區設定提供者進行字元分類 (Jeff Davis) §

    先前無論使用哪種地區設定提供者,字元分類都會使用 libc。在地區設定提供者不是 libc(例如 ICU、builtin)的資料庫中,如果透過該提供者設定的地區設定,與資料庫的 LC_CTYPE 設定有所不同,尤其是 LC_CTYPE 設為 C 時,部分全文檢索和 pg_trgm 函式的輸出可能會改變。使用 pg_upgrade 升級這類資料庫後,建議重建所有使用全文檢索和 pg_trgm 的索引,並重新計算任何已儲存的 tsvector 值。

  • 變更 fuzzystrmatch 函式處理非 ASCII 字元的方式(Peter Eisentraut、Jeff Davis)§ §

    dmetaphone() 和 dmetaphone_alt() 現在會使用資料庫的預設定序將輸入轉為大寫,不再一律使用 libc;soundex()、metaphone() 和 difference() 現在則只將 ASCII 字母視為字母。使用 pg_upgrade 升級時,建議在升級後重建任何使用這些函式的索引。

  • 移除 MULE_INTERNAL 編碼(Thomas Munro)§

    這種編碼十分複雜,而且很少使用。使用此編碼的資料庫必須以其他編碼傾印並還原。

E.1.3. 變更 #

以下將詳細說明 PostgreSQL 19 與前一個主要版本之間的變更。

E.1.3.1. 伺服器 #

E.1.3.1.1. 最佳化器 #
  • 當不存在 NULL 值時,允許將 NOT IN 子句轉換為效率更高的 ANTI JOINs(Richard Guo)§

  • 允許將更多 LEFT JOINs 轉換為 ANTI JOINs(Tender Wang、Richard Guo)§

  • 允許對內側唯一的 ANTI JOINs 使用 Memoize(Richard Guo)§

  • 允許在聯結之前先執行部分彙總處理(Richard Guo、Antonin Houska)§ § §

    這能減少需要處理的資料列數量。

  • 改善雜湊聯結處理具有 NULL 聯結鍵之資料列的方式(Tom Lane)§

  • 改善半聯結的規劃(Richard Guo)§

  • 允許 Append 和 MergeAppend 考慮明確的增量排序(Richard Guo)§

  • 在常數摺疊期間,將 IS [NOT] DISTINCT FROM NULL 轉換為 IS [NOT] NULL(Richard Guo)§

    後者形式更容易最佳化。

  • 當已證明輸入值不可為 null 時,將 IS [NOT] DISTINCT FROM 簡化為相等/不相等運運算元(Richard Guo)§

  • 在最佳化器中提早對 var IS [NOT] NULL 執行常數摺疊(Richard Guo)§

    這可進一步進行後續最佳化。

  • 簡化 COALESCE() 和 ROW(...) IS [NOT] NULL,避免評估不必要的引數(Richard Guo)§ §

  • 當已證明輸入值不可為 null 時,將 IS [NOT] TRUE/FALSE/UNKNOWN 簡化為一般布林運算式(Richard Guo)§

  • 加速大型最佳化器統計目標值下的聯結選擇性計算(Ilia Evdokimov、David Geier)§

  • 為回傳布林值的函式新增適當的最佳化器統計資料(Tom Lane)§

  • 允許在虛擬產生欄位上使用延伸統計資料(Yugo Nagata)§

  • 允許使用函式 pg_restore_extended_stats() 還原最佳化器延伸統計資料(Corey Huinker、Michael Paquier、Chao Li)§ § § §

  • 新增函式 pg_clear_extended_stats(),用來移除延伸統計資料(Corey Huinker、Michael Paquier)§

  • 調整最佳化器,使其將部分路徑的啟動成本納入考量(Robert Haas、Tomas Vondra)§

  • 允許 pg_aggregate.aggtransspace 使用負值表示記憶體用量不設上限(Richard Guo)§

    最佳化器會在規劃記憶體用量時使用這項資訊。

E.1.3.1.2. 一般效能 #
  • 改善外部索引鍵限制條件檢查的效能(Junwang Zhao、Amit Langote、Chao Li)§ §

  • 改善大型請求的非同步 I/O預讀排程(Andres Freund)§ § §

  • 允許 io_method 方法 worker 自動控制所需的背景工作者(Thomas Munro)§

    新的伺服器變數為 io_min_workers、io_max_workers、io_worker_idle_timeout 和 io_worker_launch_interval。

  • 允許查詢資料表掃描將頁面標記為 可見性對映中的全可見狀態(Melanie Plageman)§

    先前只有 VACUUM 和 COPY ... FREEZE 能執行這項操作。

  • 允許 autovacuum 使用 parallel autovacuum workers(Daniil Davydov)§ §

    工作者數量上限由伺服器變數 autovacuum_max_parallel_workers 和每個資料表的儲存引數 autovacuum_parallel_workers 控制。

  • 允許平行處理 TID 範圍掃描(Cary Huang、David Rowley)§

  • 使用 SIMD CPU 指令提升 COPY FROM 處理文字和 CSV 輸入的效能(Nazir Bilal Yavuz、Shinya Kato)§

  • 改善 NOTIFY,只喚醒正在等待指定通知的後端程式(Joel Jacobson)§

    先前 NOTIFY 會喚醒大多數後端程式。

  • 將 wal_compression 等於 on 的情況改為使用可用的最佳 WAL 壓縮方法(wenhui qiu)§

    先前一律使用 pglz。

  • 將預設的 TOAST 壓縮方法從 pglz 改為效率更高的 lz4(Euler Taveira)§

    這是透過變更伺服器變數 default_toast_compression 的預設值達成。

  • 提升內部資料列解構的效能(David Rowley)§

  • 提升重複執行 UTF-8 大小寫摺疊作業的效能(Andreas Karlsson)§

  • 使用串流讀取提升雜湊索引大量刪除和 GIN 索引清理的效能(Xuneng Zhou)§ §

  • 使用基數排序提升排序效能(John Naylor)§

  • 改善計時效能測量(Lukas Fittl、Andres Freund、David Geier)§ §

    這項改進有助於 EXPLAIN (ANALYZE, TIMING) 和 pg_test_timing,並由伺服器變數 timing_clock_source 控制。

  • 最佳化 plpgsql 語法 SELECT simple-expression INTO var(Tom Lane)§

E.1.3.1.3. 系統檢視表 #
E.1.3.1.4. 監控 #
  • 允許依處理程序型別指定 log_min_messages 記錄層級(Euler Taveira)§

    新格式為 type:level。未含冒號的值會套用至所有處理程序型別,以維持回溯相容性。

  • 新增伺服器變數 log_autoanalyze_min_duration,以記錄 autovacuum 作業執行的長時間分析作業(Shinya Kato)§

    伺服器變數 log_autovacuum_min_duration 現在只控制 autovacuum 執行的清理作業記錄。

  • 預設啟用伺服器變數 log_lock_waits(Laurenz Albe)§

  • 新增伺服器變數 debug_print_raw_parse,以記錄原始剖析樹(Chao Li)§

    以偵錯層級三以上啟動伺服器時,也會啟用此功能。

  • 讓來自遠端伺服器的訊息以與本機伺服器訊息相同的格式顯示在伺服器記錄中(Vignesh C)§

    這包括複寫、postgres_fdw 和 dblink 伺服器。

  • 在 VACUUM 和 ANALYZE 記錄中加入 WAL完整頁面寫入位元組數的回報功能(Shinya Kato)§

  • 為管線、檔案或程式中的 COPY FROM/TO 加入 I/O 等待事件(Nikolay Samokhvalov)§

  • 為 commit_delay 以及 WAL 寫入與清除 LSN 加入等待事件(Xuneng Zhou)§ §

  • 讓 pg_get_sequence_data() 回傳序列頁面的 LSN(Vignesh C)§

  • 新增函式 pg_get_multixact_stats(),以回報 multixact 活動(Naga Appani)§

  • 在交易 ID 或 multixact 的環繞距離少於 100 million 時發出警告(Nathan Bossart)§

    先前的警告門檻是 40 million。警告會傳送給使用者端,也會寫入伺服器記錄。

E.1.3.1.5. 伺服器設定 #
  • 新增 WAIT 指令,讓待命伺服器等待 LSN 值寫入、刷寫或重播(Kartyshov Ivan、Alexander Korotkov、Xuneng Zhou)§ §

  • 改善函式 pg_sync_replication_slots(),使其等待複寫同步完成(Ajin Cherian、Zhijie Hou)§

    先前,某些同步失敗情況不會回報。

  • 新增伺服器變數 wal_sender_shutdown_timeout,限制關機期間等待副本同步的時間(Andrey Silitskiy、Hayato Kuroda)§

    預設情況下,傳送端仍會無限期等待同步。

E.1.3.2. 查詢指令 #

  • 允許 GROUP BY 處理目標清單子查詢,讓其中的運算式能參照子查詢以外的欄位 (Tom Lane) §

    也修正 GROUPING() 處理目標清單子查詢別名的錯誤。

  • 允許視窗函式使用 IGNORE NULLS/RESPECT NULLS 子句忽略 NULL 值 (Oliver Ford, Tatsuo Ishii) §

    支援的視窗函式有 lead()、lag()、first_value()、last_value() 和 nth_value()。

  • 新增對 INSERT ... ON CONFLICT DO SELECT ... RETURNING 的支援 (Andreas Karlsson, Marko Tiikkaja, Viktor Holmberg) §

    這讓系統可以回傳衝突資料列,並可選擇使用 FOR UPDATE/SHARE 鎖定資料列。

E.1.3.3. 公用程式指令 #

  • 新增 REPACK 指令,取代 VACUUM FULL 和 CLUSTER (Antonin Houska) §

    前兩個指令的功能相近,但名稱容易造成混淆,因此合併為 REPACK。舊指令仍予以保留,以維持相容性。

  • 允許 REPACK 重建資料表時不必取得存取排他鎖定 (Antonin Houska, Mihail Nikalayeu, Álvaro Herrera) § § §

    透過 CONCURRENTLY 選項啟用此功能。另新增伺服器變數 max_repack_replication_slots。

  • 允許 GRANT/REVOKE 指定執行許可權調整時實際使用的角色 (Nathan Bossart, Tom Lane) §

    此設定由 GRANTED BY 子句控制。

  • 支援 CREATE SCHEMA 中 FOREIGN KEY 約束子句的向前參照 (Jian He, Tom Lane) §

  • 允許 CHECKPOINT 接受選項清單 (Christoph Berg) § § §

    支援的選項為 MODE 和 FLUSH_UNLOGGED。

  • 在 CREATE FOREIGN DATA WRAPPER 新增 CONNECTION 子句,以指定用於訂閱連線引數的呼叫函式 (Jeff Davis, Noriyoshi Shinoda) § §

  • 在 CREATE AGGREGATE 新增 SUPPORT 子句,讓擴充功能能指定支援函式,以最佳化彙總函式呼叫 (Tom Lane) §

  • 在 VACUUM (VERBOSE) 和 autovacuum 記錄中加入記憶體用量和平行處理資訊 (Tatsuya Kawata, Daniil Davydov) § §

  • 允許 COPY FROM 跳過多行標頭 (Shinya Kato, Fujii Masao) §

    之前只能跳過一行標頭。

  • 允許 COPY FROM 將無效輸入值設為 NULL (Jian He, Kirill Reshke) §

    使用 COPY 選項 ON_ERROR SET_NULL 即可完成設定。

  • 允許 COPY TO 輸出 JSON 格式 (Joe Conway, Jian He, Andrew Dunstan) § §

    JSON 輸出也可以使用 COPY 選項 FORCE_ARRAY,輸出為單一 JSON 陣列。

  • 允許 COPY TO 處理分割資料表(Jian He、Ajin Cherian)§ §

    先前必須使用 COPY (SELECT ...) 才能輸出分割資料表。這也改善了邏輯複寫的資料表同步。

  • 新增 EXPLAIN ANALYZE 選項 IO,用於回報非同步 I/O 活動(Tomas Vondra)§ § §

  • 在 EXPLAIN (ANALYZE, WAL) 輸出中加入 WAL 整頁寫入位元組數(Shinya Kato)§

  • 在 EXPLAIN 輸出中加入 Memoize 快取與查詢次數估計值(Ilia Evdokimov、Lukas Fittl)§

    這可以說明為何選擇了 Memoize。

E.1.3.4. 資料型別 #

E.1.3.5. Functions #

  • Add date, timestamp, and timestamptz versions of random(min, max) (Damien Clochard, Dean Rasheed) § §

  • Allow encode() and decode() to process data in base64url and base32hex formats (Andrey Borodin, Aleksander Alekseev, Florents Tselai) § § §

    This format retains ordering, unlike base32.

  • Add functions to return a set of ranges resulting from range subtraction (Paul A. Jungwirth) §

    The functions are range_minus_multi() and multirange_minus_multi(). This is useful to represent range subtraction results with gaps.

  • Add function error_on_null() to return the supplied parameter, or error on NULL input (Joel Jacobson) §

  • Allow IS JSON to work on domains defined over supported base types (Jian He) §

    The supported base types are TEXT, JSON, JSONB, and BYTEA.

  • Add full text stemmers for Polish and Esperanto (Tom Lane) §

    The Dutch stemmer now uses a different algorithm, which changes the stems of many words; the previous algorithm is available via dutch_porter.

    The English, French, German, Lithuanian, Norwegian, Spanish, Swedish, and Turkish stemmers have also been updated and produce different stems for some words.

  • Allow event triggers to be written using PL/Python (Euler Taveira, Dimitri Fontaine) §

  • Add special libpq protocol parameters for compatibility testing (Jelte Fennema-Nio, Jacob Champion) §

    Otherwise known as protocol grease, which was active during the 19 beta period. These will no longer be sent as of the PostgreSQL 19 official release, but the parameter reservations will remain for potential use in the future.

  • Add libpq connection parameter oauth_ca_file to specify an alternate certificate authority when communicating with OAuth providers (Jonathan Gonzalez V., Jacob Champion) §

    This can also be set via the PGOAUTHCAFILE environment variable. The default is to use curl's built-in certificates.

  • Allow libpq environment variable PGOAUTHDEBUG to specify particular debug options (Zsolt Parragi, Jacob Champion) §

    The UNSAFE option still generates all debugging output.

  • Improve custom OAuth client flows (Jacob Champion) § §

    Previously, libpq reported only a generic error message during custom flow failures, and each flow implementation was required to calculate the issuer identifier independently. Add a new authdata hook type PQAUTHDATA_OAUTH_BEARER_TOKEN_V2 that precomputes the issuer ID and lets hooks provide error details.

  • Add libpq function PQgetThreadLock() to retrieve the current locking callback (Jacob Champion) §

  • Allow the search path to appear in the psql prompt via %S (Florents Tselai) §

    This works when psql is connected to PostgreSQL 18 or later.

  • Allow the hot standby status to appear in the psql prompt via %i (Jim Jones) §

  • Modify psql backslash commands to show comments for publications, subscriptions, and extended statistics (Fujii Masao, Jim Jones) §

    The modified commands are \dRp+, \dRs+, and \dX+.

  • Allow control over how booleans are displayed in psql (David G. Johnston) §

    The \pset variables are display_true and display_false.

  • Allow psql to more accurately determine if the pager is needed (Erik Wienhold) §

  • Add or improve psql tab completion (Yamaguchi Atsuo, Yugo Nagata, Haruna Miwa, Xuneng Zhou, Dagfinn Ilmari Mannsåker, Fujii Masao, Álvaro Herrera, Jian He, Tatsuya Kawata, Ian Lawrence Barwick, Vasuki M) § § § § § § § § § § § § § §

E.1.3.8. Server Applications #

  • Allow pg_dump to include restorable extended statistics (Corey Huinker) §

  • Change vacuumdb's --analyze-only and --analyze-in-stages options to analyze partitioned tables when no targets are specified (Laurenz Albe, Mircea Cadariu, Chao Li) § §

    Previously it skipped partitioned tables. This now matches the behavior of ANALYZE.

  • Allow vacuumdb to report its commands without running them using option --dry-run (Corey Huinker) §

  • Allow pg_verifybackup to read WAL files stored in tar archives (Amul Sul) §

    Add option --wal-path as an alias for the existing and deprecated --wal-directory option.

  • Allow pg_waldump to read WAL files stored in tar archives (Amul Sul) §

  • Improve performance of pg_upgrade copying large object metadata (Nathan Bossart) § § § §

    Various methods are used, depending on the PostgreSQL version of the old cluster.

  • Allow pg_upgrade to process non-default tablespaces stored in the PGDATA directory (Nathan Bossart) §

    Previously such tablespaces generated an error.

  • Add pgbench option --continue-on-error to continue after SQL errors (Rintaro Ikeda, Yugo Nagata, Fujii Masao) §

  • Improve the usability of pg_test_timing (Hannu Krosing, Tom Lane) § §

    Report nanoseconds instead of microseconds. In addition to histogram output, output a second table that reports exact timings, with an optional cutoff set by --cutoff.

  • Allow pg_createsubscriber to ignore specified publications that already exist (Shubham Khanna) §

    Previously this generated an error.

  • Change the way pg_createsubscriber stores recovery parameters (Alyona Vinter) §

    Changes are stored in optionally-included pg_createsubscriber.conf rather than directly in postgresql.auto.conf.

  • Add pg_createsubscriber option -l/--logdir to redirect output to files (Gyan Sreejith, Hayato Kuroda) §

E.1.3.9. Source Code #

  • Restore support for AIX (Aditya Kamath, Srirama Kucherlapati, Peter Eisentraut) § §

    This uses gcc and only supports 64-bit builds.

  • Change Solaris to use unnamed POSIX semaphores (Tom Lane) §

    Previously it used System V semaphores.

  • Require Visual Studio 2019 or later (Peter Eisentraut) §

  • Allow MSVC to create PL/Python using the Python Limited API (Bryan Green) §

  • Allow building on AArch64 using MSVC (Niyas Sait, Greg Burd, Dave Cramer) §

  • Allow execution stack backtraces on Windows using DbgHelp (Bryan Green) §

  • Change the supported C language version to C11 (Peter Eisentraut) § §

    Previously C99 was used.

  • Use standard C23 and C++ attributes if available (Peter Eisentraut) §

  • Use AVX2 CPU instructions for calculating page checksums (Matthew Sterrett, Andrew Kim) §

  • Use ARM Crypto Extension to Compute CRC32C (John Naylor) §

  • Change hex_encode() and hex_decode() to use SIMD CPU instructions (Nathan Bossart, Chiranmoy Bhattacharya) §

  • Require Meson version 0.57.2 or later (Peter Eisentraut) §

  • Add Meson option to build both shared and static libraries, or only shared (Peter Eisentraut) §

  • Update Unicode data to version 17.0.0 (Peter Eisentraut) §

  • Add hooks planner_setup_hook, planner_shutdown_hook, joinrel_setup_hook, and join_path_setup_hook (Robert Haas) § §

  • Allow extensions to replace set-returning functions in the FROM clause with SQL queries (Paul A. Jungwirth) §

  • Make multixact members 64-bit (Maxim Orlov) §

  • Change function prototypes to use uint* instead of bit* typedefs (Nathan Bossart) §

  • Allow OAuth validators to supply failure details (Jacob Champion) §

    This is done by setting the ValidatorModuleResult structure member error_detail.

  • Add simplified and improved shared memory registration function ShmemRequestStruct() (Heikki Linnakangas, Ashutosh Bapat) §

    Functions ShmemInitStruct() and ShmemInitHash() remain for backward compatibility.

  • Add server variable debug_exec_backend to report how parameters are passed to new backends (Daniel Gustafsson) §

  • Add documentation section about temporal tables (Paul A. Jungwirth) §

  • Document the environment variables that control the regression tests (Michael Paquier) §

  • Update documented systemd example to include a restart setting (Andrew Jackson) §

E.1.3.10. Additional Modules #

  • Add pg_plan_advice module to stabilize and control planner decisions (Robert Haas) § §

  • Add extension pg_stash_advice to allow per-query-id advice to be specified (Robert Haas, Lukas Fittl) § §

  • Show sizes of FETCH queries as constants in pg_stat_statements (Sami Imseih) §

    Fetches of different sizes will now be grouped together in pg_stat_statements output.

  • Add generic and custom plan counts to pg_stat_statements (Sami Imseih) §

  • Refactor pg_buffercache reporting of shared memory mapping (Bertrand Drouvot) §

    New function pg_buffercache_os_pages() and system view pg_buffercache_os_pages allow reporting of shared memory mapping; the function optionally includes NUMA details. Function pg_buffercache_numa_pages() remains for backward compatibility.

  • Add functions to pg_buffercache to mark buffers as dirty (Nazir Bilal Yavuz) §

    The functions are pg_buffercache_mark_dirty(), pg_buffercache_mark_dirty_relation(), and pg_buffercache_mark_dirty_all().

  • Allow pushdown of array comparisons in prepared statements to postgres_fdw foreign servers (Alexander Pyhalov) §

  • Allow the retrieval of statistics from foreign data wrapper servers (Corey Huinker, Etsuro Fujita) § §

    This is enabled for postgres_fdw by using the option import_stats. The default is for ANALYZE to retrieve rows from the remote server to locally generate statistics.

  • Allow file_fdw to read files or program output that uses multi-line headers (Shinya Kato) §

  • Add server variable auto_explain.log_io to add IO reporting to auto_explain (Tomas Vondra) §

  • Allow auto_explain to add extension-specific EXPLAIN options via server variable auto_explain.log_extension_options (Robert Haas) §

  • Change btree_gin to support all btree-supported cross-type comparisons (Tom Lane) § §

  • Improve performance of bloom indexes by using streaming reads (Xuneng Zhou) § §

  • Improve performance of pgstattuple by using streaming reads (Xuneng Zhou) § §

  • Modify oid2name --extended to report the relation file path (David Bidoc) §

E.1.4. Acknowledgments #

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

Adam Lee
Adam Pickering
Adam Warland
Aditya Gollamudi
Aditya Kamath
Afrah Razzak
Aidar Imamov
Ajay Pal
Ajin Cherian
Akshay Joshi
Alberto Piai
Aleksander Alekseev
Aleksey Solovev
Alex Guo
Alex Shapalov
Alex Young
Alexander Borisov
Alexander Kjäll
Alexander Korotkov
Alexander Kozhemyakin
Alexander Kukushkin
Alexander Kuzmenkov
Alexander Kuznetsov
Alexander Lakhin
Alexander Pyhalov
Alexandra Wang
Alexandre Felipe
Alexey Makhmutov
Alexey Shishkin
Ali Akbar
Altan Birler
Álvaro Herrera
Alyona Vinter
Amit Kapila
Amit Langote
Amjad Shahzad
Amul Sul
Amy Burnett
Andreas Karlsson
Andreas Lind
Andrei Klychkov
Andrei Lepikhov
Andrei Varashen
Andres Freund
Andrew Bille
Andrew Dunstan
Andrew Gierth
Andrew Jackson
Andrew Kim
Andrew Krylosov
Andrew Watkins
Andrey Borodin
Andrey Chernyy
Andrey Rachitskiy
Andrey Rudometov
Andrey Silitskiy
Andrzej Doros
Andy Fan
Anh Khoa
Ante Kresic
Anthonin Bonnefoy
Antoine Violin
Anton Voloshin
Antonin Houska
Ants Aasma
Arne Roland
Arseniy Mukhin
Artem Gavrilov
Arthur Nascimento
Artur Zakirov
Ashutosh Bapat
Ashutosh Sharma
Atsuo Yamaguchi
Atsushi Torikoshi
Aya Iwata
Ayoub Kazar
Ayush Tiwari
Ayush Vatsa
Baji Shaik
Ben Morris
Benoit Lobréau
Bernd Helmle
Bernd Reiß
Bernice Southey
Bertrand Drouvot
Bharath Rupireddy
Bihua Wang
Bill Kim
Bing Tian
Bing’e Jin
Bob Kline
Bowen Shi
Brian Carpenter
Bruce Dang
Bruce Momjian
Bryan Fox
Bryan Green
Bykov Ivan
Cai Mengjuan
Cándido Antonio Martínez Descalzo
Cary Huang
Casey Shobe
Chaitanya Choudhary
ChangAo Chen
Changhong Fei
Chao Li
Charles Samborski
Chee Wooson
Chengpeng Yan
Chengxi Sun
Chi Zhang
Chiranmoy Bhattacharya
Chong Peng
Christian Ullrich
Christoph Berg
Christophe Pettus
Chuanwen Hu
Corey Huinker
DaeMyung Kang
Dagfinn Ilmari Mannsåker
Daisuke Higuchi
Damien Clochard
Dan Stefura
Daniel Bakker
Daniel Bauman
Daniel Farkaš
Daniel Firer
Daniel Gustafsson
Daniel Vérité
Daniel Woelfel
Daniele Varrazzo
Daniil Davydov
Dapeng Wang
Daria Shanina
Dave Cramer
David Bidoc
David Christensen
David Fetter
David G. Johnston
David Geier
David Rowley
David Steele
David Wheeler
Davin Shearer
Dean Rasheed
Dennis Björklund
Devanga Susmitha
Devrim Gündüz
Dewei Dai
Dharin Shah
Dhruv Chauhan
Dian Fay
Diego Frias
Dilip Kumar
Dimitre Radoulov
Dimitri Fontaine
Dimitrios Apostolou
Dipesh Dhameliya
Dmitriy Kuzmin
Dmitry Astapov
Dmitry Dolgov
Dmitry Fomin
Dmitry Igrishin
Dmitry Koval
Dmitry Kovalenko
Dmitry Mityugov
Dmitry Yurichev
Domenico Sgarbossa
Dominique Devienne
Donghang Lin
Doruk Yilmaz
Egor Chindyaskin
Ekaterina Sokolova
Emmanuel Sibi
Emmanuel Touzery
Eric Ridge
Erik Nordström
Erik Rijkers
Erik Wienhold
Ethan Mertz
Etsuro Fujita
Eugene Morgunov
Euler Taveira
Evan Montgomery-Recht
Evan Si
Evgeniy Gorbanev
Evgeny Voropaev
Ewan Young
Fabrice Chapuis
Fabrízio de Royes Mello
Feilong Meng
Feng Wu
Filip Janus
Florents Tselai
Florin Irion
Francesco Verardi
François Jehl
Frédéric Yhuel
Fredrik Widlert
Gabriel Gibson
Gaurav Singh
Gavin Panella
George Tarasov
Gilles Darold
Gilles Parc
Giovanni Fabris
Glauber Batista
Gleb Kashkin
Greg Burd
Greg Sabino Mullane
Gregory Smith
Grem Snoort
Grigorev Jurij
Grigory Smolkin
Guillaume Lelarge
Gunnar Morling
Guoqing Yang
Gurjeet Singh
Gyan Sreejith
Haibo Yan
Haiyang Li
Hang Ammmkilo
Hannu Krosing
Hans Buschmann
Haowu Ge
Haoyan Wang
Haruka Takatsuka
Haruna Miwa
Hayato Kuroda
Heewon Song
Heikki Linnakangas
Henrik TJ
Henson Choi
Hillai Ben Sasson
Holger Hoffstätte
Hubert Lubaczewski
Hugo Dubois
Hüseyin Demir
Ian Barwick
Ignat Remizov
Igor Stepansky
Ilia Evdokimov
Ilia Kashintsev
Ilya Cherdakov
Ilya Portnov
Ilya Staroverov
Ilyasov Ian
Imran Zaheer
Ivan Kush
Izumi Igi
Jack Bonatakis
Jacob Brazeal
Jacob Champion
Jacques Combrink
Jakob Egger
Jakub Wartak
Jan Nidzwetzki
Japin Li
Jasper Smit
Javier Maestro
Jeevan Chalke
Jeff Davis
Jeff Janes
Jehan-Guillaume de Rorthais
Jelte Fennema-Nio
Jérémie Hodnik
Jeroen Gui
Ji Xu
Jian He
Jianghua Yang
Jiao Shuntian
Jie Wang
Jihe Wang
Jim Jones
Jim Nasby
Jingtang Zhang
Jingzhou Fu
Jinhui Lai
Jinyang Liu
João Costa
Jochen Bandhauer
Joe Conway
Joel Jacobson
John Hsu
John Naylor
Jonas Boberg
Jonathan Gonzalez V.
Jonathan S. Katz
Jorge Solórzano
Josef Šimánek
Joseph Koshakow
Joshua Shanks
Julien Rouhaud
Julien Tachoires
Junwang Zhao
Junwen An
Justin Kwan
Justin Pryzby
Kamil Monicz
Karavaev Alexey
Karina Litskevich
Karthik S
Kartyshov Ivan
Ke Lan
Keisuke Kuroda
Keith Paskett
Kenny Chen
Kentaro Sato
Kevin K Biju
Kevin Oommen Anish
Kiran Kaki
Kirill Reshke
Konstantin Knizhnik
Krasiyan Andreev
Kristian Lejao
Kuan-Ting Kuo
Kunpeng Yi
Kuntal Ghosh
Kyotaro Horiguchi
Lakshmi G
Lakshmi N
Lars Kanis
Laurenz Albe
Lauri Siltanen
Lev Nikolaev
Lihui Zhang
Lori Corbani
Lu Feng
Lucas Velgus
Lucio Chiessi
Lukas Eder
Lukas Fittl
Maciek Sakrejda
Madhukar Prasad
Magnus Hagander
Mahendra Singh Thalor
Maksim Logvinenko
Maksim Melnikov
Maksim Milyutin
Man Zeng
Manni Wood
Manuel Reyes Bravo
Marco Nenciarini
Marcos Pegoraro
Marcus Gartner
Marian Muller Rebeyrol
Mario González
Mark Callaghan
Mark Dilger
Mark Frost
Mark Wong
Marko Grujic
Marko Tiikkaja
Martin Heistermann
Martin Rakhmanov
Masahiko Sawada
Masahiro Ikeda
Masao Fujii
Masashi Kamura
Matheus Alcantara
Mats Kindahl
Matt Long
Matthew Sterrett
Matthias van de Meent
Matthieu Denais
Matthijs van der Vleuten
Maxim Boguk
Maxim Orlov
Maxime Schoemans
Mehmet D. Ince
Melanie Plageman
Melih Mutlu
Meng Zhang
Merlin Moncure
Mert Alev
Michael Banck
Michael Malis
Michael Paquier
Michael Schönitzer
Mikael Gustavsson
Mikhail Gribkov
Mikhail Kot
Mikhail Litsarev
Mikhail Nikalayeu
Milosz Bieniek
Mingyang Zhen
Mircea Cadariu
Mohamed Ali
Moritz Sanft
Muhammad Taha Naveed
Mutaamba Maasha
Naga Appani
Natalya Aksman
Nathan Bossart
Nazir Bilal Yavuz
Neil Chen
Neil Conway
Niall Newman
Niccolò Fei
Nick Ivanov
Nicolas Adenis-Lamarre
Nikhil Kumar Veldanda
Nikhil Sontakke
Nikita Kalinin
Nikolay Samokhvalov
Nikolay Shaplov
Ning Sun
Ning Wu
Nisha Moond
Nishant Sharma
Nitin Jadhav
Nitin Motiani
Niyas Sait
Noah Misch
Noboru Saito
Noriyoshi Shinoda
Oleg Ivanov
Oleg Samoylov
Oleg Sibiryakov
Oleg Tkachenko
Oleg Tselebrovskiy
Oli Sennhauser
Oliver Ford
Oreo Yang
Orestis Markou
Osama Abdul Qader
Palak Chaturvedi
Palayret Jacques
Patrick Reynolds
Patrick Stählin
Paul Bunn
Paul Gerste
Paul Jungwirth
Paul Kim
Paul Ramsey
Pavel Borisov
Pavel Kohout
Pavel Kopylov
Pavel Luzanov
Pavel Seleznev
Pavel Stehule
Pavel Tyslacki
Pavlo Golub
Pedro Brantes
Peng Wang
Peter Eisentraut
Peter Geoghegen
Peter Mitteregger
Peter Smith
Pierre Ducroquet
Pierre Forstmann
Pierre Senellart
Pierrick Chovelon
Potapov Alexander
Pradeep Kumar
Przemyslaw Sztoch
Qifan Liu
Qing Zhang
Quan Zongliang
Radim Marek
Rafia Sabih
Rahila Syed
Rambabu V
Ran Benita
Ranier Vilela
Renan Davanzo
Renli Zou
Renzo Dani
Richard Guo
Richard Neill
Rick de Jager
Rintaro Ikeda
Rithvika Devisetti
Robert Haas
Robert Pang
Robert Treat
Rogers Wang
Rohit Prasad
Roman Khapov
Ronan Dunklau
Ruben Ruiz
Rui Zhao
Ruikai Peng
Runyuan He
Ruohang Feng
Rustam Allakov
Rustam Khamidullin
Ryan Bird
Ryo Kanbayashi
Ryo Matsumura
Sadhuprasad Patro
Sahitya Chandra
Sajeeb Lohani
Sami Imseih
Samuel Thibault
Sandeep Thakkar
Sandro Santilli
Sanjaya Waruna
Sarath Kumar
Satya Narlapuram
Satyanarayana Narlapuram
Sehrope Sarkuni
Semih Dogan
Sergei Glukhov
Sergei Kornilov
Sergei Patiakin
Sergey Fukanchik
Sergey Koposov
Sergey Prokhorenko
Sergey Shinderuk
Sergey Soloviev
Sergey Tatarintsev
Sergey Zhuravlev
Shengbin Zhao
Shenhao Wang
Shihao Zhong
Shinya Kato
Shinya Sugamoto
Shishir Sharma
Shixin Wang
Shiyu Qin
Shlok Kyal
Shruthi Gowda
Shubham Khanna
Shveta Malik
Siddharth Kothari
Sirisha Chamarthi
Solaimurugan V
Songjin Zhou
Sophie Alpert
Soumya S Murali
Srinath Reddy Sadipiralla
Srirama Kucherlapati
Stepan Neretin
Stephan Springl
Stéphane Schildknecht
Stephane Tachoires
Stephen Frost
Steve Baldwin
Steve Lau
Steven Niu
Stolpovskikh Danil
Sungwoo Chang
Sunil S
Surya Poondla
Suyang Zhong
Sven Klemm
Swirl Smog Dowry
Sylvie Mayer
Taiki Koshino
Takamichi Osumi
Tan Yang
Tan Zhen
Tatsuhito Kasahara
Tatsuo Ishii
Tatsuro Yamada
Tatsuya Kawata
Temuri Doghonadze
Tender Wang
Tenglong Gu
Thom Brown
Thomas Gabriel de Medeiros Silva
Thomas Kellerer
Thomas Munro
Tianchen Zhang
Tiancheng Ge
Tim Wood
Timur Magomedov
Tingchuan Sun
Tobias Bussmann
Todd Lang
Todd Liebenschutz-Jones
Tom Lane
Tomas Vondra
Tomer Fichman
Torsten Förtsch
Torsten Rupp
Tristan Partin
Tushar Ahuja
Tyler Smart
Ulisses de Mello dos Santos
Vaibhav Dalvi
Vaibhav Jain
Vaibhave Sekar
Valery Gubanov
Varik Matevosyan
Vasuki M
Victor Yegorov
Vignesh C
Vik Fearing
Viktor Holmberg
Viktor Leis
Vinod Sridharan
Vishal Prasanna
Vismay Tiwari
Vitaly Davydov
Vlad Lesin
Vladimir Tokarev
Walid Ibrahim
Wenhui Qiu
Xiangyu Liang
Xiaohui Liu
Xiaopeng Wang
Xing Guo
Xingbin She
Xingwang Xiang
Xueyu Gao
Xuneng Zhou
Xunqi Hu
Yang Zhu
Yanjie Zhao
Yanliang Lei
Yaroslav Saburov
Yaroslav Syrytsia
Yasuo Honda
Yi Ding
Yilin Zhang
Yingying Chen
Yiyang Liu
Yonghao Lee
Yonghwa Lee
Yu Wang
Yuan Li
Yuanchao Zhang
Yuanzhou Yang
Yuchen Li
Yuefei Shi
Yuelin Wang
Yugo Nagata
Yuhang Qiu
Yuhang Wu
Yura Sokolov
Yuri Zamyatin
Yuxiao Guo
Zane Duffield
Zechman, Derek S
Zengqi Gao
Zepeng Zhang
Zexin Li
Zhang Hu
Zhang Mingli
Zheng Tao
Zheng Wang
Zheng Yu
Zhenpeng Lin
Zhenwei Shang
Zhibai Song
Zhibin Wang
Zhihong Yu
Zhijie Hou
Zhiyuan Su
Zhou Digoal
Zizhen Qiao
Zizhuan Liu
Zsolt Parragi
來源: hackernews100 (postgresql.org)
開啟原文

讀者討論

理性交流 · 即時討論