PostgreSQL Patch Tester

Here lives an experimental bot that does this: Commitfest → Github → ( Travis, AppVeyor ). You can find a report for the current CF, the next CF or individual patch authors.

Announcing some new features: result links now take you directly to build logs, testing is now done on multiple operating systems, and new patches should be picked up a lot more quickly than before.

Ready for Committer

19/1728 Allow to warn or error on ... = NULL expressions David Fetter patch   apply success   appveyor success   travis success
19/1166 Fix LWLock degradation on NUMA Yura Sokolov patch   apply success   appveyor success   travis success
19/1647 GSSAPI encryption support Robbie Harwood patch   apply failure
19/1160 Improve geometric types Emre Hasegeli patch   apply success (new)   appveyor success   travis success
19/1661 Update psql tab completion for multiple commits Justin Pryzby patch   apply failure
19/1085 XML XPath default namespace support Pavel Stehule patch   apply success   appveyor failure   travis failure
19/1587 kNN for SP-GiST Nikita Glukhov patch   apply failure
19/669 pgbench - allow to store query results into variables Fabien Coelho patch   apply success   appveyor success   travis success
19/1723 pgbench - overflow detection Fabien Coelho patch   apply failure

Needs review

19/1622 A way to request the rotation of server logs Kyotaro Horiguchi patch   apply success   appveyor building   travis building
19/1764 ALTER TABLE on system catalogs Peter Eisentraut patch   apply success (new)   appveyor failure (new)   travis failure (new)
19/1625 Accounting of zero-filled buffers in EXPLAIN (BUFFERS) Thomas Munro patch   apply success   appveyor success   travis success
19/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
19/1319 Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs Nicolas Williams patch   apply failure
19/1724 Add IGNORE NULLS and FROM LAST options Oliver Ford patch   apply success   appveyor success   travis success
19/1760 Add a semicolon to query related to search_path patch   apply success   appveyor success (new)   travis success (new)
19/1489 Add enum releation option type Nikolay Shaplov patch   apply success   appveyor success   travis success
19/1669 Add function to release an allocated SQLDA sho kato patch   apply failure
19/1748 Add regress test for pg_read_all_stats role Alexandra Ryzhevich patch   apply success   appveyor success   travis success
19/1738 Adding a note to protocol.sgml regarding CopyData Tatsuo Ishii patch   apply success   appveyor success   travis success
19/1553 Advanced partition matching for partition-wise join Ashutosh Bapat patch   apply success   appveyor failure   travis failure
19/1605 Allow granting of permission to REFRESH MATERIALIZED VIEW, CLUSTER, and REINDEX Isaac Morland patch   apply success   appveyor success   travis success
19/1726 Allow to rename index in concurrent mode Peter Eisentraut, Andrew Klychkov
19/1721 Allow to specify a index name as ANALYZE parameter Yugo Nagata patch   apply success   appveyor success   travis success
19/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... patch   apply success   appveyor success   travis success
19/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply success   appveyor failure   travis failure
19/1727 BUG #15288: Logical Replication failed when inserting record which has CHECK con... patch   apply failure
19/1296 Better estimate for filter cost Yuto Hayamizu, Ryoji Kawamichi patch   apply success   appveyor success   travis success
19/1688 Build frontend executables (particularly pg_test_fsync) using pgwin32_open on Wi... Laurenz Albe patch   apply success   appveyor success   travis success
19/1573 Changing the autovacuum launcher scheduling; oldest table first algorithm Masahiko Sawada patch   apply failure
19/1673 Client Connection redirection support for PostgreSQL patch   apply failure
19/1639 Clone file descriptors into checkpointer, to handle fsync issues on at least lin... Andres Freund patch   apply failure
19/1001 Convert join OR clauses into UNION queries Tom Lane patch   apply failure
19/1554 ConvertRowtypeExpr reference errors from partition-wise join Ashutosh Bapat patch   apply success   appveyor success   travis success
19/1705 Copy function for logical replication slots Masahiko Sawada patch   apply success   appveyor success (new)   travis success
19/713 Correct space parsing in to_timestamp() Arthur Zakirov patch   apply success   appveyor success   travis success
19/1615 Covering GiST indexes Andrey Borodin patch   apply success   appveyor success   travis success
19/1294 Custom compression methods Ildus Kurbangaliev patch   apply failure
19/1671 Default values in partition tables don't work as expected and allow NOT NULL vio... Amit Langote patch   apply failure
19/1765 Detect shared buffer access violations using mprotect() Asim Rama Praveen patch   apply success (new)   appveyor success (new)   travis success (new)
19/1618 Easy way to handle postmaster death + related bug fixes and improvements Thomas Munro patch   apply success   appveyor success   travis success
19/1759 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis failure
19/1683 Fix cancelled queries when hot_standby_feedback = on Ivan Kartyshov patch   apply success   appveyor success   travis success
19/1766 Fix for REFRESH MATERIALIZED VIEW ownership error message Jonathan Katz
19/1756 Fix quadratic performance of regexp match/split functions Andrew Gierth patch   apply success   appveyor success   travis success
19/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply failure
19/1421 Flexible configuration for full-text search Aleksandr Parfenov patch   apply failure
19/1141 Full merge join on comparison clause Alexander Kuzmenkov patch   apply success   appveyor success   travis success
19/1651 GROUP BY optimization Fedor Sigaev patch   apply success   appveyor success   travis success
19/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
19/1598 GiST VACUUM Constantine Kuznetsov, Andrey Borodin patch   apply success   appveyor success   travis success
19/1695 Global shared meta cache Takeshi Ideriha patch   apply success   appveyor failure (new)   travis failure
19/1662 Global snapshots Stas Kelvich, Konstantin Knizhnik patch   apply success   appveyor failure   travis failure
19/1277 GnuTLS support Andreas Karlsson, Peter Eisentraut patch   apply failure
19/1543 ICU as default collation provider Marina Polyakova patch   apply success   appveyor success   travis success
19/1604 Implement ASSERTIONs per the SQL standard. Joe Wildish patch   apply success   appveyor failure   travis failure
19/1204 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success   appveyor success   travis success
19/1138 Improve compactify_tuples and PageRepairFragmentation Yura Sokolov patch   apply failure
19/1717 Incorrect error handling for two-phase state files resulting in data loss Michael Paquier patch   apply success   appveyor success   travis success
19/1124 Incremental sort Alexander Korotkov patch   apply success   appveyor success   travis failure
19/1741 Index Skip Scan Thomas Munro, Jesper Pedersen patch   apply success   appveyor success   travis success (new)
19/1753 Indicate anti-wraparound autovacuum in log_autovacuum_min_duration Sergei Kornilov patch   apply success   appveyor success   travis success
19/1734 Inline Common Table Expressions Andrew Gierth, David Fetter patch   apply success   appveyor success   travis success
19/1288 Lazy hash table for snapshot's "xid in progress" Yura Sokolov patch   apply success   appveyor success   travis success
19/944 Logical decoding of two-phase transactions Nikhil Sontakke patch   apply success   appveyor success   travis success
19/1446 MERGE Simon Riggs, Pavan Deolasee patch   apply failure
19/1657 Make deparsing of column defaults faster Jeff Janes patch   apply success   appveyor success   travis success
19/1633 Make description of heap records more talkative for flags Michael Paquier patch   apply success   appveyor success   travis success
19/1672 Make installcheck-world in a clean environment Alexander Lakhin patch   apply success   appveyor success   travis success
19/1666 Moving relation extension locks out of heavyweight lock manager Masahiko Sawada patch   apply success   appveyor success   travis success
19/1698 Nepali Snowball dictionary Arthur Zakirov, Oleg Bartunov patch   apply success   appveyor success   travis success
19/1535 Online enabling of checksums Magnus Hagander, Daniel Gustafsson patch   apply failure
19/1733 Online verification of checksums Michael Banck patch   apply success   appveyor success   travis success
19/1653 Order windows to avoid Sort node between WindowAgg where sort result can be reus... Daniel Gustafsson patch   apply success   appveyor success   travis success
19/1694 Partition tree inspection functions Amit Langote patch   apply success   appveyor success   travis success
19/1317 Pipelining/batch mode support for libpq Craig Ringer, vaishnavi prabakaran patch   apply failure
19/1283 Pluggable storage API Álvaro Herrera, Alexander Korotkov, Haribabu Kommi patch   apply failure
19/1711 Proposal for changes to recovery.conf API Simon Riggs, Sergei Kornilov patch   apply success   appveyor success   travis success
19/1761 Proposal to add work_mem option to postgres_fdw module Noriyoshi Shinoda patch   apply success (new)   appveyor success (new)   travis success (new)
19/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor success   travis success
19/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply success   appveyor success   travis success
19/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply failure
19/1624 Range phrase operator in tsquery Aleksandr Parfenov patch   apply success   appveyor success   travis success
19/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
19/1690 Reduce partition tuple routing overheads David Rowley patch   apply failure
19/1364 Remove LEFT JOINs in more cases David Rowley patch   apply success   appveyor success   travis success
19/1712 Remove self join on a unique column Alexander Kuzmenkov patch   apply success   appveyor success   travis success
19/1353 Removing [Merge]Append nodes which contain a single subpath David Rowley patch   apply failure
19/1626 Replace conversion_create.sql with normal data entries John Naylor patch   apply success   appveyor success   travis success
19/1719 Retrieve memory size allocated by libpq Lars Kanis patch   apply success   appveyor success   travis success
19/1758 Revise executor's handling of range table relations Amit Langote patch   apply success   appveyor success   travis success
19/1682 SLRU data page checksums patch   apply failure
19/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
19/1704 SQL/JSON: documentation Nikita Glukhov, Oleg Bartunov patch   apply success   appveyor success   travis success
19/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
19/1471 SQL/JSON: jsonpath Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
19/1460 Sample values for pg_stat_statements Vik Fearing patch   apply failure
19/1461 Shared Ispell dictionaries Arthur Zakirov patch   apply success   appveyor success   travis success
19/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply success   appveyor success   travis failure
19/1731 Show size of partitioned table Pavel Stehule patch   apply success   appveyor success   travis success
19/1670 Support optional message in backend cancellation/termination Daniel Gustafsson patch   apply success   appveyor failure   travis success
19/1589 Synchronous replay mode for avoiding stale reads on hot standbys Thomas Munro patch   apply success   appveyor success   travis success
19/1376 Tab completion for SELECT in psql Edmund Horner patch   apply success   appveyor success   travis success
19/1755 Tid scan improvements (ordering and range scan) Edmund Horner patch   apply success   appveyor success   travis success
19/1718 Track the next xid using 64 bits Thomas Munro patch   apply success   appveyor success   travis success
19/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply success   appveyor success   travis success
19/1641 Try to produce compiler warnings for incorrect usage of printf("%m") Tom Lane patch   apply failure (new)
19/1602 Two pass check for deadlock Yura Sokolov patch   apply success   appveyor success   travis success
19/1649 Undo logs Thomas Munro patch   apply success   appveyor success   travis success
19/1697 Update snowball stemmers Arthur Zakirov patch   apply success   appveyor failure   travis failure
19/1628 Use /etc/localtime to identify system timezone when possible Tom Lane patch   apply success   appveyor success   travis success
19/1732 VACUUM, TRUNCATE, REINDEX -- Canceling authentication due to timeout aka Denial ... Michael Paquier patch   apply success   appveyor success   travis success
19/1648 WIP: Precalculate stable functions Arthur Zakirov, Marina Polyakova patch   apply failure
19/1594 chained transactions Peter Eisentraut patch   apply failure
19/1745 conflict handling for COPY FROM Surafel Temesgen patch   apply success   appveyor failure   travis failure
19/1706 cost_sort improvement Fedor Sigaev patch   apply success   appveyor failure   travis failure
19/1667 cursors with prepared statements Peter Eisentraut patch   apply success   appveyor success   travis success
19/1619 de-deduplicate code in DML execution hooks in postgres_fdw Ashutosh Bapat patch   apply success   appveyor success   travis success
19/1742 doc - add documentation for aclitem functions Fabien Coelho patch   apply failure
19/1537 file cloning in pg_upgrade Peter Eisentraut patch   apply failure
19/1620 generalized expression syntax for partition bounds Tom Lane, Kyotaro Horiguchi, Amit Langote patch   apply success   appveyor success   travis success
19/1640 generate bootstrap entries for array types John Naylor patch   apply success   appveyor success   travis success
19/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply failure
19/1540 hash joins with bloom filters Tomas Vondra patch   apply failure
19/1631 hostorder and failover_timeout for libpq Ildar Musin patch   apply failure
19/1739 improve documentation about default privileges Fabien Coelho patch   apply failure (new)
19/1518 lc_messages parameter doesn't work on Windows Aleksandr Parfenov patch   apply success   appveyor success   travis success
19/1752 libpq should append error messages, not overwrite Tom Lane patch   apply success   appveyor failure   travis failure
19/1749 libpq should not look up all host addresses at once Tom Lane patch   apply success   appveyor success   travis success
19/1762 libpq stricter integer parsing Fabien Coelho patch   apply failure (new)
19/1238 multivariate MCV lists and histograms Tomas Vondra patch   apply success   appveyor success   travis success
19/1522 pg_hba.conf : new auth option : clientcert=verify-full Julian Markwort patch   apply success   appveyor success   travis success
19/1707 pg_stat_statements_reset() update to reset specific statement statistics Haribabu Kommi patch   apply failure
19/1637 pg_ugprade test failure on data set with column with default value with type bit... Paul Guo patch   apply success   appveyor success   travis success
19/1736 pgbench - add pseudo-random permutation function Fabien Coelho patch   apply failure
19/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply failure
19/1754 pgbench - doCustom cleanup Fabien Coelho patch   apply failure
19/1744 pgbench - document compatibility with older server versions Fabien Coelho patch   apply failure (new)
19/1388 pgbench - option to build using ppoll() for larger connection counts doug rady patch   apply success   appveyor building   travis building
19/1528 pgbench - test whether a variable exists Fabien Coelho patch   apply failure
19/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
19/1722 pread() and pwrite() Oskari Saarenmaa, Thomas Munro patch   apply success   appveyor success   travis success
19/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor success   travis success
19/1763 snprintf.c performance improvements Tom Lane patch   apply success (new)   appveyor success (new)   travis success (new)
19/1757 unused/redundant foreign key code Peter Eisentraut patch   apply success   appveyor success   travis success
19/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply success   appveyor success   travis success

