PostgreSQL Patch Tester

Here lives an experimental bot that does this: Commitfest → Github → ( 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. 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

27/1473 SQL/JSON: JSON_TABLE Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
27/2189 Windows could not stat file - over 4GB Juanjo Santamaria Flecha patch   apply success   appveyor success   travis success
27/2112 range_agg / multiranges Paul Jungwirth patch   apply failure
27/2161 standby recovery fails when re-replaying due to missing directory which was remo... Kyotaro Horiguchi, Paul Guo patch   apply success   appveyor success   travis success

Needs review

27/2234 A hook for path-removal decision on add_path KaiGai Kohei patch   apply success   appveyor success   travis success
27/2468 ALTER TABLE ... SET STORAGE does not propagate to indexes Peter Eisentraut patch   apply success   appveyor success   travis success
27/2305 Add A Glossary Corey Huinker patch   apply success   appveyor success   travis success
27/2213 Add FOREIGN to ALTER TABLE in pg_dump when the target is a foreign table Luis M Carril patch   apply success   appveyor success   travis success
27/1883 Add Hook Functions for Disk Quota Extension Haozhou Wang, Hubert Zhang, Hao Wu patch   apply success   appveyor failure   travis failure
27/2426 Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM Nathan Bossart patch   apply success   appveyor success   travis success
27/2332 Add accumulated statistics for wait event Yoshikazu Imai patch   apply success   appveyor success (new)   travis success (new)
27/2422 Add in the \conninfo start time current connection Rodrigo Ramírez patch   apply success   appveyor success   travis success
27/2423 Add in the \conninfo start time current connection Rodrigo Ramírez patch   apply success   appveyor success   travis success
27/2243 Add index AM callback to adjust opfamily member dependencies Tom Lane patch   apply success   appveyor failure   travis success
27/2356 Add reverse collations David Fetter patch   apply success   appveyor success   travis success
27/2434 Add support for IN and @> in functional-dependency statistics use Pierre Ducroquet patch   apply success   appveyor success   travis success
27/1533 Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT Matheus Oliveira patch   apply failure
27/2152 Add the capability to logical replication to transfer base types using binary Dave Cramer patch   apply failure
27/2299 Add uri percent-encoding for binary data Anders Åstrand patch   apply success   appveyor success   travis success
27/2200 Adding a test for speculative wait case Ashwin Agrawal, Melanie Plageman patch   apply failure
27/1553 Advanced partition matching for partition-wise join Etsuro Fujita, Ashutosh Bapat patch   apply success   appveyor success   travis success
27/2372 Allow FunctionScans to pipeline results John Dent patch   apply success   appveyor success (new)   travis failure
27/2269 Allow REINDEX and REINDEX CONCURRENTLY to SET TABLESPACE Alexey Kondratov patch   apply failure
27/2398 Allow WHEN in INSTEAD OF triggers David Fetter patch   apply success   appveyor success   travis success
27/2158 Allow an alias to be attached directly to a JOIN ... USING Peter Eisentraut patch   apply success   appveyor success   travis success
27/2244 Allow cluster owner to bypass authentication Peter Eisentraut patch   apply success   appveyor success   travis success
27/2255 Allow to_date() and to_timestamp() to accept localized names Juanjo Santamaria Flecha patch   apply success   appveyor success   travis success
27/2249 Asymmetric partition-wise JOIN KaiGai Kohei patch   apply success   appveyor success   travis success
27/1747 Autoprepare: implicitly replace literals with parameters and store generalized p... Konstantin Knizhnik patch   apply failure
27/2364 Autovacuum: vacuum tables in descending order of xid_age David Fetter patch   apply success   appveyor success   travis success
27/2202 B-tree deduplication Anastasia Lubennikova patch   apply success   appveyor success   travis success
27/2450 Bug in pg_restore with EventTrigger in parallel mode Fabrízio Mello patch   apply success   appveyor success   travis success
27/2067 Built-in connection proxy Konstantin Knizhnik patch   apply failure
27/2351 Collation versions for Windows Thomas Munro patch   apply success   appveyor success   travis success
27/2355 Colorization to the output of command-line has unproperly behaviors at Windows p... Juanjo Santamaria Flecha patch   apply success   appveyor success   travis success
27/2440 CommandTag enumeration Mark Dilger patch   apply success   appveyor failure   travis failure
27/2446 Comments related to fact that snapshot is taken twice for each non-prepared quer... Michail Nikolaev patch   apply success   appveyor success   travis success
27/2466 Constraint's NO INHERIT option is ignored in CREATE TABLE LIKE statement Ildar Musin, Chris Travers patch   apply success   appveyor success   travis success
27/2432 DROP OWNED CASCADE vs Temp tables Álvaro Herrera patch   apply success   appveyor success   travis success
27/2429 Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() Peter Geoghegan patch   apply success   appveyor failure   travis success
27/2454 Document concurrent index builds waiting on each other James Coleman patch   apply success   appveyor failure (new)   travis success
27/2334 ECPG new statement: DECLARE STATEMENT Hayato Kuroda patch   apply success   appveyor success   travis success
27/2433 Erase the distinctClause if the result is unique by definition Andy Fan patch   apply success   appveyor failure (new)   travis failure (new)
27/2277 Executor code refactoring around result relations Amit Langote patch   apply failure
27/2360 Expose buffer usage during planning in EXPLAIN Julien Rouhaud patch   apply success   appveyor success   travis success
27/2069 Expose queryid in pg_stat_activity in log_line_prefix Julien Rouhaud patch   apply success   appveyor success   travis success
27/2451 Exposure related to GUC value of ssl_passphrase_command Insung Moon patch   apply success   appveyor success   travis success
27/2421 Extended statistics improvements Tomas Vondra patch   apply failure
27/2331 Extracting only the columns needed for a query Ashwin Agrawal, Melanie Plageman patch   apply failure
27/2176 FETCH FIRST clause PERCENT option Surafel Temesgen patch   apply success   appveyor success   travis success
27/1844 FETCH FIRST clause WITH TIES option Surafel Temesgen patch   apply success   appveyor success   travis success
27/2448 First WAL segment file that initdb creates Fujii Masao patch   apply success   appveyor failure (new)   travis success
27/2308 Fix base backup checksum verification for random or zero page headers Michael Banck patch   apply success (new)   appveyor success (new)   travis success (new)
27/2383 Fix false "ERROR: subtransaction logged without previous top-level txn record" a... Arseny Sher patch   apply failure
27/2442 Fix for slow GIN index queries when "gin_fuzzy_search_limit" setting is relative... patch   apply success   appveyor success   travis success
27/2278 Fix handling of full outer joins by partitionwise join Amit Langote patch   apply success   appveyor failure   travis failure
27/2459 Fix logical replication slot copy function Masahiko Sawada patch   apply success   appveyor success   travis success
27/2400 Fix psql to report I/O errors on writing query results Daniel Vérité patch   apply success   appveyor success   travis success
27/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
27/2388 Fix to_char() behaviour with 'WW-D' pattern Mark Lorenz patch   apply success   appveyor success   travis success
27/2050 Fix unique join costings David Rowley patch   apply success   appveyor success   travis success
27/2266 Fix up partitionwise join on how equi-join conditions between the partition keys... Richard Guo patch   apply success   appveyor success   travis success
27/2402 GUC to disable cancellation of awaiting for synchronous replication Andrey Borodin patch   apply success   appveyor success   travis success
27/2276 GiST sorting build Andrey Borodin patch   apply success   appveyor success   travis failure
27/2444 Identifying user-created objects Masahiko Sawada patch   apply success   appveyor success   travis success
27/2218 Implement INSERT SET syntax Gareth Palmer patch   apply success   appveyor success   travis success
27/1947 Implement NULL-related checks in object address functions to prevent cache looku... Michael Paquier patch   apply success   appveyor success   travis success
27/2337 Improve checking for pg_index.xmin Alexander Korotkov patch   apply success   appveyor success   travis success
27/2439 Improve errors when setting incorrect bounds for SSL protocols Michael Paquier patch   apply success   appveyor success   travis success
27/2449 Improve logging around restore_command Jeff Janes patch   apply success   appveyor success   travis success
27/2443 In bitmap scan explain node show how many relevant heap pages were not examined Jeff Janes patch   apply success   appveyor success   travis success
27/2138 Incremental Materialized View Maintenance Yugo Nagata, takuma hoshiai patch   apply failure
27/1741 Index Skip Scan Dmitry Dolgov, Thomas Munro, Jesper Pedersen patch   apply success   appveyor success   travis success
27/2271 Introduce xid8 and xid8_current() etc, for 64 bit transaction IDs. Thomas Munro patch   apply success   appveyor success   travis success
27/2196 KMS - Internal key management system Masahiko Sawada, Ibrar Ahmed, Insung Moon patch   apply failure
27/1804 KNN for B-tree Nikita Glukhov patch   apply failure
27/2371 Level4 Warnings show many shadow vars patch   apply failure
27/1977 Ltree syntax improvement Dmitry Belyavsky patch   apply failure
27/2242 Ltree, lquery, and ltxtquery binary protocol support Nino Floris patch   apply failure
27/2201 Memory-Bounded Hash Aggregation Jeff Davis patch   apply failure   appveyor success   travis success
27/2283 Minimal logical decoding on standbys Amit Khandekar patch   apply success   appveyor success   travis success
27/2445 Minor issues in .pgpass Fujii Masao patch   apply success   appveyor success   travis success
27/2160 Multi insert in CTAS/MatView Paul Guo, Taylor Vesely patch   apply success   appveyor success   travis success
27/2023 NOT IN to ANTI JOIN transformation James Finnerty, Zheng Li patch   apply success   appveyor success   travis success
27/2260 Online checksums - take 3 Magnus Hagander, Daniel Gustafsson patch   apply success   appveyor success   travis failure
27/2369 Online checksums verification Julien Rouhaud patch   apply success   appveyor success   travis success
27/2319 Optimize dropping of relation buffers using dlist Kirk Jamison patch   apply success   appveyor success   travis success
27/2147 Parallel grouping sets Richard Guo patch   apply success   appveyor success   travis success
27/1999 Planning counters in pg_stat_statements Fujii Masao, Julien Rouhaud, Thomas Munro, PAscal L patch   apply success   appveyor success   travis success
27/931 Protect syscache from bloating with negative cache entries Kyotaro Horiguchi patch   apply success   appveyor success   travis success
27/1247 Push aggregation down to base relations and joins Antonin Houska patch   apply success   appveyor success (new)   travis success (new)
27/2453 Quoting issues with createdb Michael Paquier patch   apply success   appveyor success   travis success
27/2441 Rational number type (fractions) Joe Nelson patch   apply failure
27/2389 Recognize D part for to_date() and to_timestamp() in 'WW-D' pattern Mark Lorenz patch   apply success   appveyor success   travis success
27/2397 Recognizing superuser in pg_hba.conf Vik Fearing patch   apply success   appveyor success   travis failure
27/2452 Reduce WaitEventSet system call spam Thomas Munro patch   apply success   appveyor success   travis success
27/2330 Reducing memory usage of creating foreign key between partitioned tables sho kato patch   apply success   appveyor success   travis success
27/2437 Refactor compile-time assertion checks for C/C++ Michael Paquier patch   apply success   appveyor failure   travis success
27/2415 Removal of apply_typmod function in #if 0 vignesh C patch   apply success   appveyor success   travis success
27/2113 Remove page-read callback from XLogReaderState Kyotaro Horiguchi patch   apply failure (new)   appveyor success   travis success
27/1712 Remove self join on a unique column Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov patch   apply success   appveyor success   travis success (new)
27/2470 Remove win32ver.rc from version_stamp.pl Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
27/2464 Replica sends an incorrect epoch in its hot standby feedback to the Master Eka Palamadai
27/2463 Replica sends an incorrect epoch in its hot standby feedback to the Master
27/2462 Replica sends an incorrect epoch in its hot standby feedback to the Master
27/1995 Replica with large recovery_min_apply_delay is not receiving changes from master... Konstantin Knizhnik patch   apply success   appveyor success   travis success
27/2317 Restore replication settings when modifying a field type Zongliang Quan patch   apply success   appveyor success   travis success
27/2407 Restricting maximum keep segments by repslots patch   apply success   appveyor success   travis success
27/2211 Resume vacuum and autovacuum from interruption and cancellation Masahiko Sawada patch   apply failure
27/2456 Rework handling of wal_receiver_create_temp_slot Sergei Kornilov patch   apply success   appveyor success   travis success
27/2173 Run-time pruning for ModifyTable David Rowley patch   apply failure
27/2424 SLRU stats Tomas Vondra patch   apply success   appveyor failure   travis failure
27/790 SQL statements statistics counter view (pg_stat_sql) Haribabu Kommi patch   apply failure
27/1708 Shared-memory based stats collector Kyotaro Horiguchi patch   apply failure
27/2370 Split StdRdOptions into HeapOptions and ToastOptions Nikolay Shaplov patch   apply success   appveyor success   travis success
27/2026 Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) Noah Misch patch   apply success   appveyor failure   travis success
27/2301 Support adding partitioned tables to logical replication publications Amit Langote patch   apply success   appveyor success   travis success
27/2461 Support built control file in PGXS VPATH builds Craig Ringer patch   apply success   appveyor success   travis failure
27/2460 Support external parameters in EXECUTE command Peter Eisentraut patch   apply success   appveyor success   travis success
27/2473 Support migration of plpythonu to Python 3 Tom Lane patch   apply success (new)   appveyor building   travis building
27/1574 Transactions involving multiple postgres foreign servers Masahiko Sawada, Ashutosh Bapat patch   apply failure
27/2093 Trigger autovacuum on tuple insertion Darafei Praliaskouski patch   apply success   appveyor success   travis success
27/2376 UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR John Dent patch   apply success   appveyor success   travis failure
27/2420 Unicode escapes with any backend encoding Tom Lane patch   apply success (new)   appveyor success   travis success
27/2380 Unicode normalization SQL functions Peter Eisentraut patch   apply success   appveyor success   travis success
27/2237 Unix-domain socket support on Windows Peter Eisentraut patch   apply success   appveyor success   travis success
27/2471 Use multi_heap_inserts for catalog insertions Daniel Gustafsson patch   apply success (new)   appveyor success (new)   travis failure (new)
27/2386 Using multicolumn statistics for more precise join selectivity estimatation Konstantin Knizhnik patch   apply failure
27/2418 Verify true root on replicas with amcheck Georgy Rylov patch   apply success   appveyor success   travis success
27/2410 WAL prefetch (another approach) Thomas Munro patch   apply success   appveyor success   travis success
27/2438 WAL usage calculation Kirill Bychik patch   apply failure
27/2048 WIP: Temporal primary and foreign keys Paul Jungwirth patch   apply failure
27/2469 allow trigger to get updated columns Peter Eisentraut patch   apply success (new)   appveyor success (new)   travis success (new)
27/1911 anycompatible and anycompatiblearray polymorphic types Pavel Stehule patch   apply success   appveyor success   travis success (new)
27/2465 backend type in log_line_prefix Peter Eisentraut patch   apply success   appveyor success   travis success
27/2192 base backup client as auxiliary backend process Peter Eisentraut patch   apply failure
27/2310 bitmaps and correlation Justin Pryzby patch   apply success   appveyor success   travis success
27/2406 color by default Peter Eisentraut patch   apply success   appveyor failure   travis success
27/2186 conflict handling for COPY FROM Surafel Temesgen patch   apply success   appveyor success   travis success
27/2447 control max length of parameter values logged Alexey Bashtanov patch   apply success   appveyor success   travis failure
27/2194 de-TOAST'ing using a iterator Xiao Bao patch   apply success   appveyor success   travis success
27/2419 distinct aggregates within a window function WIP Krasiyan Andreev patch   apply success   appveyor success   travis success
27/2219 document that psql's FETCH_COUNT does not work with combined (\;) queries Fabien Coelho patch   apply success   appveyor success   travis success
27/2361 error context for vacuum to include block number 📎 Justin Pryzby patch   apply success   appveyor success   travis success
27/2428 explain HashAggregate to report bucket and memory stats Justin Pryzby patch   apply success   appveyor success (new)   travis failure
27/2307 extension patch of CREATE OR REPLACE TRIGGER Takamichi Osumi patch   apply success   appveyor success   travis success
27/2467 faster execution of simple expression in plpgsql Amit Langote patch   apply success   appveyor success   travis success
27/2349 global temporary table wjzeng anderson patch   apply success   appveyor failure   travis success
27/1927 logical streaming for large in-progress transactions Amit Kapila, Tomas Vondra, Petr Jelínek, dilip kumar patch   apply success   appveyor failure   travis failure
27/2458 more ALTER .. DEPENDS ON EXTENSION fixes Álvaro Herrera patch   apply success   appveyor success   travis success
27/1896 online change primary_conninfo Sergei Kornilov patch   apply success   appveyor success   travis success
27/2472 parallel backup Asif Rehman patch   apply success   appveyor success   travis success
27/2081 parse time support function Pavel Stehule patch   apply success   appveyor success   travis success
27/2367 per-database-object collation version tracking Julien Rouhaud, Thomas Munro patch   apply success   appveyor success   travis success
27/1849 pg_rewind: options to use restore_command from recovery.conf or command line Alexey Kondratov patch   apply success   appveyor success   travis success
27/2435 pg_stat_progress_basebackup - progress reporting for pg_basebackup, in the serve... Fujii Masao patch   apply success   appveyor failure   travis failure
27/2215 pg_upgrade fails with non-standard ACL Anastasia Lubennikova, Arthur Zakirov patch   apply success   appveyor failure   travis failure
27/2091 pgbench - add \aset to store results of combined queries (\;) Fabien Coelho patch   apply failure
27/1736 pgbench - add pseudo-random permutation function Fabien Coelho, Hironobu Suzuki patch   apply success   appveyor success   travis failure
27/1306 pgbench - another attempt at tap test for time-related options Fabien Coelho patch   apply success   appveyor failure   travis success
27/2236 pgbench - improve variable management performance Fabien Coelho patch   apply success   appveyor failure   travis success
27/2313 pgbench - refactor init functions with buffers Fabien Coelho patch   apply success   appveyor success   travis success
27/2230 pgrename_temp() – concurrent rename of temporary files on Windows Alexander Korotkov patch   apply success   appveyor success   travis success
27/2405 polymorphic table functions Peter Eisentraut patch   apply failure
27/2096 psql - add SHOW_ALL_RESULTS option Fabien Coelho patch   apply success   appveyor success   travis success
27/2262 psql - improve code coverage Fabien Coelho patch   apply failure
27/2455 recovery_target_action=pause with confusing hint Sergei Kornilov patch   apply success   appveyor success   travis success
27/1608 schema variables, LET command Pavel Stehule patch   apply success   appveyor success   travis success
27/2384 skip empty transactions for logical replication Euler Taveira patch   apply success   appveyor success   travis success
27/2175 socket_timeout in interfaces/libpq Ryohei Nagaura patch   apply failure
27/2338 ssl passphrase callback Andrew Dunstan patch   apply success   appveyor success   travis success
27/2197 standardize integer parsing in front-end utilities Surafel Temesgen, Joe Nelson patch   apply failure
27/2425 vacuum verbose is unclear Justin Pryzby patch   apply success   appveyor success   travis success
27/2430 vacuum verbose: show pages marked allvisible/frozen/hintbits Justin Pryzby patch   apply success   appveyor success   travis success

