PostgreSQL Patch Tester

Here lives an experimental bot that does this: PostgreSQL CommitfestGithub → ( AppVeyor, Cirrus CI ). The results appear in the following order: apply, Windows check, FreeBSD check-world, Linux check-world + docs, macOS check. The plan is eventually to show them on the Commitfest app.

Current commitfest | Next commitfest

Ready for Committer

33/2614 Add table expansion hook Erik Nordström patch
33/2992 Allow batched insert during cross-partition updates Amit Langote patch
33/2694 Automatic HASH and LIST partition creation Anastasia Lubennikova patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2928 EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW Bharath Rupireddy patch
33/2601 Fast COPY FROM command for the foreign tables Andrey Lepikhov patch
33/2971 Fix detection of preadv/pwritev support for OSX. James Hilliard patch
33/2860 Hooks on start/end/abort Xact command Gilles Darold patch
33/2968 Minimal logical decoding on standbys (take 6) Amit Khandekar patch
33/2807 New wal_level to disable WAL logging Takamichi Osumi patch
33/2900 On client connection event trigger Konstantin Knizhnik patch
33/2903 Parallel Hash Full Join Melanie Plageman patch
33/3034 Using COPY FREEZE in pgbench Tatsuo Ishii patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2539 allow to set a pager for psql's watch command Pavel Stehule patch
33/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor success   cirrus/freebsd success (new)   cirrus/linux success   cirrus/macos success (new)

Needs review

