PostgreSQL 19 推出 REPACK,新增多項資料庫維護與複寫功能
PostgreSQL 19
資料庫表格需要整理和維護時,舊做法可能會擋住讀寫;升級新版也可能遇到相容性變更。
- PostgreSQL 19 新增 REPACK,可整理表格並回收磁碟空間,使用 CONCURRENTLY 時仍能讓其他人讀寫。這版也加入平行自動清理,並改善外部索引鍵檢查和查詢速度。
- 複寫方面則新增序列值同步,以及讓備用伺服器等待資料寫入或重播完成的 WAIT 指令。升級前要留意變更,例如移除了 RADIUS 支援,部分舊資料庫也需要先調整或重新匯入。
AI 伴隨問答
針對這篇報導有疑問?可直接點選快捷問題或向 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_gistinet/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) §
-
變更 全文檢索 和 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)§ -
在最佳化器中提早對
varIS [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)§
-
允許使用函式
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. 一般效能 #
-
允許
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控制。 -
使用 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)§
-
使用基數排序提升排序效能(John Naylor)§
-
改善計時效能測量(Lukas Fittl、Andres Freund、David Geier)§ §
這項改進有助於
EXPLAIN (ANALYZE, TIMING)和 pg_test_timing,並由伺服器變數timing_clock_source控制。
E.1.3.1.3. 系統檢視表 #
-
新增系統檢視表
pg_stat_lock和函式pg_stat_get_lock(),用來回報各鎖定型別的統計資料(Bertrand Drouvot)§ -
新增系統檢視表
pg_stat_recovery,用來回報復原狀態(Xuneng Zhou、Shinya Kato)§ § -
新增系統檢視表
pg_stat_progress_repack,用來回報REPACK、CLUSTER和VACUUM FULL的進度(Álvaro Herrera)§ -
新增系統檢視表
pg_stat_autovacuum_scores,用來回報每個資料表的 autovacuum 詳細資訊(Sami Imseih)§ -
將 vacuum 啟動詳細資訊加入系統檢視表
pg_stat_progress_vacuum(Shinya Kato)§新的
started_by欄位會回報 vacuum 的啟動者,mode則表示其積極程度。 -
將 analyze 啟動詳細資訊加入系統檢視表
pg_stat_progress_analyze(Shinya Kato)§新的
started_by欄位會回報 analyze 的啟動者。 -
新增系統檢視表
pg_dsm_registry_allocations,用來回報 動態共用記憶體的詳細資訊(Florents Tselai、Nathan Bossart)§ § -
在系統檢視表
pg_stat_replication_slots新增mem_exceeded_count欄位(Bertrand Drouvot)§這會回報
logical_decoding_work_mem超出上限的次數。 -
將時段同步略過資訊加入
pg_stat_replication_slots和pg_replication_slots(Shlok Kyal)§ § §新增的欄位為
slotsync_skip_count、slotsync_last_skip和slotsync_skip_reason。 -
在系統檢視表
pg_stat_subscription_stats加入update_deleted欄位(Zhijie Hou)§此欄位會回報因並行刪除而略過更新的資料列數。訂閱端必須啟用
retain_dead_tuples才能使用此功能。 -
在系統檢視表
pg_stat_subscription_stats加入sync_seq_error_count欄位,以回報序列同步錯誤(Vignesh C)§ § -
在系統檢視表
pg_stat_all_tables、pg_stat_all_indexes和pg_statio_all_sequences加入stats_reset欄位(Bertrand Drouvot、Sami Imseih、Shihao Zhong)§此欄位也會出現在
sys和user檢視表變體中。 -
在系統檢視表
pg_stat_user_functions和pg_stat_database_conflicts加入stats_reset欄位(Bertrand Drouvot、Shihao Zhong)§ § -
在系統檢視表
pg_available_extensions和pg_available_extension_versions加入location欄位,以回報擴充套件的檔案系統目錄(Matheus Alcantara)§ -
在系統檢視表
pg_stat_progress_basebackup加入backup_type欄位,以回報備份型別(Shinya Kato)§可能的值為
full或incremental。 -
在系統檢視表欄位
pg_stat_wal_receiver.status加入connecting值。(Xuneng Zhou)§ -
加入 WAL 完整頁面映像檔寫入位元組數的回報功能(Shinya Kato)§
可透過系統檢視表
pg_stat_wal和函式pg_stat_get_backend_wal()取得此資訊。 -
在系統檢視表
pg_stats、pg_stats_ext和pg_stats_ext_exprs加入欄位(Corey Huinker)§將資料表
OID和屬性編號欄位加入pg_stats,並將資料表OID和統計物件OID欄位加入另外兩個檢視表。 -
在系統檢視表
pg_stats_ext_exprs加入範圍型別擴充統計資料的相關資訊(Corey Huinker、Michael Paquier)§
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 伺服器。
-
為管線、檔案或程式中的
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. 伺服器設定 #
-
新增評分系統,控制 autovacuum 處理資料表的順序(Nathan Bossart)§
新增的伺服器變數包括
autovacuum_freeze_score_weight、autovacuum_multixact_freeze_score_weight、autovacuum_vacuum_score_weight、autovacuum_vacuum_insert_score_weight和autovacuum_analyze_score_weight。 -
新增伺服器端對 SNI(Server Name Indication)的支援(Daniel Gustafsson、Jacob Champion)§
新增設定檔
PGDATA/pg_hosts.conf,用來指定主機名稱/金鑰配對。 -
允許 OAuth 驗證器註冊自訂的
pg_hba.conf驗證選項(Jacob Champion、Zsolt Parragi)§ -
允許角色
pg_read_all_data和pg_write_all_data讀取/寫入大型物件(Nitin Motiani、Nathan Bossart)§這些角色旨在讓非超級使用者執行 pg_dump。
-
允許設定背景工作程式在資料庫層級作業開始前終止(Aya Iwata)§
這讓資料庫層級作業能更快完成,因為現在可以終止造成阻塞的背景工作程式。
-
將 GB18030 編碼從 2000 版更新為 2022 版(Chao Li、Zheng Tao)§
相容性細節請參閱提交訊息。
-
新增
WAIT指令,讓待命伺服器等待 LSN 值寫入、刷寫或重播(Kartyshov Ivan、Alexander Korotkov、Xuneng Zhou)§ § -
改善函式
pg_sync_replication_slots(),使其等待複寫同步完成(Ajin Cherian、Zhijie Hou)§先前,某些同步失敗情況不會回報。
-
新增伺服器變數
wal_sender_shutdown_timeout,限制關機期間等待副本同步的時間(Andrey Silitskiy、Hayato Kuroda)§預設情況下,傳送端仍會無限期等待同步。
-
允許訂閱端儲存的序列值與發布端相符(Vignesh C)§ § §
此作業會在
ALTER SUBSCRIPTION ... [ADD|SET|REFRESH|DROP] PUBLICATION期間執行。函式pg_get_sequence_data()可用來檢查序列同步狀態。 -
允許
CREATE/ALTER PUBLICATION發布所有序列(Vignesh C、Tomas Vondra)§透過
ALL SEQUENCES子句啟用此功能。 -
允許在發布專案中使用
ALTER SUBSCRIPTION,同步訂閱端的序列是否存在,使其與發布端相符(Vignesh C)§透過
REFRESH SEQUENCES子句啟用此功能。 -
允許
CREATE/ALTER PUBLICATION排除部分資料表(Vignesh C、Shlok Kyal)§ § § §透過
EXCEPT子句控制此功能;指定ALL TABLES時也很實用。 -
新增
CREATE/ALTER SUBSCRIPTION設定retain_dead_tuples,保留衝突偵測所需的資訊(Zhijie Hou)§ § §另新增設定
max_retention_duration,用來限制retain_dead_tuples的保留時間。 -
允許
CREATE SUBSCRIPTION使用 postgres_fdw 外部資料包裝函式的連線引數(Jeff Davis)§透過
CREATE SUBSCRIPTION ... SERVER參照連線引數。 -
當伺服器變數
wal_level設為replica時,允許在需要時自動啟用邏輯複寫 (Masahiko Sawada) §新增伺服器變數
effective_wal_level、應用程式 pg_controldata 和函式pg_control_checkpoint(),用來回報實際生效的 WAL 層級。 -
允許依訂閱和使用者設定
wal_receiver_timeout(Fujii Masao) § §這讓訂閱端可以使用不同的
wal_receiver_timeout值。 -
為
pg_replication_origin_session_setup()新增選用的 pid 引數,讓 SQL 層級的複寫解決方案能夠平行處理 (Doruk Yilmaz, 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) § §
-
允許對
CHECK約束使用ALTER TABLE ALTER CONSTRAINT ... [NOT] ENFORCED(Jian He) §之前只有外部索引鍵約束支援變更強制執行設定。
-
允許
ALTER TABLE ... COLUMN SET EXPRESSION用於具有CHECK約束的虛擬欄位 (Jian He) §之前不允許這麼做。
-
允許
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. 資料型別 #
-
新增更多
jsonpath字串方法(Florents Tselai、David E. Wheeler)§這些方法為
ltrim()、rtrim()、btrim()、lower()、upper()、initcap()、replace()和split_part()。這些方法與非 JSON 字串版本一樣不可變。 -
Allow casts between
byteaanduuiddata types (Dagfinn Ilmari Mannsåker, Aleksander Alekseev) § -
Add ability to cast between database names and
oids usingregdatabase(Ian Lawrence Barwick) § -
Add functions
tid_block()andtid_offset()to extract block numbers and offsets fromtidvalues (Ayush Tiwari) §
E.1.3.5. Functions #
-
Add
date,timestamp, andtimestamptzversions ofrandom(min, max)(Damien Clochard, Dean Rasheed) § § -
Allow
encode()anddecode()to process data inbase64urlandbase32hexformats (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()andmultirange_minus_multi(). This is useful to represent range subtraction results with gaps. -
Add function
error_on_null()to return the supplied parameter, or error onNULLinput (Joel Jacobson) § -
Allow
IS JSONto work on domains defined over supported base types (Jian He) § -
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_fileto specify an alternate certificate authority when communicating with OAuth providers (Jonathan Gonzalez V., Jacob Champion) §This can also be set via the
PGOAUTHCAFILEenvironment variable. The default is to use curl's built-in certificates. -
Allow libpq environment variable
PGOAUTHDEBUGto specify particular debug options (Zsolt Parragi, Jacob Champion) §The
UNSAFEoption 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_V2that 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) §
-
Allow control over how booleans are displayed in psql (David G. Johnston) §
The \pset variables are
display_trueanddisplay_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-onlyand--analyze-in-stagesoptions 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-pathas an alias for the existing and deprecated--wal-directoryoption. -
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
PGDATAdirectory (Nathan Bossart) §Previously such tablespaces generated an error.
-
Add pgbench option
--continue-on-errorto 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.confrather than directly inpostgresql.auto.conf. -
Add pg_createsubscriber option
-l/--logdirto 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()andhex_decode()to use SIMD CPU instructions (Nathan Bossart, Chiranmoy Bhattacharya) § -
Add Meson option to build both shared and static libraries, or only shared (Peter Eisentraut) §
-
Add hooks
planner_setup_hook,planner_shutdown_hook,joinrel_setup_hook, andjoin_path_setup_hook(Robert Haas) § § -
Allow extensions to replace set-returning functions in the
FROMclause with SQL queries (Paul A. Jungwirth) § -
Make multixact members 64-bit (Maxim Orlov) §
-
Change function prototypes to use
uint*instead ofbit*typedefs (Nathan Bossart) § -
Allow OAuth validators to supply failure details (Jacob Champion) §
This is done by setting the
ValidatorModuleResultstructure member error_detail. -
Add simplified and improved shared memory registration function
ShmemRequestStruct()(Heikki Linnakangas, Ashutosh Bapat) §Functions
ShmemInitStruct()andShmemInitHash()remain for backward compatibility. -
Add server variable
debug_exec_backendto 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
FETCHqueries 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 viewpg_buffercache_os_pagesallow reporting of shared memory mapping; the function optionally includes NUMA details. Functionpg_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(), andpg_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 forANALYZEto 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_ioto add IO reporting to auto_explain (Tomas Vondra) § -
Allow auto_explain to add extension-specific
EXPLAINoptions via server variableauto_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
--extendedto 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 |