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/1684 Add application_name to "connection authorized" log messages Don Seiler patch
18/1655 Check constraint documentation about cross table constraint Lætitia AVROT, Patrick Francelle patch   apply success (new)   appveyor success (new)   travis success (new)
18/713 Correct space parsing in to_timestamp() Arthur Zakirov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1294 Custom compression methods Ildus Kurbangaliev patch   apply failure (new)
18/1166 Fix LWLock degradation on NUMA Yura Sokolov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1647 GSSAPI encryption support Robbie Harwood patch   apply success (new)   appveyor success (new)   travis success (new)
18/1491 Handling better supported channel binding types for SSL implementations Michael Paquier patch   apply success (new)   appveyor success (new)   travis success (new)
18/1160 Improve geometric types Emre Hasegeli patch   apply success (new)   appveyor success (new)   travis success (new)
18/1677 New libpq option to prefer standby for connection Haribabu Kommi patch   apply success   appveyor success   travis success
18/1085 XML XPath default namespace support Pavel Stehule patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/962 new plpgsql extra_checks Pavel Stehule patch   apply success (new)   appveyor success (new)   travis success (new)
18/1522 pg_hba.conf : new auth option : clientcert=verify-full Julian Markwort patch
18/1707 pg_stat_statements_reset() update to reset specific statement statistics Haribabu Kommi patch   apply success (new)   appveyor success (new)   travis success (new)
18/669 pgbench - allow to store query results into variables Fabien Coelho patch   apply failure (new)
18/1389 verify ALTER TABLE SET NOT NULL by valid constraints Sergei Kornilov patch   apply success (new)   appveyor success (new)   travis success (new)

Needs review

