PostgreSQL Patch Tester

Here lives an experimental bot that does this: CommitfestGithub → ( 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/1311 Another oddity in handling of WCO constraints in postgres_fdw Etsuro Fujita patch   apply failure
18/1516 Cascaded standby cannot start after a shutdown Michael Paquier, Takayuki Tsunakawa patch   apply success   appveyor success   travis success
18/1554 ConvertRowtypeExpr reference errors from partition-wise join Ashutosh Bapat patch   apply success   appveyor success   travis success
18/713 Correct space parsing in to_timestamp() Arthur Zakirov patch   apply success   appveyor success (new)   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/1502 Freeing a character string returned by pgtypes library functions crashes on Wind... Takayuki Tsunakawa patch   apply success   appveyor success   travis success
18/1491 Handling better supported channel binding types for SSL implementations Michael Paquier patch   apply failure
18/1204 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success   appveyor success   travis success
18/1160 Improve geometric types Emre Hasegeli patch   apply failure
18/1468 Parallel Aggregates for string_agg and array_agg David Rowley 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 failure   travis failure
18/1085 XML XPath default namespace support Pavel Stehule patch   apply success   appveyor success (new)   travis success
18/1638 log_min_messages shows debug instead of debug2 Takeshi Ideriha patch   apply success   appveyor success   travis success
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 failure (new)

Needs review

18/1622 A way to request the rotation of server logs Kyotaro Horiguchi patch   apply success   appveyor success (new)   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 (new)
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
18/1399 Add SKIP LOCKED option to VACUUM and ANALYZE Nathan Bossart patch   apply failure
18/1489 Add enum releation option type Nikolay Shaplov patch   apply success   appveyor success   travis success (new)
18/1499 Add missing type conversion functions for PL/Python Haozhou Wang patch   apply success   appveyor success   travis success
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/1623 Allow auto_explain to log to NOTICE Tom Dunstan patch   apply success   appveyor success   travis failure
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 failure
18/1296 Better estimate for filter cost Yuto Hayamizu, Ryoji Kawamichi patch   apply success   appveyor success   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/1639 Clone file descriptors into checkpointer, to handle fsync issues on at least lin... Andres Freund patch   apply failure (new)   appveyor failure   travis success
18/1001 Convert join OR clauses into UNION queries Tom Lane patch   apply failure
18/1615 Covering GiST indexes Andrey Borodin 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 success   travis success
18/1480 Find additional connection service files in pg_service.conf.d directory Curt Tilmes patch   apply success   appveyor success   travis success (new)
18/980 Fix a bug that can prevent standby from restarting Kyotaro Horiguchi patch   apply 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 (new)
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/1647 GSSAPI encryption support Robbie Harwood patch   apply success   appveyor failure   travis success (new)
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 (new)   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/1124 Incremental sort Alexander Korotkov patch   apply failure
18/1288 Lazy hash table for snapshot's "xid in progress" Yura Sokolov patch   apply success   appveyor success   travis success
18/944 Logical decoding of two-phase transactions Stas Kelvich, Nikhil Sontakke patch   apply failure
18/1632 MAP syntax for arrays Ildar Musin patch   apply success   appveyor failure   travis failure
18/1617 Make PostmasterIsAlive() go faster with signals Thomas Munro patch   apply success   appveyor success   travis success
18/1633 Make description of heap records more talkative for flags Michael Paquier patch   apply success   appveyor success   travis success
18/1513 OFFSET optimisation for IndexScan using visibility map Michail Nikolaev patch   apply success   appveyor success   travis failure (new)
18/1535 Online enabling of checksums Magnus Hagander, Daniel Gustafsson patch   apply failure
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/1247 Push aggregation down to base relations and joins Antonin Houska 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/1572 Remove DSM_IMPL_NONE Kyotaro Horiguchi patch   apply success   appveyor success   travis success
18/1364 Remove LEFT JOINs in more cases David Rowley patch   apply success   appveyor failure (new)   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 success   appveyor success (new)   travis success (new)
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/1004 SERIALIZABLE with parallel query Thomas Munro patch   apply success   appveyor success   travis success
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/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 (new)   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/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/1641 Try to produce compiler warnings for incorrect usage of printf("%m") Tom Lane patch   apply success   appveyor success   travis success (new)
18/1602 Two pass check for deadlock Yura Sokolov patch   apply success   appveyor success   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 (new)
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 (new)   appveyor success   travis failure
18/1648 WIP: Precalculate stable functions Arthur Zakirov, Marina Polyakova patch   apply success   appveyor success   travis success
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/1619 de-deduplicate code in DML execution hooks in postgres_fdw Ashutosh Bapat patch   apply success   appveyor success   travis success
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/1635 libpq compression Konstantin Knizhnik patch   apply success   appveyor failure   travis failure
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/1252 Foreign Key Arrays Mark Rofail patch   apply failure
18/1446 MERGE Simon Riggs, Pavan Deolasee patch   apply failure
18/1552 Nested ConvertRowtypeExpr optimization Ashutosh Bapat patch   apply success   appveyor success   travis success
18/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
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.