33/2234 A hook for path-removal decision on add_path KaiGai Kohei patch
33/2602 ALTER SYSTEM READ { ONLY | WRITE } Amul Sul patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3079 ATTACH PARTITION locking documentation for DEFAULT partitions Matthias van de Meent patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2958 Adaptive query optimization: create extented statistics using auto_explain exten... Konstantin Knizhnik patch
33/3073 Add callback table access method to reset filenode when dropping relation Mats Kindahl patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3042 Add common functions regexp_like, regexp_count, regexp_instr, regexp_substr and ... patch
33/2765 Add extra statistics to explain for Nested Loop Ekaterina Sokolova patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3054 Add missing function abs (interval) Isaac Morland patch   apply success   appveyor failure   cirrus/freebsd failure   cirrus/linux failure   cirrus/macos failure
33/3065 Add option --drop-cascade for pg_dump/restore patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/3027 Add regexp_positions(string text, pattern text, flags text) → setof record (st... Joel Jacobson patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/3036 Add some tests for pg_stat_statements compatibility verification Erica Zhang patch
33/3033 Add system views pg_permissions and pg_ownerships Joel Jacobson patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2780 Allow COPY "text" to output a header and add header matching mode to COPY FROM Rémi Lapeyre patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3046 Allow multiple recursive self-references Denis Hirn patch   apply failure
33/2706 Background writer and checkpointer in crash recovery Thomas Munro patch   apply failure
33/3043 Built-in connection pooler Konstantin Knizhnik patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/2815 CREATE INDEX CONCURRENTLY on partitioned table Justin Pryzby patch
33/3069 CREATE SEQUENCE with RESTART option Bharath Rupireddy patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2999 Catalog version access Vik Fearing patch
33/3072 Coerce Type: CollateExpr should be discarded if the target type is non-collatabl... Yulin PEI patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/2851 Consider parallel for LATERAL subqueries having LIMIT/OFFSET James Coleman patch
33/3074 Convert contrib SQL functions to new style Tom Lane patch   apply success   appveyor success   cirrus/freebsd success (new)   cirrus/linux success   cirrus/macos success (new)
33/2518 Corruption during WAL replay Teja Mupparti patch   apply success   appveyor success   cirrus/freebsd failure   cirrus/linux failure   cirrus/macos success
33/2805 DROP INDEX CONCURRENTLY on partitioned index Justin Pryzby patch
33/2603 DROP relation IF EXISTS Docs and Tests - Bug Fix David Johnston patch
33/2919 Discarding DISCARD ALL Simon Riggs patch
33/3016 Dump public schema ownership, seclabels and comments Noah Misch patch   apply success   appveyor success   cirrus/freebsd failure   cirrus/linux failure   cirrus/macos success
33/2911 Dynamic result sets from procedures Peter Eisentraut patch   apply failure
33/3058 Eliminating "Permission denied" errors on stat() (on Windows) Alexander Lakhin patch
33/2953 Extend docs on how to write correct postgres-dialect C including extensions and ... Craig Ringer patch
33/2831 Extended statistics / estimate Var op Var clauses Tomas Vondra patch   apply failure
33/3050 Extended statistics in EXPLAIN Tomas Vondra patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2176 FETCH FIRST clause PERCENT option Surafel Temesgen patch
33/2897 Faster pglz compression Andrey Borodin, Владимир Лесков patch
33/2962 Fix DROP TABLESPACE on Windows with ProcSignalBarrier? Thomas Munro patch   apply success   appveyor success   cirrus/freebsd failure   cirrus/linux failure   cirrus/macos success
33/2710 Fix behavior of geo_ops when NaN is involved Kyotaro Horiguchi patch
33/2719 Fix checksum verification in base backups for zero page headers Michael Banck patch
33/2685 Fix collation handling in postgres_fdw Tom Lane patch   apply success   appveyor success   cirrus/freebsd failure   cirrus/linux failure   cirrus/macos failure
33/2877 Fix firing of RI triggers during cross-partition updates of partitioned tables Amit Langote patch
33/2864 Fix pg_rewind race condition just after promotion Heikki Linnakangas patch
33/2266 Fix up partitionwise join on how equi-join conditions between the partition keys... Richard Guo patch
33/2966 Foreign Key Arrays Mark Rofail patch
33/2947 Full support for index LP_DEAD hint bits on standby Michail Nikolaev patch   apply failure
33/2824 Functions for sorting GiST build of gist_btree types Andrey Borodin patch
33/1651 GROUP BY optimization Fedor Sigaev, Pavel Borisov patch
33/2402 GUC to disable cancellation of awaiting for synchronous replication Andrey Borodin patch
33/3018 Hooks and API to allow loadable wire protocol extensions Jan Wieck
33/2218 Implement INSERT SET syntax Gareth Palmer patch   apply success   appveyor success   cirrus/freebsd failure   cirrus/linux failure   cirrus/macos failure
33/2959 Improve join selectivity estimation using extended statistics Konstantin Knizhnik patch
33/3076 Improve sepgsql logging so it follows the behaviour of selinux's logging. Dave Page patch   apply success (new)   appveyor success (new)   cirrus/freebsd success (new)   cirrus/linux success (new)   cirrus/macos success (new)
33/3044 In psql \?, add [+] annotation where appropriate Matthijs van der Vleuten patch
33/2973 In psql \copy from, send data to server in larger chunks Heikki Linnakangas patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2138 Incremental Materialized View Maintenance Yugo Nagata, takuma hoshiai patch
33/1741 Index Skip Scan Dmitry Dolgov, Thomas Munro, Jesper Pedersen patch
33/2952 Introduce ProcessInterrupts_hook for C extensions Craig Ringer patch
33/3078 Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncati... Matthias van de Meent patch   apply success (new)   appveyor failure (new)   cirrus/freebsd success (new)   cirrus/linux success (new)   cirrus/macos success (new)
33/2925 Key management with tests Stephen Frost, Masahiko Sawada, Bruce Momjian patch
33/3071 Lazy JIT IR code generation to increase JIT speed with partitions Luc Vlaming patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3040 Logical Replication - improve error message while adding tables to the publicati... Bharath Rupireddy patch
33/3041 Logical replication failure "ERROR: could not map filenode "base/13237/442428" t... Bertrand Drouvot, Minsoo Oh patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2829 Make Append Cost aware of some run time partition prune case Andy Fan patch   apply failure
33/772 Make async slave to wait for lsn to be replayed Ivan Kartyshov patch
33/2490 Make message at end-of-recovery less scary Kyotaro Horiguchi patch   apply failure
33/3030 Make relfile tombstone files conditional on WAL level Thomas Munro patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2909 Maximize page freezing Simon Riggs patch
33/3052 Merging statistics from children instead of re-sampling everything Tomas Vondra patch
33/2869 Mitigate pg_rewind race condition, if config file is enlarged concurrently. Heikki Linnakangas patch
33/2627 More scalable multixacts buffers and locking Kyotaro Horiguchi, Andrey Borodin patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3038 More sort-related specialisation Thomas Munro patch
33/2937 NOT VALID for Unique Indexes Simon Riggs patch
33/2871 New Table Access Methods for Multi and Single Inserts Bharath Rupireddy patch
33/2918 New default role allowing to change per-role/database settings Michael Banck patch
33/2615 Non-volatile WAL buffer Takashi Menjo patch
33/2699 Optimizing NULL check on pkey column Surafel Temesgen patch
33/3032 PROXY protocol support Magnus Hagander patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2932 Partial foreign key updates in referential integrity triggers Paul Martinez patch   apply failure
33/2907 PoC Refactor AM analyse API Denis Smirnov
33/2863 Printing backtrace of postgres processes vignesh C patch   apply failure
33/2597 Problem with RETURNING and update tuple routing Amit Langote patch
33/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch
33/2895 REINDEX backend filtering Julien Rouhaud patch
33/2817 Reduce the number of special cases to build contrib modules on windows David Rowley patch   apply failure
33/2935 Reduce the time required for a database recovery from archive. Anna Akenteva, Dmitry Shulga, Ivan Taranov patch
33/3005 Refactor ECPGconnect() and allow IPv6 connection Hayato Kuroda patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/3037 Release SPI plans for referential integrity with DISCARD Yuzuko Hosoya patch
33/1712 Remove self join on a unique column Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov patch
33/3035 Removing unused trailing linepointers from heap pages Matthias van de Meent patch   apply failure
33/2943 Rename of triggers for partitioned tables patch
33/2781 Replace polyphase merge with a simple k-way balanced merge Heikki Linnakangas patch
33/2834 ResourceOwner refactoring Heikki Linnakangas patch
33/3029 Rework the sslfiles Makefile target Jacob Champion patch   apply failure
33/2902 SQL/JSON: JSON_TABLE Nikita Glukhov patch   apply failure
33/2901 SQL/JSON: functions Nikita Glukhov patch
33/1708 Shared-memory based stats collector Kyotaro Horiguchi patch
33/2370 Split StdRdOptions into HeapOptions and ToastOptions Nikolay Shaplov patch   apply failure
33/2979 Support tab completion for upper character inputs in psql Haiying Tang patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/2955 System catalog accesses in error context callback Masahiko Sawada, Bharath Rupireddy patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success (new)
33/2922 Table AM modifications to accept column projection lists Jacob Champion, Soumyadeep Chakraborty patch   apply failure
33/3077 Teach pg_size_pretty about higher-order units David Christensen patch   apply success (new)   appveyor success (new)   cirrus/freebsd success (new)   cirrus/linux success (new)   cirrus/macos success (new)
33/2994 Track wal_level drop for backup management Takamichi Osumi patch
33/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch
33/2376 UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR John Dent patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/3066 Use SIGIO to detect postmaster death Thomas Munro patch
33/2996 Use SSE4 for verifying UTF-8 John Naylor patch
33/2386 Using multicolumn statistics for more precise join selectivity estimatation Konstantin Knizhnik patch
33/2933 WIP: Track relation size in shared memory Thomas Munro patch   apply failure
33/3063 WIP: remove 64K hard limit on rangetable size Tom Lane patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2316 WITH SYSTEM VERSIONING Temporal Tables Surafel Temesgen patch
33/3070 add explicit partial union-all and improve parallel subquery costing patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3056 add link to domain data types section from locale documentation Jürgen Purtz, Anton Voloshin patch
33/2520 archive status ".ready" files may be created too early Nathan Bossart patch
33/2838 brin: avoid errors processing work item following concurrent reindex Álvaro Herrera, Justin Pryzby patch
33/2865 create table like: ACCESS METHOD Justin Pryzby patch
33/2684 enhancing plpgsql API for debugging and tracing Pavel Stehule patch   apply success   appveyor success   cirrus/freebsd failure   cirrus/linux failure   cirrus/macos failure
33/3055 estimating joins using extended statistics Tomas Vondra patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/3059 fix ICU explorer link in locale documentation Anton Voloshin patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2349 global temporary table wenjing zeng patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2482 jsonpath syntax extensions Nikita Glukhov patch
33/2773 libpq compression Konstantin Knizhnik, Daniil Zakhlystov patch
33/2914 logical decoding of two-phase transactions Stas Kelvich, Nikhil Sontakke, Ajin Cherian, Peter Smith patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/2981 partial heap only tuples Nathan Bossart patch
33/2573 pg_dump - read data for some options from external file Pavel Stehule patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/3051 pg_dump new feature: exporting functions only Lætitia AVROT patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2377 pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ... Justin Pryzby patch
33/2837 pg_stat_statements and "IN" conditions Dmitry Dolgov patch
33/3048 pg_stat_statements: Track statement entry timestamp Andrei Zubkov patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/2861 pg_upgrade test for binary compatibility of core data types Justin Pryzby patch
33/3025 postgres-fdw: column option to override foreign types Dian Fay patch
33/2096 psql - add SHOW_ALL_RESULTS option Fabien Coelho patch   apply failure
33/3017 public schema default ACL Noah Misch patch
33/3045 rename column if exists David Oksman patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2948 simplify some RI checks to reduce SPI overhead Amit Langote patch
33/2990 speed up pg_rewind by using copy_file_range() and skipping some fsync Paul Guo patch   apply failure
33/2161 standby recovery fails when re-replaying due to missing directory which was remo... Kyotaro Horiguchi, Paul Guo patch
33/3062 tablesync early exit Peter Smith patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/3060 use AV work items infrastructure for GIN pending list's cleanup Jaime Casanova patch
33/3015 wal_compression_method=pglz/zlib/lz4/zstd Andrey Borodin, Justin Pryzby patch
33/2910 wal_sessioninfo Simon Riggs patch

Waiting on Author

33/3026 Add --create-only option to pg_dump/pg_dumpall Michael Banck patch   apply failure
33/2987 Allow setting parallel_workers on partitioned tables Seamus Abshere patch
33/2983 Autovacuum dynamic cost_limit, cost_delay Scott Mead patch   apply failure
33/2800 CLUSTER on partitioned table Justin Pryzby patch
33/2433 Erase the distinctClause if the result is unique by definition Andy Fan patch
33/2951 Extend comments on signal handling and cross-reference comments on signal handli... Craig Ringer patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2774 Further note require activity aspect of automatic checkpoint and archiving David Johnston patch
33/2553 INSERT SELECT: BulkInsertState and table_multi_insert Justin Pryzby patch
33/2957 Identify missing publications from publisher while create/alter subscription. vignesh C patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos failure
33/2960 Infrastructure changes to make the code less sensitive to transaction id bit wid... James Finnerty patch   apply failure
33/2920 MERGE SQL command Álvaro Herrera, Simon Riggs, Pavan Deolasee patch
33/3075 Replace pg_depend PIN entries with a fixed range check Tom Lane patch   apply success   appveyor success   cirrus/freebsd success (new)   cirrus/linux success   cirrus/macos success
33/2906 Row filtering for logical replication Euler Taveira patch   apply failure
33/3023 Speeding up GIST index builds using popcount Amit Khandekar patch
33/3020 alter table set TABLE ACCESS METHOD Justin Pryzby patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2716 fix spinlock contention in LogwrtResult Álvaro Herrera patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2942 increase size of pg_commit_ts buffers Álvaro Herrera patch
33/2769 parallel distinct union and aggregate support patch bucoo hsiao patch   apply failure
33/2215 pg_upgrade fails with non-standard ACL Anastasia Lubennikova, Arthur Zakirov patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2970 pg_upgrade: set default transactions to read-only at servers start Denis Laxalde patch   apply success   appveyor success   cirrus/freebsd success   cirrus/linux success   cirrus/macos success
33/2839 possibility to rename root namespace in plpgsql Pavel Stehule patch

Please send feedback to thomas.munro-at-gmail.com.