pgbench - adding pl/pgsql versions of tests 4105 Needs review Testing 19 10/10 +247−14 Hannu Krosing (hannukrosing) Fabien Coelho (calvin), Yugo Nagata (yugo.nagata), Robert Treat (xzilla) 10 2 months ago Incremental View Maintenance (IVM), take 2 4337 Waiting on Author SQL Commands Needs rebase! Yugo Nagata (yugo.nagata) Alexandre Felipe (afelipe) 16 1 month ago add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl 4390 Needs review Security Needs rebase! Cary Huang (cary) Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) 12 9 months ago Make COPY format extendable: Extract COPY TO format implementations 4681 Needs review SQL Commands Needs rebase! Kouhei Sutou (kou) Masahiko Sawada (masahikosawada), Zhao Junwang (zhjwpku), Yong Li (yoli) 11 1 week ago Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state 5029 Needs review Bugfix Logical Replication 10/10 +110−6 ChangAo Chen (chenchangao) harinath kanchu (harinath001), Lilian Ontowhee (ontowhee), haiyang li (ocean-li) 10 4 months ago Add OR REPLACE option to CREATE MATERIALIZED VIEW 5099 Needs review SQL Commands 9/10 +694−98 Erik Wienhold (ewie) Paul Jungwirth (pjungwir), newtglobal postgresql_contributors (newtpostgrescontributors) 9 2 months ago Refactor SLRU to always use long file names 5250 Ready for Committer Refactoring Only 10/10 +105−88 Aleksander Alekseev (a.alekseev) 9 2 months ago System views for versions reporting 5318 Ready for Committer Monitoring stable Needs rebase! Dmitry Dolgov (erthalion) Laurenz Albe (laurenz) 9 4 months ago Function scan FDW pushdown 5470 Needs review Performance 18 10/10 +1348−104 Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) Ashutosh Bapat (ashutoshbapat) 3 2 weeks ago SQL/JSON json_table PLAN clause 5478 Needs review 18 9/10 +2312−168 Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrew Dunstan (adunstan), Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Anton Melnikov (antonmel), Nikita Malakhov (nmalakh) Amit Langote (amitlan), Vladlen Popolitov (vladlenpopolitov) 6 11 months ago Pull-up subquery if INNER JOIN-ON contains refs to upper-query 5487 Needs review Performance 19 10/10 +1508−58 Alena Rybakina (a.rybakina) Ilia Evdokimov (ilidock95) 7 5 days ago Expanding HOT updates for expression and partial indexes 5556 Needs review Performance 19 Needs rebase! Greg Burd (gregburd) Nathan Bossart (bossartn) 6 1 week ago Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup 5570 Needs review Multithreading AIO 10/10 +448−37 Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 7 2 weeks ago Beautify read stream "per buffer data" APIs 5617 Needs review Refactoring Only 10/10 +116−44 Thomas Munro (macdice) Nazir Bilal Yavuz (nbyavuz) 5 2 days ago support create index on virtual generated column. 5667 Waiting on Author Needs rebase! Jian He (stayreal) Soumya S Murali (soumyamurali) 6 2 weeks ago Produce LLVM bitcode files on meson builds 5671 Needs review Performance 19 10/10 +928−58 Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) Peter Eisentraut (petere) 5 2 days ago Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION 5681 Waiting on Author Bugfix 10/10 +132−19 Yugo Nagata (yugo.nagata) Jim Jones (jimus), Daniil Davydov (dddaniil) 6 6 months ago ALTER DOMAIN ADD NOT NULL NOT VALID 5768 Needs review 19 10/10 +219−29 Jian He (stayreal) Peter Eisentraut (petere) 6 1 month ago Extend skipping FK checks on replicas to include ADD FK and TRUNCATE 5774 Needs review Performance Help - Stuck Rebasing Logical Replication 19 10/10 +96−3 Hannu Krosing (hannukrosing) 5 2 months ago problems with toast.* reloptions 5839 Waiting on Author Bugfix stable Needs rebase! Nathan Bossart (bossartn) 6 8 months ago Adding pg_dump flag for parallel export to pipes 5893 Needs review Performance System Administration stable Needs rebase! Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) Dilip Kumar (dilip.kumar) 4 2 weeks ago Automatically sizing the IO worker pool 5913 Needs review Performance 19 10/10 +629−145 Thomas Munro (macdice) 4 6 days ago pgbench: extend variable usage in scripts 6012 Waiting on Author libpq 19 Needs rebase! Yugo Nagata (yugo.nagata) lakshmi g (lakshmi) 5 2 months ago Little refactoring of portalcmds.c 6113 Needs review Refactoring Only Good First Review 10/10 +16−24 Aleksander Alekseev (a.alekseev) 4 5 months ago Add GoAway protocol message for graceful but fast server shutdown/switchover 6156 Needs review libpq 10/10 +553−21 Jelte Fennema-Nio (jeltef) 4 3 days ago pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized 6219 Waiting on Author Performance libpq stable 3/10 +368−50 Hannu Krosing (hannukrosing) Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) 3 4 days ago Give Plugins control at the end of CHECKPOINT to store their state 6224 Needs review Extensions 19 10/10 +215−0 Andrei Lepikhov (lepikhov), Asif Rehman (asifrana) 3 4 months ago Bypassing cursors in postgres_fdw to enable parallel plans 6233 Needs review postgres_fdw Performance 19 10/10 +628−51 Rafia Sabih (rafia.sabih) 2 yesterday split tablecmds.c 6269 Waiting on Author Refactoring Only 19 Needs rebase! Nathan Bossart (bossartn) 3 2 months ago Proposal to allow setting cursor options on Portals 6292 Needs review libpq 10/10 +1212−11 Dave Cramer (dcramer) Jelte Fennema-Nio (jeltef) 2 1 week ago Add pg_current_vxact_id() function to expose virtual transaction IDs 6298 Needs review Good First Review Monitoring 19 10/10 +109−4 Pavlo Golub (pasha_golub) Henson Choi (assam258.gmail.com) 3 1 month ago Incorrect historic snapshot may be serialized to disk during fast-forwarding 6304 Needs review Bugfix 10/10 +11−7 ChangAo Chen (chenchangao), haiyang li (ocean-li) 3 2 months ago Expose checkpoint timestamp and duration in pg_stat_checkpointer 6307 Needs review Extensions Performance 19 Needs rebase! Soumya S Murali (soumyamurali) 3 4 months ago SQL-level pg_datum_image_equal 6309 Needs review 10/10 +80−0 Matthias van de Meent (mmeent) 2 1 week ago File locks for data directory lockfile in the context of Linux namespaces 6335 Needs review stable 10/10 +111−18 Dmitry Dolgov (erthalion) 3 2 months ago Fix several Datum conversion inconsistencies (was: Remove Int8GetDatum, DatumGetUInt8 and UInt8GetDatum funcitons) 6354 Needs review Refactoring Only Good First Review 19 10/10 +31−31 Aleksander Alekseev (a.alekseev), Kirill Reshke (reshke) Peter Eisentraut (petere) 3 1 week ago QoL improvements for pgindent and combining pgindent, pgperltidy, pgperlcritic and pgperlsyncheck into one tool 6366 Needs review Devtools 10/10 +1051−516 Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 3 23 hours ago Use CASEFOLD() internally rather than LOWER() 6391 Needs review 19 10/10 +55−30 Jeff Davis (jdavis) Mark Dilger (mark.dilger) 2 1 week ago Refactor *_abbrev_convert() functions 6393 Needs review Refactoring Only Good First Review 19 10/10 +36−62 Aleksander Alekseev (a.alekseev) Aditya Gollamudi (adigoll) John Naylor (john.naylor) 2 1 month ago nbtree: reduce code redundancy by using _bt_getmeta() in _bt_gettrueroot() 6402 Needs review Refactoring Only 19 10/10 +1−21 Chao Li (chaol) 2 2 months ago Add cascade synchronous replication 6404 Needs review Missing Docs Testing Physical Replication Needs rebase! Григорий Новиков (grishanovik) 2 3 months ago ATPrepCmd: cleanup unreachable AT_AddIndexConstraint handling 6439 Needs review Refactoring Only 19 10/10 +18−14 Chao Li (chaol) 2 2 months ago tablecmds: fix Deadlock caused by Attach Partition 6442 Needs review Bugfix DDL 19 10/10 +54−0 Chao Li (chaol) 2 2 months ago Show expression of virtual columns in error messages 6460 Needs review 10/10 +208−43 Matheus Alcantara (matheus.alcantara) Peter Eisentraut (petere) 2 2 weeks ago Provide support for trailing commas 6492 Waiting on Author Needs rebase! Greg Sabino Mullane (greg) Peter Eisentraut (petere) 2 1 week ago add assertion for palloc in signal handlers 6498 Waiting on Author 19 Needs rebase! Nathan Bossart (bossartn) 2 1 month ago [PATCH] Add RetrieveInstrumentation hook for CustomScan providers so that Parallel CustomScan providers can currently aggregate worker instrumentation before DSM unlinking 6524 Needs review Extensions stable 10/10 +16−0 Siddharth Kothari (sidkot.google.com) 2 1 month ago synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication 6543 Needs review Performance Logical Replication 3/10 +1050−126 SATYANARAYANA NARLAPURAM (satyanarayanan) 2 22 hours ago Decorrelate nested tuple hash tables 6553 Needs review Performance 19 9/10 +13−7 Ants Aasma (ants) 2 1 month ago Simplify ExecWithoutOverlapsNotEmpty by removing unused parameter 6556 Ready for Committer Good First Review 10/10 +4−4 Man Zeng (zengman) shihao zhong (zhong950419) 1 3 weeks ago POC: PLpgSQL FOREACH IN JSON ARRAY 6557 Needs review PL/pgSQL 10/10 +1016−97 Pavel Stehule (okbobcz) Tom Lane (tgl), Jim Jones (jimus) 1 1 week ago Pgbench: remove synchronous prepare 6558 Needs review 9/10 +104−5 Dmitrii Bondar (difesu) 1 2 weeks ago tid_blockno() and tid_offset() accessor functions 6559 Needs review SQL Commands 10/10 +198−0 Ayush Tiwari (aytiwari) 1 2 weeks ago psql tab completion for user functions and if explicitly required also "pg_" 6563 Needs review psql 19 10/10 +49−1 Florin Irion (irionr) 1 1 month ago Reject ADD CONSTRAINT NOT NULL if name mismatches existing domain not-null constraint 6564 Needs review Bugfix stable 10/10 +40−2 Jian He (stayreal) 1 1 month ago guc: make dereference style consistent in check_backtrace_functions 6566 Needs review Bugfix 10/10 +16−16 zhang hu (zhanghu) 1 1 week ago doc: Improve wal_level and effective_wal_level GUC around logical replication 6567 Needs review Docs Only stable 10/10 +27−31 David Johnston (polobo) 1 4 weeks ago Assert failure in ReorderBufferReturnTXN during logical decoding due to leaked specinsert change 6569 Ready for Committer Bugfix stable 10/10 +54−11 Vishal Prasanna (vishalprasanna) Hayato Kuroda (ha-kun) 1 1 week ago Compress prune/freeze records with Delta Frame of Reference algorithm 6574 Needs review Performance 7/10 +4739−35 Evgeny Voropaev (evoro) 1 5 days ago Fix the wrong behavior of REFRESH MATERIALIZED VIEW CONCURRENTLY 6579 Needs review Bugfix 19 Needs rebase! Rafia Sabih (rafia.sabih), Surya Poondla (spoondla) 1 1 week ago Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY 6580 Needs review Performance 19 Needs rebase! Surya Poondla (spoondla) 1 1 week ago ECPG: inconsistent behavior with the document in “GET/SET DESCRIPTOR.” 6584 Needs review Bugfix My First Patch 10/10 +4−12 Masashi Kamura (kam) 1 3 weeks ago Fix JSON_SERIALIZE() coercion placeholder type for jsonb input 6587 Needs review Bugfix 10/10 +80−3 Matt Blewitt (mble-ps) Zsolt Parragi (zsolt.parragi) 1 2 weeks ago Speed up COPY TO text/CSV parsing using SIMD 6588 Needs review Performance 19 9/10 +262−18 Ayoub Kazar (kaz) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 yesterday MERGE PARTITIONS and DEPENDS ON EXTENSION. 6589 Needs review Bugfix 10/10 +377−0 Matheus Alcantara (matheus.alcantara) 1 3 weeks ago SQL/JSON json_table() function PLAN clause 6590 Needs review Help - Stuck Rebasing SQL Commands 10/10 +2312−168 Nikita Malakhov (nmalakh) 1 2 weeks ago A stack allocation API 6591 Needs review Refactoring Only Performance Needs rebase! Thomas Munro (macdice) 1 2 weeks ago tupdesc: simplify assert in equalTupleDescs() 6594 Needs review Refactoring Only 19 3/10 +1−2 Chao Li (chaol) 1 2 weeks ago elog: clarify usage and style of error reporting functions 6595 Needs review Comments Only 19 3/10 +21−0 Chao Li (chaol) 1 2 weeks ago Validate user-supplied c_args in meson builds 6596 Needs review Devtools 19 10/10 +9−0 Bertrand Drouvot (bertranddrouvot.pg) 1 2 weeks ago Replace __builtin_types_compatible_p with _Generic 6597 Needs review Modernization Refactoring Only 10/10 +62−77 Thomas Munro (macdice), Jelte Fennema-Nio (jeltef) 1 2 weeks ago Add ssl_(supported|shared)_groups to sslinfo 6598 Needs review Needs rebase! Dmitry Dolgov (erthalion) 1 1 week ago pg_dump: fix NOT NULL constraint name comparison using makeObjectName 6601 Needs review Bugfix 19 10/10 +258−127 JoongHyuk Shin (shin) 1 2 weeks ago rewriteGraphTable: Fix missing RTEs in FROM clause by setting inFromCl=true 6602 Waiting on Author Bugfix 19 10/10 +3−3 Man Zeng (zengman) Peter Eisentraut (petere) 1 1 week ago Avoid use of TopMemoryContext for resource owner cleanup in portals 6603 Needs review Refactoring Only 9/10 +106−23 Lukas Fittl (lfittl) 1 1 week ago Add pg_stat_vfdcache view for VFD cache statistics 6604 Needs review Monitoring 19 10/10 +411−4 Ayoub Kazar (kaz) 1 17 hours ago Two issues leading to discrepancies in FSM data on the standby server 6605 Needs review Bugfix 19 Needs rebase! Alexey Makhmutov (lerm) 1 1 week ago log_checkpoints: count WAL segment creations from all processes 6606 Needs review Monitoring 10/10 +137−4 Xuneng Zhou (dylanzhou) 1 1 week ago New pg_stat_tablespace view for tablespace level metrics 6607 Needs review Monitoring 3/10 +759−14 shihao zhong (zhong950419) 1 2 days ago bugfix - fix broken output in expanded aligned format, when data are too short 6608 Needs review Bugfix 10/10 +41−3 Pavel Stehule (okbobcz) 1 1 week ago ORDER BY ALL 6610 Needs review SQL Commands 3/10 +1348−6 Rushabh Lathia (rlathia) 1 1 week ago This adds a new GUC parameter that automatically rolls back prepared transactions that have remained unresolved beyond the configured timeout. The cleanup is performed by the checkpointer process. 6611 Needs review Performance 10/10 +513−1 Nikhil Chawla (nchawla) 1 yesterday heapam_tuple_complete_speculative : remove unnecessary tuple fetch 6613 Ready for Committer Refactoring Only stable 10/10 +1−7 Chao Li (chaol) 1 yesterday Add http connection service file functionality 6614 Needs review libpq 19 2/10 +1015−2 Andrew Jackson (andrewjackson) 1 1 week ago Make \d tablename fast again, regression introduced by 85b7efa1cdd 6615 Needs review Bugfix Performance 18 10/10 +31−1 Jelte Fennema-Nio (jeltef) 1 1 week ago VACUUM FULL, CLUSTER, and REPACK block on other sessions' temp tables 6616 Needs review Bugfix Backport stable 10/10 +95−1 Jim Jones (jimus) 1 1 week ago Fix a file descriptor leak when using io_method=io_uring 6617 Needs review Bugfix AIO My First Patch stable 10/10 +42−0 Lucas DRAESCHER (draescherl) 1 1 week ago Improving psql autocompletion for SET LOCAL / SET SESSION 6618 Needs review psql My First Patch 10/10 +7−0 Álvaro Rodríguez (arodrgr) 1 1 week ago pg_stat_xact_user_tables stat not currect during the transaction 6619 Needs review Bugfix 9/10 +332−10 Xuneng Zhou (dylanzhou) Gabriel Batista (gabo) 1 5 days ago PoC - psql - emphases line with table name in verbose output 6620 Needs review psql 10/10 +16−1 Pavel Stehule (okbobcz) 1 5 days ago Bug: wrong relname in RemoveSubscriptionRel() error detail 6621 Needs review Bugfix stable 10/10 +1−1 Chao Li (chaol) 1 3 days ago Get rid of redundant StringInfo accumulation 6622 Needs review Performance 19 10/10 +15−5 Daniil Davydov (dddaniil) 1 3 days ago Add custom EXPLAIN options support to auto_explain 6623 Needs review Extensions 10/10 +742−100 Matheus Alcantara (matheus.alcantara) 1 4 hours ago pg_stat_statements: add last_execution_start column 6624 Needs review Monitoring 19 10/10 +363−11 Pavlo Golub (pasha_golub) 1 2 days ago Add pg_stat_autovacuum_priority 6625 Ready for Committer Monitoring 19 9/10 +262−58 Sami Imseih (simseih) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 4 hours ago Fix HAVING-to-WHERE pushdown with nondeterministic collations 6626 Needs review Bugfix stable 10/10 +379−0 Richard Guo (richardguo) 1 yesterday Convert ALL SubLinks to ANY SubLinks 6627 Needs review Performance 10/10 +422−9 Richard Guo (richardguo) 1 1 week ago Fix JSON_ARRAY(query) empty set handling and view deparsing 6628 Needs review Bugfix stable 10/10 +355−69 Richard Guo (richardguo) 1 1 month ago Fix integer overflow in nodeWindowAgg.c 6629 Needs review Bugfix stable 9/10 +117−5 Richard Guo (richardguo) 1 1 month ago jsonb subscripting vs SQL/JSON array accessor semantics (SQL:2023) 6631 Needs review 10/10 +758−87 Alexandra Wang (l-wang) 1 3 days ago Add tests for src/backend/nodes/extensible.c 6632 Needs review Testing 10/10 +575−0 Aleksander Alekseev (a.alekseev) 1 3 days ago Add condition variable support to WaitEventSetWait() 6633 Needs review Refactoring Only 19 8/10 +179−48 Chao Li (chaol) 1 yesterday Skip prefetch for block references that follow a FPW or WILL_INIT of the same block 6634 Needs review Performance Physical Replication 19 Needs rebase! SATYANARAYANA NARLAPURAM (satyanarayanan) 1 1 week ago Add support for INSERT ... SET syntax 6635 Needs review SQL Commands 10/10 +779−4 Suraj Kharage (surajk) 1 3 days ago Add ParameterDescription message to libpq frontend long message types 6636 Needs review Bugfix libpq My First Patch stable 10/10 +2−1 Ning Sun (sunng) 1 2 days ago bufmgr: pass through I/O stats context in FlushUnlockedBuffer() 6637 Needs review Refactoring Only Good First Review 19 10/10 +2−2 Chao Li (chaol) 1 3 days ago Silence compiler warnings -Wmaybe-uninitialized 6638 Needs review Refactoring Only stable 10/10 +3−3 Imran Zaheer (imranzaheer) 1 16 hours ago Track skipped vacuum and analyze in pg_stat_all_tables 6639 Needs review Monitoring 0/10 +324−23 Yugo Nagata (yugo.nagata) 1 1 week ago Adjust error message for CREATE STATISTICS to account for expressions 6641 Needs review DDL Needs rebase! Yugo Nagata (yugo.nagata) 1 yesterday Warn when creating or enabling a subscription with max_logical_replication_workers = 0 6642 Needs review Logical Replication 10/10 +14−0 Yugo Nagata (yugo.nagata) 1 1 month ago Extract numeric filed in JSONB more effectively 6644 Needs review Performance 10/10 +452−5 Haibo Yan (billyean) 1 14 hours ago pg_test_timing: fix unit typo and widen diff type 6645 Needs review Bugfix 19 9/10 +6−6 Chao Li (chaol) 1 yesterday meson: Adjust test timeout for Valgrind builds 6646 Needs review Devtools 19 10/10 +21−4 Bertrand Drouvot (bertranddrouvot.pg) 1 16 hours ago Remove commented-out code in 026_overwrite_contrecord.pl 6647 Needs review Comments Only 10/10 +1−1 Imran Zaheer (imranzaheer) 1 17 hours ago Docs: Create table description for constraints markup fix and label tweaks 6648 Needs review Bugfix Docs Only 10/10 +8−8 David Johnston (polobo) 1 13 hours ago Docs: Distinguish table and index storage parameters in CREATE TABLE 6649 Needs review Docs Only 10/10 +21−12 David Johnston (polobo) Andreas Karlsson (kandreas) 1 4 hours ago remove autoanalyze corner case 6650 Needs review 19 10/10 +0−9 Nathan Bossart (bossartn) 1 4 hours ago