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/2269 Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLES... Justin Pryzby, Alexey Kondratov 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/2574 Compatible defaults for LEAD/LAG Vik Fearing patch   apply success   appveyor success   travis success
30/2675 Covering SPGiST index Pavel Borisov 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/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
30/1677 New libpq option to prefer standby for connection Haribabu Kommi, Greg Nancarrow patch   apply success   appveyor success   travis success
30/2570 SEARCH and CYCLE clauses Peter Eisentraut patch   apply failure
30/2631 deferred primary key and logical replication Euler Taveira patch   apply success   appveyor success   travis success
30/2573 pg_dump - read data for some options from external file Pavel Stehule patch   apply success   appveyor success   travis success
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/2702 pg_read_all_data default role Stephen Frost patch   apply success   appveyor success   travis success
30/2112 range_agg / multiranges Paul Jungwirth patch   apply success   appveyor success   travis success
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/2786 "unix_socket_directories" should be GUC_LIST_INPUT? Ian Barwick patch   apply success   appveyor success   travis success (new)
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 success   appveyor success   travis success
30/2689 Add <<| and |>> operators for points Emre Hasegeli patch   apply success   appveyor success   travis success
30/2604 Add Information during standby recovery conflicts Bertrand Drouvot patch   apply success   appveyor success   travis success (new)
30/2576 Add LWLock blocker(s) information Bertrand Drouvot patch   apply success   appveyor success   travis success
30/2776 Add SELECT clause literals to queries section headers David Johnston patch   apply success   appveyor success   travis success
30/2758 Add `truncate` option to subscription commands David Christensen patch   apply failure
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/2772 Add formatter for INT64 output message in incremental sort code Haiying Tang 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/2665 Add section headings to index types doc Dagfinn Ilmari Mannsåker patch   apply failure (new)   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 success   appveyor success   travis success
30/2614 Add table expansion hook Erik Nordström patch   apply success   appveyor success   travis success
30/2541 Additional Chapter "Architecture" for Part "Tutorial" Jürgen Purtz patch   apply failure (new)   appveyor success   travis success
30/2780 Allow COPY "text" to output a header and add header matching mode to COPY FROM patch   apply success   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/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 success   appveyor success   travis success
30/2694 Automatic HASH and LIST partition creation Anastasia Lubennikova patch   apply success   appveyor success   travis success
30/2492 Autovacuum on partitioned tables Yuzuko Hosoya patch   apply success   appveyor success   travis success
30/2523 BRIN multi-minmax and bloom indexes Tomas Vondra patch   apply success   appveyor success   travis success
30/2706 Background writer and checkpointer in crash recovery Thomas Munro patch   apply success   appveyor success   travis success
30/2707 Boundary value check in lazy_tid_reaped() Masahiko Sawada patch   apply success   appveyor success   travis success
30/2779 Clarify temporary table name shadowing in CREATE TABLE David Johnston
30/2775 Clarify that signal function have no feedback David Johnston patch   apply success   appveyor success   travis success
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/1430 Custom signals and handlers for extension Maksim Milyutin, Alexey Kondratov patch   apply success   appveyor success   travis success
30/2751 Delay of standby shutdown Fujii Masao patch   apply success   appveyor success   travis success
30/2429 Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() Peter Geoghegan patch   apply success   appveyor success   travis success
30/2656 Display individual query in pg_stat_activity Bertrand Drouvot 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 success   appveyor success   travis success
30/2334 ECPG new statement: DECLARE STATEMENT Hayato Kuroda patch   apply success   appveyor success   travis success
30/2783 ENUM errdetail should mention bytes, not chars Ian Barwick patch   apply success   appveyor failure   travis failure
30/2621 Eliminate overheads in executing generic plans Amit Langote patch   apply failure
30/2433 Erase the distinctClause if the result is unique by definition Andy Fan patch   apply success   appveyor success   travis success
30/2069 Expose queryid in pg_stat_activity in log_line_prefix Julien Rouhaud patch   apply success   appveyor success   travis building
30/2421 Extended statistics improvements Tomas Vondra 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 failure   travis failure
30/2176 FETCH FIRST clause PERCENT option Surafel Temesgen 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/2710 Fix behavior of geo_ops when NaN is involved Kyotaro Horiguchi 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 failure   travis failure
30/2719 Fix checksum verification in base backups for zero page headers Michael Banck patch   apply success   appveyor success   travis success (new)
30/2685 Fix collation handling in postgres_fdw Tom Lane patch   apply success   appveyor success   travis success
30/2050 Fix unique join costings David Rowley patch   apply success   appveyor failure   travis failure
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/2553 GUC for BulkInsertState Justin Pryzby patch   apply failure (new)   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/2792 Hash support for row types Peter Eisentraut 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 (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/2449 Improve logging around restore_command Jeff Janes 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/2582 Improve planner cost estimations for alternative subplans Alexey Bashtanov 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 success   appveyor success   travis success
30/2777 Introduce view updating options more succinctly David Johnston patch   apply success   appveyor success   travis success
30/2616 Keep elog(ERROR) and ereport(ERROR) calls in the cold path David Rowley 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/2793 Move catalog toast table and index declarations Peter Eisentraut patch   apply success   appveyor success   travis success
30/2615 Non-volatile WAL buffer Takashi Menjo patch   apply failure
30/2369 Online checksums verification Julien Rouhaud patch   apply success   appveyor success   travis success
30/2319 Optimize dropping of relation buffers during recovery Kirk Jamison patch   apply success   appveyor failure   travis failure
30/2699 Optimizing NULL check on pkey column Surafel Temesgen patch   apply success   appveyor success   travis success
30/2575 Overhaul UPDATE/DELETE processing Amit Langote patch   apply failure
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   appveyor success   travis failure
30/2764 Possible memory leak in pgcrypto with EVP_MD_CTX Michael Paquier patch   apply success   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 (new)
30/2597 Problem with RETURNING and update tuple routing Amit Langote patch   apply failure
30/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   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/2686 Refactor pg_rewind code and make it work against a standby Heikki Linnakangas 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/2717 Reloptions for table access methods Jeff Davis patch   apply success   appveyor success   travis success
30/2579 Removal of currtid()/currtid2() and some table AM cleanup Michael Paquier patch   apply success   appveyor success   travis success
30/2753 Remove analyze script from pg_upgrade, replace with command instructions Magnus Hagander patch   apply failure
30/2113 Remove page-read callback from XLogReaderState Kyotaro Horiguchi 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/2522 Return ERROR on COMMIT instead of silently ROLLBACK Dave Cramer patch   apply success   appveyor success   travis failure
30/2771 Runtime Partition Prune code refactor Amit Langote patch   apply success   appveyor success   travis success
30/2749 Runtime control over CLOBBER_CACHE_ALWAYS for targeted debugging Craig Ringer patch   apply success   appveyor success   travis success
30/2630 SQL-standard function body Peter Eisentraut patch   apply failure
30/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply failure
30/2755 Skip ExecCheckRTPerms in CTAS with no data Bharath Rupireddy patch   apply success   appveyor success   travis success
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 failure
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/2592 Support for NSS as TLS backend Daniel Gustafsson patch   apply success   appveyor failure (new)   travis failure
30/2610 Support parallelism for copy command vignesh C, Bharath Rupireddy patch   apply success   appveyor success (new)   travis success (new)
30/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
30/2376 UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR John Dent patch   apply success   appveyor success   travis success
30/2757 Use B-Tree deduplication infrastructure to delete garbage index tuples caused by... Peter Geoghegan patch   apply success   appveyor success   travis success (new)
30/2718 Use USE_OPENSSL_RANDOM for OpenSSL random Daniel Gustafsson 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 (new)
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 failure
30/2770 Wrong statistics for size of XLOG_SWITCH during pg_waldump movead li patch   apply success   appveyor success   travis success
30/2768 abstract Unix-domain sockets Peter Eisentraut patch   apply success (new)   appveyor success   travis success
30/2787 allow partial union-all and improve parallel subquery costing Luc Vlaming 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/2644 avoid bitmapOR-ing indexes for scan conditions implied by partition constraint Konstantin Knizhnik, Justin Pryzby patch   apply success   appveyor success   travis success
30/2310 bitmaps and correlation Justin Pryzby patch   apply failure
30/2194 de-TOAST'ing using a iterator Xiao Bao patch   apply success   appveyor success   travis success
30/2748 enable pg_stat_statements to track rows processed by REFRESH MATERIALIZED VIEW yuta katsuragi patch   apply success   appveyor success   travis success
30/2684 enahncing 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/2307 extension patch of CREATE OR REPLACE TRIGGER Takamichi Osumi 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/2785 improve tableoid description Ian Barwick 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/2769 parallel distinct union and aggregate support patch bucoo hsiao patch   apply success   appveyor failure   travis failure
30/2081 parse time support function Pavel Stehule patch   apply success   appveyor success   travis success
30/2367 per-database-object collation version tracking Julien Rouhaud, Thomas Munro patch   apply success (new)   appveyor success   travis success
30/2794 pg_dump: independently restorable child partitions Justin Pryzby patch   apply success (new)   appveyor success (new)   travis failure (new)
30/2215 pg_upgrade fails with non-standard ACL Anastasia Lubennikova, Arthur Zakirov patch   apply success   appveyor success   travis success
30/2789 pg_upgrade: avoid failing if tablespace dirs exist and are empty 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/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki 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 failure
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 (new)
30/2715 remove spurious CREATE INDEX CONCURRENTLY wait Álvaro Herrera patch   apply success   appveyor success   travis success
30/2762 scram-sha-256 broken with FIPS and OpenSSL 1.0.2 (Switch SHA2 to use EVP for Ope... Michael Paquier patch   apply failure (new)   appveyor success   travis success
30/2790 select_common_typmod Peter Eisentraut 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 (new)   appveyor success   travis success
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
30/2791 warn_unused_result Peter Eisentraut patch   apply success   appveyor success   travis success

Waiting on Author

30/2714 ALTER TABLE .. DETACH PARTITION CONCURRENTLY Álvaro Herrera patch   apply failure (new)   appveyor success   travis failure
30/2491 Asynchronous Append on postgres_fdw nodes. Kyotaro Horiguchi patch   apply failure
30/2611 Enabling data checksums in an online cluster Magnus Hagander, Daniel Gustafsson patch   apply success   appveyor success   travis success
30/2601 Fast COPY FROM command for the foreign tables Andrey Lepikhov patch   apply failure
30/2738 Feature improvement for pg_stat_statements Naoki Nakamichi patch   apply success   appveyor success   travis success
30/2588 Hashjoin fall back to block nested hashloop join Melanie Plageman, Soumyadeep Chakraborty, Jesse Zhang, David Kimura patch   apply success   appveyor failure   travis failure
30/2742 Incorrect usages of PG_GETARG_UINT32 Ashutosh Bapat patch   apply success   appveyor success   travis success
30/2138 Incremental Materialized View Maintenance Yugo Nagata, takuma hoshiai patch   apply success   appveyor success   travis success
30/2681 Inserting DEFAULT into generated columns from VALUES RTE Mikhail Titov patch   apply success   appveyor success   travis failure
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 success
30/2701 PATCH: Attempt to make dbsize a bit more consistent Georgios Kokolatos patch   apply success   appveyor success   travis success
30/2620 POC: postgres_fdw insert batching patch   apply success   appveyor success   travis failure
30/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi 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/1712 Remove self join on a unique column Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov patch   apply success   appveyor success   travis success
30/2316 System Versioned Temporal Table Surafel Temesgen patch   apply success   appveyor failure   travis failure
30/2682 Various fixes for snapshot-too-old feature Robert Haas, Thomas Munro patch   apply success   appveyor success   travis success
30/2736 [PATCH] Add features to pg_stat_statements yuta katsuragi 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/2670 extend amcheck module to check heaps Mark Dilger patch   apply failure (new)   appveyor success   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/2661 implement LogicalDecodeMessageCB for pgoutput patch   apply failure
30/2535 pgbench - allow to test whether a variable exists (2) Fabien Coelho patch   apply success   appveyor success   travis success
30/2664 psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, ... Alexandra Pervushina patch   apply success   appveyor success   travis success

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