Waiting on Author

27/2208 Add --include-foreign-data option to pg_dump to dump the data of foreign tables Luis M Carril patch   apply success   appveyor success   travis success
27/1919 Add timeline to partial WAL segments David Steele patch   apply success   appveyor success   travis success
27/2382 Fastpath while arranging the changes in LSN order in logical decoding dilip kumar patch   apply success   appveyor success   travis failure
27/1062 Generic type subscripting Dmitry Dolgov patch   apply failure
27/2140 Improve search for missing parent downlinks in amcheck Alexander Korotkov patch   apply success   appveyor failure   travis failure
27/1124 Incremental sort Alexander Korotkov, Tomas Vondra, James Coleman patch   apply success   appveyor success   travis failure
27/2274 Invalid permission check in pg_stats for functional indexes Pierre Ducroquet patch   apply success   appveyor success   travis success
27/1677 New libpq option to prefer standby for connection Haribabu Kommi, Greg Nancarrow patch   apply failure
27/2315 Parallel leader process info in EXPLAIN output Thomas Munro patch   apply failure
27/2431 Prevent pg_basebackup running as root Ian Barwick patch   apply success   appveyor success   travis success
27/1689 Psql patch to show access methods info Alik Khilazhev, Sergey Cherkashin patch   apply success   appveyor success   travis success
27/1913 Remove deprecated exclusive backup mode David Steele patch   apply failure
27/2365 Report all I/O errors in buffile.c Thomas Munro patch   apply success   appveyor success   travis success
27/2270 Row filtering for logical replication Euler Taveira patch   apply success   appveyor failure   travis failure
27/1472 SQL/JSON: functions Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov patch   apply failure
27/2378 Set host(no)ssl settings from initdb David Fetter patch   apply success   appveyor success   travis success
27/2316 System Versioned Temporal Table Surafel Temesgen patch   apply failure
27/2374 VACUUM memory management Ibrar Ahmed patch   apply failure
27/2412 [doc] vacuum full, fillfactor, and "extra space" Justin Pryzby patch   apply success   appveyor success   travis success
27/2054 fix for BUG #3720: wrong results at using ltree Filip Rembiałkowski patch   apply success   appveyor success   travis success
27/2377 pg_ls_tmpdir to show shared filesets Justin Pryzby patch   apply success   appveyor success   travis success (new)

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