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, collates test results from Cirrus CI, and posts the results to the Commitfest system. Key: or = new/recently changed, or = stable, needs rebase but previous build was successful, = working.

News: This page is no longer the best place to see Commitfest CI results. Please check the Commitfest system itself.

News: The two empty circles are placeholders for NetBSD and OpenBSD CI tasks (these are supported OSes that your patch will encounter in the build farm after commit). See CF item #5360 where they are enabled. Getting closer to turning them on everywhere...

Ready for Committer

52/5405 Add 'make check-tests' behavior to the meson based builds Nazir Bilal Yavuz  ✉ D H          
52/5325 Add sortsupport for range types and btree_gist Bernd Helmle, Christoph Heiss  ⚠ ✉ D H          
52/4237 Add XMLCanonicalize function Jim Jones  ⚠ ✉ D H          
52/5431 Add XMLDocument (SQL/XML X030) Jim Jones  ✉ D H          
52/5456 Add XMLNamespaces option to XMLElement Pavel Stehule, Jim Jones  ✉ D H          
52/5246 Allow SQL functions use CachedPlan machinery Alexander Pyhalov  ✉ D H          
52/5548 Document custom settings more consistently David Johnston  ⚠ ✉ D H          
52/5546 Document how commit handles aborted transactions David Johnston  ✉ D H          
52/5558 Draft for basic NUMA observability Jakub Wartak  ✉ D H          
52/5575 Elimination of the repetitive code at the SLRU bootstrap functions Evgeny Voropaev  ✉ D H          
52/5381 explain pgstatindex fragmentation Frédéric Yhuel  ✉ D H          
52/5189 Expose the acquired_by parameter to the pg_replication_origin_session_setup func... Doruk Yılmaz  ✉ D H          
52/4945 Extend ALTER DEFAULT PRIVILEGES for large objects Yugo Nagata  ⚠ ✉ D H          
52/5448 Incorrect result of bitmap heap scan. Matthias van de Meent ♲ ✉ D H          
52/5195 Index AM API cleanup Mark Dilger  ⚠ ✉ D H          
52/4291 Logging parallel worker draught Benoit Lobréau  ✉ D H          
52/5357 New predefined role pg_manage_extensions Michael Banck  ⚠ ✉ D H          
52/5409 postgres_fdw could deparse ArrayCoerceExpr Alexander Pyhalov  ✉ D H          
52/4964 Reduce the log spam by excluding certain SQLSTATEs Laurenz Albe  ✉ D H          
52/5250 Refactor SLRU to always use long file names Aleksander Alekseev ♲ ✉ D H          
52/5390 Sampling in pg_stat_statements Ilia Evdokimov  ✉ D H          
52/4718 Set log_lock_waits=on by default Laurenz Albe  ✉ D H          
52/5272 Truncate logs by max_log_size Kirill Gavrilov  ✉ D H          
52/5162 Use read streams in autoprewarm Nazir Bilal Yavuz  ✉ D H          
52/5522 Windows meson build Kohei Harikae  ✉ D H          

Needs review

