PostgreSQL Patch Tester

Here lives an experimental bot that does this: Commitfest → Github → ( AppVeyor, Travis ). You can find a report for the current CF, the next CF or individual patch authors.

News: Some information about this project can be seen in these slides from PGCon 2018. TL;DR: the plan discussed with the pginfra team is to integrate this into the Commitfest application. May take some time, but watch this space.

Ready for Committer

30/2614 Add table expansion hook Erik Nordström patch   apply success   appveyor success   travis success
30/2269 Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLES... Justin Pryzby, Alexey Kondratov patch   apply success (new)   appveyor success   travis success
30/2694 Automatic HASH and LIST partition creation Anastasia Lubennikova patch   apply success   appveyor success   travis success
30/2009 COPY FREEZE, PD_VISIBLE_ALL and VM status Pavan Deolasee, Ibrar Ahmed patch   apply success   appveyor success   travis success
30/2603 DROP relation IF EXISTS Docs and Tests - Bug Fix David Johnston patch   apply success   appveyor success   travis success
30/2334 ECPG new statement: DECLARE STATEMENT Hayato Kuroda patch   apply success   appveyor success   travis success
30/2747 Extending the range operators so they can cope with range element and eleme... Esteban Zimanyi patch   apply success   appveyor success   travis success
30/2719 Fix checksum verification in base backups for zero page headers Michael Banck patch   apply failure
30/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
30/2767 Release disk space for large relations sooner Thomas Munro patch   apply success   appveyor success   travis success
30/2570 SEARCH and CYCLE clauses Peter Eisentraut patch   apply success (new)   appveyor failure   travis failure
30/2310 bitmap cost should account for correlated indexes Justin Pryzby patch   apply success   appveyor success   travis success
30/2803 cleanup temporary files after crash Euler Taveira patch   apply success   appveyor success   travis success
30/2702 pg_read_all_data default role Stephen Frost patch   apply success   appveyor success   travis success
30/2215 pg_upgrade fails with non-standard ACL Anastasia Lubennikova, Arthur Zakirov patch   apply success   appveyor success   travis success
30/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor success   travis success
30/2112 range_agg / multiranges Paul Jungwirth patch   apply failure
30/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor success   travis success
30/2613 unicode unescape function Pavel Stehule patch   apply success   appveyor success   travis success

Needs review

