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

25/2069 Expose queryid in pg_stat_activity in log_line_prefix Julien Rouhaud patch   apply success   appveyor success   travis success
25/2176 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis success
25/1844 FETCH FIRST clause WITH TIES option Surafel Temesgen patch   apply success   appveyor success   travis success
25/2191 allow_system_table_mods stuff Peter Eisentraut patch   apply success   appveyor success   travis success
25/2091 pgbench - add \aset to store results of combined queries (\;) Fabien Coelho patch   apply success   appveyor success   travis success
25/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor success   travis success
25/2086 pgbench - extend initialization phase control Fabien Coelho patch   apply success   appveyor success   travis success
25/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
25/2096 psql - add SHOW_ALL_RESULTS option Fabien Coelho patch   apply success   appveyor success   travis success

Needs review

25/2234 A hook for path-removal decision on add_path KaiGai Kohei patch   apply success   appveyor success   travis success
25/2208 Add --include-foreign-data option to pg_dump to dump the data of foreign tables Luis M Carril patch   apply success   appveyor success   travis success
25/2305 Add A Glossary Corey Huinker patch   apply success   appveyor success   travis success
25/2309 Add Change Badges to documentation Corey Huinker patch   apply success   appveyor building   travis building
25/2213 Add FOREIGN to ALTER TABLE in pg_dump when the target is a foreign table Luis M Carril patch   apply success   appveyor success   travis success
25/1883 Add Hook Functions for Disk Quota Extension Haozhou Wang, Hubert Zhang, Hao Wu patch   apply success   appveyor failure   travis failure
25/2296 Add a GUC variable that control logical replication Zongliang Quan patch   apply success   appveyor success   travis success
25/2275 Add a reset_computed_values function in pg_stat_statements Pierre Ducroquet patch   apply success   appveyor failure   travis failure
25/2243 Add index AM callback to adjust opfamily member dependencies Tom Lane patch   apply success   appveyor success   travis success
25/2221 Add mandatory access control for TRUNCATE Yulian Khodorkovskiy patch   apply success   appveyor success   travis success
25/2286 Add more compile-time asserts Peter Smith patch   apply success   appveyor success   travis success (new)
25/2292 Add new developer GUC "ignore_invalid_pages", to ignore invalid pages failure du... Fujii Masao patch   apply success   appveyor success   travis success
25/2295 Add some useful asserts into View Options Macroses Nikolay Shaplov patch   apply success   appveyor success   travis success
25/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply success   appveyor success   travis success
25/2152 Add the capability to logical replication to transfer base types using binary Dave Cramer patch   apply success   appveyor success   travis success
25/2299 Add uri percent-encoding for binary data Anders Åstrand patch   apply success   appveyor success   travis success
25/2200 Adding a test for speculative wait case Ashwin Agrawal, Melanie Plageman patch   apply success   appveyor success   travis success
25/1553 Advanced partition matching for partition-wise join Etsuro Fujita, Ashutosh Bapat patch   apply failure
25/2269 Allow REINDEX and REINDEX CONCURRENTLY to SET TABLESPACE Alexey Kondratov patch   apply success   appveyor failure (new)   travis failure (new)
25/2158 Allow an alias to be attached directly to a JOIN ... USING Peter Eisentraut patch   apply success   appveyor success   travis success
25/2244 Allow cluster owner to bypass authentication Peter Eisentraut patch   apply success   appveyor success   travis success
25/2255 Allow to_date() and to_timestamp() to accept localized names Juanjo Santamaria Flecha patch   apply success   appveyor success   travis success
25/2254 Amcheck: check B-tree leftlink-rightlink invariant on standby Andrey Borodin patch   apply success   appveyor success   travis success
25/2249 Asymmetric partition-wise JOIN KaiGai Kohei patch   apply success   appveyor success   travis success
25/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... Konstantin Knizhnik patch   apply success   appveyor success   travis failure
25/2098 Avoid duplication of code to read XLOG page Antonin Houska patch   apply success   appveyor success   travis success
25/2141 Avoiding deadlock errors in CREATE INDEX CONCURRENTLY Dhruv Goel patch   apply success   appveyor success   travis success
25/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply failure
25/1774 Block level parallel vacuum Masahiko Sawada patch   apply success   appveyor failure   travis failure
25/2067 Built-in connection proxy Konstantin Knizhnik patch   apply success   appveyor success   travis success
25/2205 CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? dilip kumar, Amit Langote patch   apply success   appveyor success   travis success
25/2197 Change atoi to strtol in same place Surafel Temesgen, Joe Nelson patch   apply success   appveyor failure   travis failure
25/2267 Consolidate code that makes a sorted array unique. Thomas Munro patch   apply success   appveyor success   travis success
25/2055 DROP DATABASE FORCE Pavel Stehule, Filip Rembiałkowski patch   apply success   appveyor success   travis success
25/2297 Do not use StdRdOptions for partitioned table options, use empty structure inste... Nikolay Shaplov patch   apply success   appveyor success   travis success
25/2277 Executor code refactoring around result relations Amit Langote patch   apply success   appveyor success   travis success
25/2308 Fix base backup checksum verification for random or zero page headers Michael Banck patch   apply success   appveyor success   travis success
25/2278 Fix handling of full outer joins by partitionwise join Amit Langote patch   apply success   appveyor success   travis success
25/2179 Fix support for hypothetical indexes using BRIN access method Julien Rouhaud patch   apply failure
25/2050 Fix unique join costings David Rowley patch   apply success   appveyor success   travis success
25/2266 Fix up partitionwise join on how equi-join conditions between the partition keys... Richard Guo patch   apply success   appveyor success   travis success
25/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis failure
25/2276 GiST sorting build Andrey Borodin patch   apply failure
25/2233 Global temporary tables Konstantin Knizhnik patch   apply success   appveyor failure   travis success
25/2218 Implement INSERT SET syntax Gareth Palmer patch   apply success   appveyor success   travis success
25/1947 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success   appveyor success   travis success
25/2102 Improve Append/MergeAppend EXPLAIN output when all subplans are pruned. David Rowley patch   apply failure
25/2291 Improve recovery performance of dropping database having many tablespaces Fujii Masao patch   apply success   appveyor success   travis success
25/2140 Improve search for missing parent downlinks in amcheck Alexander Korotkov patch   apply success   appveyor building   travis success
25/2304 Include RELKIND_TOASTVALUE in get_relkind_objtype Michael Paquier patch   apply success   appveyor success   travis success
25/1124 Incremental sort Alexander Korotkov, Tomas Vondra, James Coleman patch   apply success   appveyor success   travis failure
25/1741 Index Skip Scan Dmitry Dolgov, Thomas Munro, Jesper Pedersen patch   apply success   appveyor success   travis success
25/2271 Introduce xid8 and xid8_current() etc, for 64 bit transaction IDs. Thomas Munro patch   apply success   appveyor failure   travis failure
25/2298 JIT: Optimize generated functions earlier to lower memory usage Soumyadeep Chakraborty patch   apply success   appveyor success   travis success
25/1804 KNN for B-tree Nikita Glukhov patch   apply success   appveyor success   travis success
25/1934 Log bind parameter values on error Alexey Bashtanov patch   apply success   appveyor success   travis success
25/1977 Ltree syntax improvement Dmitry Belyavsky patch   apply success   appveyor success   travis success
25/2242 Ltree, lquery, and ltxtquery binary protocol support patch   apply success   appveyor success   travis failure
25/2294 Make each Access Method to use own stucture for storing options instead of StdRd... Nikolay Shaplov patch   apply success   appveyor success   travis success
25/2285 Make integer operations more efficient, inspired by Ryū David Fetter patch   apply success   appveyor success   travis success
25/2105 Make pg_waldump and xact_desc() report the detail information like GID about PRE... Fujii Masao patch   apply success   appveyor success   travis success
25/2290 Make use of C99 designated initialisers for nulls/values arrays Peter Smith patch   apply success   appveyor success   travis success
25/2201 Memory-Bounded Hash Aggregation Jeff Davis patch   apply failure
25/2283 Minimal logical decoding on standbys Amit Khandekar patch   apply failure
25/2160 Multi insert in CTAS/MatView Paul Guo, Taylor Vesely patch   apply success   appveyor success   travis success
25/2023 NOT IN to ANTI JOIN transformation James Finnerty, Zheng Li patch   apply success   appveyor failure   travis failure
25/2241 New GUC prepared_statement_limit to limit memory used by prepared statements Daniel Migowski patch   apply success   appveyor success   travis success (new)
25/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply success   appveyor success   travis success
25/2260 Online checksums - take 3 Magnus Hagander, Daniel Gustafsson patch   apply success   appveyor success   travis success
25/2183 Opclass parameters Nikita Glukhov patch   apply failure
25/2282 Optimize expression evaluation in PL/pgSQL Konstantin Knizhnik patch   apply success   appveyor success   travis failure
25/2306 Ordering of header file inclusion vignesh C patch   apply success   appveyor failure   travis failure
25/2147 Parallel grouping sets Richard Guo patch   apply success   appveyor failure   travis failure
25/2196 Per tablespace transparent data encryption Masahiko Sawada, Insung Moon patch   apply success   appveyor failure   travis failure
25/1999 Planning counters in pg_stat_statements Fujii Masao, Julien Rouhaud, Thomas Munro, PAscal L patch   apply success   appveyor success   travis success
25/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor failure   travis success
25/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply failure
25/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   appveyor success   travis success
25/2174 Reduce size of core scanner transition array John Naylor patch   apply success   appveyor failure   travis failure
25/2169 Remove HeapTuple and Buffer dependency for predicate locking functions Ashwin Agrawal patch   apply success   appveyor success   travis success
25/2235 Remove IndexBuildCallback's dependency on HeapTuple Ashwin Agrawal patch   apply success   appveyor success   travis success
25/2113 Remove page-read callback from XLogReaderState Kyotaro Horiguchi patch   apply failure
25/2246 Remove pg_pltemplate, add trustable extensions instead Tom Lane patch   apply success   appveyor building   travis building
25/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply success   appveyor success   travis success
25/2302 Remove size limitations of vacuums dead_tuples array Ants Aasma patch   apply success   appveyor success   travis success
25/2211 Resume vacuum and autovacuum from interruption and cancellation Masahiko Sawada patch   apply success   appveyor failure   travis failure
25/2270 Row filtering for logical replication Euler Taveira patch   apply success   appveyor failure (new)   travis failure (new)
25/2173 Run-time pruning for ModifyTable David Rowley patch   apply success   appveyor failure   travis failure
25/790 SQL statements statistics counter view (pg_stat_sql) Haribabu Kommi patch   apply success   appveyor success   travis failure
25/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor failure   travis success
25/2300 Safeguards against incorrect fd flags for fsync() Michael Paquier patch   apply success   appveyor success   travis success
25/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply success   appveyor success   travis failure
25/2025 SimpleLruTruncate() mutual exclusion (data loss from lack thereof) Noah Misch patch   apply success   appveyor failure   travis failure
25/2288 Sort policies and triggers by table name in pg_dump Benjie Gillam patch   apply failure
25/1993 Speed up transaction completion faster after many relations are accessed in a tr... Takayuki Tsunakawa patch   apply success   appveyor success   travis success
25/2026 Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) Noah Misch patch   apply success   appveyor success   travis success
25/2259 Startup Centralization Mike Palmiotto, Yulian Khodorkovskiy patch   apply failure
25/2301 Support adding partitioned tables to logical replication publications Amit Langote patch   apply success   appveyor success   travis success
25/2133 Support for jsonpath .datetime() method Alexander Korotkov, Nikita Glukhov patch   apply success   appveyor success   travis success
25/1960 Support huge_pages on AIX Thomas Munro patch   apply success   appveyor success   travis success
25/1755 Tid range scan Edmund Horner patch   apply failure
25/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
25/2093 Trigger autovacuum on tuple insertion Darafei Praliaskouski patch   apply success   appveyor success   travis success
25/1649 Undo logs dilip kumar, Thomas Munro patch   apply failure
25/2237 Unix-domain socket support on Windows Peter Eisentraut patch   apply failure
25/2125 Use heap_multi_insert for catalog relations Daniel Gustafsson patch   apply success   appveyor success   travis failure
25/2119 Use memcpy in pglz decompression Andrey Borodin, Владимир Лесков patch   apply success   appveyor success   travis success
25/2189 Windows could not stat file - over 4GB Juanjo Santamaria Flecha patch   apply success   appveyor success   travis success
25/2273 Write visibility map during CLUSTER/VACUUM FULL Alexander Korotkov patch   apply success   appveyor success   travis success
25/2289 Wrong value in metapage of GIN INDEX. Insung Moon patch   apply success   appveyor success   travis success
25/2045 [WIP] Temporal query processing with range types - Temporal Normalization Peter Moser, Anton Dignös patch   apply success   appveyor failure   travis failure
25/2163 allow to set log_statement_sample_limit - maximal duration for sampling Pavel Stehule patch   apply failure
25/1911 anycompatible and anycompatiblearray polymorphic types Pavel Stehule patch   apply success   appveyor success   travis success
25/2192 base backup client as auxiliary backend process Peter Eisentraut patch   apply success   appveyor failure   travis success (new)
25/2310 bitmaps and correlation Justin Pryzby patch   apply success   appveyor failure   travis failure
25/2186 conflict handling for COPY FROM Surafel Temesgen patch   apply success   appveyor success   travis success
25/2219 document that psql's FETCH_COUNT does not work with combined (\;) queries Fabien Coelho patch   apply success   appveyor success   travis success
25/2279 enhance SPI to support EXECUTE commands Zongliang Quan patch   apply success   appveyor success   travis success
25/2281 ensure same width of last column Pavel Stehule patch   apply success   appveyor failure   travis failure
25/2177 errbacktrace Peter Eisentraut patch   apply success   appveyor success   travis success
25/2307 extension patch of CREATE OR REPLACE TRIGGER Takamichi Osumi patch   apply success   appveyor failure (new)   travis failure (new)
25/2054 fix for BUG #3720: wrong results at using ltree Filip Rembiałkowski patch   apply success   appveyor success   travis success
25/2225 get current and recovery timeline Jehan-Guillaume patch   apply success   appveyor success   travis success
25/2293 logical decoding : exceeded maxAllocatedDescs for .spill files Amit Khandekar patch   apply success   appveyor success   travis success
25/1927 logical streaming for large in-progress transactions Tomas Vondra, Petr Jelínek patch   apply success   appveyor failure   travis failure
25/1896 online change primary_conninfo Sergei Kornilov patch   apply success   appveyor failure   travis failure
25/2081 parse time support function Pavel Stehule patch   apply success   appveyor success   travis success
25/2284 pause recovery if pitr target not reached when recovery_target_time is specified Leif Gunnar Erlandsen patch   apply failure
25/1849 pg_rewind: options to use restore_command from recovery.conf or command line Alexey Kondratov patch   apply failure
25/2215 pg_upgrade fails with non-standard ACL Anastasia Lubennikova, Arthur Zakirov patch   apply failure
25/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor success   travis success
25/2090 pgbench - implement strict TPC-B benchmark Fabien Coelho patch   apply failure
25/2236 pgbench - improve variable management performance Fabien Coelho patch   apply success   appveyor failure   travis success
25/2230 pgrename_temp() – concurrent rename of temporary files on Windows Alexander Korotkov patch   apply success   appveyor success   travis success
25/2164 progress report for ANALYZE Álvaro Herrera, Vinayak Pokale, Tatsuro Yamada patch   apply success   appveyor success   travis success
25/2262 psql - improve code coverage Fabien Coelho patch   apply success   appveyor success   travis failure
25/2112 range_agg / multiranges Paul Jungwirth patch   apply failure
25/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor failure (new)   travis failure (new)
25/2263 seccomp-bpf support Joe Conway patch   apply success   appveyor success   travis success
25/2272 share string to *int64 functions, take two Michael Paquier, Fabien Coelho patch   apply success   appveyor success   travis success
25/2175 socket_timeout in interfaces/libpq Ryohei Nagaura patch   apply success   appveyor success   travis success
25/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
25/2120 tableam vs. TOAST Robert Haas patch   apply success   appveyor success   travis success

