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

53/5646 Accessing an invalid pointer in BufferManagerRelation structure Daniil Davydov  ✉ D H          
53/5405 Add 'make check-tests' behavior to the meson based builds Nazir Bilal Yavuz  ⚠ ✉ D H          
53/5230 Add IGNORE NULLS to Window functions Oliver Ford  ✉ D H          
53/4237 Add XMLCanonicalize function Jim Jones  ✉ D H               
53/5431 Add XMLDocument (SQL/XML X030) Jim Jones  ✉ D H          
53/5456 Add XMLNamespaces option to XMLElement Pavel Stehule, Jim Jones  ⚠ ✉ D H          
53/5546 Document how commit handles aborted transactions David Johnston  ⚠ ✉ D H          
53/5575 Elimination of the repetitive code at the SLRU bootstrap functions Evgeny Voropaev  ⚠ ✉ D H          
53/5381 explain pgstatindex fragmentation Frédéric Yhuel  ✉ D H          
53/4959 Fix BackgroundPsql to report error on query timeout rather than calling die Daniel Gustafsson  ⚠ ✉ D H          
53/5274 Introduce the ability to enable/disable indexes using ALTER INDEX Shayon Mukherjee  ⚠ ✉ D H          
53/5752 make VALIDATE domain constraint lock on related relations as ShareUpdateExclusiv... Jian He  ✉ D H          
53/5638 Minor rework of ALTER TABLE SET RelOptions code Nikolay Shaplov ♲ ⚠ ✉ D H          
53/5409 postgres_fdw could deparse ArrayCoerceExpr Alexander Pyhalov  ✉ D H          
53/5250 Refactor SLRU to always use long file names Aleksander Alekseev  ✉ D H          
53/5746 regdatabase Ian Barwick  ✉ D H          
53/4718 Set log_lock_waits=on by default Laurenz Albe  ✉ D H          
53/5467 speedup COPY TO for partitioned table Jian He  ✉ D H          
53/5691 update documentation for when aborted and committed rows are tracked in pg_stat_... Sami Imseih  ✉ D H          

Needs review

