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

22/1489 Add enum relation option type Nikolay Shaplov patch   apply success   appveyor success   travis success
22/1898 Add sqlstate output mode to VERBOSITY didier gautheron patch   apply success   appveyor success   travis success
22/2009 COPY FREEZE, PD_VISIBLE_ALL and VM status Pavan Deolasee patch   apply success   appveyor success   travis success
22/1868 Detoast Compressed Datum Slice Paul Ramsey patch   apply success   appveyor success   travis success
22/1922 EXPLAIN with information about modified GUC values Tomas Vondra patch   apply success   appveyor success   travis success
22/1997 Generated as identity field in a temporary table with on commit drop corrupts sy... Michael Paquier patch   apply success   appveyor success   travis success
22/1731 Show size of partitioned table Pavel Stehule patch   apply success   appveyor success   travis success
22/1778 Speed up planning with partitions Amit Langote patch   apply failure (new)   appveyor success   travis success
22/1892 idle-in-transaction timeout error does not give a hint Tatsuo Ishii patch   apply success   appveyor success   travis success
22/2006 pg_restore supports stdout in --file Euler Taveira patch   apply success   appveyor success   travis success
22/1849 pg_rewind: options to use restore_command from recovery.conf or command line Alexey Kondratov patch   apply success   appveyor success   travis success
22/1943 pg_upgrade: Pass -j option down to vacuumdb Jesper Pedersen patch   apply success   appveyor success   travis success
22/2036 pgbench - improve zipfian documentation about performance Fabien Coelho patch   apply success   appveyor success   travis success (new)
22/2035 pgbench state change cleanup Fabien Coelho patch   apply success   appveyor success   travis success

Needs review

