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/1615 Covering GiST indexes Andrey Borodin patch   apply success   appveyor success   travis success
22/1887 Delay locking partitions during INSERT and UPDATE David Rowley patch   apply success   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/1860 pg_dumpall --exclude-database option Andrew Dunstan patch   apply success   appveyor success   travis success
22/1522 pg_hba.conf : new auth option : clientcert=verify-full Julian Markwort patch   apply failure

Needs review

22/2001 A separate table level option to control compression Pavan Deolasee patch   apply success (new)   appveyor success (new)   travis success (new)
22/1764 ALTER TABLE on system catalogs Peter Eisentraut patch   apply success   appveyor failure   travis failure
22/1842 ATTACH/DETACH PARTITION CONCURRENTLY Álvaro Herrera, Robert Haas, David Rowley patch   apply failure
22/1883 Add Hook Functions for Disk Quota Extension Haozhou Wang, Hubert Zhang, Hao Wu patch   apply success   appveyor success   travis success
22/1873 Adding a TAP test checking data consistency on standby with minRecoveryPoint Michael Paquier patch   apply success   appveyor success   travis success
22/1553 Advanced partition matching for partition-wise join Etsuro Fujita, Ashutosh Bapat patch   apply failure
22/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... Konstantin Knizhnik patch   apply success   appveyor success   travis success
22/1821 Avoid creation of the free space map for small tables John Naylor patch   apply success   appveyor success   travis success
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 failure
22/1803 DNS SRV support for LDAP authentication Thomas Munro patch   apply success   appveyor success   travis success
22/1897 Delay locking partitions during query execution David Rowley patch   apply success   appveyor success   travis success
22/1868 Detoast Compressed Datum Slice Paul Ramsey patch   apply success   appveyor success   travis success
22/1996 Empty targetlist in a plan for certain inherited updates causes user-facing erro... Amit Langote patch   apply success   appveyor success   travis success
22/1844 FETCH FIRST clause WITH TIES option Surafel Temesgen patch   apply success   appveyor success   travis success
22/1979 First SVG graphic Jürgen Purtz patch   apply success   appveyor success   travis success
22/1982 Fix DROP FUNCTION IF NOT EXISTS with ambiguous function David Rowley patch   apply success   appveyor success (new)   travis success
22/1983 Fix inadequate executor locking of indexes David Rowley patch   apply success   appveyor success   travis success
22/2000 Fix optimization of foreign-key on update actions Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
22/1984 Fix performance issue in foreign-key-aware join estimation David Rowley patch   apply success   appveyor success   travis success
22/1989 Fix pgbench tap tests when the path contains a perl special character Fabien Coelho patch   apply success   appveyor success   travis success
22/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply success   appveyor success   travis success
22/1647 GSSAPI encryption support Robbie Harwood patch   apply failure
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/1062 Generic type subscripting Dmitry Dolgov patch   apply failure
22/1598 GiST VACUUM Constantine Kuznetsov, Andrey Borodin patch   apply failure
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 failure
22/1934 Log bind parameter values on error Alexey Bashtanov patch   apply success   appveyor success   travis success
22/1980 Log10 and hyperbolic functions for SQL:2016 compliance Lætitia AVROT patch   apply success   appveyor failure   travis failure
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 patch   apply success   appveyor success   travis success
22/1817 New vacuum option to do only freezing Masahiko Sawada patch   apply success   appveyor success   travis success
22/1944 Offline enabling/disabling of checksums Michael Banck patch   apply success   appveyor success   travis success
22/1733 Online verification of checksums Michael Banck patch   apply failure (new)   appveyor success   travis success
22/1850 Ordered Partitioned Table Scans David Rowley patch   apply success   appveyor success   travis success
22/1999 Planning counters in pg_stat_statements patch   apply failure
22/1283 Pluggable storage API Álvaro Herrera, Andres Freund, Alexander Korotkov, Haribabu Kommi patch   apply failure
22/1969 Prevent extension creation in temporary schemas Michael Paquier patch   apply success   appveyor success   travis success
22/1786 Progress reporting for pg_verify_checksums Bernd Helmle, Michael Banck patch   apply success   appveyor success   travis success
22/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply failure
22/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply 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 success   appveyor success   travis success
22/1975 Referential Integrity Checks with Statement Level Triggers Corey Huinker patch   apply success   appveyor failure   travis failure
22/1913 Remove deprecated exclusive backup mode David Steele patch   apply failure
22/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply failure
22/1353 Removing [Merge]Append nodes which contain a single subpath David Rowley patch   apply success   appveyor success   travis failure (new)
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/621 Respect client-initiated CopyDone during logical streaming replication Dave Cramer, Vladimir Gordiychuk patch   apply success   appveyor success   travis failure
22/1799 SERIALIZABLE on standby servers Thomas Munro patch   apply success   appveyor success   travis success
22/1004 SERIALIZABLE with parallel query Thomas Munro patch   apply success   appveyor success   travis success
22/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
22/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
22/1731 Show size of partitioned table Pavel Stehule patch   apply success   appveyor success (new)   travis success (new)
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 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 Andres Freund, Thomas Munro patch   apply failure
22/1961 Synchronizing slots from primary to standby Petr Jelínek patch   apply success   appveyor success   travis success
22/1589 Synchronous replay mode for avoiding stale reads on hot standbys Thomas Munro patch   apply success   appveyor success   travis success
22/1951 Temporary materialized views Mi Tar patch   apply failure
22/1755 Tid scan improvements (ordering and range scan) Edmund Horner patch   apply success   appveyor success (new)   travis success
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/1970 Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (ver... daisuke higuchi patch   apply failure
22/1872 XML fixes Pavel Stehule, Chapman Flack patch   apply failure
22/1976 \describe: verbose commands in psql Corey Huinker patch   apply success   appveyor success   travis success
22/1925 block level PRAGMA Pavel Stehule patch   apply success   appveyor success   travis success
22/1594 chained transactions Peter Eisentraut patch   apply failure
22/1911 commontype and commontypearray polymorphic types Pavel Stehule patch   apply success   appveyor failure   travis failure
22/1893 create and use subscription for nonsuperuser Evgeny Efimkin patch   apply success   appveyor success   travis success
22/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply success   appveyor success   travis success
22/1952 insensitive/non-deterministic collations Peter Eisentraut patch   apply failure
22/1635 libpq compression Konstantin Knizhnik patch   apply success   appveyor building   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 success   appveyor failure (new)   travis success
22/1966 monitoring CREATE INDEX [CONCURRENTLY] Álvaro Herrera patch   apply success   appveyor failure   travis failure
22/1849 pg_rewind: options to use restore_command from recovery.conf or command line Alexey Kondratov patch   apply success (new)   appveyor success   travis success
22/1974 pg_stat_statements should notice FOR UPDATE clauses Andrew Gierth 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/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor success   travis success
22/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
22/2002 query logging of prepared statements Justin Pryzby patch   apply success (new)   appveyor success (new)   travis success (new)
22/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor success   travis failure
22/1874 support VARIADIC arg for least/greatest functions Pavel Stehule patch   apply success   appveyor success (new)   travis success
22/1902 timeout parameters in libpq Ryohei Nagaura patch   apply success   appveyor success   travis failure
22/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply success   appveyor success   travis success

Waiting on Author

22/1919 Add timeline to partial WAL segments David Steele patch   apply success   appveyor success   travis success
22/1705 Copy function for logical replication slots Masahiko Sawada patch   apply success   appveyor success   travis success
22/1294 Custom compression methods Ildus Kurbangaliev patch   apply failure
22/1922 EXPLAIN with information about modified GUC values Tomas Vondra patch   apply success   appveyor success   travis success
22/1664 Evaluate immutable functions during planning (in FROM clause) Aleksandr Parfenov patch   apply failure
22/1759 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis success
22/1877 Foreign keys referencing partitioned tables Álvaro Herrera patch   apply failure
22/1971 Include all columns in default names for foreign key constraints. Paul Martinez patch   apply success   appveyor failure   travis failure
22/1988 Incorrect value of snapshot_type Antonin Houska patch   apply success   appveyor success   travis success
22/1741 Index Skip Scan Thomas Munro, Jesper Pedersen 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/944 Logical decoding of two-phase transactions Nikhil Sontakke patch   apply success (new)   appveyor success (new)   travis success (new)
22/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
22/1879 Prove IS NOT NULL inference for large arrays James Coleman patch   apply success   appveyor building   travis building
22/1829 Refactoring the checkpointer's fsync request queue Thomas Munro patch   apply failure
22/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply success   appveyor success   travis success
22/1471 SQL/JSON: jsonpath Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
22/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
22/1991 SortSupport implementation on inet/cdir Brandur Leach patch   apply failure
22/1778 Speed up planning with partitions Amit Langote patch   apply success   appveyor success   travis success
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/1800 amcheck verification for GiST Andrey Borodin patch   apply success   appveyor success   travis success
22/1745 conflict handling for COPY FROM Surafel Temesgen patch   apply failure
22/1796 documenting signal handling with readme Chris Travers patch   apply success   appveyor success   travis success
22/1927 logical streaming for large in-progress transactions Tomas Vondra, Petr Jelínek patch   apply failure
22/1238 multivariate MCV lists and histograms Tomas Vondra patch   apply failure
22/1896 online change primary_conninfo Sergei Kornilov patch   apply success   appveyor success   travis success
22/1832 pg_dump multi VALUES INSERT David Rowley, Surafel Temesgen patch   apply success   appveyor failure (new)   travis failure (new)
22/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply failure
22/1950 postgres_fdw: Perform UPPERREL_ORDERED and UPPERREL_FINAL steps remotely Etsuro Fujita patch   apply failure (new)   appveyor success   travis success

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