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
25/2208	Add --include-foreign-data option to pg_dump to dump the data of foreign tables	Luis M Carril	patch
25/2069	Expose queryid in pg_stat_activity in log_line_prefix	Julien Rouhaud	patch
25/2176	FETCH FIRST clause PERCENT option	Surafel Temesgen	patch
25/1844	FETCH FIRST clause WITH TIES option	Surafel Temesgen	patch
25/528	Fix the optimization to skip WAL-logging on table created in same transaction	Heikki Linnakangas, Michael Paquier, Kyotaro Horiguchi	patch
25/2294	Make each Access Method to use own stucture for storing options instead of StdRd...	Nikolay Shaplov	patch
25/2344	Refactor parse analysis of EXECUTE command	Peter Eisentraut	patch
25/2191	allow_system_table_mods stuff	Peter Eisentraut	patch
25/2091	pgbench - add \aset to store results of combined queries (\;)	Fabien Coelho	patch
25/1736	pgbench - add pseudo-random permutation function	Fabien Coelho, Hironobu Suzuki	patch
25/2096	psql - add SHOW_ALL_RESULTS option	Fabien Coelho	patch
25/2321	psql: echo edited query after \e	Tom Lane	patch
Needs review
25/2234	A hook for path-removal decision on add_path	KaiGai Kohei	patch
25/2130	ALTER TABLE restructuring	Tom Lane	patch
25/2213	Add FOREIGN to ALTER TABLE in pg_dump when the target is a foreign table	Luis M Carril	patch
25/1883	Add Hook Functions for Disk Quota Extension	Haozhou Wang, Hubert Zhang, Hao Wu	patch
25/2275	Add a reset_computed_values function in pg_stat_statements	Pierre Ducroquet	patch
25/2332	Add accumulated statistics for wait event	Yoshikazu Imai	patch
25/2243	Add index AM callback to adjust opfamily member dependencies	Tom Lane	patch
25/2292	Add new developer GUC "ignore_invalid_pages", to ignore invalid pages failure du...	Fujii Masao	patch
25/1533	Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT	Matheus Oliveira	patch
25/2327	Add support for automatically updating Unicode derived files	Peter Eisentraut	patch
25/2152	Add the capability to logical replication to transfer base types using binary	Dave Cramer	patch
25/2299	Add uri percent-encoding for binary data	Anders Åstrand	patch
25/2200	Adding a test for speculative wait case	Ashwin Agrawal, Melanie Plageman	patch
25/1553	Advanced partition matching for partition-wise join	Etsuro Fujita, Ashutosh Bapat	patch
25/2342	Allow 'sslkey' and 'sslcert' in postgres_fdw user mappings		patch
25/2269	Allow REINDEX and REINDEX CONCURRENTLY to SET TABLESPACE	Alexey Kondratov	patch
25/2158	Allow an alias to be attached directly to a JOIN ... USING	Peter Eisentraut	patch
25/2244	Allow cluster owner to bypass authentication	Peter Eisentraut	patch
25/2340	Allow superuser to grant passwordless connection rights on postgres_fdw		patch
25/2255	Allow to_date() and to_timestamp() to accept localized names	Juanjo Santamaria Flecha	patch
25/2254	Amcheck: check B-tree leftlink-rightlink invariant on standby	Andrey Borodin	patch
25/2249	Asymmetric partition-wise JOIN	KaiGai Kohei	patch
25/1747	Autoprepare: implicitly replace literals with parameters and store generalized p...	Konstantin Knizhnik	patch
25/2098	Avoid duplication of code to read XLOG page	Antonin Houska	patch
25/1348	BRIN bloom and multi-minmax indexes	Tomas Vondra	patch
25/1774	Block level parallel vacuum	Masahiko Sawada	patch
25/2067	Built-in connection proxy	Konstantin Knizhnik	patch
25/2205	CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof?	dilip kumar, Amit Langote	patch
25/2197	Change atoi to strtol in same place	Surafel Temesgen, Joe Nelson	patch
25/2055	DROP DATABASE FORCE	Pavel Stehule, Filip Rembiałkowski	patch
25/2334	ECPG new statement: DECLARE STATEMENT	Hayato Kuroda	patch
25/2277	Executor code refactoring around result relations	Amit Langote	patch
25/2331	Extracting only the columns needed for a query	Ashwin Agrawal, Melanie Plageman	patch
25/2308	Fix base backup checksum verification for random or zero page headers	Michael Banck	patch
25/2278	Fix handling of full outer joins by partitionwise join	Amit Langote	patch
25/2050	Fix unique join costings	David Rowley	patch
25/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
25/1062	Generic type subscripting	Dmitry Dolgov	patch
25/2276	GiST sorting build	Andrey Borodin	patch
25/2233	Global temporary tables	Konstantin Knizhnik	patch
25/1947	Implement NULL-related checks in object address functions to prevent cache looku...	Michael Paquier	patch
25/2102	Improve Append/MergeAppend EXPLAIN output when all subplans are pruned.	David Rowley	patch
25/2337	Improve checking for pg_index.xmin	Alexander Korotkov	patch
25/2140	Improve search for missing parent downlinks in amcheck	Alexander Korotkov	patch
25/1124	Incremental sort	Alexander Korotkov, Tomas Vondra, James Coleman	patch
25/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
25/2271	Introduce xid8 and xid8_current() etc, for 64 bit transaction IDs.	Thomas Munro	patch
25/1804	KNN for B-tree	Nikita Glukhov	patch
25/1977	Ltree syntax improvement	Dmitry Belyavsky	patch
25/2242	Ltree, lquery, and ltxtquery binary protocol support		patch
25/2285	Make integer operations more efficient, inspired by Ryū	David Fetter	patch
25/2314	Make list of reportable GUC's configurable	Dave Cramer	patch
25/2290	Make use of C99 designated initialisers for nulls/values arrays	Peter Smith	patch
25/2201	Memory-Bounded Hash Aggregation	Jeff Davis	patch
25/2283	Minimal logical decoding on standbys	Amit Khandekar	patch
25/2160	Multi insert in CTAS/MatView	Paul Guo, Taylor Vesely	patch
25/2023	NOT IN to ANTI JOIN transformation	James Finnerty, Zheng Li	patch
25/1677	New libpq option to prefer standby for connection	Haribabu Kommi	patch
25/2260	Online checksums - take 3	Magnus Hagander, Daniel Gustafsson	patch
25/2183	Opclass parameters	Nikita Glukhov	patch
25/2319	Optimize dropping of relation buffers using dlist	Kirk Jamison	patch
25/2147	Parallel grouping sets	Richard Guo	patch
25/2315	Parallel leader process info in EXPLAIN output	Thomas Munro	patch
25/2196	Per tablespace transparent data encryption	Masahiko Sawada, Insung Moon	patch
25/1999	Planning counters in pg_stat_statements	Fujii Masao, Julien Rouhaud, Thomas Munro, PAscal L	patch
25/2328	Preserve versions of initdb-created collations in pg_upgrade	Peter Eisentraut	patch
25/931	Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	patch
25/1689	Psql patch to show access methods info	Alik Khilazhev, Sergey Cherkashin	patch
25/1247	Push aggregation down to base relations and joins	Antonin Houska	patch
25/2174	Reduce size of core scanner transition array	John Naylor	patch
25/2330	Reducing memory usage of creating foreign key between partitioned tables	sho kato	patch
25/2169	Remove HeapTuple and Buffer dependency for predicate locking functions	Ashwin Agrawal	patch
25/2343	Remove configure --disable-float4-byval and --disable-float8-byval	Peter Eisentraut	patch
25/2113	Remove page-read callback from XLogReaderState	Kyotaro Horiguchi	patch
25/2246	Remove pg_pltemplate, add trustable extensions instead	Tom Lane	patch
25/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
25/2302	Remove size limitations of vacuums dead_tuples array	Ants Aasma	patch
25/2317	Restore replication settings when modifying a field type	Zongliang Quan	patch
25/2211	Resume vacuum and autovacuum from interruption and cancellation	Masahiko Sawada	patch
25/2270	Row filtering for logical replication	Euler Taveira	patch
25/2173	Run-time pruning for ModifyTable	David Rowley	patch
25/790	SQL statements statistics counter view (pg_stat_sql)	Haribabu Kommi	patch
25/1472	SQL/JSON: functions	Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov	patch
25/2300	Safeguards against incorrect fd flags for fsync()	Michael Paquier	patch
25/2325	Shared Memory Context	Takeshi Ideriha	patch
25/2326	Shared system catalog cache	Takeshi Ideriha	patch
25/1708	Shared-memory based stats collector	Kyotaro Horiguchi	patch
25/2025	SimpleLruTruncate() mutual exclusion (data loss from lack thereof)	Noah Misch	patch
25/1993	Speed up transaction completion faster after many relations are accessed in a tr...	Takayuki Tsunakawa	patch
25/2026	Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss)	Noah Misch	patch
25/2259	Startup Centralization	Mike Palmiotto, Yulian Khodorkovskiy	patch
25/1960	Support huge_pages on AIX	Thomas Munro	patch
25/2316	System Versioned Temporal Table	Surafel Temesgen	patch
25/2339	TestLib::command_fails_like enhancement	Andrew Dunstan	patch
25/1755	Tid range scan	Edmund Horner	patch
25/1574	Transactions involving multiple postgres foreign servers	Masahiko Sawada, Ashutosh Bapat	patch
25/2093	Trigger autovacuum on tuple insertion	Darafei Praliaskouski	patch
25/1649	Undo logs	dilip kumar, Thomas Munro	patch
25/2237	Unix-domain socket support on Windows	Peter Eisentraut	patch
25/2125	Use heap_multi_insert for catalog relations	Daniel Gustafsson	patch
25/2320	Using multiple extended statistics for estimates	Tomas Vondra	patch
25/2189	Windows could not stat file - over 4GB	Juanjo Santamaria Flecha	patch
25/2273	Write visibility map during CLUSTER/VACUUM FULL	Alexander Korotkov	patch
25/2045	[WIP] Temporal query processing with range types - Temporal Normalization	Peter Moser, Anton Dignös	patch
25/1911	anycompatible and anycompatiblearray polymorphic types	Pavel Stehule	patch
25/2192	base backup client as auxiliary backend process	Peter Eisentraut	patch
25/2310	bitmaps and correlation	Justin Pryzby	patch
25/2186	conflict handling for COPY FROM	Surafel Temesgen	patch
25/2219	document that psql's FETCH_COUNT does not work with combined (\;) queries	Fabien Coelho	patch
25/2279	enhance SPI to support EXECUTE commands	Zongliang Quan	patch
25/2307	extension patch of CREATE OR REPLACE TRIGGER	Takamichi Osumi	patch
25/2336	fe_utils - share query cancellation code	Fabien Coelho	patch
25/2225	get current and recovery timeline	Jehan-Guillaume	patch
25/2341	libpq sslpassword parameter and callback function	Andrew Dunstan	patch
25/2293	logical decoding : exceeded maxAllocatedDescs for .spill files	Amit Khandekar	patch
25/1927	logical streaming for large in-progress transactions	Tomas Vondra, Petr Jelínek	patch
25/1896	online change primary_conninfo	Sergei Kornilov	patch
25/2081	parse time support function	Pavel Stehule	patch
25/2284	pause recovery if pitr target not reached when recovery_target_time is specified	Leif Gunnar Erlandsen	patch
25/1849	pg_rewind: options to use restore_command from recovery.conf or command line	Alexey Kondratov	patch
25/1306	pgbench - another attempt at tap test for time-related options	Fabien Coelho	patch
25/2236	pgbench - improve variable management performance	Fabien Coelho	patch
25/2313	pgbench - refactor init functions with buffers	Fabien Coelho	patch
25/2230	pgrename_temp() – concurrent rename of temporary files on Windows	Alexander Korotkov	patch
25/2164	progress report for ANALYZE	Álvaro Herrera, Vinayak Pokale, Tatsuro Yamada	patch
25/2262	psql - improve code coverage	Fabien Coelho	patch
25/1608	schema variables, LET command	Pavel Stehule	patch
25/2263	seccomp-bpf support	Joe Conway	patch
25/2272	share string to *int64 functions, take two	Michael Paquier, Fabien Coelho	patch
25/2175	socket_timeout in interfaces/libpq	Ryohei Nagaura	patch
25/2338	ssl passphrase callback	Andrew Dunstan	patch
25/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
25/2120	tableam vs. TOAST	Robert Haas	patch
Waiting on Author
25/2305	Add A Glossary	Corey Huinker	patch
25/2309	Add Change Badges to documentation	Corey Huinker	patch
25/2296	Add a GUC variable that control logical replication	Zongliang Quan	patch
25/2221	Add mandatory access control for TRUNCATE	Yulian Khodorkovskiy	patch
25/2286	Add more compile-time asserts	Peter Smith	patch
25/1819	Allow AddForeignUpdateTargets to add extra target expressions other than columns	Etsuro Fujita, Kyotaro Horiguchi	patch
25/2071	Avoid full GIN index scan when possible	Julien Rouhaud, Nikita Glukhov	patch
25/2141	Avoiding deadlock errors in CREATE INDEX CONCURRENTLY	Dhruv Goel	patch
25/2202	B-tree deduplication	Anastasia Lubennikova	patch
25/1863	Cleaning up orphaned files using undo logs	Thomas Munro	patch
25/2020	Convert NOT IN to anti-joins when possible	David Rowley	patch
25/2104	Data at rest encryption	Antonin Houska, Ants Aasma	patch
25/2003	Fix Deadlock Issue in Single User Mode When IO Failure Occurs	Chengchao Yu	patch
25/2218	Implement INSERT SET syntax	Gareth Palmer	patch
25/2138	Incremental Materialized View Maintenance	Yugo Nagata	patch
25/2274	Invalid permission check in pg_stats for functional indexes	Pierre Ducroquet	patch
25/1934	Log bind parameter values on error	Alexey Bashtanov	patch
25/2241	New GUC prepared_statement_limit to limit memory used by prepared statements	Daniel Migowski	patch
25/2282	Optimize expression evaluation in PL/pgSQL	Konstantin Knizhnik	patch
25/1995	Replica with large recovery_min_apply_delay is not receiving changes from master...	Konstantin Knizhnik	patch
25/1260	Restricting maximum keep segments by repslots	Kyotaro Horiguchi	patch
25/1473	SQL/JSON: JSON_TABLE	Fedor Sigaev, Alexander Korotkov, Nikita Glukhov, Oleg Bartunov	patch
25/2301	Support adding partitioned tables to logical replication publications	Amit Langote	patch
25/2119	Use memcpy in pglz decompression	Andrey Borodin, Владимир Лесков	patch
25/2048	WIP: Temporal primary and foreign keys	Paul Jungwirth	patch
25/1970	Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (ver...	daisuke higuchi, Ramanarayana M	patch
25/2345	abs function for interval	Euler Taveira	patch
25/2109	accounting for memory used for BufFile during hash joins	Tomas Vondra	patch
25/1800	amcheck verification for GiST	Andrey Borodin	patch
25/2194	de-TOAST'ing using a iterator	Xiao Bao	patch
25/2054	fix for BUG #3720: wrong results at using ltree	Filip Rembiałkowski	patch
25/2323	jsonb_set_lax function	Andrew Dunstan	patch
25/2018	pg_basebackup to adjust existing data directory permissions	Haribabu Kommi	patch
25/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Arthur Zakirov	patch
25/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