53/4971 [CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting sh... Michail Nikolaev, Mihail Nikalayeu ♲ ⚠ ✉ D H          
53/5721 [SP-]GiST IOS visibility bug (was: Why doens't GiST require super-exclusive lock... Matthias van de Meent ♲ ✉ D H
53/5727 Accounting for metapages in genericcostestimate() Tom Lane  ✉ D H          
53/5674 Add "\gi file" to psql to allow COPY with variable expansion Fabien Coelho  ⚠ ✉ D H          
53/5644 Add arbitrary xid and mxid to pg_resetwal Daniil Davydov  ⚠ ✉ D H          
53/5679 Add comments about fire_triggers argument in ri_triggers.c Yugo Nagata  ✉ D H          
53/4390 add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl Cary Huang  ⚠ ✉ D H          
53/5396 Add Option to Check All Addresses For Matching target_session_attr Andrew Jackson ♲ ✉ D H          
53/5690 Add os_page_num to pg_buffercache Bertrand Drouvot  ✉ D H          
53/5694 Add pg_buffercache_mark_dirty[_all]() functions to the pg_buffercache Nazir Bilal Yavuz  ✉ D H          
53/5696 Add pg_get_injection_points() for information of injection points Michael Paquier  ✉ D H          
53/5697 Add planner expectations for Memoize in EXPLAIN Ilia Evdokimov  ⚠ ✉ D H          
53/5526 Add storage I/O tracking to EXPLAIN BUFFERS Atsushi Torikoshi  ✉ D H          
53/5110 Add XMLCast (SQL/XML X025) Jim Jones  ⚠ ✉ D H          
53/5279 Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) Jim Jones  ⚠ ✉ D H          
53/5699 Adding error messages to a few slash commands Abhishek Chanda  ✉ D H          
53/5704 adjust the place of list_copy() call to reduce the overhead of function call and... Tender Wang  ✉ D H          
53/5249 Allow CI to only run the compiler warnings task Bertrand Drouvot  ✉ D H          
53/5747 Allow parallelism for plpgsql return expression after commit 556f7b7 Dipesh Dhameliya  ✉ D H          
53/5387 Allow PGSERVICEFILE to be specified as part of the connection string Torsten Foertsch  ⚠ ✉ D H          
53/5631 Allow table AMs to define their own reloptions Julien Tachoires  ✉ D H          
53/5714 Allow to collect statistics on virtual generated columns Yugo Nagata  ⚠ ✉ D H          
53/5715 amcheck support for BRIN indexes Arseniy Mukhin  ⚠ ✉ D H          
53/5651 Available disk space per tablespace Christoph Berg  ✉ D H          
53/5723 Avoid circular header file dependency Bertrand Drouvot  ✉ D H          
53/5670 avoid double scanning in function byteain Steven Niu  ✉ D H          
53/5612 Avoid infinite loop in checkpointer Maxim Orlov  ✉ D H          
53/4942 Avoid orphaned objects dependencies, take 3 Bertrand Drouvot ♲ ⚠ ✉ D H          
53/5682 Better HINT message for "unexpected data beyond EOF" Jakub Wartak ♲ ✉ D H          
53/5438 bt_index_parent_check false alarm for indexes created concurrently Michail Nikolaev, Mihail Nikalayeu  ✉ D H          
53/5570 Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup Jelte Fennema-Nio  ✉ D H          
53/5319 Changing shared_buffers without restart Dmitry Dolgov ♲ ⚠ ✉ D H          
53/5705 Check for tuplestorestate nullness before dereferencing Alexander Kuznetsov  ✉ D H          
53/5662 Check for TupleTableSlot nullness before dereferencing Alexander Kuznetsov  ✉ D H          
53/5454 Clarify FileTag-based unlinking Matthias van de Meent  ✉ D H          
53/5301 Collation and ctype method tables and extension hooks Jeff Davis ♲ ✉ D H          
53/5378 Conflict detection for update_deleted in logical replication Zhijie Hou  ✉ D H          
53/5750 Consider explicit incremental sort for Append and MergeAppend Richard Guo  ✉ D H          
53/5718 contrib/xml2: xslt_process() should report XSLT-related error details and accept... Robin Haberkorn  ⚠ ✉ D H          
53/4716 COPY TO json Joe Conway  ✉ D H          
53/5677 Covering the comparison test between date and timestamp(tz) datatype Kwangwon Seo  ✉ D H          
53/5692 Create DATA dump objects for partitioned tables too Tom Lane  ✉ D H          
53/5535 Cross-type index comparison support in contrib/btree_gin Tom Lane  ⚠ ✉ D H          
53/1608 declarative session variables, LET command Pavel Stehule  ✉ D H          
53/5707 Detect buffer underflow in get_th() Alexander Kuznetsov  ⚠ ✉ D H          
53/5151 DirtyScanshot index scan skips concurrently updated tuples Michail Nikolaev, Mihail Nikalayeu  ✉ D H          
53/5751 Disable parallel query by default Scott Mead  ⚠ ✉ D H          
53/5647 DOCS: Make the Server Application docs synopses more consistent Peter Smith  ✉ D H          
53/5333 Document how to run only specific regress tests Paul Jungwirth  ⚠ ✉ D H          
53/5086 Document NULL Concepts and Behaviors David Johnston  ⚠ ✉ D H          
53/5725 domain over virtual generated column Jian He  ⚠ ✉ D H          
53/5708 don't generate fake alias names, only fake eref names Robert Haas  ✉ D H          
53/5654 dsm_registry: Add detach and destroy features Sungwoo Chang  ⚠ ✉ D H          
53/4881 Eager aggregation, take 3 Richard Guo ♲ ⚠ ✉ D H          
53/5556 Expanding HOT updates for expression and partial indexes Greg Burd  ⚠ ✉ D H          
53/5517 Extended Statistics set/restore/clear functions Corey Huinker  ⚠ ✉ D H          
53/5018 Extension security improvement: Add support for extensions with an owned schema Jelte Fennema-Nio  ⚠ ✉ D H          
53/5585 Filter irrelevant change before reassemble transactions during logical decoding Jie Li, Ajin Cherian, Zhijie Hou  ✉ D H          
53/5736 Fix a race condition in ConditionVariableTimedSleep() Bertrand Drouvot  ✉ D H          
53/5542 Fix buffer pinning logic in [SP-]Gist Peter Geoghegan, Michail Nikolaev, Matthias van de Meent, Mihail Nikalayeu  ⚠ ✉ D H          
53/5379 Fix bug with accessing to temporary tables of other sessions Daniil Davydov  ⚠ ✉ D H          
53/5741 Fix hostaddr crash during non-blocking cancellation Jacob Champion  ✉ D H          
53/5743 Fix missing comma in Requires.private Jacob Champion  ✉ D H          
53/5627 Fix oldest LSN calculation for WAL segments removal when slots are advancing dur... Vitaly Davydov  ⚠ ✉ D H          
53/5749 Fix PQport to never return NULL if the connection is valid Daniele Varrazzo  ✉ D H          
53/5713 Fix premature xmin advancement during fast forward decoding Zhijie Hou  ✉ D H          
53/5693 Fix replica identity checks for MERGE command on published table. Zhijie Hou  ✉ D H          
53/5664 Fix slot synchronization with two_phase decoding enabled Zhijie Hou ♲ ✉ D H          
53/4460 Implement row pattern recognition feature Tatsuo Ishii  ✉ D H          
53/5680 Improve coments on structures in trigger.c Yugo Nagata  ✉ D H          
53/5733 Improve explicit cursor handling in pg_stat_statements Sami Imseih  ⚠ ✉ D H          
53/5738 Improve hash join's handling of tuples with null join keys Tom Lane  ⚠ ✉ D H          
53/5734 Improve logicalrep_worker_launch() logic Fujii Masao  ✉ D H          
53/5620 Improve monitoring of shared memory allocations Rahila Syed  ✉ D H          
53/5748 Improve Valgrind support and remove some memory leaks Tom Lane  ⚠ ✉ D H          
53/5519 Improve verification of recovery_target_timeline GUC. David Steele  ✉ D H          
53/5742 Incorrect calculation of path fraction value in MergeAppend Andrei Lepikhov  ✉ D H          
53/5070 Incorrect error message for cancellation triggered by statement_timeout & flaky ... Jelte Fennema-Nio  ⚠ ✉ D H          
53/5754 Incremental Sort Cost Estimation Instability Andrei Lepikhov  ✉ D H          
53/5091 inplace update: send nontransactional invalidations Noah Misch  ✉ D H          
53/5732 Introduce some randomness to autovacuum Zhao Junwang  ✉ D H          
53/5160 Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY Michail Nikolaev  ⚠ ✉ D H          
53/5251 libpq: Fix processing of SSL records >8kB on async API Lars Kanis  ⚠ ✉ D H          
53/5299 Limiting overshoot in nbtree SAOP parallel index scans Matthias van de Meent  ⚠ ✉ D H          
53/5633 Lock-free XLog Reservation from WAL Yura Sokolov  ✉ D H          
53/5745 Log prefix missing for subscriber log messages received from publisher vigneshwaran C  ⚠ ✉ D H          
53/5447 log_min_messages per backend type Euler Taveira  ⚠ ✉ D H          
53/5205 Make MultiXactOffset 64-bit type Maxim Orlov  ✉ D H          
53/5636 Memoize ANTI and SEMI JOIN inner Andrei Lepikhov  ✉ D H          
53/5719 MergeAppend could consider sorting cheapest child path Andrei Lepikhov, Alexander Pyhalov  ✉ D H          
53/5700 minor error message enhancement in refuseDupeIndexAttach Jian He  ⚠ ✉ D H          
53/5689 New criteria for autovacuum Konstantin Knizhnik ♲ ✉ D H
53/5044 new plpgsql.extra_errors check - strict_expr_check Pavel Stehule  ⚠ ✉ D H          
53/5703 NUMA shared memory interleaving Jakub Wartak  ⚠ ✉ D H          
53/5635 OAuth Followup Patches Jacob Champion  ✉ D H          
53/5744 oauth: Prevent stack overflow by limiting JSON parse depth Jacob Champion  ✉ D H          
53/4817 on_error table, saving error info to a table jian he  ✉ D H          
53/5624 Options to control remote transactions’ access/deferrable modes in postgres_fdw Etsuro Fujita  ✉ D H          
53/5326 Parallel heap vacuum Masahiko Sawada  ✉ D H          
53/5755 Parallel processing of indexes in autovacuum Maxim Orlov, Daniil Davydov  ✉ D H          
53/5650 Parallel safety docs for CTEs James Coleman  ⚠ ✉ D H          
53/5710 Patch for migration of the pg_commit_ts directory Sergey Levin  ✉ D H          
53/5731 Persist injection points across server restarts Michael Paquier  ✉ D H          
53/5652 pg_dsm_registry system view Florents Tselai  ⚠ ✉ D H          
53/5676 pg_restore documentation and --create/--single-transaction limitation Ashutosh Bapat  ⚠ ✉ D H          
53/5681 Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION Yugo Nagata  ✉ D H          
53/5671 Produce LLVM bitcode files on meson builds Andres Freund, Diego Fronza, Nazir Bilal Yavuz  ✉ D H          
53/5726 Proposal for enabling auto-vectorization for checksum calculations Matthew Sterrett  ⚠ ✉ D H          
53/5656 Prune partitions by ScalarArrayOpExpr with an array parameter (partkey = ANY($1)... Andrei Lepikhov  ✉ D H          
53/5673 Random pg_upgrade 004_subscription test failure on drongo vigneshwaran C  ⚠ ✉ D H          
53/5685 Reduce "Var IS [NOT] NULL" quals during constant folding Richard Guo ♲ ✉ D H          
53/5455 refactor AlterDomainAddConstraint (alter domain add constraint) Jian He  ⚠ ✉ D H          
53/5739 Remove redundant comment regarding RelationBuildRowSecurity in relcache.c Tanzeel Khan  ✉ D H          
53/5626 ReplicationSlotRelease() crashes when the instance is in the single user mode Hayato Kuroda  ⚠ ✉ D H          
53/4997 Return pg_control from pg_backup_stop(). David Steele  ⚠ ✉ D H          
53/5722 Sanding down some edge cases for PL/pgSQL reserved words Tom Lane  ✉ D H          
53/5663 Selectively invalidate caches in pgoutput when pg_namespace is modified Hayato Kuroda  ⚠ ✉ D H          
53/4677 Sequence Access Methods, round two Michael Paquier  ✉ D H          
53/5701 Silence resource leaks alerts Ranier Vilela  ⚠ ✉ D H          
53/5698 Simplify COALESCE with single argument Maksim Milyutin  ⚠ ✉ D H          
53/5573 sinvaladt.c: remove msgnumLock Yura Sokolov  ✉ D H          
53/5683 Small optimization set tuple block/tableOid once Ranier Vilela  ⚠ ✉ D H          
53/5737 speed up pg_upgrade with many large objects Nathan Bossart  ✉ D H          
53/5515 split func.sgml to separated individual sgml files Jian He  ✉ D H          
53/5665 Split varlena.c into varlena.c and bytea.c Aleksander Alekseev  ✉ D H          
53/5735 SQL function to access to `creating_extension` Yurii Rashkovskii  ✉ D H          
53/5660 SQL:2011 application time Paul Jungwirth ♲ ⚠ ✉ D H          
53/5214 SQL:2023 JSON simplified accessor support Alexandra Wang  ⚠ ✉ D H          
53/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          
53/5296 Streaming Replication vs Logical Paul Jungwirth  ⚠ ✉ D H          
53/4735 Support a wildcard in backtrace_functions Jelte Fennema-Nio  ✉ D H          
53/5645 support ALTER COLUMN SET EXPRESSION over virtual generated column with check con... Jian He  ✉ D H          
53/5667 support create index on virtual generated column. Jian He  ✉ D H          
53/5641 support fast default for domain with constraints Jian He  ⚠ ✉ D H          
53/5538 SVE enablement for hex-encode and hex-decode Chiranmoy Bhattacharya, Susmitha Devanga ♲ ⚠ ✉ D H          
53/5111 Synchronization of sequences to subscriber vigneshwaran C  ✉ D H          
53/5318 System views for versions reporting Dmitry Dolgov ♲ ⚠ ✉ D H          
53/5728 teach pg_upgrade to handle in-place tablespaces Nathan Bossart  ✉ D H          
53/4690 Teach predtest about IS [NOT] <boolean> proofs James Coleman  ✉ D H          
53/5711 temporary file usage report with extended protocol and unnamed portals Frédéric Yhuel  ✉ D H          
53/5724 temporary file usage report with extended protocol and unnamed portals Sami Imseih  ✉ D H          
53/5634 track generic and custom plans in pg_stat_statements Sami Imseih  ✉ D H          
53/5661 Update LDAP Protocol in fe-connect.c to v3 Andrew Jackson  ✉ D H          
53/5669 Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze Jianghua yang  ⚠ ✉ D H          
53/5444 using index to speedup add not null constraints to a table Jian He  ✉ D H               
53/5012 Vacuum statistics Andrei Lepikhov, Andrei Zubkov, Alena Rybakina  ✉ D H          
53/5720 virtual generated column as partition key Jian He  ✉ D H          
53/5702 ZStandard (with dictionaries) compression support for TOAST compression Nikhil Kumar Veldanda  ✉ D H          

Waiting on Author

53/5524 add function argument name to substring and substr Jian He  ⚠ ✉ D H          
53/5382 Adding compression of temporary files Filip Januš  ⚠ ✉ D H          
53/5621 Compress big WAL records Andrey Borodin ♲ ✉ D H
53/4810 COPY ON_ERROR 'NULL' jian he  ✉ D H          
53/5615 Corrupted FSM page is not saved after zeroing. Anton Melnikov  ⚠ ✉ D H          
53/4529 CREATE SUBSCRIPTION ... SERVER Jeff Davis ♲ ⚠ ✉ D H          
53/5547 Doc: Create table improvements David Johnston  ✉ D H          
53/5087 Doc: Move and modify standalone hot backups section David Johnston  ✉ D H          
53/5548 Document custom settings more consistently David Johnston  ⚠ ✉ D H          
53/5483 Don't dirty pages while they are getting flushed out Andres Freund ♲ ⚠ ✉ D H          
53/5450 Eliminating SPI / SQL from some RI trigger functions Amit Langote ♲ ✉ D H          
53/5479 Enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada ♲ ⚠ ✉ D H          
53/5643 encode/decode support for base64url Florents Tselai  ✉ D H          
53/5262 ensure we have a snapshot when dropping an index concurrently Nathan Bossart ♲ ✉ D H          
53/5487 Exists pull-up application with JoinExpr Alena Rybakina ♲ ⚠ ✉ D H          
53/5583 Improve ACL checks in pg_prewarm for indexes Ayush Vatsa  ⚠ ✉ D H          
53/4337 Incremental View Maintenance (IVM), take 2 Yugo Nagata ♲ ✉ D H
53/4351 Index Prefetching Tomas Vondra  ⚠ ✉ D H          
53/5532 Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData Michael Paquier  ✉ D H          
53/5270 jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part Florents Tselai  ⚠ ✉ D H          
53/5330 Logging plan of the currently running query Atsushi Torikoshi  ✉ D H          
53/5166 Make ECPG locale usage thread-safe Thomas Munro ♲ ✉ D H          
53/5608 Orphaned users in PG16 and above can only be managed by Superusers Ashutosh Sharma  ✉ D H          
53/4966 Parallel CREATE INDEX for GIN indexes Tomas Vondra  ⚠ ✉ D H          
53/4738 psql: Rethinking of \du command Pavel Luzanov  ⚠ ✉ D H          
53/5007 relfilenode statistics Bertrand Drouvot ♲ ✉ D H
53/4458 Retiring is_pushed_down Richard Guo ♲ ✉ D H
53/5397 revamp row-security tracking Nathan Bossart  ⚠ ✉ D H          
53/4285 Revise get_cheapest_parallel_safe_total_inner Richard Guo  ⚠ ✉ D H          
53/4984 Serverside SNI for SSL connections Daniel Gustafsson  ⚠ ✉ D H          
53/4904 SQL Property Graph Queries (SQL/PGQ) Peter Eisentraut, Ashutosh Bapat ♲ ⚠ ✉ D H          
53/5323 Support enabling checksums online Magnus Hagander, Daniel Gustafsson ♲ ⚠ ✉ D H          
53/5530 TOAST is acronym so should be uppercase Peter Smith  ⚠ ✉ D H          
53/5272 Truncate logs by max_log_size Kirill Gavrilov  ⚠ ✉ D H