52/4720 "unexpected duplicate for tablespace" problem in logical replication Shenhao Wang  ✉ D H          
52/4971 [CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting sh... Michail Nikolaev  ⚠ ✉ D H          
52/5422 [PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clau... Ravi Revathy  ✉ D H          
52/5396 Add Option to Check All Addresses For Matching target_session_attr Andrew Jackson  ✉ D H          
52/5493 Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Nazir Bilal Yavuz  ✉ D H          
52/3659 Add SPLIT PARTITION/MERGE PARTITIONS commands Dmitry Koval  ✉ D H          
52/5110 Add XMLCast (SQL/XML X025) Jim Jones  ⚠ ✉ D H          
52/5279 Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) Jim Jones  ✉ D H          
52/5500 Adding support for SSLKEYLOGFILE in the frontend Abhishek Chanda  ✉ D H          
52/5429 Adopt <inttypes.h> macros in format strings. Thomas Munro ♲ ✉ D H          
52/5227 AIO Andres Freund  ✉ D H          
52/5249 Allow CI to only run the compiler warnings task Bertrand Drouvot  ✉ D H          
52/5612 Avoid infinite loop in checkpointer Maxim Orlov  ✉ D H          
52/4942 Avoid orphaned objects dependencies, take 3 Bertrand Drouvot  ⚠ ✉ D H          
52/5617 Beautify read stream "per buffer data" APIs Thomas Munro  ⚠ ✉ D H          
52/5438 bt_index_parent_check false alarm for indexes created concurrently Michail Nikolaev  ⚠ ✉ D H          
52/5454 Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment Matthias van de Meent  ✉ D H          
52/5570 Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup Jelte Fennema-Nio ♲ ✉ D H          
52/5567 Change log level for notifying hot standby is waiting non-overflowed snapshot Atsushi Torikoshi  ✉ D H          
52/5509 Coccinelle for PostgreSQL development Mats Kindahl  ⚠ ✉ D H          
52/5301 Collation and ctype method tables and extension hooks Jeff Davis  ✉ D H          
52/5533 COPY materialized view TO Jian He  ✉ D H          
52/4886 CREATE DATABASE ... STRATEGY=FILE_CLONE Thomas Munro, Nazir Bilal Yavuz  ✉ D H          
52/5099 CREATE OR REPLACE MATERIALIZED VIEW Erik Wienhold  ✉ D H          
52/5535 Cross-type index comparison support in contrib/btree_gin Tom Lane  ✉ D H          
52/4766 data loss bug in initial sync of logical replication Tomas Vondra  ✉ D H          
52/1608 declarative session variables, LET command Pavel Stehule  ✉ D H          
52/5151 DirtyScanshot index scan skips concurrently updated tuples Michail Nikolaev  ✉ D H          
52/5086 Document NULL Concepts and Behaviors David Johnston  ⚠ ✉ D H          
52/4881 Eager aggregation, take 3 Richard Guo  ⚠ ✉ D H          
52/5450 Eliminating SPI / SQL from some RI trigger functions Amit Langote ♲ ✉ D H          
52/5355 Enhance memory context statistics reporting for all PostgreSQL processes. Rahila Syed  ✉ D H          
52/4980 Expand applicability of aggregate's sortop optimization Matthias van de Meent  ✉ D H          
52/5556 Expanding HOT updates for expression and partial indexes Greg Burd  ⚠ ✉ D H          
52/5018 Extension security improvement: Add support for extensions with an owned schema Jelte Fennema-Nio  ✉ D H          
52/5568 Fix 035_standby_logical_decoding.pl race conditions Bertrand Drouvot ♲ ✉ D H          
52/5542 Fix buffer pinning logic in [SP-]Gist Peter Geoghegan, Michail Nikolaev, Matthias van de Meent ♲ ⚠ ✉ D H          
52/5379 Fix bug with accessing to temporary tables of other sessions Daniil Davydov  ✉ D H          
52/5610 Fix MINGW build on ARM64 on Windows Lars Kanis  ✉ D H          
52/5199 Fix standby may crash when switching-over in certain special cases pixian shi  ✉ D H          
52/5470 Function scan FDW pushdown Alexander Pyhalov, Gleb Kashkin  ⚠ ✉ D H          
52/5277 general purpose array_sort Zhao Junwang  ✉ D H          
52/5511 Get rid of WALBufMappingLock Alexander Korotkov, Yura Sokolov  ✉ D H          
52/5029 Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state ChangAo Chen  ✉ D H          
52/4460 Implement row pattern recognition feature Tatsuo Ishii  ⚠ ✉ D H          
52/5545 Improve CRC32C performance on SSE4.2 Raghuveer Devulapalli  ✉ D H          
52/5620 Improve monitoring of shared memory allocations Rahila Syed  ⚠ ✉ D H          
52/5519 Improve verification of recovery_target_timeline GUC. David Steele  ✉ D H          
52/5588 Improvement of var_eq_non_const() Fedor Sigaev  ✉ D H          
52/5070 Incorrect error message for cancellation triggered by statement_timeout & flaky ... Jelte Fennema-Nio  ⚠ ✉ D H          
52/5093 Incremental Sort Cost Estimation Instability Andrei Lepikhov  ⚠ ✉ D H          
52/5091 inplace update: send nontransactional invalidations Noah Misch  ⚠ ✉ D H          
52/5274 Introduce the ability to enable/disable indexes using ALTER INDEX Shayon Mukherjee  ✉ D H          
52/5577 Invalid cached plan in check_foreign_key; cascade update in check_primary_key; r... Dmitrii Bondar  ✉ D H          
52/5160 Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Michail Nikolaev  ⚠ ✉ D H          
52/5361 Let an Append to consider a tuple fraction when choosing fractional subpaths Andrei Lepikhov, Nikita Malakhov ♲ ⚠ ✉ D H          
52/5251 libpq: Fix processing of SSL records >8kB on async API Lars Kanis  ✉ D H          
52/5447 log_min_messages per backend type Euler Taveira  ⚠ ✉ D H          
52/5330 Logging plan of the currently running query Atsushi Torikoshi  ✉ D H          
52/5601 Logical replication timeout  ✉ D H          
52/5205 Make MultiXactOffset 64-bit type Maxim Orlov ♲ ✉ D H          
52/5623 Make numeric type accessible to third-party code. Ed Behn  ⚠ ✉ D H          
52/4870 Make query cancellation keys longer Heikki Linnakangas, Jelte Fennema-Nio  ⚠ ✉ D H          
52/5613 making EXPLAIN extensible Robert Haas  ✉ D H          
52/5114 MergeJoin beats HashJoin in the case of multiple hash clauses Andrei Lepikhov ♲ ✉ D H          
52/5481 Modern SHA2- based password hashes for pgcrypto Bernd Helmle  ✉ D H          
52/5081 nbtree skip scan Peter Geoghegan  ✉ D H          
52/4748 Network failure may prevent promotion Kyotaro Horiguchi  ✉ D H          
52/4688 New [relation] options engine Nikolay Shaplov ♲ ✉ D H          
52/5044 new plpgsql.extra_errors check - strict_expr_check Pavel Stehule  ⚠ ✉ D H          
52/5495 Non-text mode for pg_dumpall Mahendra Singh Thalor  ✉ D H          
52/5285 NOT ENFORCED constraint feature Amul Sul  ✉ D H          
52/5608 Orphaned users in PG16 and above can only be managed by Superusers Ashutosh Sharma  ✉ D H          
52/5326 Parallel heap vacuum Masahiko Sawada  ✉ D H          
52/5512 pg_stat_statements: improve loading and saving routines for the dump file. Mikhail Litsarev  ⚠ ✉ D H          
52/5206 pg_upgrade: Support for upgrading to checksums enabled Peter Eisentraut ♲ ✉ D H          
52/5473 Proposal: Progressive explain Rafael Castro  ✉ D H             
52/5594 psql \dh: List High-Level (Root) Tables and Indexes Sadeq Dousti  ✉ D H          
52/4564 Reducing memory consumed by RestrictInfo list translations in partitionwise join... Ashutosh Bapat  ⚠ ✉ D H          
52/5149 Remove duplicated smgrclose call Steven Niu  ✉ D H          
52/5606 Remove extra Sort node above a btree-compatible Index Scan Alexandra Wang  D H
52/5283 Replace IN VALUES with ANY in WHERE clauses during optimization Andrei Lepikhov, Alena Rybakina  ⚠ ✉ D H          
52/4997 Return pg_control from pg_backup_stop(). David Steele  ✉ D H          
52/5607 SIMD optimization for list_sort Rakshit R  ⚠ ✉ D H          
52/5573 sinvaladt.c: remove msgnumLock Yura Sokolov  ✉ D H          
52/5467 speedup COPY TO for partitioned table Jian He  ✉ D H          
52/5611 SQL function which allows to distinguish a server being in point in time recover... Mikhail Litsarev  ✉ D H          
52/5478 SQL/JSON json_table PLAN clause Fedor Sigaev, Alexander Korotkov, Andrew Dunstan, Amit Langote, Nikita Glukhov, Oleg Bartunov, Anton Melnikov, Nikita Malakhov  ⚠ ✉ D H          
52/5553 starjoin join order planning Tomas Vondra  ⚠ ✉ D H          
52/4538 Statistics Import and Export Corey Huinker  ✉ D H          
52/4735 Support a wildcard in backtrace_functions Jelte Fennema-Nio  ⚠ ✉ D H          
52/5554 Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Rushabh Lathia ♲ ✉ D H          
52/5538 SVE enablement for hex-encode and hex-decode Chiranmoy Bhattacharya, Susmitha Devanga  ⚠ ✉ D H          
52/5318 System views for versions reporting Dmitry Dolgov  ⚠ ✉ D H          
52/4690 Teach predtest about IS [NOT] <boolean> proofs James Coleman  ✉ D H          
52/4956 Test to dump and restore objects left behind by regression Ashutosh Bapat  ⚠ ✉ D H          
52/5596 The walsender does not update its IO statistics until it exits Bertrand Drouvot  ✉ D H          
52/5595 Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem o... James Hunter ♲ ⚠ ✉ D H          
52/5472 Unicode 16 update Peter Eisentraut, Jeff Davis  ✉ D H          
52/4941 Use XLOG_CONTROL_FILE macro everywhere Anton Melnikov  ✉ D H          
52/5117 VACUUM FULL / CLUSTER CONCURRENTLY Antonin Houska  ⚠ ✉ D H          
52/5012 Vacuum statistics Andrei Lepikhov, Andrei Zubkov, Alena Rybakina  ⚠ ✉ D H          
52/5597 Warn, and disallow, clear text passwords via SQL Greg Sabino Mullane  ✉ D H          

Waiting on Author

52/5514 Add a function to get the version of installed extension Yugo Nagata  ✉ D H          
52/5576 Add function - pg_accept_connections_start_time() Robins Tharakan  ✉ D H          
52/5524 add function argument name to substring and substr Jian He  ✉ D H          
52/4907 Add local address to log_line_prefix Greg Sabino Mullane  ✉ D H          
52/3405 Add pg_stat_session Rafia Sabih, Sergey Dudoladov ♲ ✉ D H          
52/5602 Add support for EXTRA_REGRESS_OPTS for meson test Andreas Karlsson  ✉ D H          
52/4764 Adding comments to help understand psql hidden queries David Christensen, Greg Sabino Mullane  ✉ D H          
52/5382 Adding compression of temporary files Filip Januš ♲ ✉ D H        
52/5128 Allow partition-wise join when whole row var is needed Ashutosh Bapat, Alexander Pyhalov ♲ ⚠ ✉ D H        
52/5505 Allow to use an index for ILIKE in more cases Yugo Nagata ♲ ⚠ ✉ D H        
52/5129 Asynchronous MergeAppend Execution Alexander Pyhalov ♲ ⚠ ✉ D H        
52/5319 Changing shared_buffers without restart Dmitry Dolgov ♲ ⚠ ✉ D H          
52/5621 Compress big WAL records Andrey Borodin ♲ ✉ D H
52/4810 COPY ON_ERROR 'NULL' jian he ♲ ✉ D H          
52/5615 Corrupted FSM page is not saved after zeroing. Anton Melnikov  ✉ D H          
52/4529 CREATE SUBSCRIPTION ... SERVER Jeff Davis  ✉ D H          
52/5483 Don't dirty pages while they are getting flushed out Andres Freund ♲ ⚠ ✉ D H        
52/5609 Enable fine-grained control over what gets logged on connection attempt (reduces... Sergey Dudoladov ♲ ⚠ ✉ D H          
52/5479 Enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada ♲ ⚠ ✉ D H          
52/5262 ensure we have a snapshot when dropping an index concurrently Nathan Bossart  ⚠ ✉ D H          
52/5487 Exists pull-up application with JoinExpr Alena Rybakina  ⚠ ✉ D H          
52/5525 explain plans for foreign servers dinesh salve ♲ ⚠ ✉ D H          
52/5517 Extended Statistics set/restore/clear functions Corey Huinker  ✉ D H          
52/5616 Extensible storage manager API Andreas Karlsson, Anastasia Lubennikova, Matthias van de Meent, Tristan Partin ♲ ⚠ ✉ D H          
52/5365 Fix creation of empty .log files during log rotation Arseny Kositsin  ⚠ ✉ D H          
52/5303 Fix for consume_xids advancing XIDs incorrectly Yushi Ogiwara  ⚠ ✉ D H          
52/5268 Fix incorrect Assert in gistFindCorrectParent()  ⚠ ✉ D H          
52/5276 Fix race between WAL flush and InstallXLogFileSegment() Thomas Munro  ✉ D H          
52/5124 Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() Thomas Munro ♲ ✉ D H
52/4884 Fix rare recovery shutdown hang Thomas Munro ♲ ✉ D H        
52/5583 Improve ACL checks in pg_prewarm for indexes Ayush Vatsa  ✉ D H          
52/5100 Improved crc32c performance with AVX-512 algorithm. Paul Amonson, Raghuveer Devulapalli ♲ ✉ D H        
52/4337 Incremental View Maintenance (IVM), take 2 Yugo Nagata ♲ ✉ D H
52/4351 Index Prefetching Tomas Vondra ♲ ✉ D H        
52/5413 INSERT ... ON CONFLICT DO SELECT [FOR ...] Andreas Karlsson, Marko Tiikkaja  ✉ D H          
52/4871 KNN-btree Nikita Glukhov, Anton Melnikov ♲ ✉ D H
52/5299 Limiting overshoot in nbtree SAOP parallel index scans Matthias van de Meent ♲ ✉ D H        
52/5386 Log LSN before table is dropped Andrey Borodin, Nikolay Samokhvalov, Kirk Wolak  ⚠ ✉ D H          
52/4681 Make COPY format extendable: Extract COPY TO format implementations Kouhei Sutou ♲ ✉ D H          
52/5166 Make ECPG locale usage thread-safe Thomas Munro ♲ ✉ D H          
52/5614 Metadata and record block access stats for indexes Mircea Cadariu ♲ ⚠ ✉ D H          
52/4966 Parallel CREATE INDEX for GIN indexes Tomas Vondra  ⚠ ✉ D H          
52/4573 pg_ctl start may return 0 even if the postmaster has been already started on Win... Kyotaro Horiguchi ♲ ✉ D H        
52/5105 Prevent incorrect entries in pg_stat_activity. Fujii Masao  ⚠ ✉ D H          
52/5154 psql client does not handle WSAEWOULDBLOCK on Windows  ✉ D H          
52/5619 Read stream scalability improvements and AIO-compatibility Thomas Munro ♲ ⚠ ✉ D H          
52/5622 Reduce timing overhead of EXPLAIN ANALYZE using rdtsc Andres Freund, Lukas Fittl, David Geier ♲ ⚠ ✉ D H          
52/3701 Reducing planning time when tables have many partitions Yuya Watari  ✉ D H          
52/5007 relfilenode statistics Bertrand Drouvot ♲ ⚠ ✉ D H        
52/4458 Retiring is_pushed_down Richard Guo ♲ ✉ D H
52/5397 revamp row-security tracking Nathan Bossart  ⚠ ✉ D H          
52/4285 Revise get_cheapest_parallel_safe_total_inner Richard Guo  ✉ D H          
52/4984 Serverside SNI for SSL connections Daniel Gustafsson  ⚠ ✉ D H          
52/5359 Showing applied extended statistics in explain Part2 Tatsuro Yamada ♲ ✉ D H          
52/4904 SQL Property Graph Queries (SQL/PGQ) Peter Eisentraut, Ashutosh Bapat ♲ ⚠ ✉ D H          
52/5323 Support enabling checksums online Magnus Hagander, Daniel Gustafsson ♲ ⚠ ✉ D H          
52/5170 Thread-safe nl_langinfo(), localeconv(), check_locale() Thomas Munro  ✉ D H          
52/5550 Waiting for LSN replay with WAIT FOR command Alexander Korotkov ♲ ✉ D H          
52/4986 WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts Matthias van de Meent  ✉ D H