PostgreSQL Patch Tester

Current commitfest | Next commitfest | FAQ | Statistics | Highlights

Here lives an experimental bot that converts email threads that are registered in the Commitfest system into branches on Github, and collates test results from Cirrus CI. Key: or = new/recently changed, or = stable, needs rebase but previous build was successful, = working.

Ready for Committer

50/4237 Add CANONICAL option to xmlserialize Jim Jones   D H        
50/4390 add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl Cary Huang    D H        
50/4829 Add trim_trailing_whitespace to editorconfig file Jelte Fennema-Nio   D H        
50/4921 allow changing autovacuum_max_workers without restarting Nathan Bossart   D H        
50/5052 better error message when --single is not the first arg to postgres executable Nathan Bossart, Greg Sabino Mullane   D H        
50/5158 Blast-RADIUS mitigation Thomas Munro   D H        
50/5255 C-Language Functions docs on how to call internal functions Florents Tselai   D H        
50/4240 Cross-database SERIALIZABLE safe snapshots Thomas Munro   D H
50/5262 ensure we have a snapshot when dropping an index concurrently Nathan Bossart   D H        
50/4959 Fix BackgroundPsql to report error on query timeout rather than calling die Daniel Gustafsson   D H        
50/4884 Fix rare recovery shutdown hang Thomas Munro   D H        
50/5153 Prohibit to use EphemeralNamedRelation in materialized views Yugo Nagata   D H        
50/5149 Remove duplicated smgrclose call Steven Niu   D H        
50/4888 Run deferred triggers in the correct security context Laurenz Albe   D H        
50/4718 Set log_lock_waits=on by default Laurenz Albe   D H        
50/4627 Special-case executor expression steps for common combinations Andres Freund, Daniel Gustafsson   D H        
50/5027 Track the amount of time waiting due to cost_delay Bertrand Drouvot   D H        
50/4314 Unlinking Parallel Hash Join inner batch files sooner Thomas Munro   D H        

Needs review