22/1883 Add Hook Functions for Disk Quota Extension Haozhou Wang, Hubert Zhang, Hao Wu patch   apply success   appveyor success   travis success
22/2042 Add exclusive backup deprecation notes to documentation David Steele patch   apply success   appveyor success   travis success
22/1553 Advanced partition matching for partition-wise join Etsuro Fujita, Ashutosh Bapat patch   apply success   appveyor success   travis success
22/2015 Align timestamps in pg_regress output Christoph Berg patch   apply success   appveyor success   travis success
22/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... Konstantin Knizhnik patch   apply success   appveyor success   travis failure
22/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply failure
22/1774 Block level parallel vacuum Masahiko Sawada patch   apply success   appveyor success   travis success
22/2043 Bloom index cost model Jeff Janes patch   apply success   appveyor success   travis failure
22/1779 CLUSTER command progress monitor Tatsuro Yamada patch   apply success   appveyor success   travis success
22/2019 Convert Lists into arrays Tom Lane patch   apply success   appveyor failure   travis failure
22/2020 Convert NOT IN to anti-joins when possible David Rowley patch   apply success   appveyor success   travis success
22/1705 Copy function for logical replication slots Masahiko Sawada patch   apply success   appveyor failure   travis failure
22/1294 Custom compression methods Ildus Kurbangaliev patch   apply failure
22/2013 Don't count parallel worker transactions as commits or rollbacks Haribabu Kommi patch   apply success   appveyor success   travis success
22/1759 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis failure
22/1844 FETCH FIRST clause WITH TIES option Surafel Temesgen patch   apply success   appveyor failure (new)   travis failure (new)
22/1979 First SVG graphic Jürgen Purtz patch   apply success   appveyor success   travis success
22/2003 Fix Deadlock Issue in Single User Mode When IO Failure Occurs Chengchao Yu patch   apply success   appveyor failure (new)   travis success
22/1983 Fix inadequate executor locking of indexes David Rowley patch   apply success   appveyor success   travis success
22/1984 Fix performance issue in foreign-key-aware join estimation David Rowley patch   apply success   appveyor success   travis success
22/2050 Fix unique join costings David Rowley patch   apply success   appveyor success   travis success
22/2028 Flexible partition pruning hook Mike Palmiotto patch   apply success   appveyor failure   travis failure
22/1877 Foreign keys referencing partitioned tables Álvaro Herrera patch   apply success (new)   appveyor success   travis success
22/1647 GSSAPI encryption support Robbie Harwood patch   apply success   appveyor success   travis success
22/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
22/1695 Global shared meta cache Takeshi Ideriha patch   apply failure
22/1947 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success   appveyor success   travis success
22/2031 Improve WAL on COW filesystems Jerry Jelinek patch   apply success   appveyor success   travis success
22/1804 KNN for B-tree Nikita Glukhov patch   apply failure
22/1923 Log a sample of transactions Adrien Nayrat patch   apply success   appveyor success   travis success
22/1977 Ltree syntax improvement Dmitry Belyavsky patch   apply success   appveyor success   travis failure
22/1672 Make installcheck-world in a clean environment Alexander Lakhin patch   apply success   appveyor success   travis success
22/1787 Make nbtree keys unique by appending heap TID, suffix truncation Peter Geoghegan
22/2023 NOT IN to ANTI JOIN transformation James Finnerty, Zheng Li patch   apply success   appveyor success   travis success
22/1817 New vacuum option to do only freezing Masahiko Sawada patch   apply failure
22/1733 Online verification of checksums Michael Banck patch   apply failure (new)   appveyor success   travis failure
22/2011 Optimization of some jsonb functions Nikita Glukhov patch   apply success   appveyor failure   travis failure
22/1850 Ordered Partitioned Table Scans David Rowley patch   apply success   appveyor success (new)   travis success
22/1283 Pluggable storage API Álvaro Herrera, Andres Freund, Alexander Korotkov, Haribabu Kommi patch   apply failure (new)   appveyor success   travis success
22/2029 Problem with default partition pruning Yuzuko Hosoya patch   apply failure
22/1786 Progress reporting for pg_verify_checksums Bernd Helmle, Michael Banck patch   apply failure (new)   appveyor success   travis success
22/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor success   travis success
22/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   appveyor success   travis failure
22/1921 REINDEX CONCURRENTLY Peter Eisentraut patch   apply success   appveyor success   travis success
22/1578 Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist Anastasia Lubennikova, Andrey Lepikhov patch   apply failure (new)   appveyor success   travis success
22/1353 Removing [Merge]Append nodes which contain a single subpath David Rowley patch   apply success   appveyor success   travis success
22/1995 Replica with large recovery_min_apply_delay is not receiving changes from master... Konstantin Knizhnik patch   apply success   appveyor success   travis success
22/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply success   appveyor success   travis success
22/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success (new)   appveyor success   travis success
22/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
22/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply failure
22/2025 SimpleLruTruncate() mutual exclusion (data loss from lack thereof) Noah Misch patch   apply failure
22/1981 Skip table truncation at VACUUM Takayuki Tsunakawa patch   apply success   appveyor success   travis success
22/1993 Speed up transaction completion faster after many relations are accessed in a tr... Takayuki Tsunakawa patch   apply failure
22/2026 Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) Noah Misch patch   apply success   appveyor success   travis success
22/1767 Strengthen PGSharedMemoryCreate checks for still-attached processes Noah Misch patch   apply success   appveyor success   travis success
22/1960 Support huge_pages on AIX Thomas Munro patch   apply failure
22/2039 Switch current_schema() to PARALLEL UNSAFE Michael Paquier patch   apply success   appveyor success   travis success
22/1961 Synchronizing slots from primary to standby Petr Jelínek patch   apply failure
22/1948 Triggers on Materialized Views Mi Tar patch   apply success   appveyor success   travis success
22/1649 Undo logs dilip kumar, Thomas Munro patch   apply failure
22/1828 Undo worker and transaction rollback Amit Kapila, dilip kumar, mithun cy, Rafia Sabih patch   apply failure
22/1963 Unified logging system for command-line programs Peter Eisentraut patch   apply failure
22/2048 WIP: Temporal primary and foreign keys Paul Jungwirth patch   apply failure
22/1872 XML fixes Pavel Stehule, Chapman Flack patch   apply success (new)   appveyor success (new)   travis success (new)
22/2045 [WIP] Temporal query processing with range types - Temporal Normalization Peter Moser, Anton Dignös patch   apply success   appveyor failure   travis failure
22/1925 block level PRAGMA Pavel Stehule patch   apply success   appveyor failure   travis success
22/1594 chained transactions Peter Eisentraut patch   apply success   appveyor success   travis success
22/1911 commontype and commontypearray polymorphic types Pavel Stehule patch   apply failure
22/1745 conflict handling for COPY FROM Surafel Temesgen patch   apply failure
22/1893 create and use subscription for nonsuperuser Evgeny Efimkin patch   apply success   appveyor success   travis failure
22/2034 extension patch of CREATE OR REPLACE TRIGGER Takamichi Osumi patch   apply success   appveyor failure   travis failure
22/1635 libpq compression Konstantin Knizhnik patch   apply success   appveyor failure   travis failure
22/1769 libpq host/hostaddr consistency Fabien Coelho patch   apply success   appveyor success   travis success
22/1854 libpq trace log Aya Iwata patch   apply failure
22/1896 online change primary_conninfo Sergei Kornilov patch   apply success   appveyor success   travis success
22/2018 pg_basebackup to adjust existing data directory permissions Haribabu Kommi patch   apply success   appveyor success   travis success
22/1974 pg_stat_statements should notice FOR UPDATE clauses Andrew Gierth patch   apply success   appveyor success   travis success
22/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor success   travis success
22/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor success   travis success
22/1950 postgres_fdw: Perform UPPERREL_ORDERED and UPPERREL_FINAL steps remotely Etsuro Fujita patch   apply success   appveyor success   travis success
22/2044 propagating replica identity to partitions Álvaro Herrera patch   apply failure
22/1899 psql display of foreign keys Álvaro Herrera patch   apply success (new)   appveyor success (new)   travis success (new)
22/2002 query logging of prepared statements Justin Pryzby patch   apply success   appveyor success   travis success
22/1608 schema variables, LET command Pavel Stehule patch   apply success (new)   appveyor success (new)   travis success (new)
22/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply failure