Waiting on Author

25/2130 ALTER TABLE restructuring Tom Lane patch   apply failure
25/1919 Add timeline to partial WAL segments David Steele patch   apply success   appveyor success   travis success
25/1819 Allow AddForeignUpdateTargets to add extra target expressions other than columns Etsuro Fujita, Kyotaro Horiguchi patch   apply failure
25/2071 Avoid full GIN index scan when possible Julien Rouhaud, Nikita Glukhov patch   apply success   appveyor success   travis success
25/2202 B-tree deduplication Anastasia Lubennikova patch   apply success   appveyor success   travis success
25/1863 Cleaning up orphaned files using undo logs Thomas Munro patch   apply failure
25/2020 Convert NOT IN to anti-joins when possible David Rowley patch   apply success   appveyor success   travis success
25/2104 Data at rest encryption Antonin Houska, Ants Aasma patch   apply failure
25/2003 Fix Deadlock Issue in Single User Mode When IO Failure Occurs Chengchao Yu patch   apply success   appveyor success   travis success
25/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply failure
25/2256 ICU for global collation Peter Eisentraut patch   apply success   appveyor failure   travis success
25/2138 Incremental Materialized View Maintenance Yugo Nagata patch   apply success   appveyor success   travis success
25/2274 Invalid permission check in pg_stats for functional indexes Pierre Ducroquet patch   apply success   appveyor success   travis success
25/1913 Remove deprecated exclusive backup mode David Steele patch   apply failure
25/1995 Replica with large recovery_min_apply_delay is not receiving changes from master... Konstantin Knizhnik patch   apply failure
25/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
25/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor failure   travis success
25/2048 WIP: Temporal primary and foreign keys Paul Jungwirth patch   apply failure
25/1970 Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (ver... daisuke higuchi, Ramanarayana M patch   apply success   appveyor success   travis success
25/2109 accounting for memory used for BufFile during hash joins Tomas Vondra patch   apply success   appveyor success   travis failure
25/1800 amcheck verification for GiST Andrey Borodin patch   apply success   appveyor success   travis success
25/2194 de-TOAST'ing using a iterator Xiao Bao patch   apply success   appveyor success   travis success
25/2018 pg_basebackup to adjust existing data directory permissions Haribabu Kommi patch   apply failure

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