Waiting on Author

19/1621 ALTER TABLE - check for column existence before starting operations Pierre Ducroquet patch   apply success   appveyor success   travis success (new)
19/1399 Add SKIP LOCKED option to VACUUM and ANALYZE Nathan Bossart patch   apply success   appveyor success   travis success
19/1684 Add application_name to "connection authorized" log messages Don Seiler patch   apply success   appveyor success   travis success
19/1499 Add missing type conversion functions for PL/Python Haozhou Wang patch   apply success   appveyor success   travis failure
19/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply failure
19/1629 Allow COPY's 'text' format to output a header Simon Muller patch   apply success   appveyor success   travis success
19/1485 Applying PMDK to WAL operations for persistent memory yoshimi ichiyanagi patch   apply failure
19/1655 Check constraint documentation about cross table constraint Lætitia AVROT, Patrick Francelle patch   apply success   appveyor success   travis success
19/1664 Evaluate immutable functions during planning (in FROM clause) Aleksandr Parfenov patch   apply success   appveyor failure   travis failure
19/1264 Exclude partition constaint checking in query execution plan for partitioned tab... Konstantin Knizhnik patch   apply success   appveyor failure   travis failure
19/1480 Find additional connection service files in pg_service.conf.d directory Curt Tilmes patch   apply success   appveyor success   travis success
19/1252 Foreign Key Arrays Mark Rofail patch   apply success   appveyor failure   travis failure
19/1658 Improve recovery performance of dropping database having many tablespaces Fujii Masao patch   apply success   appveyor success   travis success
19/1552 Nested ConvertRowtypeExpr optimization Ashutosh Bapat patch   apply success   appveyor success   travis success
19/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply failure
19/1513 OFFSET optimisation for IndexScan using visibility map Michail Nikolaev patch   apply success   appveyor success   travis success
19/1685 Push down aggregates below joins. Heikki Linnakangas patch   apply success   appveyor failure   travis failure
19/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply failure
19/1710 Row filtering for logical replication Euler Taveira patch   apply failure
19/1004 SERIALIZABLE with parallel query Thomas Munro patch   apply success   appveyor success   travis success
19/1691 Sample rate logging Adrien Nayrat patch   apply success   appveyor success   travis success
19/1530 Speed up WAL file removal during recovery Takayuki Tsunakawa patch   apply success   appveyor success   travis success
19/1646 Subplan result cache Heikki Linnakangas patch   apply success   appveyor success   travis success
19/1725 Upper limit arguments of pg_logical_slot_xxx_changes functions accept invalid va... Masahiko Sawada patch   apply success   appveyor success   travis success
19/844 Vacuum: allow usage of more than 1GB of work mem Heikki Linnakangas, Claudio Freire patch   apply success   appveyor success   travis success
19/1645 WIP: Pgbench Errors and serialization/deadlock retries Marina Polyakova patch   apply failure
19/1500 csv output format for psql Daniel Vérité patch   apply success   appveyor success   travis success
19/1635 libpq compression Konstantin Knizhnik patch   apply success   appveyor success   travis success
19/1429 logical streaming for large in-progress transactions Tomas Vondra, Petr Jelínek patch   apply failure
19/1490 macOS Secure Transport SSL Support Daniel Gustafsson patch   apply failure
19/1700 option to disable WAL recycling Jerry Jelinek patch   apply failure
19/1743 pg_dumpall --exclude-database option Andrew Dunstan patch   apply success   appveyor success   travis success
19/1470 pg_stat_statements with plans (v02) Marius Timmer, Julian Markwort patch   apply success   appveyor failure   travis success
19/1751 pgbench - set non zero exit code on all errors Peter Eisentraut patch   apply success   appveyor success   travis success

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