30/2750 (ALTER SYSTEM) SET +=/-= operator support Abhijit Menon-Sen patch   apply success   appveyor success   travis success
30/2234 A hook for path-removal decision on add_path KaiGai Kohei patch   apply success   appveyor success   travis success
30/2602 ALTER SYSTEM READ { ONLY | WRITE } Amul Sul patch   apply failure (new)   appveyor failure   travis success
30/2604 Add Information during standby recovery conflicts Bertrand Drouvot patch   apply success   appveyor success   travis success
30/2654 Add a feature that enables row-wise comparison partition pruning sho kato patch   apply success   appveyor success   travis success
30/2765 Add extra statistics to explain for Nested Loop Ekaterina Sokolova patch   apply success   appveyor success   travis success
30/2713 Add information about generic/custom plan to pg_stat_statements Atsushi Torikoshi patch   apply success   appveyor success   travis success
30/2639 Add session statistics to pg_stat_database Laurenz Albe patch   apply success   appveyor success   travis success
30/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply failure
30/2541 Additional Chapter "Architecture" for Part "Tutorial" Jürgen Purtz patch   apply success   appveyor success   travis success
30/2780 Allow COPY "text" to output a header and add header matching mode to COPY FROM patch   apply failure   appveyor success   travis success
30/2709 Allow CRL "directory" for crl_file Kyotaro Horiguchi patch   apply success   appveyor success   travis success
30/2158 Allow an alias to be attached directly to a JOIN ... USING Peter Eisentraut patch   apply success   appveyor success   travis success
30/2491 Asynchronous Append on postgres_fdw nodes. Kyotaro Horiguchi patch   apply success   appveyor success   travis success
30/2492 Autovacuum on partitioned tables Yuzuko Hosoya patch   apply success   appveyor success   travis failure
30/2523 BRIN multi-minmax and bloom indexes Tomas Vondra patch   apply failure   appveyor success   travis success
30/2706 Background writer and checkpointer in crash recovery Thomas Munro patch   apply success   appveyor success   travis success
30/2757 Bottom-up index deletion (targets old duplicate versions from non-HOT updates) Peter Geoghegan patch   apply failure (new)   appveyor success   travis success
30/2707 Boundary value check in lazy_tid_reaped() Masahiko Sawada patch   apply success   appveyor success   travis success
30/2800 CLUSTER on partitioned table Justin Pryzby patch   apply success   appveyor success   travis failure
30/2815 CREATE INDEX CONCURRENTLY on partitioned table Justin Pryzby patch   apply failure
30/2675 Covering SPGiST index Pavel Borisov patch   apply success   appveyor failure   travis failure
30/2805 DROP INDEX CONCURRENTLY on partitioned index Justin Pryzby patch   apply success   appveyor success   travis success
30/2454 Document concurrent index builds waiting on each other James Coleman patch   apply success   appveyor success   travis success
30/2698 Dumping/restoring fails on inherited generated column Masahiko Sawada patch   apply failure
30/2621 Eliminate overheads in executing generic plans Amit Langote patch   apply failure   appveyor success   travis success
30/2611 Enabling data checksums in an online cluster Magnus Hagander, Daniel Gustafsson patch   apply success   appveyor success   travis success
30/2433 Erase the distinctClause if the result is unique by definition Andy Fan patch   apply failure
30/2069 Expose queryid in pg_stat_activity and log_line_prefix Julien Rouhaud patch   apply success   appveyor success   travis success
30/2421 Extended statistics improvements Tomas Vondra patch   apply success   appveyor success   travis success
30/2176 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis success
30/2738 Feature improvement for pg_stat_statements Naoki Nakamichi patch   apply success   appveyor success   travis success
30/2658 Fix autovac for large number of tables Kasahara Tatsuhito patch   apply success   appveyor success   travis success
30/2754 Fix broken query with gather merge paths added in incremental sort patch James Coleman patch   apply success   appveyor success   travis success
30/2685 Fix collation handling in postgres_fdw Tom Lane patch   apply success   appveyor success   travis success
30/2266 Fix up partitionwise join on how equi-join conditions between the partition keys... Richard Guo patch   apply success   appveyor success   travis success
30/2774 Further note require activity aspect of automatic checkpoint and archiving David Johnston patch   apply success   appveyor success   travis success
30/1651 GROUP BY optimization Fedor Sigaev, Pavel Borisov patch   apply success   appveyor success   travis success
30/2402 GUC to disable cancellation of awaiting for synchronous replication Andrey Borodin patch   apply success   appveyor success   travis success
30/2711 Get memory contexts of an arbitrary backend process Atsushi Torikoshi patch   apply success   appveyor success   travis success
30/2569 Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley patch   apply success   appveyor success   travis success
30/2553 INSERT SELECT: BulkInsertState and table_multi_insert Justin Pryzby patch   apply success   appveyor success   travis failure (new)
30/2218 Implement INSERT SET syntax Gareth Palmer patch   apply success   appveyor success   travis success
30/2489 Improve handling of parameter differences in physical replication Peter Eisentraut patch   apply success   appveyor success   travis success
30/2728 Improve pg_dump dumping publication tables John Hsu patch   apply success   appveyor success   travis success
30/2795 Improve replay pause dilip kumar patch   apply success   appveyor success   travis success
30/2509 Improve standby connection denied error message James Coleman patch   apply success   appveyor success   travis success
30/1741 Index Skip Scan Dmitry Dolgov, Thomas Munro, Jesper Pedersen patch   apply failure
30/2777 Introduce view updating options more succinctly David Johnston patch   apply success   appveyor success   travis success
30/2490 Make message at end-of-recovery less scary Kyotaro Horiguchi patch   apply success   appveyor success   travis success
30/2778 Minor variable related cleanup and rewording of plpgsql docs David Johnston patch   apply success   appveyor success   travis success
30/2807 New wal_level to disable WAL logging Takamichi Osumi patch   apply success   appveyor success   travis success
30/2615 Non-volatile WAL buffer Takashi Menjo patch   apply success (new)   appveyor failure   travis failure
30/2810 OpenSSL 3.0.0 compatibility Daniel Gustafsson patch   apply success   appveyor success   travis success
30/2699 Optimizing NULL check on pkey column Surafel Temesgen patch   apply failure (new)   appveyor success   travis success
30/2575 Overhaul UPDATE/DELETE processing Amit Langote patch   apply success   appveyor success   travis success
30/2701 PATCH: Attempt to make dbsize a bit more consistent Georgios Kokolatos patch   apply success   appveyor success   travis success
30/2752 Parameters for initdb and pg_upgrade to avoid printing next-step instructions Magnus Hagander patch   apply success   appveyor success   travis success
30/2724 Pipelining/batch mode support for libpq Craig Ringer, Matthieu Garrigues patch   apply success (new)   appveyor success   travis success
30/2652 Prefer explicit JOIN syntax over (old) implicit syntax in tutorial Jürgen Purtz patch   apply success   appveyor success   travis success
30/2597 Problem with RETURNING and update tuple routing Amit Langote patch   apply success   appveyor success   travis success
30/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply failure (new)   appveyor success   travis success
30/2733 Reduce PostmasterIsAlive() checks during recovery Thomas Munro patch   apply success   appveyor success   travis success
30/2452 Reduce WaitEventSet system call spam Thomas Munro patch   apply success   appveyor success   travis success
30/2717 Reloptions for table access methods Jeff Davis patch   apply success   appveyor success   travis success
30/2113 Remove page-read callback from XLogReaderState Kyotaro Horiguchi patch   apply success   appveyor success   travis success
30/1712 Remove self join on a unique column Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov patch   apply success   appveyor success   travis success
30/2781 Replace polyphase merge with a simple k-way balanced merge Heikki Linnakangas patch   apply success   appveyor success   travis success
30/2771 Runtime Partition Prune code refactor Amit Langote patch   apply success   appveyor success   travis success
30/2630 SQL-standard function body Peter Eisentraut patch   apply success   appveyor success   travis success
30/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply failure
30/2370 Split StdRdOptions into HeapOptions and ToastOptions Nikolay Shaplov patch   apply success   appveyor success   travis success
30/2026 Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) Noah Misch patch   apply success   appveyor success   travis success
30/2592 Support for NSS as TLS backend Daniel Gustafsson patch   apply failure
30/2610 Support parallelism for copy command vignesh C, Bharath Rupireddy patch   apply failure (new)   appveyor success   travis success
30/2316 System Versioned Temporal Table Surafel Temesgen patch   apply failure (new)   appveyor success   travis failure
30/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply success (new)   appveyor success   travis success
30/2376 UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR John Dent patch   apply success   appveyor success   travis success
30/2756 Use standard SIGHUP and/or SIGTERM handlers in autoprewarm, startup, syslogger a... Fujii Masao, Bharath Rupireddy patch   apply success   appveyor success   travis success
30/2386 Using multicolumn statistics for more precise join selectivity estimatation Konstantin Knizhnik patch   apply success   appveyor success   travis success
30/2410 WAL prefetch (another approach) Thomas Munro patch   apply success   appveyor success   travis success
30/2770 Wrong statistics for size of XLOG_SWITCH during pg_waldump movead li patch   apply success   appveyor building   travis building
30/2787 allow partial union-all and improve parallel subquery costing Luc Vlaming patch   apply success   appveyor success   travis success
30/2802 allow restore_command to be changed with reload Sergei Kornilov patch   apply success   appveyor success   travis success
30/2539 allow to set a pager for psql's watch command Pavel Stehule patch   apply success   appveyor success   travis success
30/2799 automatic analyze: add "avg read rate" log message Jakub Wartak patch   apply success   appveyor success   travis success
30/2813 custom compression methods for toast Ildus Kurbangaliev patch   apply success   appveyor failure   travis failure
30/2684 enhancing plpgsql API for debugging and tracing Pavel Stehule patch   apply success   appveyor success   travis success
30/2766 explain: show JIT details in non-text format, even if zero Justin Pryzby patch   apply success   appveyor success   travis success
30/2482 jsonpath syntax extensions Nikita Glukhov patch   apply success   appveyor success   travis success
30/2773 libpq compression Konstantin Knizhnik patch   apply success   appveyor failure   travis failure
30/2081 parse time support function Pavel Stehule patch   apply success   appveyor success   travis success
30/2697 possibility to write window function in PL languages (like PLpgSQL) Pavel Stehule patch   apply success   appveyor success   travis success
30/2650 postgres_fdw connection caching enable/disable or timeout feature Bharath Rupireddy patch   apply success   appveyor success   travis success
30/2620 postgres_fdw insert batching Takayuki Tsunakawa patch   apply success   appveyor failure (new)   travis failure (new)
30/2812 protocol default result formats setting Peter Eisentraut patch   apply success   appveyor success   travis success
30/2536 psql - possibility to specify where status row should be displayed Pavel Stehule patch   apply success   appveyor success   travis success
30/2788 psql \df choose functions by their arguments Greg Sabino Mullane patch   apply success   appveyor failure   travis failure
30/2806 remove pg_standby Justin Pryzby patch   apply failure (new)   appveyor success   travis failure
30/2715 remove spurious CREATE INDEX CONCURRENTLY wait Álvaro Herrera patch   apply success (new)   appveyor success   travis success (new)
30/2762 scram-sha-256 broken with FIPS and OpenSSL 1.0.2 (Switch SHA2 to use EVP for Ope... Michael Paquier patch   apply success   appveyor success   travis success
30/2657 shared tempfile was not removed on statement_timeout Justin Pryzby patch   apply success   appveyor success   travis success
30/2161 standby recovery fails when re-replaying due to missing directory which was remo... Kyotaro Horiguchi, Paul Guo patch   apply failure
30/2474 truncating timestamps on arbitrary intervals John Naylor patch   apply success   appveyor success   travis success
30/2688 update ps display for recovery checkpoint Justin Pryzby patch   apply success   appveyor success   travis success

Waiting on Author

30/2714 ALTER TABLE .. DETACH PARTITION CONCURRENTLY Álvaro Herrera patch   apply success   appveyor success   travis success
30/2646 Allow terminating the idle sessions Japin Li patch   apply success   appveyor success   travis success
30/2249 Asymmetric partition-wise JOIN KaiGai Kohei patch   apply failure
30/2545 Confusing list foreign table options in psql - Fixing slash usage text Hamid Akhtar patch   apply success   appveyor success   travis success
30/2730 Corner-case bug in pg_rewind Ian Barwick patch   apply success   appveyor success   travis success
30/2518 Corruption during WAL replay Teja Mupparti patch   apply success   appveyor success   travis success
30/2656 Display individual query in pg_stat_activity Bertrand Drouvot patch   apply failure
30/2601 Fast COPY FROM command for the foreign tables Andrey Lepikhov patch   apply failure (new)   appveyor success   travis success
30/2710 Fix behavior of geo_ops when NaN is involved Kyotaro Horiguchi patch   apply success   appveyor success   travis success
30/2050 Fix unique join costings David Rowley patch   apply success   appveyor failure   travis failure
30/2742 Incorrect usages of PG_GETARG_UINT32 Ashutosh Bapat patch   apply success (new)   appveyor success   travis success
30/2138 Incremental Materialized View Maintenance Yugo Nagata, takuma hoshiai patch   apply success   appveyor success   travis success (new)
30/772 Make async slave to wait for lsn to be replayed Ivan Kartyshov patch   apply success   appveyor success   travis success
30/2627 More scalable multixacts buffers and locking Kyotaro Horiguchi, Andrey Borodin patch   apply success   appveyor success   travis failure
30/1677 New libpq option to prefer standby for connection Haribabu Kommi, Greg Nancarrow patch   apply failure (new)   appveyor success   travis success
30/2319 Optimize dropping of relation buffers during recovery Kirk Jamison patch   apply success   appveyor success   travis success
30/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
30/2817 Reduce the number of special cases to build contrib modules on windows David Rowley patch   apply success   appveyor success   travis success
30/2732 Reduce the time required for a database recovery from archive. Anna Akenteva, Dmitry Shulga, Ivan Taranov patch   apply failure
30/2522 Return ERROR on COMMIT instead of silently ROLLBACK Dave Cramer patch   apply success   appveyor success   travis failure
30/2749 Runtime control over CLOBBER_CACHE_ALWAYS for targeted debugging Craig Ringer patch   apply success   appveyor success   travis success
30/2676 Start WAL streaming as early as possible, without waiting for startup process to... Asim Rama Praveen, Hao Wu patch   apply success   appveyor success   travis success
30/2682 Various fixes for snapshot-too-old feature Robert Haas, Thomas Munro patch   apply success   appveyor success   travis success
30/2520 archive status ".ready" files may be created too early Nathan Bossart patch   apply success   appveyor success   travis success
30/2644 avoid bitmapOR-ing indexes for scan conditions implied by partition constraint Justin Pryzby, Soumyadeep Chakraborty, Soumyadeep Chakraborty patch   apply success   appveyor success   travis success
30/2631 deferred primary key and logical replication Euler Taveira patch   apply success   appveyor success   travis success
30/2670 extend amcheck module to check heaps Mark Dilger patch   apply success   appveyor failure   travis success
30/2624 fix (partially) pgbench :variable substitution for -M extended and prepared Fabien Coelho patch   apply success   appveyor success   travis success
30/2716 fix spinlock contention in LogwrtResult Álvaro Herrera patch   apply success   appveyor success   travis success
30/2782 function pg_setting_value_split() to parse shared_preload_libraries etc. Ian Barwick patch   apply success   appveyor failure   travis failure
30/2349 global temporary table wenjing zeng patch   apply failure
30/2661 implement LogicalDecodeMessageCB for pgoutput Dave Cramer patch   apply success   appveyor success   travis success
30/2801 list of extended statistics on psql Tatsuro Yamada patch   apply success   appveyor success   travis success
30/2769 parallel distinct union and aggregate support patch bucoo hsiao patch   apply failure
30/2573 pg_dump - read data for some options from external file Pavel Stehule patch   apply success   appveyor success   travis success
30/2794 pg_dump: independently restorable child partitions Justin Pryzby patch   apply success   appveyor success   travis failure
30/2377 pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ... Justin Pryzby patch   apply success   appveyor success   travis success
30/2557 pgbench - add a synchronization barrier when starting Fabien Coelho patch   apply success   appveyor success   travis success
30/2535 pgbench - allow to test whether a variable exists (2) Fabien Coelho patch   apply success   appveyor success   travis success
30/2798 remove deprecated v8.2 containment operators Justin Pryzby patch   apply failure

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