18/1622 A way to request the rotation of server logs Kyotaro Horiguchi patch   apply success (new)   appveyor success (new)   travis success (new)
18/1621 ALTER TABLE - check for column existence before starting operations Pierre Ducroquet patch   apply success (new)   appveyor success (new)   travis success (new)
18/1625 Accounting of zero-filled buffers in EXPLAIN (BUFFERS) Thomas Munro patch   apply success (new)   appveyor success (new)   travis success (new)
18/1319 Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs Nicolas Williams patch   apply failure (new)
18/1489 Add enum releation option type Nikolay Shaplov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1669 Add function to release an allocated SQLDA sho kato patch   apply failure (new)
18/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply failure (new)
18/1553 Advanced partition matching for partition-wise join Ashutosh Bapat patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1629 Allow COPY's 'text' format to output a header Simon Muller patch   apply success (new)   appveyor success (new)   travis success (new)
18/1623 Allow auto_explain to log to NOTICE Tom Dunstan patch   apply failure (new)
18/1605 Allow granting of permission to REFRESH MATERIALIZED VIEW, CLUSTER, and REINDEX Isaac Morland patch   apply success (new)   appveyor success (new)   travis success (new)
18/1485 Applying PMDK to WAL operations for persistent memory yoshimi ichiyanagi patch   apply failure (new)
18/1348 BRIN bloom and multi-minmax indexes Tomas Vondra patch   apply success (new)   appveyor success (new)   travis success (new)
18/1296 Better estimate for filter cost Yuto Hayamizu, Ryoji Kawamichi patch   apply success (new)   appveyor success (new)   travis success (new)
18/1688 Build frontend executables (particularly pg_test_fsync) using pgwin32_open on Wi... Laurenz Albe patch   apply success (new)   appveyor failure (new)   travis success (new)
18/1573 Changing the autovacuum launcher scheduling; oldest table first algorithm Masahiko Sawada patch   apply failure (new)
18/1673 Client Connection redirection support for PostgreSQL patch
18/1639 Clone file descriptors into checkpointer, to handle fsync issues on at least lin... Andres Freund patch   apply failure (new)
18/1001 Convert join OR clauses into UNION queries Tom Lane patch   apply failure (new)
18/1554 ConvertRowtypeExpr reference errors from partition-wise join Ashutosh Bapat patch   apply failure (new)
18/1705 Copy function for logical replication slots Masahiko Sawada patch   apply failure (new)
18/1615 Covering GiST indexes Andrey Borodin patch
18/1671 Default values in partition tables don't work as expected and allow NOT NULL vio... Amit Langote patch
18/1618 Easy way to handle postmaster death + related bug fixes and improvements Thomas Munro patch   apply success   appveyor success   travis success
18/1480 Find additional connection service files in pg_service.conf.d directory Curt Tilmes patch
18/1683 Fix cancelled queries when hot_standby_feedback = on Ivan Kartyshov patch   apply success (new)   appveyor success (new)   travis failure (new)
18/1642 Fix some error handling for read() and errno Michael Paquier patch   apply failure (new)
18/528 Fix the optimization to skip WAL-logging on table created in same transaction Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi patch   apply failure
18/1421 Flexible configuration for full-text search Aleksandr Parfenov patch   apply success (new)   appveyor failure (new)   travis failure (new)
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 (new)   appveyor success (new)   travis success (new)
18/1062 Generic type subscripting Dmitry Dolgov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1695 Global shared meta cache Takeshi Ideriha patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1662 Global snapshots Stas Kelvich, Konstantin Knizhnik patch   apply success (new)   appveyor success (new)   travis success (new)
18/1543 ICU as default collation provider Marina Polyakova
18/1604 Implement ASSERTIONs per the SQL standard. Peter Eisentraut, Joe Wildish patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1204 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success (new)   appveyor success (new)   travis success (new)
18/1138 Improve compactify_tuples and PageRepairFragmentation Yura Sokolov patch   apply failure (new)
18/1124 Incremental sort Alexander Korotkov patch   apply success (new)   appveyor success (new)   travis failure (new)
18/1696 Issue with Logical replication workers and sub-transactions Amit Khandekar patch   apply failure
18/1288 Lazy hash table for snapshot's "xid in progress" Yura Sokolov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1659 Locking B-tree leafs immediately in exclusive mode Alexander Korotkov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1693 Log query parameters for terminated execute Sergei Kornilov patch   apply success (new)   appveyor success (new)   travis success (new)
18/944 Logical decoding of two-phase transactions Nikhil Sontakke patch   apply success   appveyor success   travis success
18/1632 MAP syntax for arrays Ildar Musin patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1446 MERGE Simon Riggs, Pavan Deolasee patch   apply failure (new)
18/1657 Make deparsing of column defaults faster Jeff Janes patch   apply success (new)   appveyor success (new)   travis success (new)
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 (new)
18/1666 Moving relation extension locks out of heavyweight lock manager Masahiko Sawada patch   apply success (new)   appveyor success (new)   travis success (new)
18/1686 Multi-inserts for partitioned tables in COPY David Rowley patch   apply success (new)   appveyor success (new)   travis success (new)
18/1698 Nepali Snowball dictionary Arthur Zakirov, Oleg Bartunov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1535 Online enabling of checksums Magnus Hagander, Daniel Gustafsson patch   apply failure (new)
18/1317 Pipelining/batch mode support for libpq Craig Ringer, vaishnavi prabakaran patch   apply success (new)   appveyor success (new)   travis success (new)
18/1283 Pluggable storage API Álvaro Herrera, Alexander Korotkov, Haribabu Kommi patch   apply failure (new)
18/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success (new)   appveyor success (new)   travis success (new)
18/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply success (new)   appveyor success (new)   travis success (new)
18/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply failure (new)
18/1624 Range phrase operator in tsquery Aleksandr Parfenov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1690 Reduce partition tuple routing overheads David Rowley patch   apply failure
18/1364 Remove LEFT JOINs in more cases David Rowley patch
18/1626 Replace conversion_create.sql with normal data entries John Naylor patch   apply success (new)   appveyor success (new)   travis success (new)
18/1675 Run-time partition pruning for MergeAppend David Rowley patch   apply success (new)   appveyor success (new)   travis success (new)
18/1682 SLRU data page checksums patch   apply failure (new)
18/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure (new)
18/1704 SQL/JSON: documentation Nikita Glukhov, Oleg Bartunov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure (new)
18/1471 SQL/JSON: jsonpath Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1460 Sample values for pg_stat_statements Vik Fearing patch   apply success (new)   appveyor success (new)   travis success (new)
18/1461 Shared Ispell dictionaries Arthur Zakirov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply success (new)   appveyor success (new)   travis failure (new)
18/1376 Tab completion for SELECT in psql Edmund Horner patch   apply success (new)   appveyor success (new)   travis success (new)
18/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply success (new)   appveyor building   travis building
18/1641 Try to produce compiler warnings for incorrect usage of printf("%m") Tom Lane patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1602 Two pass check for deadlock Yura Sokolov patch   apply success (new)   appveyor success (new)   travis failure (new)
18/1697 Update snowball stemmers Arthur Zakirov patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1628 Use /etc/localtime to identify system timezone when possible Tom Lane patch   apply failure (new)
18/1648 WIP: Precalculate stable functions Arthur Zakirov, Marina Polyakova patch   apply failure (new)
18/1594 chained transactions Peter Eisentraut patch   apply failure (new)
18/1706 cost_sort improvement Fedor Sigaev patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1500 csv output format for psql Daniel Vérité patch   apply failure (new)
18/1667 cursors with prepared statements Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
18/1619 de-deduplicate code in DML execution hooks in postgres_fdw Ashutosh Bapat patch   apply success (new)   appveyor building   travis success (new)
18/1620 generalized expression syntax for partition bounds Tom Lane, Kyotaro Horiguchi, Amit Langote patch   apply success (new)   appveyor success (new)   travis success (new)
18/1640 generate bootstrap entries for array types John Naylor patch   apply success (new)   appveyor success (new)   travis success (new)
18/1536 get rid of StdRdOptions, use individual binary reloptions representation for eac... Nikolay Shaplov patch   apply failure (new)
18/1540 hash joins with bloom filters Tomas Vondra patch   apply failure (new)
18/1631 hostorder and failover_timeout for libpq Ildar Musin patch   apply success (new)   appveyor success (new)   travis success (new)
18/1518 lc_messages parameter doesn't work on Windows Aleksandr Parfenov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1238 multivariate MCV lists and histograms Tomas Vondra patch   apply success   appveyor success   travis success
18/1470 pg_stat_statements with plans (v02) Marius Timmer, Julian Markwort patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1637 pg_ugprade test failure on data set with column with default value with type bit... Paul Guo patch   apply success (new)   appveyor success (new)   travis failure (new)
18/1528 pgbench - test whether a variable exists Fabien Coelho patch   apply failure (new)
18/1525 postgres.exe doesn't output crash dump when it crashes before main() Takayuki Tsunakawa patch   apply success   appveyor success   travis success
18/1701 ssl_library parameter Peter Eisentraut patch

