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

18/1676 Adding tests for inheritance trees with temporary tables Michael Paquier patch   apply success   appveyor success   travis success
18/1311 Another oddity in handling of WCO constraints in postgres_fdw Etsuro Fujita patch   apply failure
18/1652 Bitmapset optimization in postgres_fdw Daniel Gustafsson patch   apply success   appveyor success   travis success
18/713 Correct space parsing in to_timestamp() Arthur Zakirov patch   apply success   appveyor success   travis success
18/1294 Custom compression methods Ildus Kurbangaliev patch   apply failure
18/922 Failure at replay for corrupted 2PC files + reduce window between end-of-recover... Heikki Linnakangas, Michael Paquier patch   apply success   appveyor success   travis success
18/1166 Fix LWLock degradation on NUMA Yura Sokolov patch   apply success   appveyor success   travis success
18/1421 Flexible configuration for full-text search Aleksandr Parfenov patch   apply failure
18/1647 GSSAPI encryption support Robbie Harwood patch   apply success   appveyor success   travis building
18/1491 Handling better supported channel binding types for SSL implementations Michael Paquier patch   apply success   appveyor success   travis success
18/1204 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply failure
18/1160 Improve geometric types Emre Hasegeli patch   apply success   appveyor failure   travis success
18/1687 Incorrect comments in commit_ts.c bret shao patch   apply failure
18/1113 Replication status in logical replication Masahiko Sawada patch   apply failure
18/1426 Test partition-wise join with partitioned tables containing default partition rajkumar raghuwanshi patch   apply success   appveyor success   travis success
18/1085 XML XPath default namespace support Pavel Stehule patch   apply success   appveyor failure   travis failure
18/1674 location reporting in TAP test failures Peter Eisentraut patch   apply success   appveyor success   travis success
18/1638 log_min_messages shows debug instead of debug2 Takeshi Ideriha patch   apply success (new)   appveyor success (new)   travis success (new)
18/962 new plpgsql extra_checks Pavel Stehule patch   apply success   appveyor success   travis success
18/1522 pg_hba.conf : new auth option : clientcert=verify-full Julian Markwort patch   apply failure
18/669 pgbench - allow to store query results into variables Fabien Coelho patch   apply failure
18/1388 pgbench - option to build using ppoll() for larger connection counts doug rady patch   apply success   appveyor failure   travis success
18/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply success   appveyor success   travis success

Needs review

