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
26/2208	Add --include-foreign-data option to pg_dump to dump the data of foreign tables	Luis M Carril	patch
26/2176	FETCH FIRST clause PERCENT option	Surafel Temesgen	patch
26/528	Fix the optimization to skip WAL-logging on table created in same transaction	Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi	patch
26/1736	pgbench - add pseudo-random permutation function	Fabien Coelho, Hironobu Suzuki	patch
26/2096	psql - add SHOW_ALL_RESULTS option	Fabien Coelho	patch
Needs review
26/2234	A hook for path-removal decision on add_path	KaiGai Kohei	patch
26/2130	ALTER TABLE restructuring	Tom Lane	patch
26/2213	Add FOREIGN to ALTER TABLE in pg_dump when the target is a foreign table	Luis M Carril	patch
26/1883	Add Hook Functions for Disk Quota Extension	Haozhou Wang, Hubert Zhang, Hao Wu	patch
26/2243	Add index AM callback to adjust opfamily member dependencies	Tom Lane	patch
26/2286	Add more compile-time asserts	Peter Smith	patch
26/2356	Add reverse collations	David Fetter	patch
26/1533	Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT	Matheus Oliveira	patch
26/2327	Add support for automatically updating Unicode derived files	Peter Eisentraut	patch
26/2152	Add the capability to logical replication to transfer base types using binary	Dave Cramer	patch
26/2299	Add uri percent-encoding for binary data	Anders Åstrand	patch
26/2200	Adding a test for speculative wait case	Ashwin Agrawal, Melanie Plageman	patch
26/1553	Advanced partition matching for partition-wise join	Etsuro Fujita, Ashutosh Bapat	patch
26/2269	Allow REINDEX and REINDEX CONCURRENTLY to SET TABLESPACE	Alexey Kondratov	patch
26/2158	Allow an alias to be attached directly to a JOIN ... USING	Peter Eisentraut	patch
26/2244	Allow cluster owner to bypass authentication	Peter Eisentraut	patch
26/2340	Allow superuser to grant passwordless connection rights on postgres_fdw	Andrew Dunstan	patch
26/2255	Allow to_date() and to_timestamp() to accept localized names	Juanjo Santamaria Flecha	patch
26/2254	Amcheck: check B-tree leftlink-rightlink invariant on standby	Andrey Borodin	patch
26/2364	Autovacuum: vacuum tables in descending order of xid_age	David Fetter	patch
26/2071	Avoid full GIN index scan when possible	Julien Rouhaud, Nikita Glukhov	patch
26/2067	Built-in connection proxy	Konstantin Knizhnik	patch
26/2197	Change atoi to strtol in same place	Surafel Temesgen, Joe Nelson	patch
26/2351	Collation versions for Windows	Thomas Munro	patch
26/2355	Colorization to the output of command-line has unproperly behaviors at Windows p...	Juanjo Santamaria Flecha	patch
26/2051	DOC: Document encode() and decode() base64 encoding	Karl Pinc	patch
26/2055	DROP DATABASE FORCE	Pavel Stehule, Filip Rembiałkowski	patch
26/2334	ECPG new statement: DECLARE STATEMENT	Hayato Kuroda	patch
26/2277	Executor code refactoring around result relations	Amit Langote	patch
26/2360	Expose buffer usage during planning in EXPLAIN	Julien Rouhaud	patch
26/2331	Extracting only the columns needed for a query	Ashwin Agrawal, Melanie Plageman	patch
26/2366	Fix PostgreSQL server build and install problems under MSYS2	Guram Duka	patch
26/2308	Fix base backup checksum verification for random or zero page headers	Michael Banck	patch
26/2278	Fix handling of full outer joins by partitionwise join	Amit Langote	patch
26/2050	Fix unique join costings	David Rowley	patch
26/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
26/1062	Generic type subscripting	Dmitry Dolgov	patch
26/2218	Implement INSERT SET syntax	Gareth Palmer	patch
26/1947	Implement NULL-related checks in object address functions to prevent cache looku...	Michael Paquier	patch
26/2337	Improve checking for pg_index.xmin	Alexander Korotkov	patch
26/2346	Improve psql's tab completion for file names	Tom Lane	patch
26/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
26/2271	Introduce xid8 and xid8_current() etc, for 64 bit transaction IDs.	Thomas Munro	patch
26/1804	KNN for B-tree	Nikita Glukhov	patch
26/1934	Log bind parameter values on error	Alexey Bashtanov	patch
26/1977	Ltree syntax improvement	Dmitry Belyavsky	patch
26/2285	Make integer operations more efficient, inspired by Ryū	David Fetter	patch
26/2283	Minimal logical decoding on standbys	Amit Khandekar	patch
26/2362	Modernizing SQL functions' result type coercions	Tom Lane	patch
26/2160	Multi insert in CTAS/MatView	Paul Guo, Taylor Vesely	patch
26/2023	NOT IN to ANTI JOIN transformation	James Finnerty, Zheng Li	patch
26/2347	New argument "latest" for recovery_target parameter	Grigory Smolkin	patch
26/1677	New libpq option to prefer standby for connection	Haribabu Kommi	patch
26/2319	Optimize dropping of relation buffers using dlist	Kirk Jamison	patch
26/2315	Parallel leader process info in EXPLAIN output	Thomas Munro	patch
26/1999	Planning counters in pg_stat_statements	Fujii Masao, Julien Rouhaud, Thomas Munro, PAscal L	patch
26/1247	Push aggregation down to base relations and joins	Antonin Houska	patch
26/2358	REINDEX CONCURRENTLY failures with temporary tables	Michael Paquier	patch
26/2174	Reduce size of core scanner transition array	John Naylor	patch
26/2330	Reducing memory usage of creating foreign key between partitioned tables	sho kato	patch
26/2344	Refactor parse analysis of EXECUTE command	Peter Eisentraut	patch
26/2169	Remove HeapTuple and Buffer dependency for predicate locking functions	Ashwin Agrawal	patch
26/2113	Remove page-read callback from XLogReaderState	Kyotaro Horiguchi	patch
26/2246	Remove pg_pltemplate, add trustable extensions instead	Tom Lane	patch
26/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
26/1995	Replica with large recovery_min_apply_delay is not receiving changes from master...	Konstantin Knizhnik	patch
26/2365	Report all I/O errors in buffile.c	Thomas Munro	patch
26/2317	Restore replication settings when modifying a field type	Zongliang Quan	patch
26/2211	Resume vacuum and autovacuum from interruption and cancellation	Masahiko Sawada	patch
26/2359	Rework manipulation and structure of attribute mappings	Michael Paquier	patch
26/790	SQL statements statistics counter view (pg_stat_sql)	Haribabu Kommi	patch
26/1472	SQL/JSON: functions	Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov	patch
26/2368	Setting min/max TLS protocol in clientside libpq	Daniel Gustafsson	patch
26/2025	SimpleLruTruncate() mutual exclusion (data loss from lack thereof)	Noah Misch	patch
26/2026	Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss)	Noah Misch	patch
26/2316	System Versioned Temporal Table	Surafel Temesgen	patch
26/2093	Trigger autovacuum on tuple insertion	Darafei Praliaskouski	patch
26/2237	Unix-domain socket support on Windows	Peter Eisentraut	patch
26/2048	WIP: Temporal primary and foreign keys	Paul Jungwirth	patch
26/2189	Windows could not stat file - over 4GB	Juanjo Santamaria Flecha	patch
26/1911	anycompatible and anycompatiblearray polymorphic types	Pavel Stehule	patch
26/2192	base backup client as auxiliary backend process	Peter Eisentraut	patch
26/2310	bitmaps and correlation	Justin Pryzby	patch
26/2186	conflict handling for COPY FROM	Surafel Temesgen	patch
26/2194	de-TOAST'ing using a iterator	Xiao Bao	patch
26/2219	document that psql's FETCH_COUNT does not work with combined (\;) queries	Fabien Coelho	patch
26/2279	enhance SPI to support EXECUTE commands	Zongliang Quan	patch
26/2361	error context for vacuum to include block number 📎	Justin Pryzby	patch
26/2307	extension patch of CREATE OR REPLACE TRIGGER	Takamichi Osumi	patch
26/2225	get current and recovery timeline	Jehan-Guillaume	patch
26/2349	global temporary table	wjzeng anderson	patch
26/2293	logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Khandekar	patch
26/1896	online change primary_conninfo	Sergei Kornilov	patch
26/2081	parse time support function	Pavel Stehule	patch
26/2367	per-database-object collation version tracking	Julien Rouhaud, Thomas Munro	patch
26/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Arthur Zakirov	patch
26/1306	pgbench - another attempt at tap test for time-related options	Fabien Coelho	patch
26/2236	pgbench - improve variable management performance	Fabien Coelho	patch
26/2313	pgbench - refactor init functions with buffers	Fabien Coelho	patch
26/2230	pgrename_temp() – concurrent rename of temporary files on Windows	Alexander Korotkov	patch
26/2164	progress report for ANALYZE	Álvaro Herrera, Vinayak Pokale, Tatsuro Yamada	patch
26/2262	psql - improve code coverage	Fabien Coelho	patch
26/2353	remove trailing zeroes from numeric value (minscale)	Pavel Stehule	patch
26/1608	schema variables, LET command	Pavel Stehule	patch
26/2263	seccomp-bpf support	Joe Conway	patch
26/2175	socket_timeout in interfaces/libpq	Ryohei Nagaura	patch
26/2338	ssl passphrase callback	Andrew Dunstan	patch
26/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
26/2120	tableam vs. TOAST	Robert Haas	patch
Waiting on Author
26/2332	Add accumulated statistics for wait event	Yoshikazu Imai	patch
26/2292	Add new developer GUC "ignore_invalid_pages", to ignore invalid pages failure du...	Fujii Masao	patch
26/1919	Add timeline to partial WAL segments	David Steele	patch
26/2342	Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings	Andrew Dunstan	patch
26/2249	Asymmetric partition-wise JOIN	KaiGai Kohei	patch
26/1747	Autoprepare: implicitly replace literals with parameters and store generalized p...	Konstantin Knizhnik	patch
26/2202	B-tree deduplication	Anastasia Lubennikova	patch
26/1774	Block level parallel vacuum	Masahiko Sawada	patch
26/2354	Connection string usage for Core Postgresql client applications	Lætitia AVROT	patch
26/2069	Expose queryid in pg_stat_activity in log_line_prefix	Julien Rouhaud	patch
26/1844	FETCH FIRST clause WITH TIES option	Surafel Temesgen	patch
26/2003	Fix Deadlock Issue in Single User Mode When IO Failure Occurs	Chengchao Yu	patch
26/2276	GiST sorting build	Andrey Borodin	patch
26/2233	Global temporary tables	Konstantin Knizhnik	patch
26/2140	Improve search for missing parent downlinks in amcheck	Alexander Korotkov	patch
26/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	patch
26/1124	Incremental sort	Alexander Korotkov, Tomas Vondra, James Coleman	patch
26/2274	Invalid permission check in pg_stats for functional indexes	Pierre Ducroquet	patch
26/2242	Ltree, lquery, and ltxtquery binary protocol support	Nino Floris	patch
26/2201	Memory-Bounded Hash Aggregation	Jeff Davis	patch
26/2260	Online checksums - take 3	Magnus Hagander, Daniel Gustafsson	patch
26/2147	Parallel grouping sets	Richard Guo	patch
26/2196	Per tablespace transparent data encryption	Masahiko Sawada, Insung Moon	patch
26/2328	Preserve versions of initdb-created collations in pg_upgrade	Peter Eisentraut	patch
26/931	Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	patch
26/1689	Psql patch to show access methods info	Alik Khilazhev, Sergey Cherkashin	patch
26/1913	Remove deprecated exclusive backup mode	David Steele	patch
26/2270	Row filtering for logical replication	Euler Taveira	patch
26/2173	Run-time pruning for ModifyTable	David Rowley	patch
26/1473	SQL/JSON: JSON_TABLE	Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov	patch
26/2325	Shared Memory Context	Takeshi Ideriha	patch
26/2326	Shared system catalog cache	Takeshi Ideriha	patch
26/1708	Shared-memory based stats collector	Kyotaro Horiguchi	patch
26/1993	Speed up transaction completion faster after many relations are accessed in a tr...	Takayuki Tsunakawa	patch
26/2301	Support adding partitioned tables to logical replication publications	Amit Langote	patch
26/1574	Transactions involving multiple postgres foreign servers	Masahiko Sawada, Ashutosh Bapat	patch
26/2125	Use heap_multi_insert for catalog relations	Daniel Gustafsson	patch
26/2320	Using multiple extended statistics for estimates	Tomas Vondra	patch
26/2045	[WIP] Temporal query processing with range types - Temporal Normalization	Peter Moser, Anton Dignös	patch
26/2054	fix for BUG #3720: wrong results at using ltree	Filip Rembiałkowski	patch
26/2323	jsonb_set_lax function	Andrew Dunstan	patch
26/1927	logical streaming for large in-progress transactions	Tomas Vondra, Petr Jelínek	patch
26/2284	pause recovery if pitr target not reached when recovery_target_time is specified	Leif Gunnar Erlandsen	patch
26/1849	pg_rewind: options to use restore_command from recovery.conf or command line	Alexey Kondratov	patch
26/2091	pgbench - add \aset to store results of combined queries (\;)	Fabien Coelho	patch
26/2112	range_agg / multiranges	Paul Jungwirth	patch

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

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author