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

28/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
28/2491 Asynchronous Append on postgres_fdw nodes. Kyotaro Horiguchi patch   apply success   appveyor success   travis success
28/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
28/1947 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success (new)   appveyor success   travis success
28/2369 Online checksums verification Julien Rouhaud patch   apply failure (new)   appveyor success   travis success
28/2514 expose parallel leader in CSV and log_line_prefix Justin Pryzby patch   apply success   appveyor success   travis success
28/2558 loop over unbound cursor Pavel Stehule patch   apply success   appveyor success   travis success
28/1608 schema variables, LET command Pavel Stehule patch   apply success (new)   appveyor success   travis success

Needs review

28/2234 A hook for path-removal decision on add_path KaiGai Kohei patch   apply success   appveyor success   travis success
28/2602 ALTER SYSTEM READ { ONLY | WRITE } Amul Sul patch   apply failure
28/2608 Add and annotation to tags Dagfinn Ilmari Mannsåker patch   apply failure (new)   appveyor success   travis success
28/2576 Add LWLock blocker(s) information Bertrand Drouvot patch   apply success   appveyor success   travis success
28/2426 Add MAIN_RELATION_CLEANUP and TOAST_TABLE_CLEANUP options to VACUUM Nathan Bossart patch   apply success   appveyor success   travis success
28/2243 Add index AM callback to adjust opfamily member dependencies Tom Lane patch   apply success   appveyor success   travis success
28/2599 Add missing cross-links in system catalog documentation Dagfinn Ilmari Mannsåker patch   apply failure (new)   appveyor success   travis success
28/2525 Add missing libraries to Libs.private of libpq.pc
28/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply success   appveyor success   travis success
28/2587 Add support for choosing huge page size Odin Ugedal patch   apply success   appveyor success   travis success
28/2614 Add table expansion hook Erik Nordström patch   apply success   appveyor success   travis success
28/2504 Allow COPY "text" to output a header and add header matching mode to COPY FROM Rémi Lapeyre patch   apply failure
28/2158 Allow an alias to be attached directly to a JOIN ... USING Peter Eisentraut patch   apply success   appveyor success   travis success
28/2519 Allow backslash continuations in "pg_hba.conf' files Fabien Coelho patch   apply success   appveyor success   travis success
28/2568 Allow parallel restore of pg_dump written to stdout (or other unseekable file wi... David Gilman patch   apply success (new)   appveyor success   travis success (new)
28/2543 Allow pg_stat_statements track the total number of rows affected by utility comm... Fujii Masao patch   apply success   appveyor success   travis success
28/2591 Auto-vectorization speeds up multiplication of large-precision numerics Amit Khandekar patch   apply success   appveyor success   travis success
28/2364 Autovacuum: vacuum tables in descending order of xid_age David Fetter patch   apply success   appveyor success   travis success
28/2523 BRIN multi-minmax and bloom indexes Tomas Vondra patch   apply success   appveyor success (new)   travis success (new)
28/2581 Batch processing of RI checks Antonin Houska, Corey Huinker patch   apply success   appveyor success   travis success
28/2542 Binary search in ScalarArrayOpExpr for OR'd constant arrays James Coleman patch   apply success   appveyor success   travis success
28/2511 Btree BackwardScan race condition on Standby during VACUUM Michail Nikolaev patch   apply success   appveyor success   travis success
28/2606 Cache relation sizes in recovery Thomas Munro patch   apply success   appveyor success   travis success
28/2578 Command statistics system Haribabu Kommi, Mark Dilger patch   apply success   appveyor success   travis success
28/2548 Comment simplehash/dynahash trade-offs James Coleman patch   apply success   appveyor success   travis success
28/2574 Compatible defaults for LEAD/LAG Vik Fearing patch   apply success   appveyor success   travis success
28/2518 Corruption during WAL replay Teja Mupparti patch   apply success   appveyor success   travis success
28/2603 DROP relation IF EXISTS Docs and Tests - Bug Fix David Johnston patch   apply success   appveyor success   travis success
28/2429 Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() Peter Geoghegan patch   apply success   appveyor success   travis success
28/2454 Document concurrent index builds waiting on each other James Coleman patch   apply success   appveyor success   travis success
28/2334 ECPG new statement: DECLARE STATEMENT Hayato Kuroda patch   apply success   appveyor success   travis success
28/2621 Eliminate overheads in executing generic plans Amit Langote patch   apply failure (new)   appveyor success   travis success
28/2611 Enabling data checksums in an online cluster Magnus Hagander, Daniel Gustafsson patch   apply success   appveyor success   travis success
28/2433 Erase the distinctClause if the result is unique by definition Andy Fan patch   apply success   appveyor success   travis success
28/2069 Expose queryid in pg_stat_activity in log_line_prefix Julien Rouhaud patch   apply success   appveyor success   travis success
28/2421 Extended statistics improvements Tomas Vondra patch   apply success   appveyor success   travis success
28/2176 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply failure
28/2601 Fast COPY FROM command for the foreign tables Andrey Lepikhov patch   apply success   appveyor success   travis success
28/2527 Fast DSM segments Thomas Munro patch   apply success   appveyor success   travis success
28/2050 Fix unique join costings David Rowley patch   apply success   appveyor failure   travis failure
28/2266 Fix up partitionwise join on how equi-join conditions between the partition keys... Richard Guo patch   apply success   appveyor success   travis success
28/2556 Fix wrong results for text search queries with NOT Tom Lane, Pavel Borisov patch   apply success   appveyor success   travis success
28/2622 Function for exposing memory usage of local backend process Fujii Masao, atsushi torikoshi patch   apply success   appveyor success   travis success
28/2402 GUC to disable cancellation of awaiting for synchronous replication Andrey Borodin patch   apply success   appveyor success   travis success
28/2276 GiST sorting build Andrey Borodin patch   apply success   appveyor success   travis success (new)
28/2588 Hashjoin fall back to block nested hashloop join Melanie Plageman, Jesse Zhang, David Kimura patch   apply success   appveyor success   travis success
28/2569 Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley patch   apply success   appveyor success   travis success (new)
28/2553 INSERT SELECT to use a BulkInsertState Justin Pryzby patch   apply success   appveyor success   travis success
28/2218 Implement INSERT SET syntax Gareth Palmer patch   apply success   appveyor success   travis success
28/2609 Improve I/O pattern for parallel seqscan David Rowley, Thomas Munro patch   apply success   appveyor success   travis success
28/2489 Improve handling of parameter differences in physical replication Peter Eisentraut patch   apply failure (new)   appveyor success   travis success
28/2449 Improve logging around restore_command Jeff Janes patch   apply success   appveyor success   travis success
28/2582 Improve planner cost estimations for alternative subplans Alexey Bashtanov patch   apply success   appveyor success   travis success
28/2509 Improve standby connection denied error message James Coleman patch   apply success   appveyor success   travis success
28/2138 Incremental Materialized View Maintenance Yugo Nagata, takuma hoshiai patch   apply success   appveyor success   travis success
28/1741 Index Skip Scan Dmitry Dolgov, Thomas Munro, Jesper Pedersen patch   apply success (new)   appveyor success   travis success (new)
28/2594 Infinities in type numeric Tom Lane patch   apply success   appveyor success   travis success
28/2501 JIT expression evaluation improvements Andres Freund patch   apply failure
28/2196 KMS - Internal key management system Masahiko Sawada, Ibrar Ahmed, Insung Moon patch   apply success   appveyor failure   travis failure
28/2616 Keep elog(ERROR) and ereport(ERROR) calls in the cold path David Rowley patch   apply failure
28/772 Make async slave to wait for lsn to be replayed Ivan Kartyshov patch   apply success   appveyor success   travis success
28/2490 Make mesage at end-of-recovery less scary Kyotaro Horiguchi patch   apply success   appveyor success   travis success
28/2605 Mark btree_gist functions as PARALLEL SAFE Steven Winfield patch   apply success   appveyor success   travis success
28/2565 More tests with USING INDEX replident and dropped indexes Michael Paquier patch   apply success   appveyor success   travis success
28/2160 Multi insert in CTAS/MatView Paul Guo, Taylor Vesely patch   apply failure
28/1677 New libpq option to prefer standby for connection Haribabu Kommi, Greg Nancarrow patch   apply success   appveyor success   travis failure (new)
28/2615 Non-volatile WAL buffer Takashi Menjo patch   apply failure (new)   appveyor failure   travis success
28/2319 Optimize dropping of relation buffers using dlist Kirk Jamison patch   apply success   appveyor success   travis success
28/2575 Overhaul UPDATE/DELETE processing Amit Langote patch   apply failure (new)   appveyor success   travis success
28/2620 POC: postgres_fdw insert batching patch   apply success   appveyor success   travis failure
28/2597 Problem with RETURNING and update tuple routing Amit Langote patch   apply success   appveyor success   travis success
28/2607 Progress reporting for COPY command Josef Šimánek patch   apply success   appveyor success   travis success
28/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor success   travis success
28/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   appveyor success   travis success
28/2441 Rational number type (fractions) Joe Nelson patch   apply failure
28/2330 Reducing memory usage of creating foreign key between partitioned tables sho kato patch   apply success   appveyor success   travis failure (new)
28/2579 Removal of currtid()/currtid2() and some table AM cleanup Michael Paquier patch   apply success   appveyor success   travis success
28/2540 Remove non-fast promotion Fujii Masao patch   apply success   appveyor success   travis success
28/2113 Remove page-read callback from XLogReaderState Kyotaro Horiguchi patch   apply success   appveyor success   travis success
28/1712 Remove self join on a unique column Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov patch   apply success   appveyor success   travis success
28/1995 Replica with large recovery_min_apply_delay is not receiving changes from master... Konstantin Knizhnik patch   apply failure
28/2522 Return ERROR on COMMIT instead of silently ROLLBACK Dave Cramer patch   apply failure
28/2570 SEARCH and CYCLE clauses Peter Eisentraut patch   apply success   appveyor success   travis success
28/790 SQL statements statistics counter view (pg_stat_sql) Haribabu Kommi patch   apply success   appveyor success   travis success
28/2630 SQL-standard function body Peter Eisentraut patch   apply success   appveyor success   travis failure
28/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply failure (new)   appveyor failure   travis failure
28/2370 Split StdRdOptions into HeapOptions and ToastOptions Nikolay Shaplov patch   apply success   appveyor success   travis success
28/2026 Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) Noah Misch patch   apply failure
28/2498 Startup Centralization Mike Palmiotto, Yulian Khodorkovskiy patch   apply failure
28/2592 Support for NSS as TLS backend Daniel Gustafsson patch   apply failure (new)   appveyor failure   travis failure
28/2610 Support parallelism for copy command vignesh C, Bharath Rupireddy patch   apply success (new)   appveyor success   travis success
28/2585 SyncRepLock acquired exclusively in default configuration Fujii Masao, Masahiko Sawada patch   apply success   appveyor success   travis success
28/2316 System Versioned Temporal Table Surafel Temesgen patch   apply failure
28/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply success   appveyor success   travis success
28/2376 UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR John Dent patch   apply success   appveyor success   travis success
28/2560 Use MinimalTuple in TupleQueue, with one fewer copy Thomas Munro patch   apply success   appveyor success   travis success
28/2471 Use heap_multi_insert()s for catalog insertions Daniel Gustafsson patch   apply success   appveyor success   travis success
28/2386 Using multicolumn statistics for more precise join selectivity estimatation Konstantin Knizhnik patch   apply success   appveyor success   travis success
28/2410 WAL prefetch (another approach) Thomas Munro patch   apply failure (new)   appveyor success   travis success
28/2048 WIP: Temporal primary and foreign keys Paul Jungwirth patch   apply failure
28/2189 Windows could not stat file - over 4GB Juanjo Santamaria Flecha patch   apply success   appveyor success   travis success
28/2539 allow to set a pager for psql's watch command Pavel Stehule patch   apply success   appveyor success   travis success
28/2520 archive status ".ready" files may be created too early Nathan Bossart patch   apply failure (new)   appveyor success   travis success
28/2310 bitmaps and correlation Justin Pryzby patch   apply success   appveyor success   travis success (new)
28/2194 de-TOAST'ing using a iterator Xiao Bao patch   apply success   appveyor success   travis success
28/2631 deferred primary key and logical replication Euler Taveira patch   apply failure
28/2219 document that psql's FETCH_COUNT does not work with combined (\;) queries Fabien Coelho patch   apply success   appveyor success   travis success
28/2307 extension patch of CREATE OR REPLACE TRIGGER Takamichi Osumi patch   apply success   appveyor success   travis success
28/2624 fix (partially) pgbench :variable substitution for -M extended and prepared Fabien Coelho patch   apply success   appveyor success (new)   travis success (new)
28/2349 global temporary table wenjing zeng patch   apply failure
28/2482 jsonpath syntax extensions Nikita Glukhov patch   apply success   appveyor success   travis success
28/1927 logical streaming for large in-progress transactions Amit Kapila, Tomas Vondra, Petr Jelínek, dilip kumar patch   apply failure
28/2081 parse time support function Pavel Stehule patch   apply success   appveyor success   travis success
28/2367 per-database-object collation version tracking Julien Rouhaud, Thomas Munro patch   apply success   appveyor success   travis success
28/2573 pg_dump - read data for some options from external file Pavel Stehule patch   apply success   appveyor success   travis success
28/2600 pg_dump --where option Surafel Temesgen, Carter Thaxton patch   apply success   appveyor success   travis failure
28/2629 pg_dump: refactoring of dumpFunc() and dumpAgg() Peter Eisentraut patch   apply success   appveyor success   travis success
28/2377 pg_ls_tmpdir to show shared filesets Justin Pryzby patch   apply success   appveyor success   travis failure
28/2215 pg_upgrade fails with non-standard ACL Anastasia Lubennikova, Arthur Zakirov patch   apply success   appveyor success   travis success
28/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success (new)   appveyor success   travis success (new)
28/2535 pgbench - allow to test whether a variable exists (2) Fabien Coelho patch   apply success   appveyor success   travis success
28/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor success   travis success
28/2236 pgbench - improve variable management performance Fabien Coelho patch   apply failure
28/2313 pgbench - refactor init functions with buffers Fabien Coelho patch   apply success (new)   appveyor success   travis success
28/2096 psql - add SHOW_ALL_RESULTS option Fabien Coelho patch   apply success   appveyor success   travis failure
28/2536 psql - possibility to specify where status row should be displayed Pavel Stehule patch   apply success   appveyor success   travis success
28/2586 psql: Include access method in listTables output Georgios Kokolatos patch   apply success   appveyor success   travis success
28/2112 range_agg / multiranges Paul Jungwirth patch   apply failure (new)   appveyor success   travis failure
28/2571 record whether plans are generic or custom Kyotaro Horiguchi, atsushi torikoshi patch   apply success   appveyor success   travis success
28/2559 reduce memory requirments of PLpgSQL CALL statement Pavel Stehule patch   apply success   appveyor success   travis success
28/2384 skip empty transactions for logical replication Euler Taveira patch   apply success   appveyor success   travis success
28/2562 speed up unicode normalization quick check John Naylor patch   apply success   appveyor success   travis success
28/2538 split string to table Pavel Stehule patch   apply success   appveyor success   travis success
28/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
28/2474 truncating timestamps on arbitrary intervals John Naylor patch   apply success   appveyor success   travis success
28/2613 unicode unescape function Pavel Stehule patch   apply success   appveyor success   travis success
28/2430 vacuum verbose: show pages marked allvisible/frozen/hintbits Justin Pryzby patch   apply success   appveyor success   travis success
28/2515 vacuum: cost-based delay: wait event, and report in vacuum verbose Justin Pryzby patch   apply failure
28/2419 window function improvements WIP Krasiyan Andreev patch   apply failure

