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. Since then the reliability problem with winbison has been fixed (thanks to David Fetter!) 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

20/1728 Allow to warn or error on ... = NULL expressions David Fetter patch   apply success   appveyor success   travis success
20/1655 Check constraint documentation about cross table constraint Lætitia AVROT, Patrick Francelle patch   apply success   appveyor success   travis success
20/1856 Document PostgreSQL Limitations David Rowley patch   apply success   appveyor success   travis success
20/1618 Easy way to handle postmaster death + related bug fixes and improvements Thomas Munro patch   apply success   appveyor success   travis success
20/1166 Fix LWLock degradation on NUMA Yura Sokolov patch   apply success   appveyor success   travis success
20/1811 Fix incorrect hi_options in COPY to partitioned table David Rowley patch   apply success   appveyor success   travis success
20/1792 In one case, XLogReadRecord returns a pointer to the shared memory buffer Andrey Lepikhov patch   apply success   appveyor success   travis success
20/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply success   appveyor success   travis success
20/1690 Reduce partition tuple routing overheads David Rowley patch   apply success   appveyor success   travis success
20/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply success   appveyor building   travis failure
20/1822 Support custom socket directory in pg_upgrade Daniel Gustafsson patch   apply success   appveyor success   travis success
20/1861 csv output format for psql Daniel Vérité patch   apply failure (new)   appveyor success   travis success
20/1739 improve documentation about default privileges Fabien Coelho patch   apply success   appveyor success   travis success
20/1853 improve pgbench doc about prepared statements Tatsuo Ishii patch   apply success   appveyor success   travis success
20/1860 pg_dumpall --exclude-database option Andrew Dunstan patch   apply success   appveyor success   travis success
20/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success (new)   appveyor success (new)   travis success (new)
20/669 pgbench - allow to store query results into variables Fabien Coelho patch   apply success   appveyor success   travis success
20/1815 settings to control SSL/TLS protocol version Peter Eisentraut patch   apply success   appveyor success   travis success

Needs review

