PostgreSQL Patch Tester

Here lives an experimental bot that does this: CommitfestGithub → ( 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

29/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
29/2009 COPY FREEZE, PD_VISIBLE_ALL and VM status Pavan Deolasee, Ibrar Ahmed patch   apply success   appveyor success   travis success
29/2675 Covering SPGiST index Pavel Borisov patch   apply success   appveyor success   travis success
29/2603 DROP relation IF EXISTS Docs and Tests - Bug Fix David Johnston patch   apply success   appveyor success   travis building
29/2138 Incremental Materialized View Maintenance Yugo Nagata, takuma hoshiai patch   apply failure   appveyor success   travis success
29/1677 New libpq option to prefer standby for connection Haribabu Kommi, Greg Nancarrow patch   apply success   appveyor success   travis success
29/2631 deferred primary key and logical replication Euler Taveira patch   apply success   appveyor success   travis success
29/2307 extension patch of CREATE OR REPLACE TRIGGER Takamichi Osumi patch   apply success   appveyor success   travis success
29/2573 pg_dump - read data for some options from external file Pavel Stehule patch   apply success   appveyor success   travis success
29/2377 pg_ls_* functions for showing metadata and recursing (pg_ls_tmpdir to show share... Justin Pryzby patch   apply success   appveyor success   travis success
29/2702 pg_read_all_data default role Stephen Frost patch   apply success   appveyor success   travis success
29/2562 speed up unicode normalization quick check John Naylor patch   apply success   appveyor success   travis success
29/2613 unicode unescape function Pavel Stehule patch   apply success   appveyor success   travis success

Needs review

29/2234 A hook for path-removal decision on add_path KaiGai Kohei patch   apply success   appveyor success   travis success
29/2602 ALTER SYSTEM READ { ONLY | WRITE } Amul Sul patch   apply success   appveyor success   travis success
29/2714 ALTER TABLE .. DETACH PARTITION CONCURRENTLY Álvaro Herrera patch   apply failure (new)   appveyor success   travis success
29/2608 Add and annotation to tags Dagfinn Ilmari Mannsåker patch   apply failure
29/2604 Add Information during standby recovery conflicts Bertrand Drouvot patch   apply success   appveyor success   travis success
29/2576 Add LWLock blocker(s) information Bertrand Drouvot patch   apply success   appveyor success   travis success
29/2654 Add a feature that enables row-wise comparison partition pruning sho kato patch   apply success   appveyor success   travis success
29/2639 Add session statistics to pg_stat_database Laurenz Albe patch   apply success   appveyor success   travis success
29/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply success   appveyor success   travis success
29/2614 Add table expansion hook Erik Nordström patch   apply success   appveyor success   travis success
29/2541 Additional Chapter "Architecture" for Part "Tutorial" Jürgen Purtz patch   apply success   appveyor success   travis success
29/2709 Allow CRL "directory" for crl_file Kyotaro Horiguchi patch   apply success   appveyor success   travis success
29/2158 Allow an alias to be attached directly to a JOIN ... USING Peter Eisentraut patch   apply success   appveyor success   travis success
29/2646 Allow terminating the idle sessions Japin Li patch   apply success   appveyor success   travis success
29/2249 Asymmetric partition-wise JOIN KaiGai Kohei patch   apply success   appveyor success   travis success
29/2491 Asynchronous Append on postgres_fdw nodes. Kyotaro Horiguchi patch   apply failure (new)   appveyor success   travis success
29/2492 Autovacuum on partitioned tables Yuzuko Hosoya patch   apply success   appveyor success   travis success
29/2523 BRIN multi-minmax and bloom indexes Tomas Vondra patch   apply success (new)   appveyor success (new)   travis success (new)
29/2706 Background writer and checkpointer in crash recovery Thomas Munro patch   apply success   appveyor success   travis success
29/2707 Boundary value check in lazy_tid_reaped() Masahiko Sawada patch   apply success   appveyor success (new)   travis success
29/2645 Bug 16419 Doc and Test Adds David Johnston patch   apply success   appveyor success   travis success
29/2705 Choose AlternativeSubPlan alternative within the planner Tom Lane patch   apply success   appveyor success   travis success
29/2574 Compatible defaults for LEAD/LAG Vik Fearing patch   apply success   appveyor success   travis success
29/2545 Confusing list foreign table options in psql - Fixing slash usage text Hamid Akhtar patch   apply success   appveyor success   travis success
29/2518 Corruption during WAL replay Teja Mupparti patch   apply success   appveyor success   travis success
29/2429 Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() Peter Geoghegan patch   apply success   appveyor success   travis success
29/2454 Document concurrent index builds waiting on each other James Coleman patch   apply success   appveyor success   travis success
29/2698 Dumping/restoring fails on inherited generated column Masahiko Sawada patch   apply success   appveyor success   travis success
29/2334 ECPG new statement: DECLARE STATEMENT Hayato Kuroda patch   apply success   appveyor success   travis success
29/2621 Eliminate overheads in executing generic plans Amit Langote patch   apply success   appveyor success   travis success
29/2433 Erase the distinctClause if the result is unique by definition Andy Fan patch   apply success   appveyor success   travis success
29/2277 Executor code refactoring around result relations Amit Langote patch   apply success   appveyor success   travis success
29/2069 Expose queryid in pg_stat_activity in log_line_prefix Julien Rouhaud patch   apply success   appveyor success   travis success
29/2421 Extended statistics improvements Tomas Vondra patch   apply success   appveyor success   travis success
29/2658 Fix autovac for large number of tables Kasahara Tatsuhito patch   apply success   appveyor success   travis success
29/2710 Fix behavior of geo_ops when NaN is involved Kyotaro Horiguchi patch   apply success   appveyor success   travis success
29/2719 Fix checksum verification in base backups for zero page headers Michael Banck patch   apply success   appveyor success   travis success
29/2685 Fix collation handling in postgres_fdw Tom Lane patch   apply success   appveyor success   travis success
29/2050 Fix unique join costings David Rowley patch   apply success   appveyor failure   travis failure
29/2266 Fix up partitionwise join on how equi-join conditions between the partition keys... Richard Guo patch   apply success   appveyor success   travis success
29/2553 GUC for BulkInsertState Justin Pryzby patch   apply success (new)   appveyor success   travis success
29/2402 GUC to disable cancellation of awaiting for synchronous replication Andrey Borodin patch   apply success   appveyor success   travis success
29/2669 Handing SLRU sync work over to the checkpointer Thomas Munro patch   apply failure (new)   appveyor success   travis success
29/2569 Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley patch   apply success   appveyor success   travis failure
29/2218 Implement INSERT SET syntax Gareth Palmer patch   apply success   appveyor success   travis success
29/2489 Improve handling of parameter differences in physical replication Peter Eisentraut patch   apply success   appveyor success   travis success
29/2449 Improve logging around restore_command Jeff Janes patch   apply success   appveyor success   travis success
29/2582 Improve planner cost estimations for alternative subplans Alexey Bashtanov patch   apply success   appveyor success   travis success
29/2642 Improvements in Copy From vignesh C patch   apply success   appveyor success   travis success
29/1741 Index Skip Scan Dmitry Dolgov, Thomas Munro, Jesper Pedersen patch   apply success   appveyor success   travis success
29/2616 Keep elog(ERROR) and ereport(ERROR) calls in the cold path David Rowley patch   apply success (new)   appveyor success   travis success
29/2490 Make message at end-of-recovery less scary Kyotaro Horiguchi patch   apply success   appveyor success   travis success
29/2369 Online checksums verification Julien Rouhaud patch   apply success   appveyor success   travis success
29/2319 Optimize dropping of relation buffers during recovery Kirk Jamison patch   apply success   appveyor success   travis success
29/2699 Optimizing NULL check on pkey column Surafel Temesgen patch   apply success   appveyor success   travis success
29/2575 Overhaul UPDATE/DELETE processing Amit Langote patch   apply success   appveyor success   travis success
29/2620 POC: postgres_fdw insert batching patch   apply success   appveyor success   travis failure
29/2724 Pipelining/batch mode support for libpq Craig Ringer, Matthieu Garrigues patch   apply success   appveyor failure (new)   travis failure
29/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor success   travis failure
29/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   appveyor success   travis success
29/2674 Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration Michael Paquier patch   apply success   appveyor success (new)   travis success (new)
29/2452 Reduce WaitEventSet system call spam Thomas Munro patch   apply success   appveyor success   travis success
29/2717 Reloptions for table access methods Jeff Davis patch   apply success   appveyor success   travis success
29/2579 Removal of currtid()/currtid2() and some table AM cleanup Michael Paquier patch   apply success   appveyor success   travis success
29/2630 SQL-standard function body Peter Eisentraut patch   apply failure (new)   appveyor success   travis failure
29/2370 Split StdRdOptions into HeapOptions and ToastOptions Nikolay Shaplov patch   apply success   appveyor success   travis success
29/2026 Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) Noah Misch patch   apply failure
29/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
29/2592 Support for NSS as TLS backend Daniel Gustafsson patch   apply failure
29/2703 Support for OUT parameters in procedures Peter Eisentraut patch   apply success   appveyor success (new)   travis success
29/2610 Support parallelism for copy command vignesh C, Bharath Rupireddy patch   apply success (new)   appveyor success   travis success
29/2316 System Versioned Temporal Table Surafel Temesgen patch   apply failure (new)   appveyor success   travis failure
29/2376 UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR John Dent patch   apply success   appveyor success   travis success
29/2718 Use USE_OPENSSL_RANDOM for OpenSSL random Daniel Gustafsson patch   apply success   appveyor success   travis success
29/2386 Using multicolumn statistics for more precise join selectivity estimatation Konstantin Knizhnik patch   apply success   appveyor success   travis success
29/2682 Various fixes for snapshot-too-old feature Robert Haas, Thomas Munro patch   apply success   appveyor success (new)   travis success
29/2410 WAL prefetch (another approach) Thomas Munro patch   apply success (new)   appveyor success (new)   travis success (new)
29/2539 allow to set a pager for psql's watch command Pavel Stehule patch   apply success   appveyor success   travis success
29/2637 audo-detect and use -moutline-atomics compilation flag for aarch64 Tsahi Zidenberg patch   apply success   appveyor success   travis success
29/2644 avoid bitmapOR-ing partition indexes with unnecessarily scan conditions Konstantin Knizhnik, Justin Pryzby patch   apply success   appveyor failure   travis failure
29/2310 bitmaps and correlation Justin Pryzby patch   apply success   appveyor success   travis success
29/2194 de-TOAST'ing using a iterator Xiao Bao patch   apply success   appveyor success   travis success
29/2684 enahncing plpgsql API for debugging and tracing Pavel Stehule patch   apply success   appveyor success   travis success
29/2670 extend amcheck module to check heaps Mark Dilger patch   apply success   appveyor failure   travis failure
29/2716 fix spinlock contention in LogwrtResult Álvaro Herrera patch   apply success   appveyor success   travis success
29/2482 jsonpath syntax extensions Nikita Glukhov patch   apply success   appveyor success   travis success (new)
29/2081 parse time support function Pavel Stehule patch   apply success   appveyor success   travis success
29/2367 per-database-object collation version tracking Julien Rouhaud, Thomas Munro patch   apply success   appveyor success (new)   travis success (new)
29/2215 pg_upgrade fails with non-standard ACL Anastasia Lubennikova, Arthur Zakirov patch   apply success   appveyor success   travis success
29/2557 pgbench - add a synchronization barrier when starting Fabien Coelho patch   apply success   appveyor success   travis success
29/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor success   travis success
29/2535 pgbench - allow to test whether a variable exists (2) Fabien Coelho patch   apply success   appveyor success   travis success
29/2313 pgbench - refactor init functions with buffers Fabien Coelho patch   apply success   appveyor success   travis success
29/2697 possibility to write window function in PL languages (like PLpgSQL) Pavel Stehule patch   apply success   appveyor success   travis success
29/2650 postgres_fdw connection caching enable/disable or timeout feature Bharath Rupireddy patch   apply success   appveyor failure   travis success
29/2536 psql - possibility to specify where status row should be displayed Pavel Stehule patch   apply success   appveyor success   travis success
29/2664 psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, ... Alexandra Pervushina patch   apply success   appveyor success   travis success
29/2112 range_agg / multiranges Paul Jungwirth patch   apply success (new)   appveyor success (new)   travis success (new)
29/2559 reduce memory requirements of PLpgSQL CALL statement Pavel Stehule patch   apply success   appveyor success   travis success
29/2715 remove spurious CREATE INDEX CONCURRENTLY wait Álvaro Herrera patch   apply success   appveyor success   travis success
29/2657 shared tempfile was not removed on statement_timeout Justin Pryzby patch   apply success   appveyor success   travis success
29/2161 standby recovery fails when re-replaying due to missing directory which was remo... Kyotaro Horiguchi, Paul Guo patch   apply success   appveyor success   travis success
29/2474 truncating timestamps on arbitrary intervals John Naylor patch   apply success   appveyor success   travis success
29/2688 update ps display for recovery checkpoint Justin Pryzby patch   apply success   appveyor success   travis success

Waiting on Author

29/2689 Add <<| and |>> operators for points Emre Hasegeli patch   apply success   appveyor success   travis success
29/2713 Add information about generic/custom plan to pg_stat_statements Atsushi Torikoshi patch   apply success   appveyor success   travis failure
29/2668 Add information to rm_redo_error_callback() Bertrand Drouvot patch   apply success   appveyor success   travis success
29/2665 Add section headings to index types doc Dagfinn Ilmari Mannsåker patch   apply success   appveyor success   travis success
29/1919 Add timeline to partial WAL segments David Steele patch   apply success   appveyor success   travis success
29/2660 Adding Support for Copy callback functionality on COPY TO api Bilva Sanaba patch   apply success   appveyor success   travis success
29/2504 Allow COPY "text" to output a header and add header matching mode to COPY FROM Rémi Lapeyre patch   apply success   appveyor success   travis success
29/2648 Allow queries in WHEN expression of FOR EACH STATEMENT triggers Joe Wildish patch   apply success   appveyor success   travis failure
29/2694 Automatic HASH and LIST partition creation Anastasia Lubennikova patch   apply success   appveyor failure (new)   travis failure (new)
29/2581 Batch processing of RI checks Antonin Houska, Corey Huinker patch   apply success   appveyor success   travis success
29/2542 Binary search in ScalarArrayOpExpr for OR'd constant arrays James Coleman patch   apply success   appveyor success   travis success
29/2635 Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX .... Marina Polyakova, Anna Akenteva patch   apply failure
29/2679 Change return type of EXTRACT to numeric Peter Eisentraut patch   apply failure
29/2656 Display individual query in pg_stat_activity Bertrand Drouvot patch   apply failure
29/2611 Enabling data checksums in an online cluster Magnus Hagander, Daniel Gustafsson patch   apply success   appveyor success   travis success (new)
29/2176 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply failure (new)   appveyor success   travis success
29/2601 Fast COPY FROM command for the foreign tables Andrey Lepikhov patch   apply success (new)   appveyor success   travis success
29/1062 Generic type subscripting Dmitry Dolgov patch   apply success (new)   appveyor success   travis success
29/2711 Get memory contexts of an arbitrary backend process Atsushi Torikoshi patch   apply success   appveyor success   travis failure
29/2588 Hashjoin fall back to block nested hashloop join Melanie Plageman, Soumyadeep Chakraborty, Jesse Zhang, David Kimura patch   apply success   appveyor failure   travis failure
29/2628 Implement for window functions Vik Fearing patch   apply failure   appveyor success   travis failure
29/2509 Improve standby connection denied error message James Coleman patch   apply success   appveyor success   travis success
29/2681 Inserting DEFAULT into generated columns from VALUES RTE Mikhail Titov patch   apply success   appveyor success   travis failure
29/2501 JIT expression evaluation improvements Andres Freund patch   apply failure
29/2196 KMS - Internal key management system Masahiko Sawada, Ibrar Ahmed, Insung Moon patch   apply failure
29/1977 Ltree syntax improvement Dmitry Belyavsky patch   apply success   appveyor success   travis failure
29/772 Make async slave to wait for lsn to be replayed Ivan Kartyshov patch   apply failure (new)   appveyor success   travis success
29/2627 More scalable multixacts buffers and locking Kyotaro Horiguchi, Andrey Borodin patch   apply success   appveyor success   travis success
29/2693 New statistics for tuning WAL buffer size Masahiro Ikeda patch   apply success   appveyor building   travis building
29/2701 PATCH: Attempt to make dbsize a bit more consistent Georgios Kokolatos patch   apply success   appveyor failure   travis failure
29/2652 Prefer explicit JOIN syntax over (old) implicit syntax in tutorial Jürgen Purtz patch   apply success   appveyor success   travis success
29/2708 Prepare for deprecate clientcert=no-verify in pg_hba.conf Kyotaro Horiguchi patch   apply failure
29/2597 Problem with RETURNING and update tuple routing Amit Langote patch   apply failure (new)   appveyor success   travis success
29/2584 REINDEX/CIC/CLUSTER of partitioned tables Justin Pryzby patch   apply success   appveyor success   travis success
29/2686 Refactor pg_rewind code and make it work against a standby Heikki Linnakangas patch   apply success (new)   appveyor success   travis success
29/2113 Remove page-read callback from XLogReaderState Kyotaro Horiguchi patch   apply success   appveyor success   travis success
29/1712 Remove self join on a unique column Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov patch   apply success   appveyor success   travis success
29/2663 Remove useless distinct clauses Pierre Ducroquet patch   apply success   appveyor success   travis failure
29/2634 Replace spinlock with lwlock in pg_stat_statements Fujii Masao patch   apply success   appveyor success   travis success
29/2651 Retry Cached Remote Connections for postgres_fdw in case remote backend gets kil... Bharath Rupireddy patch   apply success   appveyor success   travis success
29/2522 Return ERROR on COMMIT instead of silently ROLLBACK Dave Cramer patch   apply success   appveyor success   travis failure
29/2570 SEARCH and CYCLE clauses Peter Eisentraut patch   apply success   appveyor success   travis success
29/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply failure
29/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
29/2048 WIP: Temporal primary and foreign keys Paul Jungwirth patch   apply failure
29/2189 Windows could not stat file - over 4GB Juanjo Santamaria Flecha patch   apply success (new)   appveyor success   travis success
29/2520 archive status ".ready" files may be created too early Nathan Bossart patch   apply failure
29/2219 document that psql's FETCH_COUNT does not work with combined (\;) queries Fabien Coelho patch   apply success   appveyor success   travis success
29/2624 fix (partially) pgbench :variable substitution for -M extended and prepared Fabien Coelho patch   apply success   appveyor success   travis success
29/2349 global temporary table wenjing zeng patch   apply success   appveyor success   travis success
29/2661 implement LogicalDecodeMessageCB for pgoutput patch   apply failure
29/2692 list of extended statistics on psql Tatsuro Yamada patch   apply success   appveyor success (new)   travis success (new)
29/2600 pg_dump --where option Surafel Temesgen, Carter Thaxton patch   apply failure (new)   appveyor success   travis success
29/2096 psql - add SHOW_ALL_RESULTS option Fabien Coelho patch   apply success   appveyor success   travis failure
29/1608 schema variables, LET command Pavel Stehule patch   apply failure (new)   appveyor success   travis success

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