Waiting on Author

22/2001 A separate table level option to control compression Pavan Deolasee patch   apply success   appveyor success   travis success
22/2027 Document the limitations of row-level security Pierre Ducroquet patch   apply success   appveyor success   travis success
22/2046 Fix memleaks and error handling in jsonb_plpython Nikita Glukhov patch   apply failure
22/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply failure
22/1741 Index Skip Scan Thomas Munro, Jesper Pedersen patch   apply success   appveyor failure   travis failure
22/1934 Log bind parameter values on error Alexey Bashtanov patch   apply failure
22/944 Logical decoding of two-phase transactions Nikhil Sontakke patch   apply failure
22/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply success   appveyor success   travis success (new)
22/1999 Planning counters in pg_stat_statements Fujii Masao, Thomas Munro, PAscal L patch   apply failure
22/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply success (new)   appveyor success   travis success
22/1829 Refactoring the checkpointer's fsync request queue Thomas Munro, Shawn Debnath patch   apply success   appveyor success   travis success
22/1975 Referential Integrity Checks with Statement Level Triggers Corey Huinker patch   apply failure
22/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply success   appveyor success   travis success
22/1471 SQL/JSON: jsonpath Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success (new)   appveyor success   travis success
22/2007 Shared Ispell dictionaries Arthur Zakirov patch   apply failure
22/2016 Show temp table namespace xid in pg_stat_activity Magnus Hagander patch   apply success   appveyor success   travis success
22/1991 SortSupport implementation on inet/cdir Brandur Leach patch   apply failure
22/1755 Tid scan improvements (ordering and range scan) Edmund Horner patch   apply success   appveyor success   travis success (new)
22/1718 Track the next xid using 64 bits Thomas Munro patch   apply success   appveyor success   travis success
22/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
22/1870 Update INSTALL file Andreas 'ads' Scherbaum patch   apply success   appveyor success   travis success
22/1970 Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (ver... daisuke higuchi patch   apply failure
22/1976 \describe: verbose commands in psql Corey Huinker patch   apply success   appveyor success   travis success
22/1800 amcheck verification for GiST Andrey Borodin patch   apply failure
22/1443 generated columns Peter Eisentraut patch   apply success   appveyor success   travis success
22/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply failure
22/1927 logical streaming for large in-progress transactions Tomas Vondra, Petr Jelínek patch   apply failure
22/1966 monitoring CREATE INDEX [CONCURRENTLY] Álvaro Herrera patch   apply failure
22/2024 move current_logfiles to log_directory or change the permissions of the file to ... Haribabu Kommi patch   apply success   appveyor success   travis success
22/1238 multivariate MCV lists and histograms Tomas Vondra patch   apply success   appveyor success (new)   travis success (new)
22/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
22/1902 timeout parameters in libpq Ryohei Nagaura patch   apply failure

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