PostgreSQL Patch Tester

Here lives an experimental bot that does this: CommitfestGithub → ( 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/1726 Allow to rename index in concurrent mode Peter Eisentraut, Andrew Klychkov patch   apply success   appveyor success   travis success
20/1728 Allow to warn or error on ... = NULL expressions David Fetter patch   apply success   appveyor success   travis success
20/1768 Calculate total_table_pages after set_base_rel_sizes() David Rowley patch   apply success   appveyor success   travis success
20/1166 Fix LWLock degradation on NUMA Yura Sokolov patch   apply success   appveyor success   travis success
20/1690 Reduce partition tuple routing overheads David Rowley patch   apply success   appveyor success   travis success
20/1670 Support optional message in backend cancellation/termination Daniel Gustafsson patch   apply success   appveyor success   travis success
20/1739 improve documentation about default privileges Fabien Coelho patch   apply success   appveyor success   travis success
20/669 pgbench - allow to store query results into variables Fabien Coelho patch   apply success   appveyor building   travis building

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   appveyor success   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   appveyor success   travis success
20/1090 Add and report the new "session_read_only" GUC pseudo-variable. Elvis Pranskevichus patch   apply success   appveyor success   travis failure
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/1669 Add function to release an allocated SQLDA sho kato patch   apply failure
20/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply success   appveyor success   travis success
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
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   appveyor success   travis success
20/1774 Block level parallel vacuum Masahiko Sawada patch   apply failure
20/1824 COPY FROM WHEN condition Surafel Temesgen patch   apply success   appveyor success   travis success
20/1826 Change simple_heap_insert() to a macro Andrew Klychkov 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/1810 Clean .ready and .done files for missing WAL segments at recovery Michael Paquier patch   apply success   appveyor success   travis success
20/1639 Clone file descriptors into checkpointer, to handle fsync issues on at least lin... Andres Freund, Thomas Munro patch   apply success   appveyor success   travis success
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 failure
20/1803 DNS SRV support for LDAP authentication Thomas Munro patch   apply success   appveyor success   travis success
20/1671 Default values in partition tables don't work as expected and allow NOT NULL vio... Amit Langote patch   apply failure
20/1765 Detect shared buffer access violations using mprotect() Asim Rama Praveen patch   apply success   appveyor success   travis success
20/1618 Easy way to handle postmaster death + related bug fixes and improvements Thomas Munro patch   apply failure
20/1664 Evaluate immutable functions during planning (in FROM clause) Aleksandr Parfenov patch   apply success   appveyor success   travis failure
20/1759 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis failure
20/1683 Fix cancelled queries when hot_standby_feedback = on Ivan Kartyshov patch   apply success   appveyor success   travis failure
20/1811 Fix incorrect hi_options in COPY to partitioned table David Rowley patch   apply success   appveyor success   travis success
20/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply failure
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   appveyor success   travis success
20/1797 Function to promote standby servers Laurenz Albe patch   apply success   appveyor success   travis success
20/1647 GSSAPI encryption support Robbie Harwood patch   apply success   appveyor success   travis success
20/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
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 success   appveyor failure   travis 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/1805 Improve semijoin selectivity estimates by clamping them to not more than innerjo... Tom Lane 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/1124 Incremental sort Alexander Korotkov 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/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   appveyor success   travis success
20/1446 MERGE Simon Riggs, Pavan Deolasee patch   apply failure
20/1633 Make description of heap records more talkative for flags Michael Paquier patch   apply success   appveyor success   travis success
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 success   appveyor success   travis success
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/1552 Nested ConvertRowtypeExpr optimization Ashutosh Bapat 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/1817 New vacuum option to do only freezing Masahiko Sawada patch   apply failure
20/1535 Online enabling of checksums Magnus Hagander, Daniel Gustafsson patch   apply failure
20/1733 Online verification of checksums Michael Banck patch   apply success   appveyor success   travis failure
20/1694 Partition tree inspection functions Amit Langote patch   apply failure
20/1283 Pluggable storage API Álvaro Herrera, Alexander Korotkov, Haribabu Kommi patch   apply failure
20/1786 Progress reporting for pg_verify_checksums Bernd Helmle, Michael Banck patch   apply success   appveyor failure   travis success
20/1711 Proposal for changes to recovery.conf API Simon Riggs, Sergei Kornilov patch   apply success   appveyor success   travis success
20/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply failure
20/1831 Pull up sublink of type 'NOT NOT (expr)' Richard Guo patch   apply success (new)   appveyor success (new)   travis success (new)
20/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   appveyor failure   travis 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   appveyor success   travis success
20/1829 Refactoring the checkpointer's fsync request queue Thomas Munro patch   apply success   appveyor success   travis success
20/1806 Remove dsm_resize() Thomas Munro patch   apply success   appveyor success   travis success
20/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply success   appveyor failure   travis failure
20/1626 Replace conversion_create.sql with normal data entries John Naylor patch   apply success   appveyor success   travis success
20/621 Respect client-initiated CopyDone during logical streaming replication Dave Cramer, Vladimir Gordiychuk patch   apply failure
20/1823 Restore CurrentUserId only if 'prevUser' is valid when abort transaction Richard Guo patch   apply success   appveyor success   travis success
20/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply success   appveyor success   travis success
20/1802 Retail IndexTuple Deletion Andrey Lepikhov patch   apply success   appveyor failure   travis failure
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   appveyor success   travis success
20/1704 SQL/JSON: documentation Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor success   travis success
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 failure
20/1731 Show size of partitioned table Pavel Stehule patch   apply success   appveyor success   travis success
20/1791 Small performance tweak to run-time partition pruning David Rowley patch   apply success   appveyor success   travis success
20/1825 Small run-time pruning doc fix David Rowley patch   apply success   appveyor success   travis success
20/1812 Some incorrect comments and out-dated README from run-time pruning David Rowley patch   apply success   appveyor success   travis success
20/1767 Strengthen PGSharedMemoryCreate checks for still-attached processes Noah Misch patch   apply success   appveyor success   travis success
20/1822 Support custom socket directory in pg_upgrade Daniel Gustafsson patch   apply success   appveyor success   travis success
20/1814 Sync ECPG scanner with core John Naylor patch   apply success   appveyor success   travis success
20/1589 Synchronous replay mode for avoiding stale reads on hot standbys Thomas Munro patch   apply failure
20/1718 Track the next xid using 64 bits Thomas Munro patch   apply success   appveyor success   travis success
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/1085 XML XPath default namespace support Pavel Stehule patch   apply success   appveyor failure   travis failure
20/1800 amcheck verification for GiST Andrey Borodin patch   apply success   appveyor success   travis success
20/1594 chained transactions Peter Eisentraut patch   apply failure
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 failure   travis failure
20/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply failure
20/1808 kqueue Thomas Munro patch   apply success   appveyor success   travis success
20/1769 libpq host/hostaddr consistency Fabien Coelho patch   apply success   appveyor success   travis success
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/1522 pg_hba.conf : new auth option : clientcert=verify-full Julian Markwort patch   apply success   appveyor success   travis success
20/1707 pg_stat_statements_reset() update to reset specific statement statistics Haribabu Kommi 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/1722 pread() and pwrite() Oskari Saarenmaa, Thomas Munro patch   apply success   appveyor success   travis success
20/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor failure   travis failure
20/1815 settings to control SSL/TLS protocol version Peter Eisentraut patch   apply success   appveyor success   travis success
20/1763 snprintf.c performance improvements Tom Lane patch   apply failure
20/1757 unused/redundant foreign key code Peter Eisentraut patch   apply success   appveyor success   travis success
20/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply success   appveyor success   travis success

Waiting on Author

20/1319 Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs Nicolas Williams patch   apply failure
20/1821 Avoid creation of the free space map for small tables John Naylor patch   apply success   appveyor success   travis success
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   travis failure
20/1573 Changing the autovacuum launcher scheduling; oldest table first algorithm Masahiko Sawada patch   apply failure
20/1651 GROUP BY optimization Fedor Sigaev patch   apply failure
20/1598 GiST VACUUM Constantine Kuznetsov, Andrey Borodin patch   apply failure
20/1277 GnuTLS support Andreas Karlsson, Peter Eisentraut patch   apply failure
20/1543 ICU as default collation provider Marina Polyakova patch   apply failure
20/1604 Implement ASSERTIONs per the SQL standard. Joe Wildish 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 success   travis success
20/1317 Pipelining/batch mode support for libpq Craig Ringer, vaishnavi prabakaran patch   apply failure
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 failure
20/1460 Sample values for pg_stat_statements Vik Fearing patch   apply failure
20/1778 Speed up planning with partitions Amit Langote patch   apply failure
20/1755 Tid scan improvements (ordering and range scan) Edmund Horner patch   apply failure
20/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply success   appveyor success   travis success
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/1537 file cloning in pg_upgrade Peter Eisentraut 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/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor building   travis building

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