Waiting on Author

18/1644 Add --include-table-data-where option to pg_dump, to export only a subset of tab... patch   apply success (new)   appveyor success (new)   travis success (new)
18/1399 Add SKIP LOCKED option to VACUUM and ANALYZE Nathan Bossart patch   apply failure
18/1499 Add missing type conversion functions for PL/Python Haozhou Wang patch   apply success (new)   appveyor success (new)   travis success (new)
18/1664 Evaluate immutable functions during planning (in FROM clause) Aleksandr Parfenov patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1264 Exclude partition constaint checking in query execution plan for partitioned tab... Konstantin Knizhnik patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1252 Foreign Key Arrays Mark Rofail patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1598 GiST VACUUM Constantine Kuznetsov, Andrey Borodin patch   apply success   appveyor building   travis building
18/1658 Improve recovery performance of dropping database having many tablespaces Fujii Masao patch   apply success (new)   appveyor success (new)   travis success (new)
18/1552 Nested ConvertRowtypeExpr optimization Ashutosh Bapat patch   apply success (new)   appveyor success (new)   travis success (new)
18/1513 OFFSET optimisation for IndexScan using visibility map Michail Nikolaev patch   apply success (new)   appveyor success (new)   travis success (new)
18/1653 Order windows to avoid Sort node between WindowAgg where sort result can be reus... Daniel Gustafsson patch   apply success (new)   appveyor success (new)   travis success (new)
18/1694 Partition tree inspection functions Amit Langote patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1654 Provide toast tables for all system tables except those that the toast mechanism... Joe Conway patch   apply success   appveyor success   travis success
18/1685 Push down aggregates below joins. Heikki Linnakangas patch   apply success (new)   appveyor failure (new)   travis failure (new)
18/1578 Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist Anastasia Lubennikova patch   apply failure (new)
18/1505 Reset temp schema on connection to prevent XID wraparound Takayuki Tsunakawa patch   apply success (new)   appveyor success (new)   travis success (new)
18/1260 Restricting maximum keep segments by repslots Kyotaro Horiguchi patch   apply success (new)   appveyor success (new)   travis success (new)
18/1710 Row filtering for logical replication Euler Taveira patch   apply failure (new)
18/1004 SERIALIZABLE with parallel query Thomas Munro patch   apply success (new)   appveyor success (new)   travis success (new)
18/1691 Sample rate logging Adrien Nayrat patch   apply success (new)   appveyor success (new)   travis success (new)
18/1530 Speed up WAL file removal during recovery Takayuki Tsunakawa patch
18/1646 Subplan result cache Heikki Linnakangas   apply success (new)   appveyor success (new)   travis success (new)
18/1670 Support optional message in backend cancellation/termination Daniel Gustafsson patch   apply success (new)   appveyor failure (new)   travis success (new)
18/1661 Update psql tab completion for multiple commits Justin Pryzby patch   apply failure (new)
18/844 Vacuum: allow usage of more than 1GB of work mem Heikki Linnakangas, Claudio Freire patch   apply success (new)   appveyor success (new)   travis success (new)
18/1645 WIP: Pgbench Errors and serialization/deadlock retries Marina Polyakova patch   apply failure (new)
18/1537 file cloning in pg_upgrade Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
18/1587 kNN for SP-GiST Nikita Glukhov patch   apply success (new)   appveyor success (new)   travis success (new)
18/1635 libpq compression Konstantin Knizhnik patch   apply success (new)   appveyor success (new)   travis success (new)
18/1490 macOS Secure Transport SSL Support Daniel Gustafsson patch   apply failure (new)
18/1700 option to disable WAL recycling Jerry Jelinek patch   apply success (new)   appveyor success (new)   travis success (new)
18/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply failure
18/1388 pgbench - option to build using ppoll() for larger connection counts doug rady patch   apply success (new)   appveyor failure (new)   travis success (new)
18/1608 schema variables, LET command Pavel Stehule patch   apply failure (new)

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