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

23/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply success   appveyor success   travis success
23/2151 Allow table AM's to cache stuff in relcache Heikki Linnakangas patch   apply success   appveyor success   travis success
23/2076 Change ereport level for QueuePartitionConstraintValidation Sergei Kornilov patch   apply success   appveyor success   travis success
23/2051 DOC: Document encode() and decode() base64 encoding Karl Pinc patch   apply success   appveyor success   travis success
23/2055 DROP DATABASE FORCE Pavel Stehule, Filip Rembiałkowski patch   apply success   appveyor success   travis success
23/1993 Speed up transaction completion faster after many relations are accessed in a tr... David Rowley, Takayuki Tsunakawa patch   apply success   appveyor success   travis success
23/2163 allow to set log_statement_sample_limit - maximal duration for sampling Pavel Stehule patch   apply success   appveyor success   travis success
23/2178 pg_receivewal Jesper Pedersen patch   apply success   appveyor success   travis success
23/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor success   travis success
23/2086 pgbench - extend initialization phase control Fabien Coelho patch   apply success   appveyor success   travis success

Needs review

23/1883 Add Hook Functions for Disk Quota Extension Haozhou Wang, Hubert Zhang, Hao Wu patch   apply success   appveyor success   travis success
23/1489 Add enum relation option type Nikolay Shaplov patch   apply success   appveyor success   travis success
23/2152 Add the capability to logical replication to transfer base types using binary Dave Cramer patch   apply success   appveyor success   travis success
23/1553 Advanced partition matching for partition-wise join Etsuro Fujita, Ashutosh Bapat patch   apply success   appveyor success   travis success
23/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... Konstantin Knizhnik patch   apply success   appveyor success   travis success
23/2098 Avoid duplication of code to read XLOG page Antonin Houska patch   apply failure
23/2071 Avoid full GIN index scan when possible Julien Rouhaud patch   apply success   appveyor building   travis building
23/2141 Avoiding deadlock errors in CREATE INDEX CONCURRENTLY Dhruv Goel patch   apply success   appveyor success   travis success
23/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply success   appveyor failure   travis failure
23/1774 Block level parallel vacuum Masahiko Sawada patch   apply success   appveyor success   travis success
23/2043 Bloom index cost model Jeff Janes patch   apply success   appveyor success   travis failure
23/2067 Built-in connection proxy Konstantin Knizhnik patch   apply success   appveyor failure   travis failure (new)
23/1863 Cleaning up orphaned files using undo logs Thomas Munro patch   apply failure
23/2129 Cleanup and speedup string functions David Rowley patch   apply success   appveyor success   travis success
23/2020 Convert NOT IN to anti-joins when possible David Rowley patch   apply success   appveyor success   travis success
23/1294 Custom compression methods Ildus Kurbangaliev patch   apply success   appveyor failure   travis failure
23/2104 Data at rest encryption Antonin Houska, Ants Aasma patch   apply success   appveyor failure   travis failure
23/2063 Data-only mode for pg_rewind Chris Travers patch   apply failure
23/2187 Duplicated LSN in ReorderBuffer Ildar Musin patch   apply success   appveyor success   travis success
23/1664 Evaluate immutable functions during planning (in FROM clause) Alexander Kuzmenkov, Aleksandr Parfenov patch   apply failure
23/2069 Expose queryid in pg_stat_activity in log_line_prefix Julien Rouhaud patch   apply success   appveyor success   travis success
23/1844 FETCH FIRST clause WITH TIES option Surafel Temesgen patch   apply success   appveyor success   travis success
23/2003 Fix Deadlock Issue in Single User Mode When IO Failure Occurs Chengchao Yu patch   apply success   appveyor success   travis success
23/2103 Fix failure of identity columns if there is a second sequence OWNED BY the colum... Laurenz Albe patch   apply success   appveyor success   travis success
23/2128 Fix issues with "x SIMILAR TO y ESCAPE NULL" Tom Lane patch   apply success   appveyor success   travis success
23/2179 Fix support for hypothetical indexes using BRIN access method Julien Rouhaud patch   apply success   appveyor success   travis success
23/2050 Fix unique join costings David Rowley patch   apply success   appveyor success   travis success
23/2028 Flexible partition pruning hook Mike Palmiotto patch   apply success   appveyor success   travis success
23/2155 Formatting of warning about using ident Daniel Gustafsson patch   apply success   appveyor success   travis success
23/1062 Generic type subscripting Dmitry Dolgov patch   apply failure
23/1695 Global shared meta cache Takeshi Ideriha patch   apply failure
23/1947 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success   appveyor success (new)   travis success (new)
23/2102 Improve Append/MergeAppend EXPLAIN output when all subplans are pruned. David Rowley patch   apply failure
23/2140 Improve search for missing parent downlinks in amcheck Alexander Korotkov patch   apply failure (new)   appveyor success   travis success
23/2138 Incremental Materialized View Maintenance Yugo Nagata patch   apply success   appveyor failure   travis failure
23/2124 Introduce spgist quadtree @<(point,circle) operator Matwey V. Kornilov patch   apply success   appveyor success   travis success (new)
23/1804 KNN for B-tree Nikita Glukhov patch   apply success   appveyor failure   travis failure
23/1934 Log bind parameter values on error Alexey Bashtanov patch   apply success   appveyor success   travis success
23/2171 Logging corruption error codes Andrey Borodin patch   apply success   appveyor success   travis success
23/1672 Make installcheck-world in a clean environment Alexander Lakhin patch   apply success   appveyor success   travis success
23/2082 Mingw: Fix import library extension, build actual static libraries Sandro Mani patch   apply success   appveyor success   travis success
23/2160 Multi insert in CTAS/MatView Paul Guo, Taylor Vesely patch   apply success   appveyor success   travis success
23/2023 NOT IN to ANTI JOIN transformation James Finnerty, Zheng Li patch   apply success   appveyor failure   travis failure
23/2053 NOTIFY options + COLLAPSE (make deduplication optional) Filip Rembiałkowski patch   apply success   appveyor failure   travis failure
23/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply success   appveyor success   travis success
23/2183 Opclass parameters Nikita Glukhov patch   apply success   appveyor failure   travis failure
23/2011 Optimization of some jsonb functions Nikita Glukhov patch   apply failure
23/2180 Optimize pglz compression Andrey Borodin, Владимир Лесков patch   apply success   appveyor success   travis success
23/2147 Parallel grouping sets Richard Guo patch   apply success   appveyor success   travis success
23/1999 Planning counters in pg_stat_statements Fujii Masao, Julien Rouhaud, Thomas Munro, PAscal L patch   apply success   appveyor success   travis success
23/2087 Problem during Windows service start Ramanarayana M patch   apply success   appveyor success   travis success
23/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor failure   travis success
23/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply success   appveyor success   travis success
23/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   appveyor success   travis success
23/2154 Race conditions with TAP test for syncrep Michael Paquier patch   apply success   appveyor success   travis success
23/2126 Rearrange postmaster startup order to improve logging behavior Tom Lane patch   apply success   appveyor success   travis success
23/2174 Reduce size of core scanner transition array John Naylor patch   apply success   appveyor success   travis success
23/2169 Remove HeapTuple and Buffer dependency for predicate locking functions Ashwin Agrawal patch   apply success   appveyor success   travis success
23/2113 Remove page-read callback from XLogReaderState Kyotaro Horiguchi patch   apply success   appveyor success   travis success
23/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply success   appveyor failure   travis failure
23/1995 Replica with large recovery_min_apply_delay is not receiving changes from master... Konstantin Knizhnik patch   apply failure
23/2173 Run-time pruning for ModifyTable David Rowley patch   apply success   appveyor success   travis success
23/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor success (new)   travis success (new)
23/2166 Shared Memory Context Takeshi Ideriha patch   apply success   appveyor failure   travis success
23/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply success   appveyor success   travis success
23/2025 SimpleLruTruncate() mutual exclusion (data loss from lack thereof) Noah Misch patch   apply success   appveyor success   travis success
23/2145 Speedup truncates of relation forks Kirk Jamison patch   apply success   appveyor success   travis success
23/2026 Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) Noah Misch patch   apply success   appveyor success   travis success
23/2133 Support for jsonpath .datetime() method Alexander Korotkov, Nikita Glukhov patch   apply success   appveyor success   travis success
23/1961 Synchronizing slots from primary to standby Petr Jelínek patch   apply failure
23/1755 Tid range scan Edmund Horner patch   apply failure
23/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
23/2093 Trigger autovacuum on tuple insertion Darafei Praliaskouski patch   apply success   appveyor success   travis success
23/2106 Two new options for pg_rewind (1. Ensure clean shutdown 2. Add recovery conf inf... Ashwin Agrawal, Paul Guo, Jimmy Yih patch   apply success   appveyor success   travis success
23/2062 Unaccent extension python script Issue in Windows Hugh Ranalli, Ramanarayana M patch   apply success   appveyor success   travis success
23/1649 Undo logs dilip kumar, Thomas Munro patch   apply failure
23/1828 Undo worker and transaction rollback Amit Kapila, dilip kumar, mithun cy, Rafia Sabih patch   apply failure
23/2125 Use heap_multi_insert for catalog relations Daniel Gustafsson patch   apply success   appveyor success   travis failure
23/2119 Use memcpy in pglz decompression Andrey Borodin, Владимир Лесков patch   apply success   appveyor success   travis success
23/2048 WIP: Temporal primary and foreign keys Paul Jungwirth patch   apply failure
23/2061 [WIP] Show a human-readable n_distinct in pg_stats view Maxence Ahlouche patch   apply success   appveyor success   travis success
23/2045 [WIP] Temporal query processing with range types - Temporal Normalization Peter Moser, Anton Dignös patch   apply failure
23/2191 allow_system_table_mods stuff Peter Eisentraut patch   apply success   appveyor success   travis success
23/1800 amcheck verification for GiST Andrey Borodin patch   apply success   appveyor success   travis success
23/1911 anycompatible and anycompatiblearray polymorphic types Pavel Stehule patch   apply success   appveyor success   travis success
23/2192 base backup client as auxiliary backend process Peter Eisentraut patch   apply success   appveyor failure   travis success
23/2186 conflict handling for COPY FROM Surafel Temesgen patch   apply success   appveyor success   travis success
23/2194 de-TOAST'ing using a iterator Xiao Bao patch   apply success   appveyor success   travis success
23/1796 documenting signal handling with readme Chris Travers patch   apply success   appveyor success   travis success
23/2177 errbacktrace Peter Eisentraut patch   apply success   appveyor success   travis success
23/2054 fix for BUG #3720: wrong results at using ltree Filip Rembiałkowski patch   apply success   appveyor success   travis success
23/2077 fix pgbench -R hanging on pg11 Fabien Coelho patch   apply success   appveyor success   travis building
23/2172 fsync error handling in pg_receivewal, pg_recvlogical Peter Eisentraut patch   apply success   appveyor success   travis success
23/1769 libpq host/hostaddr consistency Fabien Coelho patch   apply success   appveyor success   travis success
23/1854 libpq trace log Aya Iwata patch   apply success   appveyor success   travis success
23/2110 make \d pg_toast.foo show its indices, and the associated non-toast table, and \... Justin Pryzby patch   apply success   appveyor success   travis success
23/2114 make libpq documentation navigable between functions Fabien Coelho patch   apply success   appveyor success   travis success
23/1896 online change primary_conninfo Sergei Kornilov patch   apply success   appveyor success   travis success
23/2081 parse time support function Pavel Stehule patch   apply success   appveyor success   travis success
23/2018 pg_basebackup to adjust existing data directory permissions Haribabu Kommi patch   apply failure
23/1849 pg_rewind: options to use restore_command from recovery.conf or command line Alexey Kondratov patch   apply success   appveyor success   travis success
23/2095 pg_upgrade version and path checking Daniel Gustafsson patch   apply success   appveyor success   travis success
23/2091 pgbench - add \aset to store results of combined queries (\;) Fabien Coelho patch   apply success   appveyor success   travis success
23/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor success   travis success
23/2090 pgbench - implement strict TPC-B benchmark Fabien Coelho patch   apply success   appveyor success   travis success
23/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
23/2044 propagating replica identity to partitions Álvaro Herrera patch   apply failure
23/2096 psql - add SHOW_ALL_RESULTS option Fabien Coelho patch   apply success   appveyor success   travis success
23/2188 psql - sort by size Pavel Stehule patch   apply success   appveyor success   travis success
23/2168 run collation tests by default Peter Eisentraut patch   apply success   appveyor success   travis success
23/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor success   travis success
23/2175 socket_timeout in interfaces/libpq Ryohei Nagaura patch   apply success   appveyor success   travis success
23/2064 src/test/modules/dummy_index -- way to test reloptions from inside of access met... Nikolay Shaplov patch   apply success   appveyor success   travis failure
23/2161 standby recovery fails when re-replaying due to missing directory which was remo... Kyotaro Horiguchi, Paul Guo patch   apply success   appveyor success   travis failure
23/2060 suppress errors thrown by to_reg*() takuma hoshiai patch   apply success   appveyor success   travis success
23/2120 tableam vs. TOAST Robert Haas patch   apply success   appveyor success   travis success (new)
23/2170 using explicit_bzero Peter Eisentraut patch   apply success   appveyor success   travis success
23/2148 vacuumlo: report the number of large objects going to be removed Timur Birsh patch   apply success   appveyor success   travis success

Waiting on Author

23/2190 ALTER STATISTICS ... SET STATISTICS ... Tomas Vondra patch   apply success   appveyor success   travis success
23/2130 ALTER TABLE restructuring Tom Lane patch   apply success   appveyor success   travis success
23/2146 Add CREATE DATABASE LOCALE option Peter Eisentraut patch   apply success   appveyor success   travis success
23/1882 Add client connection check during the execution of the query Sergey Cherkashin patch   apply success   appveyor failure   travis success
23/2193 Add parallelism and glibc dependent only options to reindexdb Julien Rouhaud patch   apply success (new)   appveyor success   travis success
23/2158 Allow an alias to be attached directly to a JOIN ... USING Peter Eisentraut patch   apply success   appveyor success   travis success
23/2078 Compile from source using latest Microsoft Windows SDK Peifeng Qiu patch   apply success   appveyor success   travis success (new)
23/2088 Contribution to Perldoc for TestLib module in Postgres Ramanarayana M patch   apply failure
23/2176 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis success
23/2144 Fix runtime errors from -fsanitize=undefined Peter Eisentraut patch   apply success   appveyor success   travis success
23/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply failure
23/1741 Index Skip Scan Dmitry Dolgov, Thomas Munro, Jesper Pedersen patch   apply success   appveyor success   travis success
23/944 Logical decoding of two-phase transactions Nikhil Sontakke patch   apply failure
23/1977 Ltree syntax improvement Dmitry Belyavsky patch   apply success   appveyor success   travis success
23/2105 Make pg_waldump and xact_desc() report the detail information like GID about PRE... Fujii Masao patch   apply success   appveyor success   travis success
23/2135 Optimized partial TOAST decompression Xiao Bao patch   apply success   appveyor success   travis success
23/2108 Parallel-aware file_fdw Thomas Munro patch   apply success   appveyor success   travis success
23/2029 Problem with default partition pruning Yuzuko Hosoya patch   apply success   appveyor success   travis success
23/2142 Reduce overhead of NOTIFY with many databases Martijn van Oosterhout patch   apply success   appveyor success   travis success
23/1975 Referential Integrity Checks with Statement Level Triggers Corey Huinker patch   apply failure
23/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply failure
23/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor success   travis success
23/1991 SortSupport implementation on inet/cdir Brandur Leach patch   apply failure
23/1970 Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (ver... daisuke higuchi patch   apply success   appveyor success   travis success
23/1976 \describe: verbose commands in psql Corey Huinker patch   apply failure
23/2109 accounting for memory used for BufFile during hash joins Tomas Vondra patch   apply success   appveyor success   travis failure
23/2034 extension patch of CREATE OR REPLACE TRIGGER Takamichi Osumi patch   apply success   appveyor success (new)   travis success (new)
23/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply success   appveyor success   travis success
23/2162 initdb: Change authentication defaults Peter Eisentraut patch   apply success   appveyor success   travis success
23/2094 libpq - improve PQexec documentation Fabien Coelho patch   apply success   appveyor success   travis success
23/1927 logical streaming for large in-progress transactions Tomas Vondra, Petr Jelínek patch   apply failure
23/2164 progress report for ANALYZE Álvaro Herrera patch   apply success   appveyor success   travis success
23/2112 range_agg Paul Jungwirth patch   apply success   appveyor failure   travis failure
23/2185 relative rpath Peter Eisentraut patch   apply success   appveyor success   travis failure
23/2099 share string to *int64 functions Fabien Coelho patch   apply success   appveyor success   travis success
23/2167 unlogged sequences Peter Eisentraut patch   apply success   appveyor success   travis success

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