50/5184 [PROPOSAL] : Disallow use of empty column name in (column_name '') in ALTER or C... Nishant Sharma   D H        
50/3478 AcquireExecutorLocks() and run-time pruning Amit Langote   D H        
50/4909 Add a attopt to disable MCV when estimating for Var = Const Andy Fan   D H        
50/5266 Add column name to error description Marcos Pegoraro, Jian He   D H        
50/5229 Add ExprState hashing for GROUP BY and hashed SubPlans David Rowley   D H        
50/4913 Add extension_destdir GUC Christoph Berg, David Wheeler   D H        
50/5230 Add IGNORE NULLS to Window functions Oliver Ford   D H        
50/4355 Add last_commit_lsn to pg_stat_database James Coleman   D H        
50/4907 Add local address to log_line_prefix Greg Sabino Mullane   D H        
50/4924 add multiple client certificate selection feature Cary Huang   D H        
50/5360 Add NetBSD and OpenBSD OSes to Postgres CI Nazir Bilal Yavuz   D H          
50/4736 Add new protocol message to change GUCs to be able to change protocol extension ... Jelte Fennema-Nio    D H        
50/5238 Add parallel columns for seq scan and index scan on pg_stat_all_tables and _inde... Guillaume Lelarge   D H        
50/5260 Add parameter in jsonb_strip_nulls(jsonb, bool) to strip nulls from arrays Florents Tselai   D H        
50/5033 Add pg_ownerships and pg_privileges system views Joel Jacobson   D H        
50/5331 Add reject_limit option to file_fdw Atsushi Torikoshi   D H        
50/5221 Add roman support for to_number function Hunaid Sohail   D H           
50/3659 Add SPLIT PARTITION/MERGE PARTITIONS commands Dmitry Koval   D H        
50/5356 Add support for database service to psql prompt Michael Banck   D H        
50/5110 Add XMLCast (SQL/XML X025) Jim Jones   D H        
50/5279 Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) Jim Jones   D H        
50/4764 Adding comments to help understand psql hidden queries David Christensen, Greg Sabino Mullane   D H
50/5347 Additional function inlining for slow_deform_heap_tuple David Rowley   D H        
50/5176 Allow casting between bytea and integer types Aleksander Alekseev   D H        
50/5249 Allow CI to only run the compiler warnings task Bertrand Drouvot    D H        
50/5353 Allow default \watch interval in psql to be configured Daniel Gustafsson   D H        
50/5246 Allow SQL functions use CachedPlan machinery Alexander Pyhalov    D H        
50/3705 ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables Justin Pryzby   D H        
50/4929 apply_scanjoin_target_to_paths and partitionwise join Ashutosh Bapat    D H        
50/5129 Asynchronous MergeAppend Execution Alexander Pyhalov   D H        
50/4942 Avoid orphaned objects dependencies, take 3 Bertrand Drouvot   D H        
50/4319 Avoid unnecessary PlaceHolderVars for simple Vars Richard Guo    D H        
50/3772 BCP 47 locale names for Windows Thomas Munro   D H        
50/4874 BitmapHeapScan table AM violation removal (and use streaming read API) Melanie Plageman    D H        
50/5152 Casts from jsonb to other types should cope with json null Tom Lane   D H        
50/4763 Change prefetch and read strategies to use range in pg_prewarm Cédric Villemain   D H        
50/5310 Clarify old WAL files cannot be removed until they are summarized Fujii Masao   D H        
50/5146 Clarify the behavior of AT TIME ZONE Aleksander Alekseev   D H        
50/4412 Client authentication via OAuth 2.0 Jacob Champion   D H        
50/5301 Collation and ctype method tables and extension hooks Jeff Davis   D H        
50/5231 Consider the number of columns in the sort cost model Andrei Lepikhov    D H        
50/4918 Convert internals documentation to Markdown Daniel Gustafsson   D H        
50/4992 Convert sepgsql tests to TAP Peter Eisentraut   D H        
50/5346 Count and log pages set all frozen by vacuum Melanie Plageman    D H        
50/4620 CRC32C Parallel Computation Optimization on ARM xiang gao   D H        
50/4886 CREATE DATABASE ... STRATEGY=FILE_CLONE Thomas Munro, Nazir Bilal Yavuz   D H        
50/4876 CREATE DATABASE ... STRICT_UNICODE Jeff Davis   D H
50/5004 CREATE INDEX CONCURRENTLY for partitioned tables Ilya Gladyshev    D H        
50/5099 CREATE OR REPLACE MATERIALIZED VIEW Erik Wienhold    D H        
50/5190 CREATE SUBSCRIPTION - add missing test case Peter Smith   D H        
50/4529 CREATE SUBSCRIPTION ... SERVER Jeff Davis   D H        
50/4912 CSN snapshots in hot standby Heikki Linnakangas    D H        
50/4766 data loss bug in initial sync of logical replication Tomas Vondra   D H        
50/5284 database-specific role memberships Denis Laxalde, Kenaniah Cerny    D H        
50/4761 date_trunc function in interval version Przemysław Sztoch   D H        
50/1608 declarative session variables, LET command Pavel Stehule   D H        
50/5295 deprecate md5 passwords Nathan Bossart   D H        
50/5021 Detection and resolution of logical replication conflict Hou Zhijie, shveta malik, Nisha Moond    D H        
50/5151 DirtyScanshot index scan skips concurrently updated tuples Michail Nikolaev    D H        
50/5088 Doc: Improve hostssl related descriptions and option presentation David Johnston   D H
50/5156 doc: Meson is not experimental on Windows Aleksander Alekseev   D H        
50/5087 Doc: Move and modify standalone hot backups section David Johnston   D H        
50/5308 doc: virtual envs with Pl/Python Florents Tselai   D H        
50/5333 Document how to run only specific regress tests Paul Jungwirth   D H        
50/5086 Document NULL Concepts and Behaviors David Johnston   D H        
50/4881 Eager aggregation, take 3 Richard Guo    D H        
50/4939 ECPG cleanup and fix for clang compile-time problem Tom Lane   D H        
50/5282 Enhance file_fdw to report processed and skipped tuples in COPY progress Fujii Masao   D H        
50/4980 Expand applicability of aggregate's sortop optimization Matthias van de Meent    D H        
50/5189 Expose the acquired_by parameter to the pg_replication_origin_session_setup func... Doruk Yılmaz   D H        
50/4945 Extend ALTER DEFAULT PRIVILEGES for large objects Yugo Nagata   D H        
50/5018 Extension security improvement: Add support for extensions with an owned schema Jelte Fennema-Nio   D H        
50/4476 Extract numeric field in JSONB more effectively Andy Fan   D H        
50/5303 Fix for consume_xids advancing XIDs incorrectly Yushi Ogiwara   D H        
50/5349 Fix for Extra Parenthesis in pgbench progress message Yushi Ogiwara   D H        
50/5268 Fix incorrect Assert in gistFindCorrectParent()   D H        
50/5242 Fix RelationTruncate() corruption Robert Haas, Thomas Munro    D H        
50/5199 Fix standby may crash when switching-over in certain special cases pixian shi   D H        
50/3256 functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) Justin Pryzby    D H        
50/5098 gamma() and lgamma() functions Dean Rasheed   D H        
50/5029 Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state ChangAo Chen   D H        
50/4460 Implement row pattern recognition feature Tatsuo Ishii    D H        
50/5354 Improve code coverage of network address functions Aleksander Alekseev   D H        
50/5336 Improve error messages for database object stats manipulation functions during r... Fujii Masao   D H        
50/5063 Improve EXPLAIN output for multicolumn B-Tree Index Masahiro Ikeda   D H        
50/5269 Improve statistics estimation considering GROUP-BY as a 'uniqueiser' Andrei Lepikhov   D H        
50/5100 Improved crc32c performance with AVX-512 algorithm. Paul Amonson   D H        
50/5167 Improvements for pg_wal_replay_wait() Alexander Korotkov   D H        
50/5339 Inconsistent output handling in 002_pg_upgrade.pl test logs Joel Jacobson   D H        
50/5070 Incorrect error message for cancellation triggered by statement_timeout & flaky ... Jelte Fennema-Nio    D H        
50/5343 Increase 2Gb limit of memory GUC variables in 64-bit Windows Vladlen Popolitov   D H        
50/5093 Incremental Sort Cost Estimation Instability Andrei Lepikhov   D H        
50/5195 Index AM API cleanup Mark Dilger    D H        
50/4351 Index Prefetching Tomas Vondra   D H        
50/5091 inplace update: send nontransactional invalidations Noah Misch   D H        
50/5304 introduce INT64_HEX_FORMAT/UINT64_HEX_FORMAT Nathan Bossart   D H        
50/4777 Introduce new multi insert Table AM and improve performance of various SQL comma... Bharath Rupireddy   D H        
50/5274 Introduce the ability to enable/disable indexes using ALTER INDEX Shayon Mukherjee   D H        
50/4770 Introduce XID age and inactive timeout based replication slot invalidation Bharath Rupireddy   D H        
50/5160 Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Michail Nikolaev    D H        
50/5236 JIT: The nullness of casetest.value can be determined at the JIT compile time. Xing Guo   D H        
50/5270 jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part Florents Tselai    D H        
50/5251 libpq: Fix processing of SSL records >8kB on async API   D H        
50/5299 Limiting overshoot in nbtree SAOP parallel index scans Matthias van de Meent   D H        
50/4291 Logging parallel worker draught Benoit Lobréau   D H        
50/5330 Logging plan of the currently running query Atsushi Torikoshi   D H        
50/4681 Make COPY format extendable: Extract COPY TO format implementations Kouhei Sutou   D H        
50/5205 Make MultiXactOffset 64-bit type Maxim Orlov   D H        
50/5256 Make pg_stat_io view count IOs as bytes instead of blocks Nazir Bilal Yavuz   D H        
50/5097 Make tuple deformation faster David Rowley   D H        
50/5348 Making error message more user-friendly with spaces in a URI Yushi Ogiwara    D H        
50/5114 MergeJoin beats HashJoin in the case of multiple hash clauses Andrei Lepikhov   D H        
50/5315 More CppAsString2() in psql's describe.c Michael Paquier   D H        
50/5289 Move clause_sides_match_join() into pathnode.h James Hunter   D H        
50/5081 nbtree skip scan Peter Geoghegan   D H        
50/4638 nbtree: downlink right separator/HIKEY optimization Matthias van de Meent   D H        
50/5300 New "single" COPY format Joel Jacobson   D H        
50/4688 New [relation] options engine Nikolay Shaplov   D H        
50/5046 New GUC autovacuum_max_threshold   D H        
50/5044 new plpgsql.extra_errors check - strict_expr_check Pavel Stehule   D H        
50/5285 NOT ENFORCED constraint feature Amul Sul   D H        
50/4817 on_error table, saving error info to a table jian he   D H        
50/5026 Parallel CREATE INDEX for GiST indexes Tomas Vondra   D H        
50/5326 Parallel heap vacuum Masahiko Sawada   D H        
50/4975 pg_parse_json: don't leak token copies on failure Jacob Champion   D H        
50/4974 pg_stat_activity: make slow/hanging authentication more visible Jacob Champion   D H        
50/2837 pg_stat_statements and "IN" conditions Dmitry Dolgov   D H        
50/5105 Prevent incorrect entries in pg_stat_activity. Fujii Masao    D H        
50/5332 Provide means to disable legacy crypt() and gen_salt() functions in pgcrypto Joe Conway   D H
50/4814 psql meta-command conninfo+ Maiquel Grassi, Hunaid Sohail   D H        
50/5102 psql: Add leakproof field to \dAo+ meta-command results Yugo Nagata   D H        
50/4738 psql: Rethinking of \du command Pavel Luzanov   D H        
50/4908 Recheck foreign key if a referenced collation was nondeterministic Paul Jungwirth   D H        
50/5148 Recovery of .partial WAL segments Stefan Fercot   D H        
50/4964 Reduce the log spam by excluding certain SQLSTATEs Laurenz Albe   D H        
50/4564 Reducing memory consumed by RestrictInfo list translations in partitionwise join... Ashutosh Bapat   D H        
50/3701 Reducing planning time when tables have many partitions Yuya Watari   D H        
50/5288 Refactor bytea_sortsupport() Aleksander Alekseev   D H        
50/5250 Refactor SLRU to always use long file names Aleksander Alekseev   D H        
50/5122 REINDEX not updating partition progress Ilya Gladyshev   D H        
50/5291 Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c Tender Wang   D H        
50/5031 Remove dependence on integer wrapping Joseph Koshakow    D H        
50/5043 Remove self join on a unique column Andrei Lepikhov   D H        
50/5350 Remove useless casts to (void *) Peter Eisentraut   D H        
50/5263 removes attndims and typndims entirely Jian He   D H        
50/4787 Reordering DISTINCT keys to match input path's pathkeys Richard Guo   D H        
50/4450 Replace a large number of OR clauses with ANY expression Andrei Lepikhov, Alena Rybakina   D H        
50/5283 Replace IN VALUES with ANY in WHERE clauses during optimization Andrei Lepikhov, Alena Rybakina    D H        
50/4997 Return pg_control from pg_backup_stop(). David Steele    D H        
50/4723 RETURNING OLD/NEW values Dean Rasheed   D H        
50/4971 Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements Michail Nikolaev   D H        
50/5118 SendProcSignal(), SetLatch() → SendInterrupt() Heikki Linnakangas, Thomas Munro   D H        
50/4554 Separate memory contexts for relcache and catcache Melih Mutlu   D H        
50/4677 Sequence Access Methods, round two Michael Paquier   D H        
50/4984 Serverside SNI for SSL connections Daniel Gustafsson    D H        
50/5306 Set AUTOCOMMIT to on in script output by pg_dump Shinya Kato   D H        
50/3998 SetLatches() Thomas Munro   D H        
50/4759 shared detoast datum Andy Fan    D H        
50/5358 Shave a few cycles off our ilog10 implementation David Fetter   D H        
50/4950 Show WAL stats on pg_stat_io Nazir Bilal Yavuz   D H        
50/5359 Showing applied extended statistics in explain Part2 Tatsuro Yamada   D H        
50/5183 Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP sc... Peter Geoghegan   D H        
50/5313 simplify regular expression locale global variables Peter Eisentraut   D H        
50/5338 Skip logical decoding of already-aborted transactions. Masahiko Sawada   D H        
50/4904 SQL Property Graph Queries (SQL/PGQ) Peter Eisentraut, Ashutosh Bapat   D H        
50/4308 SQL:2011 application time Paul Jungwirth   D H        
50/5214 SQL:2023 JSON simplified accessor support Alexandra Wang   D H        
50/4538 Statistics Import and Export Corey Huinker    D H        
50/5296 Streaming Replication vs Logical Paul Jungwirth   D H        
50/5089 Streaming Vacuum Thomas Munro, Melanie Plageman   D H        
50/4735 Support a wildcard in backtrace_functions Jelte Fennema-Nio   D H        
50/5323 Support enabling checksums online Magnus Hagander, Daniel Gustafsson    D H        
50/4965 Support LIKE with nondeterministic collations Peter Eisentraut   D H        
50/5209 Support POSITION with nondeterministic collations Peter Eisentraut   D H        
50/3663 Switching XLog source from archive to streaming when primary available Bharath Rupireddy, SATYANARAYANA NARLAPURAM   D H        
50/5111 Synchronization of sequences to subscriber vigneshwaran C   D H        
50/5309 Syncrep and improving latency due to WAL throttling Tomas Vondra, Jakub Wartak   D H
50/5318 System views for versions reporting Dmitry Dolgov    D H        
50/4690 Teach predtest about IS [NOT] <boolean> proofs James Coleman   D H        
50/5141 Track collation and ctype versions separately Jeff Davis   D H        
50/5320 Trigger more frequent autovacuums for insert-heavy tables Melanie Plageman   D H        
50/5252 Trim the heap free memory Shawn Wang    D H        
50/5272 Truncate logs by max_log_size Kirill Gavrilov    D H        
50/5317 type cache cleanup improvements Fedor Sigaev, Alexander Korotkov, Andrei Lepikhov    D H        
50/5341 Use "protocol options" name instead of "protocol extensions" everywhere Jelte Fennema-Nio   D H        
50/5321 use a non-locking initial test in TAS_SPIN on AArch64 Nathan Bossart   D H        
50/5316 Use more CppAsString2() in pg_amcheck.c Michael Paquier   D H        
50/5162 Use read streams in autoprewarm Nazir Bilal Yavuz   D H        
50/5327 Use read_stream in index vacuum Andrey Borodin   D H        
50/4952 Use WALReadFromBuffers in more places Bharath Rupireddy   D H        
50/4941 Use XLOG_CONTROL_FILE macro everywhere Anton Melnikov   D H        
50/5340 Useless field ispartitioned in CreateStmtContext hugo zhang   D H        
50/4388 UUID v7 Andrey Borodin   D H        
50/5117 VACUUM FULL / CLUSTER CONCURRENTLY Antonin Houska    D H        
50/5012 Vacuum statistics Andrei Lepikhov, Andrei Zubkov, Alena Rybakina    D H        
50/5225 Vectored IO in XLogWrite() Melih Mutlu   D H        
50/4972 Virtual generated columns Peter Eisentraut   D H        
50/3482 warn if GUC set to an invalid shared library Justin Pryzby   D H        
50/5060 windows compilation fails when gssapi & openssl are enabled Imran Zaheer   D H        