18/1622 A way to request the rotation of server logs Kyotaro Horiguchi patch   apply success   appveyor success   travis success
18/1621 ALTER TABLE - check for column existence before starting operations Pierre Ducroquet patch   apply success   appveyor success   travis success
18/1625 Accounting of zero-filled buffers in EXPLAIN (BUFFERS) Thomas Munro patch   apply success   appveyor success   travis success
18/1644 Add --include-table-data-where option to pg_dump, to export only a subset of tab... patch   apply success   appveyor success   travis success
18/1319 Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs Nicolas Williams patch   apply success   appveyor success   travis success
18/1399 Add SKIP LOCKED option to VACUUM and ANALYZE Nathan Bossart patch   apply success   appveyor success   travis success
18/1684 Add application_name to "connection authorized" log messages Don Seiler patch   apply success   appveyor success   travis success
18/1489 Add enum releation option type Nikolay Shaplov patch   apply success   appveyor success   travis success
18/1669 Add function to release an allocated SQLDA sho kato patch   apply failure
18/1499 Add missing type conversion functions for PL/Python Haozhou Wang patch   apply success   appveyor success   travis success (new)
18/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply failure
18/1553 Advanced partition matching for partition-wise join Ashutosh Bapat patch   apply success   appveyor failure   travis failure
18/1629 Allow COPY's 'text' format to output a header Simon Muller patch   apply success   appveyor success   travis failure
18/1668 Allow build.pl just to construct project files without running a build Andrew Dunstan patch   apply success   appveyor success   travis success
18/1605 Allow granting of permission to REFRESH MATERIALIZED VIEW, CLUSTER, and REINDEX Isaac Morland patch   apply success   appveyor success   travis success
18/1485 Applying PMDK to WAL operations for persistent memory yoshimi ichiyanagi patch   apply failure
18/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply success (new)   appveyor failure (new)   travis success (new)
18/1296 Better estimate for filter cost Yuto Hayamizu, Ryoji Kawamichi patch   apply success   appveyor success   travis success
18/1688 Build frontend executables (particularly pg_test_fsync) using pgwin32_open on Wi... Laurenz Albe patch   apply success   appveyor failure   travis success
18/1455 Changing WAL Header to reduce contention during ReserveXLogInsertLocation() Simon Riggs, Pavan Deolasee patch   apply success   appveyor success   travis success
18/1573 Changing the autovacuum launcher scheduling; oldest table first algorithm Masahiko Sawada patch   apply failure
18/1655 Check constraint documentation about cross table constraint Lætitia AVROT, Patrick Francelle patch   apply success   appveyor success   travis success
18/1673 Client Connection redirection support for PostgreSQL patch   apply failure
18/1639 Clone file descriptors into checkpointer, to handle fsync issues on at least lin... Andres Freund patch   apply success   appveyor success   travis success
18/1660 Concurrency bug in UPDATE of partition-key Amit Khandekar patch   apply success   appveyor success   travis success
18/1663 Consider avoiding terms "partition" and "partitioned" in docs for inheritence-ba... Justin Pryzby patch   apply failure
18/1001 Convert join OR clauses into UNION queries Tom Lane patch   apply failure
18/1554 ConvertRowtypeExpr reference errors from partition-wise join Ashutosh Bapat patch   apply success   appveyor success (new)   travis success
18/1615 Covering GiST indexes Andrey Borodin patch   apply success   appveyor success   travis success
18/1671 Default values in partition tables don't work as expected and allow NOT NULL vio... Amit Langote patch   apply failure
18/1656 Desirability of psql \if expressions? Fabien Coelho
18/1664 Evaluate immutable functions during planning (in FROM clause) Aleksandr Parfenov patch   apply success   appveyor failure   travis failure
18/1679 Excessive CPU usage in StandbyReleaseLocks() Thomas Munro patch   apply success   appveyor success   travis success
18/1264 Exclude partition constaint checking in query execution plan for partitioned tab... Konstantin Knizhnik patch   apply failure
18/1618 Exit by default if postmaster dies Thomas Munro patch   apply success   appveyor failure (new)   travis success
18/1480 Find additional connection service files in pg_service.conf.d directory Curt Tilmes patch   apply success   appveyor success   travis success
18/1683 Fix cancelled queries when hot_standby_feedback = on Ivan Kartyshov patch   apply success   appveyor failure (new)   travis failure
18/1650 Fix slot's xmin advancement and subxact's lost snapshots in decoding Arseny Sher patch   apply success   appveyor success   travis success
18/1642 Fix some error handling for read() and errno Michael Paquier patch   apply success   appveyor success   travis success
18/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
18/1613 Fsync queue forgets requests on failure Thomas Munro patch   apply success   appveyor success   travis success
18/1141 Full merge join on comparison clause Alexander Kuzmenkov patch   apply success   appveyor success   travis success
18/1651 GROUP BY optimization Fedor Sigaev patch   apply success   appveyor success   travis success
18/1062 Generic type subscripting Dmitry Dolgov patch   apply success   appveyor success   travis success
18/1598 GiST VACUUM Constantine Kuznetsov, Andrey Borodin patch   apply success   appveyor success   travis success
18/1662 Global snapshots Stas Kelvich, Konstantin Knizhnik patch   apply success   appveyor success   travis success
18/1277 GnuTLS support Andreas Karlsson patch   apply failure
18/1543 ICU as default collation provider Marina Polyakova
18/1604 Implement ASSERTIONs per the SQL standard. patch   apply success   appveyor failure   travis failure
18/1138 Improve compactify_tuples and PageRepairFragmentation Yura Sokolov patch   apply failure
18/1658 Improve recovery performance of dropping database having many tablespaces Fujii Masao patch   apply success   appveyor success   travis success
18/1124 Incremental sort Alexander Korotkov patch   apply success   appveyor success   travis failure
18/1288 Lazy hash table for snapshot's "xid in progress" Yura Sokolov patch   apply success   appveyor success   travis success
18/1659 Locking B-tree leafs immediately in exclusive mode Alexander Korotkov patch   apply success   appveyor success   travis success
18/944 Logical decoding of two-phase transactions Stas Kelvich, Nikhil Sontakke patch   apply failure
18/1678 Logical replication docs indicating cross platform support Haribabu Kommi patch   apply success   appveyor success   travis success
18/1632 MAP syntax for arrays Ildar Musin patch   apply success   appveyor failure   travis failure
18/1446 MERGE Simon Riggs, Pavan Deolasee patch   apply failure
18/1617 Make PostmasterIsAlive() go faster with signals Thomas Munro patch   apply success   appveyor success   travis success
18/1657 Make deparsing of column defaults faster Jeff Janes patch   apply success   appveyor success   travis success
18/1633 Make description of heap records more talkative for flags Michael Paquier patch   apply success (new)   appveyor success (new)   travis success (new)
18/1672 Make installcheck-world in a clean environment Alexander Lakhin patch   apply failure
18/1666 Moving relation extension locks out of heavyweight lock manager Masahiko Sawada patch   apply success   appveyor success   travis success
18/1686 Multi-inserts for partitioned tables in COPY David Rowley patch   apply success   appveyor success   travis success
18/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply success   appveyor success   travis success
18/1513 OFFSET optimisation for IndexScan using visibility map Michail Nikolaev patch   apply success   appveyor success   travis success
18/1535 Online enabling of checksums Magnus Hagander, Daniel Gustafsson patch   apply failure
18/1653 Order windows to avoid Sort node between WindowAgg where sort result can be reus... Daniel Gustafsson patch   apply success   appveyor success   travis success
18/1680 PANIC during crash recovery of a recently promoted standby Kyotaro Horiguchi, Pavan Deolasee patch   apply success   appveyor success   travis success
18/1317 Pipelining/batch mode support for libpq Craig Ringer, vaishnavi prabakaran patch   apply success   appveyor success   travis success
18/1283 Pluggable storage API Álvaro Herrera, Alexander Korotkov, Haribabu Kommi patch   apply failure
18/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply failure
18/1654 Provide toast tables for all system tables except those that the toast mechanism... Joe Conway patch   apply failure
18/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply success   appveyor success   travis success
18/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply failure (new)
18/1685 Push down aggregates below joins. Heikki Linnakangas patch   apply failure
18/1624 Range phrase operator in tsquery Aleksandr Parfenov patch   apply failure
18/1578 Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist Anastasia Lubennikova patch   apply failure
18/1690 Reduce partition tuple routing overheads David Rowley patch   apply success   appveyor success (new)   travis success
18/1572 Remove DSM_IMPL_NONE Kyotaro Horiguchi patch   apply success   appveyor success (new)   travis success
18/1364 Remove LEFT JOINs in more cases David Rowley patch   apply success   appveyor success   travis success
18/1353 Removing [Merge]Append nodes which contain a single subpath David Rowley patch   apply failure
18/1626 Replace conversion_create.sql with normal data entries John Naylor patch   apply failure
18/1505 Reset temp schema on connection to prevent XID wraparound Takayuki Tsunakawa patch   apply success   appveyor success   travis success
18/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply failure
18/1675 Run-time partition pruning for MergeAppend David Rowley patch   apply success   appveyor success   travis success
18/1004 SERIALIZABLE with parallel query Thomas Munro patch   apply success   appveyor success   travis success
18/1682 SLRU data page checksums patch   apply failure
18/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
18/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
18/1471 SQL/JSON: jsonpath Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
18/1691 Sample rate logging Adrien Nayrat patch   apply success (new)   appveyor success (new)   travis success (new)
18/1460 Sample values for pg_stat_statements Vik Fearing patch   apply success   appveyor failure (new)   travis success
18/1461 Shared Ispell dictionaries Arthur Zakirov patch   apply success   appveyor success   travis success
18/1609 Simplify final sync in pg_rewind's target folder and add --no-sync Michael Paquier patch   apply success   appveyor success   travis success
18/1530 Speed up WAL file removal during recovery Takayuki Tsunakawa patch   apply success   appveyor success   travis success
18/1616 Speedup of relation deletes during recovery Fujii Masao patch   apply success   appveyor success   travis success
18/1646 Subplan result cache Heikki Linnakangas patch   apply success   appveyor success   travis success
18/1670 Support optional message in backend cancellation/termination Daniel Gustafsson patch   apply success   appveyor failure (new)   travis success
18/1589 Synchronous replay mode for avoiding stale reads on hot standbys Thomas Munro patch   apply failure
18/1376 Tab completion for SELECT in psql Edmund Horner patch   apply success   appveyor success   travis success
18/1630 Temporary WAL segments files not cleaned up after an instance crash Michael Paquier patch   apply success   appveyor success   travis success
18/1643 Test for trigger accessing a system column Ashutosh Bapat patch   apply success   appveyor failure   travis failure
18/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply success   appveyor success   travis success
18/1641 Try to produce compiler warnings for incorrect usage of printf("%m") Tom Lane patch   apply success   appveyor failure   travis failure
18/1602 Two pass check for deadlock Yura Sokolov patch   apply success   appveyor success (new)   travis success
18/1649 Undo logs Thomas Munro patch   apply success   appveyor success   travis success
18/1628 Use /etc/localtime to identify system timezone when possible Tom Lane patch   apply success   appveyor success   travis success
18/1636 Use access() to check file existence in GetNewRelFileNode(). Paul Guo patch   apply success   appveyor success   travis success
18/844 Vacuum: allow usage of more than 1GB of work mem Claudio Freire patch   apply success   appveyor success   travis success
18/1645 WIP: Pgbench Errors and serialization/deadlock retries Marina Polyakova patch   apply failure
18/1648 WIP: Precalculate stable functions Arthur Zakirov, Marina Polyakova patch   apply failure
18/990 add GUCs to control custom plan logic Pavel Stehule patch   apply success   appveyor success   travis success
18/1594 chained transactions Peter Eisentraut patch   apply failure
18/1500 csv output format for psql Daniel Vérité patch   apply success   appveyor failure   travis failure
18/1667 cursors with prepared statements Peter Eisentraut patch   apply success   appveyor success   travis success
18/1619 de-deduplicate code in DML execution hooks in postgres_fdw Ashutosh Bapat patch   apply success   appveyor success   travis failure (new)
18/1537 file cloning in pg_upgrade Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
18/1591 fix constraint exclusion failure for certain partition key types Amit Langote patch   apply failure
18/1620 generalized expression syntax for partition bounds Tom Lane, Kyotaro Horiguchi, Amit Langote patch   apply failure
18/1640 generate bootstrap entries for array types John Naylor patch   apply success   appveyor success   travis success
18/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply failure
18/1540 hash joins with bloom filters Tomas Vondra patch   apply failure
18/1631 hostorder and failover_timeout for libpq Ildar Musin patch   apply success   appveyor success   travis success
18/1587 kNN for SP-GiST Nikita Glukhov patch   apply failure
18/1518 lc_messages parameter doesn't work on Windows Aleksandr Parfenov patch   apply success   appveyor success   travis success
18/1490 macOS Secure Transport SSL Support Daniel Gustafsson patch   apply failure
18/1238 multivariate MCV lists and histograms Tomas Vondra patch   apply failure
18/1482 pg_rewind corrupts control file global/pg_control Michael Paquier patch   apply success   appveyor success   travis success
18/1470 pg_stat_statements with plans (v02) Marius Timmer, Julian Markwort patch   apply success   appveyor failure   travis failure
18/1637 pg_ugprade test failure on data set with column with default value with type bit... Paul Guo patch   apply success   appveyor success   travis failure
18/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply failure
18/1528 pgbench - test whether a variable exists Fabien Coelho patch   apply failure
18/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
18/1608 schema variables, LET command Pavel Stehule patch   apply failure

Waiting on Author

18/1665 --on-conflict-do-nothing option to pg_dump Surafel Temesgen
18/1623 Allow auto_explain to log to NOTICE Tom Dunstan patch   apply success   appveyor success   travis failure
18/1252 Foreign Key Arrays Mark Rofail patch   apply success   appveyor failure   travis failure
18/1552 Nested ConvertRowtypeExpr optimization Ashutosh Bapat patch   apply success   appveyor success   travis success
18/1661 Update psql tab completion for multiple commits Justin Pryzby
18/1635 libpq compression Konstantin Knizhnik patch   apply success   appveyor success   travis success (new)
18/1429 logical streaming for large in-progress transactions Tomas Vondra, Petr Jelínek patch   apply failure

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