Waiting on Author

28/1883 Add Hook Functions for Disk Quota Extension Haozhou Wang, Hubert Zhang, Hao Wu patch   apply success   appveyor success   travis failure
28/2604 Add Information during standby recovery conflicts Bertrand Drouvot patch   apply success   appveyor success   travis success
28/2332 Add accumulated statistics for wait event Yoshikazu Imai patch   apply failure
28/2152 Add the capability to logical replication to transfer base types using binary Dave Cramer patch   apply success   appveyor success (new)   travis success (new)
28/2299 Add uri percent-encoding for binary data Anders Åstrand patch   apply failure
28/2541 Additional Chapter "Architecture" for Part "Tutorial" Jürgen Purtz patch   apply failure (new)   appveyor success   travis success
28/2249 Asymmetric partition-wise JOIN KaiGai Kohei patch   apply failure
28/2492 Autovacuum on partitioned tables Yuzuko Hosoya patch   apply success   appveyor success   travis failure
28/2067 Built-in connection proxy Konstantin Knizhnik patch   apply success   appveyor success   travis success
28/2009 COPY FREEZE, PD_VISIBLE_ALL and VM status Pavan Deolasee, Ibrar Ahmed patch   apply success   appveyor success   travis failure
28/2545 Confusing list foreign table options in psql - Fixing slash usage text Hamid Akhtar patch   apply success   appveyor success   travis success
28/2567 Default gucs for EXPLAIN Vik Fearing patch   apply success   appveyor success   travis success
28/2277 Executor code refactoring around result relations Amit Langote patch   apply failure
28/2461 Fix PGXS so built control files work with VPATH builds Craig Ringer patch   apply success   appveyor success   travis failure
28/2308 Fix base backup checksum verification for random or zero page headers Michael Banck patch   apply failure
28/2444 Identifying user-created objects Masahiko Sawada patch   apply success   appveyor failure   travis failure
28/2628 Implement for window functions Vik Fearing patch   apply success   appveyor success   travis failure
28/2500 Improving connection scalability: GetSnapshotData() Andres Freund patch   apply failure
28/1977 Ltree syntax improvement Dmitry Belyavsky patch   apply success   appveyor success   travis failure
28/2627 More scalable multixacts buffers and locking Kyotaro Horiguchi, Andrey Borodin patch   apply failure
28/2632 Performance Improvement For Copy From Binary Files Amit Langote, vignesh C, Bharath Rupireddy patch   apply success   appveyor success (new)   travis success (new)
28/2584 REINDEX/CIC/CLUSTER of partitioned tables Justin Pryzby patch   apply success   appveyor success   travis success
28/2452 Reduce WaitEventSet system call spam Thomas Munro patch   apply failure
28/2533 Report error position for CREATE/ATTACH PARTITION bounds check Amit Langote, Ashwin Agrawal, Alexandra Wang patch   apply failure
28/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
28/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
28/2378 Set host(no)ssl settings from initdb David Fetter patch   apply failure
28/2612 TAP tests and symlinks on Windows Michael Paquier patch   apply success   appveyor success   travis success
28/2499 TRUNCATE on foreign tables KaiGai Kohei patch   apply failure
28/2526 Use internal pthreads reimplementation only when building with MSVC Sandro Mani patch   apply success   appveyor success   travis success
28/2550 Using Valgrind to detect buffer accesses without a pin or buffer Peter Geoghegan patch   apply success   appveyor success   travis success
28/2412 [doc] vacuum full, fillfactor, and "extra space" Justin Pryzby patch   apply success   appveyor success   travis success
28/2428 explain to report bucket and memory stats for TupleHashTable nodes Justin Pryzby patch   apply failure
28/2557 pgbench - add a syncrhonization barrier when starting Fabien Coelho patch   apply success   appveyor success   travis building
28/2262 psql - improve code coverage Fabien Coelho patch   apply failure

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