20/1809 64-bit hash function for hstore and citext data type Amul Sul patch   apply success   appveyor success   travis success
20/1764 ALTER TABLE on system catalogs Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
20/1842 ATTACH/DETACH PARTITION CONCURRENTLY Álvaro Herrera, David Rowley patch   apply success (new)   appveyor success (new)   travis success
20/1625 Accounting of zero-filled buffers in EXPLAIN (BUFFERS) Thomas Munro patch   apply success   appveyor success   travis success
20/1644 Add --include-table-data-where option to pg_dump, to export only a subset of tab... Carter Thaxton patch   apply success (new)   appveyor success (new)   travis success (new)
20/1090 Add and report the new "session_read_only" GUC pseudo-variable. Elvis Pranskevichus patch   apply failure
20/1841 Add entry creation timestamp column to pg_stat_replication MyungKyu Lim patch   apply success   appveyor success   travis success
20/1489 Add enum releation option type Nikolay Shaplov patch   apply success   appveyor success   travis success
20/1789 Add extension options to control TAP and isolation tests (Makefile rules) Michael Paquier patch   apply success   appveyor success   travis success
20/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply success (new)   appveyor success (new)   travis success (new)
20/1553 Advanced partition matching for partition-wise join Ashutosh Bapat patch   apply success   appveyor success   travis success
20/1819 Allow AddForeignUpdateTargets to add extra target expressions other than columns Etsuro Fujita, Kyotaro Horiguchi patch   apply success   appveyor success   travis success (new)
20/1605 Allow granting of permission to REFRESH MATERIALIZED VIEW, CLUSTER, and REINDEX Isaac Morland patch   apply success   appveyor success   travis success
20/1783 Allow has_table_previlege to return false when user has no previlege on namespac... Yugo Nagata patch   apply success   appveyor failure   travis failure
20/1485 Applying PMDK to WAL operations for persistent memory yoshimi ichiyanagi patch   apply failure
20/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... patch   apply success (new)   appveyor success (new)   travis success (new)
20/1821 Avoid creation of the free space map for small tables John Naylor patch   apply success   appveyor success   travis success
20/1866 Avoid duplicate XIDs at recovery when building initial snapshot - take 2 Michael Paquier patch   apply failure (new)
20/1774 Block level parallel vacuum Masahiko Sawada patch   apply success (new)   appveyor success (new)   travis success (new)
20/1824 COPY FROM WHEN condition Surafel Temesgen patch   apply success (new)   appveyor success (new)   travis success (new)
20/1810 Clean .ready and .done files for missing WAL segments at recovery Michael Paquier patch   apply success   appveyor success   travis success
20/1863 Cleaning up orphaned files using undo logs Thomas Munro patch   apply failure
20/1639 Clone file descriptors into checkpointer, to handle fsync issues on at least lin... Andres Freund, Thomas Munro patch   apply success (new)   appveyor success (new)   travis success (new)
20/1867 Connection slots reserved for replication Alexander Kukushkin patch   apply failure (new)
20/1705 Copy function for logical replication slots Masahiko Sawada patch   apply success   appveyor success   travis success
20/1615 Covering GiST indexes Andrey Borodin patch   apply success   appveyor success   travis success
20/1294 Custom compression methods Ildus Kurbangaliev patch   apply success   appveyor success   travis success
20/1803 DNS SRV support for LDAP authentication Thomas Munro patch   apply failure
20/1765 Detect shared buffer access violations using mprotect() Asim Rama Praveen patch   apply success   appveyor success   travis success
20/1664 Evaluate immutable functions during planning (in FROM clause) Aleksandr Parfenov patch   apply success   appveyor success   travis success
20/1759 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor failure   travis failure
20/1683 Fix cancelled queries when hot_standby_feedback = on Ivan Kartyshov patch   apply success   appveyor success   travis failure
20/1846 Fix psql \conninfo & \connect when both host & hostaddr are used Fabien Coelho patch   apply success (new)   appveyor success (new)   travis success (new)
20/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
20/1421 Flexible configuration for full-text search Aleksandr Parfenov patch   apply success   appveyor success   travis success
20/1141 Full merge join on comparison clause Alexander Kuzmenkov patch   apply success (new)   appveyor success (new)   travis success (new)
20/1647 GSSAPI encryption support Robbie Harwood patch   apply success   appveyor success   travis success
20/1062 Generic type subscripting Dmitry Dolgov patch   apply failure
20/1695 Global shared meta cache Takeshi Ideriha patch   apply success   appveyor success   travis success
20/1662 Global snapshots Stas Kelvich, Konstantin Knizhnik patch   apply failure
20/1204 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success   appveyor success   travis success
20/1807 Implement predicate propagation for non-equivalence clauses. Richard Guo patch   apply success   appveyor success   travis failure
20/1741 Index Skip Scan Thomas Munro, Jesper Pedersen patch   apply success   appveyor success   travis success
20/1734 Inline Common Table Expressions Andrew Gierth, David Fetter patch   apply success   appveyor success   travis success
20/1857 Installation instructions update (pg_ctl) Andreas 'ads' Scherbaum patch   apply success   appveyor success   travis success
20/1804 KNN for B-tree Nikita Glukhov patch   apply success   appveyor success   travis failure
20/1288 Lazy hash table for snapshot's "xid in progress" Yura Sokolov patch   apply success   appveyor success   travis success
20/944 Logical decoding of two-phase transactions Nikhil Sontakke patch   apply success (new)   appveyor success (new)   travis success (new)
20/1446 MERGE Simon Riggs, Pavan Deolasee patch   apply failure
20/1672 Make installcheck-world in a clean environment Alexander Lakhin patch   apply success   appveyor success   travis success
20/1787 Make nbtree keys unique by appending heap TID, suffix truncation Peter Geoghegan patch   apply failure
20/1827 Make the planner treat empty jointrees as selecting from a new dummy RTE type Tom Lane patch   apply success   appveyor success   travis success
20/1817 New vacuum option to do only freezing Masahiko Sawada patch   apply success   appveyor success   travis success
20/1850 Ordered Partitioned Table Scans David Rowley patch   apply failure
20/1283 Pluggable storage API Álvaro Herrera, Alexander Korotkov, Haribabu Kommi patch   apply failure
20/1711 Proposal for changes to recovery.conf API Simon Riggs, Sergei Kornilov patch   apply success (new)   appveyor success (new)   travis success (new)
20/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor failure   travis failure
20/1831 Pull up sublink of type 'NOT NOT (expr)' Richard Guo patch   apply success   appveyor success   travis success
20/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply failure
20/1624 Range phrase operator in tsquery Aleksandr Parfenov patch   apply success   appveyor success   travis success
20/1578 Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist Anastasia Lubennikova, Andrey Lepikhov patch   apply success (new)   appveyor success (new)   travis success (new)
20/1829 Refactoring the checkpointer's fsync request queue Thomas Munro patch   apply success   appveyor success   travis success
20/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply success   appveyor success   travis success
20/1626 Replace conversion_create.sql with normal data entries John Naylor patch   apply success (new)   appveyor success (new)   travis success (new)
20/621 Respect client-initiated CopyDone during logical streaming replication Dave Cramer, Vladimir Gordiychuk patch   apply failure
20/1802 Retail IndexTuple Deletion Andrey Lepikhov patch   apply success   appveyor failure   travis failure
20/1862 Row filtering for logical replication Euler Taveira patch   apply success   appveyor success   travis success
20/1799 SERIALIZABLE on standby servers Thomas Munro patch   apply success   appveyor success   travis success
20/1004 SERIALIZABLE with parallel query Thomas Munro patch   apply success (new)   appveyor success (new)   travis success (new)
20/1838 SIGPIPE handling in COPY TO/FROM PROGRAM Tom Lane patch   apply success   appveyor success   travis success
20/1704 SQL/JSON: documentation Nikita Glukhov, Oleg Bartunov patch   apply success (new)   appveyor success (new)   travis success (new)
20/1691 Sample rate logging Adrien Nayrat patch   apply success   appveyor success   travis success
20/1461 Shared Ispell dictionaries Arthur Zakirov patch   apply success   appveyor success   travis success
20/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply success (new)   appveyor failure (new)   travis failure (new)
20/1731 Show size of partitioned table Pavel Stehule patch   apply success   appveyor success   travis success
20/1778 Speed up planning with partitions Amit Langote patch   apply success   appveyor success   travis success (new)
20/1767 Strengthen PGSharedMemoryCreate checks for still-attached processes Noah Misch patch   apply success   appveyor success   travis success
20/1589 Synchronous replay mode for avoiding stale reads on hot standbys Thomas Munro patch   apply success   appveyor success   travis success
20/1755 Tid scan improvements (ordering and range scan) Edmund Horner patch   apply success   appveyor success   travis success
20/1718 Track the next xid using 64 bits Thomas Munro patch   apply success (new)   appveyor success (new)   travis success (new)
20/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply success (new)   appveyor success (new)   travis success (new)
20/1602 Two pass check for deadlock Yura Sokolov patch   apply success   appveyor success   travis success
20/1828 Undo worker and transaction rollback Amit Kapila, dilip kumar, mithun cy, Rafia Sabih patch   apply failure
20/1834 Use single-byte Boyer-Moore-Horspool search even with multibyte encodings. Heikki Linnakangas patch   apply success (new)   appveyor success (new)   travis failure (new)
20/1085 XML XPath default namespace support Pavel Stehule patch   apply success (new)   appveyor failure (new)   travis failure (new)
20/1800 amcheck verification for GiST Andrey Borodin patch   apply success   appveyor success   travis success
20/1745 conflict handling for COPY FROM Surafel Temesgen patch   apply success   appveyor failure   travis failure
20/1706 cost_sort improvement Fedor Sigaev patch   apply success   appveyor failure   travis failure
20/1667 cursors with prepared statements Peter Eisentraut patch   apply success   appveyor success   travis success
20/1619 de-deduplicate code in DML execution hooks in postgres_fdw Ashutosh Bapat patch   apply success   appveyor success   travis success
20/1796 documenting signal handling with readme Chris Travers patch   apply success   appveyor success   travis success
20/1620 generalized expression syntax for partition bounds Tom Lane, Kyotaro Horiguchi, Amit Langote patch   apply success   appveyor success   travis success
20/1443 generated columns Peter Eisentraut patch   apply success   appveyor success   travis success
20/1769 libpq host/hostaddr consistency Fabien Coelho patch   apply success (new)   appveyor success (new)   travis success (new)
20/1852 logical decoding Segmentation fault (predicate index causing crash) Álvaro Herrera, Petr Jelínek patch   apply failure
20/1490 macOS Secure Transport SSL Support Daniel Gustafsson patch   apply success   appveyor failure   travis success
20/1238 multivariate MCV lists and histograms Tomas Vondra patch   apply success   appveyor success   travis success
20/1832 pg_dump multi VALUES INSERT Surafel Temesgen patch   apply success   appveyor building   travis building
20/1522 pg_hba.conf : new auth option : clientcert=verify-full Julian Markwort patch   apply success   appveyor success   travis success
20/1849 pg_rewind: options to use restore_command from recovery.conf or command line Alexey Kondratov patch   apply success (new)   appveyor success (new)   travis success (new)
20/1833 pg_stat_ssl additions Peter Eisentraut
20/1707 pg_stat_statements_reset() update to reset specific statement statistics Haribabu Kommi patch   apply success   appveyor success   travis success
20/1845 pg_waldump output on CREATE DATABASE Jean-Christophe Arnu patch   apply success   appveyor success   travis success
20/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor success   travis success
20/1754 pgbench - doCustom cleanup Fabien Coelho patch   apply success   appveyor success   travis success
20/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
20/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor success   travis success
20/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply success (new)   appveyor success (new)   travis success (new)

