PostgreSQL Patch Tester

Current commitfest | Next commitfest | Draft 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 empty circles are paused CI tasks for other OSes that may be enabled soon...

Ready for Committer

57/6208 Add pg_get_subscription_ddl() function Vaibhav Dalvi  ✉ D H           
57/4237 Add XMLCanonicalize function Jim Jones  ✉ D H           
57/5431 Add XMLDocument (SQL/XML X030) Jim Jones  ✉ D H           
57/5456 Add XMLNamespaces option to XMLElement Pavel Stehule, Jim Jones  ✉ D H           
57/6258 Adds two new modifiers for \dt[Oo] and \di[Oo]. This helps inspect large deploym... M.Atıf CEYLAN  ✉ D H           
57/6071 Doc: add XML ID attributes to <varlistentry> tags for create_foreign_table, alte... Jian He  ✉ D H           
57/5086 Document NULL Concepts and Behaviors David Johnston  ✉ D H           
57/5992 Fix ALTER TABLE DROP EXPRESSION with ONLY option Jian He ♲ ⚠ ✉ D H           
57/5802 Improve the performance of Unicode Normalization Forms. Alexander Borisov ♲ ⚠ ✉ D H           
57/5070 Incorrect error message for cancellation triggered by statement_timeout & flaky ... Jelte Fennema-Nio  ✉ D H           
57/6119 Migrate pg_commit_ts directory to the new node during an upgrade Sergey Levin  ✉ D H           
57/6180 minor error message enhance: print RLS policy name when only one permissive poli... Jian He  ✉ D H           
57/6125 pgstattuple: Use streaming read API in pgstatindex functions Xuneng Zhou  ✉ D H           
57/5250 Refactor SLRU to always use long file names Aleksander Alekseev ♲ ⚠ ✉ D H           
57/5824 Returning nbtree posting list TIDs in DESC order during backwards scans Peter Geoghegan  ✉ D H           
57/5214 SQL:2023 JSON simplified accessor support Alexandra Wang  ✉ D H           
57/5296 Streaming Replication vs Logical Paul Jungwirth  ✉ D H           
57/4314 Unlinking Parallel Hash Join inner batch files sooner Thomas Munro  ✉ D H           
57/6230 vacuumdb: add --dry-run Corey Huinker  ✉ D H           

Needs review