Waiting on Author

50/4720 "unexpected duplicate for tablespace" problem in logical replication Shenhao Wang    D H        
50/5355 A patch to provide a view of memory context statistics for all PostgreSQL proces... Rahila Syed    D H        
50/5294 Add “FOR UPDATE NOWAIT” lock details to the log. Yuki Seino   D H        
50/5131 add log_transaction GUC setting Sergey Solovev    D H        
50/5325 Add sortsupport for range types and btree_gist Bernd Helmle, Christoph Heiss, jian he    D H        
50/4709 Add the page header to each SLRU page. Rishu Bagga, Yong Li   D H        
50/5227 AIO Andres Freund   D H        
50/5068 Allow logical decoding to output generated columns Peter Smith, Shubham Khanna, Shlok Kyal   D H        
50/5128 Allow partition-wise join when whole row var is needed Ashutosh Bapat, Alexander Pyhalov    D H        
50/3733 Amcheck verification of GiST and GIN Heikki Linnakangas, Andrey Borodin, Grigory Kryachko   D H        
50/5174 Call rm_redo in a temporary memory context Heikki Linnakangas    D H        
50/5319 Changing shared_buffers without restart Dmitry Dolgov   D H
50/3709 CI and test improvements Justin Pryzby   D H        
50/5342 Consider pipeline implicit transaction as a transaction block Anthonin Bonnefoy   D H        
50/4810 COPY ON_ERROR 'NULL' jian he    D H        
50/4716 COPY TO json Joe Conway   D H        
50/5164 Fix a few issues in collation cache Jeff Davis   D H        
50/5276 Fix race between WAL flush and InstallXLogFileSegment() Thomas Munro   D H        
50/5124 Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() Thomas Munro   D H        
50/5277 general purpose array_sort Zhao Junwang   D H        
50/3461 In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ... Kyotaro Horiguchi   D H        
50/4337 Incremental View Maintenance (IVM), take 2 Yugo Nagata    D H        
50/4871 KNN-btree Nikita Glukhov, Anton Melnikov    D H        
50/5166 Make ECPG locale usage thread-safe Thomas Munro   D H        
50/3672 nbtree performance improvements through specialization on key shape Matthias van de Meent   D H
50/4635 nbtree: implement dynamic prefix truncation Matthias van de Meent   D H        
50/4748 Network failure may prevent promotion Kyotaro Horiguchi   D H
50/5061 New function rand_array() to contrib/tablefunc Andy Fan   D H        
50/5357 New predefined role pg_manage_extensions Michael Banck    D H        
50/4966 Parallel CREATE INDEX for GIN indexes Tomas Vondra    D H        
50/5232 per backend I/O statistics Bertrand Drouvot   D H        
50/4573 pg_ctl start may return 0 even if the postmaster has been already started on Win... Kyotaro Horiguchi   D H        
50/5206 pg_upgrade: Support for upgrading to checksums enabled Peter Eisentraut   D H        
50/3986 Post-special Page Storage TDE support (aka Reserved Page Size) David Christensen   D H
50/5208 prefetching for nestloop / indexscan Tomas Vondra    D H        
50/5154 psql client does not handle WSAEWOULDBLOCK on Windows   D H        
50/5007 relfilenode statistics Bertrand Drouvot    D H        
50/4458 Retiring is_pushed_down Richard Guo   D H        
50/4285 Revise get_cheapest_parallel_safe_total_inner Richard Guo   D H        
50/5036 Sort functions with specialized comparators Andrey Borodin, Stepan Neretin   D H        
50/5334 Support regular expressions with nondeterministic collations Peter Eisentraut    D H        
50/4956 Test to dump and restore objects left behind by regression Ashutosh Bapat   D H        
50/5170 Thread-safe nl_langinfo(), localeconv(), check_locale() Thomas Munro   D H        
50/4938 Use <stdint.h> for int64_t and other exact-width integer types Thomas Munro   D H        
50/5196 Use function smgrclose() to replace the loop Steven Niu    D H        
50/4986 WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts Matthias van de Meent   D H