Waiting on Author

20/1319 Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs Nicolas Williams patch   apply failure
20/1669 Add function to release an allocated SQLDA sho kato patch   apply failure
20/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply failure
20/1779 CLUSTER command progress monitor Tatsuro Yamada patch   apply success   appveyor success (new)   travis failure
20/1573 Changing the autovacuum launcher scheduling; oldest table first algorithm Masahiko Sawada patch   apply failure
20/1844 FETCH FIRST clause WITH TIES option Surafel Temesgen patch   apply success   appveyor failure   travis failure
20/1651 GROUP BY optimization Fedor Sigaev patch   apply failure
20/1598 GiST VACUUM Constantine Kuznetsov, Andrey Borodin patch   apply success   appveyor success   travis success
20/1277 GnuTLS support Andreas Karlsson, Peter Eisentraut patch   apply failure
20/1543 ICU as default collation provider Marina Polyakova patch   apply success   appveyor success   travis failure
20/1604 Implement ASSERTIONs per the SQL standard. Joe Wildish patch   apply failure
20/1805 Improve semijoin selectivity estimates by clamping them to not more than innerjo... Tom Lane patch   apply success   appveyor building   travis success
20/1124 Incremental sort Alexander Korotkov patch   apply failure
20/1666 Moving relation extension locks out of heavyweight lock manager Masahiko Sawada patch   apply failure
20/1820 NOTIFY and pg_notify performance when deduplicating notifications Julien Demoor patch   apply success   appveyor failure   travis failure
20/1733 Online verification of checksums Michael Banck patch   apply success   appveyor success   travis success
20/1317 Pipelining/batch mode support for libpq Craig Ringer, vaishnavi prabakaran patch   apply failure
20/1786 Progress reporting for pg_verify_checksums Bernd Helmle, Michael Banck patch   apply failure (new)
20/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply failure
20/1353 Removing [Merge]Append nodes which contain a single subpath David Rowley patch   apply failure
20/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
20/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
20/1471 SQL/JSON: jsonpath Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor failure   travis success
20/1460 Sample values for pg_stat_statements Vik Fearing patch   apply failure
20/1670 Support optional message in backend cancellation/termination Daniel Gustafsson patch   apply failure
20/1649 Undo logs dilip kumar, Thomas Munro patch   apply failure
20/1648 WIP: Precalculate stable functions Arthur Zakirov, Marina Polyakova patch   apply failure
20/1594 chained transactions Peter Eisentraut patch   apply failure
20/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply failure
20/1540 hash joins with bloom filters Tomas Vondra patch   apply failure
20/1631 hostorder and failover_timeout for libpq Ildar Musin patch   apply failure
20/1518 lc_messages parameter doesn't work on Windows Aleksandr Parfenov patch   apply success   appveyor success   travis success
20/1635 libpq compression Konstantin Knizhnik patch   apply success   appveyor success   travis success
20/1854 libpq trace log Aya Iwata patch   apply success   appveyor success   travis success
20/1843 timeout parameters in libpq Ryohei Nagaura patch   apply failure

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