57/4971 [CREATE|RE] INDEX CONCURRENTLY with single heap scan Michail Nikolaev, Mihail Nikalayeu ♲ ✉ D H           
57/6268 <stdatomic.h> Thomas Munro ♲ ✉ D H
57/6238 001_password.pl fails with --without-readline Oleg Tselebrovskiy ♲ ⚠ ✉ D H           
57/5727 Accounting for metapages in genericcostestimate() Tom Lane  ✉ D H           
57/6274 Add a greedy join search algorithm to handle large join problems Chengpeng Yan  ✉ D H           
57/6156 Add GoAway protocol message for graceful but fast server shutdown/switchover Jelte Fennema-Nio  ✉ D H           
57/6225 Add memory usage reporting to VACUUM VERBOSE Tatsuya Kawata  ✉ D H           
57/5969 Add mode and reason columns to pg_stat_progress_vacuum Shinya Kato ♲ ⚠ ✉ D H           
57/6265 Add MODE parameter to WAIT FOR LSN command Xuneng Zhou  ✉ D H           
57/5099 Add OR REPLACE option to CREATE MATERIALIZED VIEW Erik Wienhold  ✉ D H           
57/6215 Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement Akshay Joshi  ✉ D H           
57/6166 Add pg_get_role_ddl() functions for role recreation Mario Gonzalez, Bryan Green  ✉ D H           
57/6203 Add pretty formatting to pg_get_triggerdef Phil Alger  ✉ D H           
57/5872 Add prompt option to display read-only and read/write states in psql Jim Jones ♲ ⚠ ✉ D H           
57/6288 Add sampling statistics to autoanalyze log output Tatsuya Kawata  ✉ D H           
57/3659 Add SPLIT PARTITION/MERGE PARTITIONS commands Dmitry Koval  ✉ D H           
57/5526 Add storage I/O tracking to EXPLAIN BUFFERS Atsushi Torikoshi  ✉ D H           
57/6116 Add Windows support for backtrace_functions (MSVC only) Bryan Green  ✉ D H           
57/5110 Add XMLCast (SQL/XML X025) Jim Jones ♲ ⚠ ✉ D H           
57/5279 Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) Jim Jones ♲ ⚠ ✉ D H           
57/6228 Adding callback support for custom statistics kinds Sami Imseih ♲ ⚠ ✉ D H           
57/5942 Adding locks statistics Bertrand Drouvot ♲ ✉ D H           
57/5947 Adding per backend commit and rollback counters Bertrand Drouvot  ✉ D H           
57/6289 Adding TRIM_SPACE option to COPY Tatsuya Kawata  ✉ D H           
57/6202 ago(interval) → timestamptz Florents Tselai  ✉ D H           
57/6239 Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect on publisher... Fujii Masao ♲ ⚠ ✉ D H           
57/6146 Alow ALTER COLUMN TYPE when dependent generated column has SET EXPRESSION Chao Li  ✉ D H           
57/6010 ALTER COLUMN SET EXPRESSION [GENERATED|STORED] Jian He  ✉ D H           
57/5768 ALTER DOMAIN ADD NOT NULL NOT VALID Jian He  ✉ D H           
57/5913 Automatically sizing the IO worker pool Thomas Munro ♲ ✉ D H
57/6121 avoid call ATPostAlterTypeCleanup twice Jian He  ✉ D H           
57/4942 Avoid orphaned objects dependencies, take 3 Bertrand Drouvot ♲ ✉ D H
57/6209 Avoid overflow (src/backend/utils/adt/formatting.c) Ranier Vilela  ✉ D H           
57/6248 Avoid pallocs in async.c's "critical section" Joel Jacobson  ✉ D H           
57/5617 Beautify read stream "per buffer data" APIs Thomas Munro  ✉ D H           
57/6266 Better Performance for PostgreSQL with large INSERTs Filip Januš  ✉ D H           
57/5570 Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup Jelte Fennema-Nio ♲ ✉ D H           
57/6233 Bypassing cursors in postgres_fdw to enable parallel plans Rafia Sabih ♲ ⚠ ✉ D H           
57/5941 CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Jian He ♲ ⚠ ✉ D H           
57/6287 Change comment in `contrib/amcheck` regression suite Kirill Reshke  ✉ D H           
57/6043 Checkpointer write combining Melanie Plageman  ✉ D H           
57/6148 CI: Add task that runs pgindent Jelte Fennema-Nio  ✉ D H            
57/6090 Clarify EXPLAIN ANALYZE docs on fractional rows and parallelism Tom Lane, Maciek Sakrejda  ✉ D H           
57/6282 Clarify the scope and intended use of pg_dumpall Laurenz Albe  ✉ D H           
57/6262 Cleanup shadows variable warnings Chao Li  ✉ D H           
57/6178 COPY FROM with RLS Jian He  ✉ D H           
57/4716 COPY TO json Joe Conway  ✉ D H           
57/5692 Create DATA dump objects for partitioned tables too Tom Lane  ✉ D H           
57/5985 CREATE SCHEMA ... CREATE DOMAIN support Jian He ♲ ✉ D H           
57/6064 CREATE TABLE LIKE INCLUDING POLICIES Jian He  ✉ D H           
57/6088 create table like including storage parameter Jian He  ✉ D H           
57/6087 CREATE TABLE LIKE INCLUDING TRIGGERS Jian He ♲ ⚠ ✉ D H           
57/5151 DirtySnapshot index scan skips concurrently updated tuples leading to lost updat... Michail Nikolaev, Mihail Nikalayeu  ✉ D H           
57/6259 doc: Clarify ANALYZE VERBOSE output Shinya Kato  ✉ D H           
57/6281 domain for WITHOUT OVERLAPS Jian He ♲ ⚠ ✉ D H           
57/5483 Don't dirty pages while they are getting flushed out Andres Freund  ✉ D H           
57/5919 Eagerly evict bulkwrite strategy ring Melanie Plageman  ✉ D H           
57/5841 Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume Melanie Plageman  ✉ D H           
57/5479 Enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada  ✉ D H           
57/6222 enhance wraparound warnings Nathan Bossart  ✉ D H           
57/6285 explain plans for foreign scans dinesh salve  ✉ D H           
57/5811 Expose internal MultiXact member count function for efficient monitoring Naga Appani  ✉ D H           
57/6260 extend JSON_TABLE top level path expression Jian He  ✉ D H           
57/5018 Extension security improvement: Add support for extensions with an owned schema Jelte Fennema-Nio  ✉ D H           
57/5759 finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it Jian He  ✉ D H           
57/6294 Fix a minor typo in the comment of read_stream_start_pending Xuneng Zhou  ✉ D H           
57/6243 Fix ARM64/MSVC atomic memory ordering issues on Win11 by adding explicit DMB ​ba... Dave Cramer, Greg Burd  ✉ D H           
57/6279 Fix crash during recovery when redo segment is missing Nitin Jadhav  ✉ D H           
57/6206 Fix fragile walreceiver test. Bryan Green ♲ ✉ D H           
57/6201 Fix orphaned backend processes on Windows using Job Objects Bryan Green  ✉ D H           
57/6207 Fix socket handle inheritance on Windows Bryan Green  ✉ D H           
57/5944 Fixing the btree_gist inet mess Tom Lane  ✉ D H           
57/5782 foreign key on virtual generated column Jian He  ✉ D H           
57/6025 Get rid of pgstat_count_backend_io_op*() functions Bertrand Drouvot  ✉ D H           
57/6224 Give Plugins control at the end of CHECKPOINT to store their state Andrei Lepikhov, Asif Rehman ♲ ✉ D H           
57/6229 Have BackendXidGetPid return pid_t Sami Imseih ♲ ⚠ ✉ D H           
57/5029 Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state ChangAo Chen  ✉ D H           
57/6245 Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY... Boris Mironov ♲ ⚠ ✉ D H           
57/5957 implement CAST(expr AS type FORMAT 'template') Jian He  ✉ D H           
57/6218 implement GRANT/REVOKE ... GRANTED BY Nathan Bossart  ✉ D H           
57/6235 Implement pg_add_size_overflow() and friends Jacob Champion  ✉ D H           
57/4460 Implement row pattern recognition feature Tatsuo Ishii  ✉ D H           
57/6024 Improve read_local_xlog_page_guts by replacing polling with latch-based waiting Xuneng Zhou  ✉ D H           
57/5810 Improve tab completion for various SET/RESET forms Dagfinn Ilmari Mannsåker  ✉ D H           
57/6059 Improving the names generated for indexes on expressions Tom Lane  ✉ D H           
57/6067 Include extension path on pg_available_extensions Matheus Alcantara  ✉ D H           
57/6114 incremental autovacuum scheduling improvements Nathan Bossart ♲ ✉ D H           
57/6234 Introduce a new GUC to allow logical walsender to shutdown immediately without w... Andrey Silitskiy ♲ ⚠ ✉ D H           
57/6237 IS JSON predicate support for domain base type as JSON/JSONB/BYTEA/TEXT Jian He  ✉ D H           
57/6054 let ALTER COLUMN SET DATA TYPE cope with POLICY dependency Jian He ♲ ⚠ ✉ D H           
57/6089 let ALTER COLUMN SET DATA TYPE cope with trigger dependency Jian He  ✉ D H           
57/6055 let ALTER TABLE DROP COLUMN drop whole-row referenced object Jian He  ✉ D H           
57/6157 libpq: Bump protocol version to version 3.2 at least until the first/second beta Jelte Fennema-Nio  ✉ D H           
57/6113 Little refactoring of portalcmds.c Aleksander Alekseev  ✉ D H           
57/5330 Logging plan of the currently running query Atsushi Torikoshi  ✉ D H           
57/5769 make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated Jian He  ✉ D H           
57/4681 Make COPY format extendable: Extract COPY TO format implementations Kouhei Sutou  ✉ D H           
57/6291 Make copyObject work in C++ Jelte Fennema-Nio  ✉ D H           
57/5623 Make numeric type accessible to third-party code. Ed Behn  ✉ D H           
57/6056 meson: Fix libpq search order Thomas Munro ♲ ✉ D H           
57/6255 Minor refactor of ExecScanExtended() ChangAo Chen  ✉ D H           
57/6001 minor refactor on src/test/modules/test_ddl_deparse/sql/alter_table.sql Jian He ♲ ⚠ ✉ D H           
57/6231 misleading error message in DefineIndex Jian He  ✉ D H           
57/6210 Move instrumentation structs Mario Gonzalez  ✉ D H           
57/6286 Moving _bt_readpage and _bt_checkkeys into a new .c file Peter Geoghegan  ✉ D H           
57/5907 no table rewrite when set column type to constrained domain Jian He ♲ ✉ D H           
57/6029 NOT NULL NOT ENFORCED Jian He  ✉ D H           
57/6197 O_CLOEXEC not honored on Windows - handle inheritance chain Bryan Green  ✉ D H           
57/6152 Optimization of the is_normalized() function. Alexander Borisov  ✉ D H           
57/6078 Optimize LISTEN/NOTIFY Joel Jacobson  ✉ D H           
57/6187 Optimize SnapBuild by maintaining committed.xip in sorted order Xuneng Zhou ♲ ⚠ ✉ D H           
57/6141 Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary ar... Xuneng Zhou  ✉ D H                 
57/5326 Parallel heap vacuum Masahiko Sawada ♲ ⚠ ✉ D H           
57/6242 parallel pgbench -i Mircea Cadariu ♲ ⚠ ✉ D H           
57/5958 Per backend relation statistics tracking Bertrand Drouvot ♲ ✉ D H
57/6219 pg_dump flag for dumping tables data in multiple chunks, for huge tables can oft... Hannu Krosing  ✉ D H           
57/6212 pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement Florin Irion, Tim Waizenegger  ✉ D H           
57/5831 pgindent: improve formatting of multiline comments Aleksander Alekseev  ✉ D H           
57/6272 PoC: Simplify recovery after dropping a table by LOGGING the restore LSN Dmitry Lebedev ♲ ✉ D H
57/6137 postgres_fdw: Use COPY to speed up batch inserts Matheus Alcantara  ✉ D H           
57/6118 Preserve index stats during ALTER TABLE ... TYPE ... Bertrand Drouvot ♲ ⚠ ✉ D H           
57/6292 Proposal to allow setting cursor options on Portals Dave Cramer ♲ ⚠ ✉ D H           
57/6252 Proposal: Conflict log history table for Logical Replication Dilip Kumar  ✉ D H           
57/6220 psql: add \dcs to list all constraints Tatsuro Yamada ♲ ⚠ ✉ D H           
57/6244 psql: tab completion for ALTER ROLE ... IN DATABASE ... Ian Barwick  ✉ D H           
57/5487 Pull-up subquery if INNER JOIN-ON contains refs to upper-query Alena Rybakina  ✉ D H           
57/6271 Qual push down to table AM Julien Tachoires  ✉ D H           
57/6240 quoteOneName() inconsistency with quote_all_identifiers — replacement API propos... Chao Li ♲ ✉ D H           
57/5622 Reduce timing overhead of EXPLAIN ANALYZE using rdtsc Andres Freund, Lukas Fittl, David Geier  ✉ D H           
57/6216 Reduce unnecessary locking of pruned partitions when reusing cached plans Amit Langote ♲ ⚠ ✉ D H           
57/5889 Refactor bytea_sortsupport(), take two Aleksander Alekseev  ✉ D H           
57/6106 refactor CreateStatsStmt Jian He ♲ ✉ D H           
57/6280 refactor ExecInitPartitionInfo Jian He  ✉ D H           
57/6144 refactor func-matching.sgml, make regexp* function more readable Jian He  ✉ D H           
57/6221 Refactor how we form HeapTuples for CatalogTuple(Insert|Update) Greg Burd ♲ ✉ D H           
57/5007 relfilenode statistics Bertrand Drouvot ♲ ✉ D H
57/6246 Remove ctid from self-join examples in UPDATE and DELETE docs Bernice Southey  ✉ D H           
57/6263 Remove unused function parameters, part 1: contrib Bertrand Drouvot  ✉ D H           
57/6264 Remove unused function parameters, part 2: replication Bertrand Drouvot  ✉ D H           
57/6247 Reorganize pqcomm.h a bit Jacob Champion  ✉ D H           
57/4997 Return pg_control from pg_backup_stop(). David Steele  ✉ D H           
57/6276 Safer hash table initialization macro Bertrand Drouvot ♲ ✉ D H           
57/6293 Select PG_PRINTF_ATTRIBUTE separately for C and C++ Tom Lane  ✉ D H           
57/5118 SendProcSignal(), SetLatch() → SendInterrupt() Heikki Linnakangas, Thomas Munro ♲ ✉ D H
57/4677 Sequence Access Methods, round two Michael Paquier ♲ ✉ D H           
57/5952 Speed up COPY FROM text/CSV parsing using SIMD Shinya Kato  ✉ D H           
57/6269 split tablecmds.c Nathan Bossart ♲ ✉ D H           
57/4904 SQL Property Graph Queries (SQL/PGQ) Peter Eisentraut, Ashutosh Bapat ♲ ⚠ ✉ D H           
57/6023 Stack-based tracking of per-node WAL/buffer usage Lukas Fittl  ✉ D H           
57/6261 Static assertion implementation improvements Peter Eisentraut, Thomas Munro ♲ ✉ D H
57/4735 Support a wildcard in backtrace_functions Jelte Fennema-Nio ♲ ✉ D H
57/5645 support ALTER COLUMN SET EXPRESSION over virtual generated column with check con... Jian He ♲ ⚠ ✉ D H           
57/5667 support create index on virtual generated column. Jian He ♲ ⚠ ✉ D H           
57/5641 support fast default for domain with constraints Jian He ♲ ✉ D H           
57/5830 Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Michael Paquier  ✉ D H           
57/5873 Support for basic ALTER TABLE progress reporting. Jiří Kavalík ♲ ⚠ ✉ D H           
57/6283 Support getrandom() for pg_strong_random() source Masahiko Sawada ♲ ✉ D H
57/6102 Termination of Background Workers for ALTER/DROP DATABASE Aya Iwata  ✉ D H           
57/6021 ternary reloption type Nikolay Shaplov  ✉ D H           
57/6217 tuple radix sort John Naylor ♲ ⚠ ✉ D H           
57/6270 UPDATE run check constraints for affected columns only Jian He  ✉ D H           
57/6031 UPDATE with invalid domain constraint Jian He  ✉ D H           
57/6027 Use enum type replacing #define for exec state of hashjoin and mergejoin Tender Wang  ✉ D H           
57/6251 Use ROLERECURSE_PRIVS in is_admin_of_role() ChangAo Chen ♲ ⚠ ✉ D H           
57/6101 use SIMD in GetPrivateRefCountEntry() Nathan Bossart  ✉ D H           
57/5444 using index to speedup add not null constraints to a table Jian He ♲ ✉ D H           
57/5720 virtual generated column as partition key Jian He ♲ ⚠ ✉ D H           
57/6253 Visibility bug in tuple lock David Geier ♲ ⚠ ✉ D H           
57/6204 Windows relation extension failure at 2GB and 4GB Bryan Green  ✉ D H           
57/6205 Write Notifications Through WAL Rishu Bagga  ✉ D H           

Waiting on Author

57/5524 add function argument name to substring and substr Jian He ♲ ✉ D H           
57/5796 alter check constraint enforceability Jian He  ✉ D H           
57/6176 Batching in executor, part 1: add batch variant of table AM scan API Amit Langote ♲ ✉ D H           
57/5885 Decouple C++ support in Meson's PGXS from LLVM enablement Tristan Partin ♲ ⚠ ✉ D H           
57/5988 disallow alter individual column if partition key contains wholerow reference Jian He  ✉ D H           
57/5863 docs: Update protocol changes checklist with 3.2 changes Dave Cramer, Jelte Fennema-Nio  ✉ D H           
57/5124 Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() Thomas Munro ♲ ✉ D H
57/5738 Improve hash join's handling of tuples with null join keys Tom Lane  ✉ D H           
57/4351 Index Prefetching Peter Geoghegan, Tomas Vondra  ⚠ ✉ D H           
57/4573 pg_ctl start may return 0 even if the postmaster has been already started on Win... Kyotaro Horiguchi  ✉ D H           
57/5839 problems with toast.* reloptions Nathan Bossart ♲ ✉ D H
57/5455 refactor AlterDomainAddConstraint (alter domain add constraint) Jian He  ✉ D H           
57/6188 Report oldest xmin source when autovacuum cannot remove tuples Shinya Kato ♲ ⚠ ✉ D H           
57/5012 Vacuum statistics Andrei Lepikhov, Andrei Zubkov, Alena Rybakina ♲ ✉ D H