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
29/2269	Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLES...	Justin Pryzby, Alexey Kondratov	patch
29/2009	COPY FREEZE, PD_VISIBLE_ALL and VM status	Pavan Deolasee, Ibrar Ahmed	patch
29/2675	Covering SPGiST index	Pavel Borisov	patch
29/2603	DROP relation IF EXISTS Docs and Tests - Bug Fix	David Johnston	patch
29/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	patch
29/1677	New libpq option to prefer standby for connection	Haribabu Kommi, Greg Nancarrow	patch
29/2631	deferred primary key and logical replication	Euler Taveira	patch
29/2307	extension patch of CREATE OR REPLACE TRIGGER	Takamichi Osumi	patch
29/2573	pg_dump - read data for some options from external file	Pavel Stehule	patch
29/2377	pg_ls_* functions for showing metadata and recursing (pg_ls_tmpdir to show share...	Justin Pryzby	patch
29/2702	pg_read_all_data default role	Stephen Frost	patch
29/2562	speed up unicode normalization quick check	John Naylor	patch
29/2613	unicode unescape function	Pavel Stehule	patch
Needs review
29/2234	A hook for path-removal decision on add_path	KaiGai Kohei	patch
29/2602	ALTER SYSTEM READ { ONLY \| WRITE }	Amul Sul	patch
29/2714	ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Álvaro Herrera	patch
29/2608	Add and annotation to tags	Dagfinn Ilmari Mannsåker	patch
29/2604	Add Information during standby recovery conflicts	Bertrand Drouvot	patch
29/2576	Add LWLock blocker(s) information	Bertrand Drouvot	patch
29/2654	Add a feature that enables row-wise comparison partition pruning	sho kato	patch
29/2639	Add session statistics to pg_stat_database	Laurenz Albe	patch
29/1533	Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT	Matheus Oliveira	patch
29/2614	Add table expansion hook	Erik Nordström	patch
29/2541	Additional Chapter "Architecture" for Part "Tutorial"	Jürgen Purtz	patch
29/2709	Allow CRL "directory" for crl_file	Kyotaro Horiguchi	patch
29/2158	Allow an alias to be attached directly to a JOIN ... USING	Peter Eisentraut	patch
29/2646	Allow terminating the idle sessions	Japin Li	patch
29/2249	Asymmetric partition-wise JOIN	KaiGai Kohei	patch
29/2491	Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	patch
29/2492	Autovacuum on partitioned tables	Yuzuko Hosoya	patch
29/2523	BRIN multi-minmax and bloom indexes	Tomas Vondra	patch
29/2706	Background writer and checkpointer in crash recovery	Thomas Munro	patch
29/2707	Boundary value check in lazy_tid_reaped()	Masahiko Sawada	patch
29/2645	Bug 16419 Doc and Test Adds	David Johnston	patch
29/2705	Choose AlternativeSubPlan alternative within the planner	Tom Lane	patch
29/2574	Compatible defaults for LEAD/LAG	Vik Fearing	patch
29/2545	Confusing list foreign table options in psql - Fixing slash usage text	Hamid Akhtar	patch
29/2518	Corruption during WAL replay	Teja Mupparti	patch
29/2429	Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare()	Peter Geoghegan	patch
29/2454	Document concurrent index builds waiting on each other	James Coleman	patch
29/2698	Dumping/restoring fails on inherited generated column	Masahiko Sawada	patch
29/2334	ECPG new statement: DECLARE STATEMENT	Hayato Kuroda	patch
29/2621	Eliminate overheads in executing generic plans	Amit Langote	patch
29/2433	Erase the distinctClause if the result is unique by definition	Andy Fan	patch
29/2277	Executor code refactoring around result relations	Amit Langote	patch
29/2069	Expose queryid in pg_stat_activity in log_line_prefix	Julien Rouhaud	patch
29/2421	Extended statistics improvements	Tomas Vondra	patch
29/2658	Fix autovac for large number of tables	Kasahara Tatsuhito	patch
29/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	patch
29/2719	Fix checksum verification in base backups for zero page headers	Michael Banck	patch
29/2685	Fix collation handling in postgres_fdw	Tom Lane	patch
29/2050	Fix unique join costings	David Rowley	patch
29/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
29/2553	GUC for BulkInsertState	Justin Pryzby	patch
29/2402	GUC to disable cancellation of awaiting for synchronous replication	Andrey Borodin	patch
29/2669	Handing SLRU sync work over to the checkpointer	Thomas Munro	patch
29/2569	Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	patch
29/2218	Implement INSERT SET syntax	Gareth Palmer	patch
29/2489	Improve handling of parameter differences in physical replication	Peter Eisentraut	patch
29/2449	Improve logging around restore_command	Jeff Janes	patch
29/2582	Improve planner cost estimations for alternative subplans	Alexey Bashtanov	patch
29/2642	Improvements in Copy From	vignesh C	patch
29/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
29/2616	Keep elog(ERROR) and ereport(ERROR) calls in the cold path	David Rowley	patch
29/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	patch
29/2369	Online checksums verification	Julien Rouhaud	patch
29/2319	Optimize dropping of relation buffers during recovery	Kirk Jamison	patch
29/2699	Optimizing NULL check on pkey column	Surafel Temesgen	patch
29/2575	Overhaul UPDATE/DELETE processing	Amit Langote	patch
29/2620	POC: postgres_fdw insert batching		patch
29/2724	Pipelining/batch mode support for libpq	Craig Ringer, Matthieu Garrigues	patch
29/931	Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	patch
29/1247	Push aggregation down to base relations and joins	Antonin Houska	patch
29/2674	Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration	Michael Paquier	patch
29/2452	Reduce WaitEventSet system call spam	Thomas Munro	patch
29/2717	Reloptions for table access methods	Jeff Davis	patch
29/2579	Removal of currtid()/currtid2() and some table AM cleanup	Michael Paquier	patch
29/2630	SQL-standard function body	Peter Eisentraut	patch
29/2370	Split StdRdOptions into HeapOptions and ToastOptions	Nikolay Shaplov	patch
29/2026	Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss)	Noah Misch	patch
29/2676	Start WAL streaming as early as possible, without waiting for startup process to...	Asim Rama Praveen, Hao Wu	patch
29/2592	Support for NSS as TLS backend	Daniel Gustafsson	patch
29/2703	Support for OUT parameters in procedures	Peter Eisentraut	patch
29/2610	Support parallelism for copy command	vignesh C, Bharath Rupireddy	patch
29/2316	System Versioned Temporal Table	Surafel Temesgen	patch
29/2376	UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR	John Dent	patch
29/2718	Use USE_OPENSSL_RANDOM for OpenSSL random	Daniel Gustafsson	patch
29/2386	Using multicolumn statistics for more precise join selectivity estimatation	Konstantin Knizhnik	patch
29/2682	Various fixes for snapshot-too-old feature	Robert Haas, Thomas Munro	patch
29/2410	WAL prefetch (another approach)	Thomas Munro	patch
29/2539	allow to set a pager for psql's watch command	Pavel Stehule	patch
29/2637	audo-detect and use -moutline-atomics compilation flag for aarch64	Tsahi Zidenberg	patch
29/2644	avoid bitmapOR-ing partition indexes with unnecessarily scan conditions	Konstantin Knizhnik, Justin Pryzby	patch
29/2310	bitmaps and correlation	Justin Pryzby	patch
29/2194	de-TOAST'ing using a iterator	Xiao Bao	patch
29/2684	enahncing plpgsql API for debugging and tracing	Pavel Stehule	patch
29/2670	extend amcheck module to check heaps	Mark Dilger	patch
29/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	patch
29/2482	jsonpath syntax extensions	Nikita Glukhov	patch
29/2081	parse time support function	Pavel Stehule	patch
29/2367	per-database-object collation version tracking	Julien Rouhaud, Thomas Munro	patch
29/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Arthur Zakirov	patch
29/2557	pgbench - add a synchronization barrier when starting	Fabien Coelho	patch
29/1736	pgbench - add pseudo-random permutation function	Fabien Coelho, Hironobu Suzuki	patch
29/2535	pgbench - allow to test whether a variable exists (2)	Fabien Coelho	patch
29/2313	pgbench - refactor init functions with buffers	Fabien Coelho	patch
29/2697	possibility to write window function in PL languages (like PLpgSQL)	Pavel Stehule	patch
29/2650	postgres_fdw connection caching enable/disable or timeout feature	Bharath Rupireddy	patch
29/2536	psql - possibility to specify where status row should be displayed	Pavel Stehule	patch
29/2664	psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, ...	Alexandra Pervushina	patch
29/2112	range_agg / multiranges	Paul Jungwirth	patch
29/2559	reduce memory requirements of PLpgSQL CALL statement	Pavel Stehule	patch
29/2715	remove spurious CREATE INDEX CONCURRENTLY wait	Álvaro Herrera	patch
29/2657	shared tempfile was not removed on statement_timeout	Justin Pryzby	patch
29/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
29/2474	truncating timestamps on arbitrary intervals	John Naylor	patch
29/2688	update ps display for recovery checkpoint	Justin Pryzby	patch
Waiting on Author
29/2689	Add <<\| and \|>> operators for points	Emre Hasegeli	patch
29/2713	Add information about generic/custom plan to pg_stat_statements	Atsushi Torikoshi	patch
29/2668	Add information to rm_redo_error_callback()	Bertrand Drouvot	patch
29/2665	Add section headings to index types doc	Dagfinn Ilmari Mannsåker	patch
29/1919	Add timeline to partial WAL segments	David Steele	patch
29/2660	Adding Support for Copy callback functionality on COPY TO api	Bilva Sanaba	patch
29/2504	Allow COPY "text" to output a header and add header matching mode to COPY FROM	Rémi Lapeyre	patch
29/2648	Allow queries in WHEN expression of FOR EACH STATEMENT triggers	Joe Wildish	patch
29/2694	Automatic HASH and LIST partition creation	Anastasia Lubennikova	patch
29/2581	Batch processing of RI checks	Antonin Houska, Corey Huinker	patch
29/2542	Binary search in ScalarArrayOpExpr for OR'd constant arrays	James Coleman	patch
29/2635	Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ....	Marina Polyakova, Anna Akenteva	patch
29/2679	Change return type of EXTRACT to numeric	Peter Eisentraut	patch
29/2656	Display individual query in pg_stat_activity	Bertrand Drouvot	patch
29/2611	Enabling data checksums in an online cluster	Magnus Hagander, Daniel Gustafsson	patch
29/2176	FETCH FIRST clause PERCENT option	Surafel Temesgen	patch
29/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	patch
29/1062	Generic type subscripting	Dmitry Dolgov	patch
29/2711	Get memory contexts of an arbitrary backend process	Atsushi Torikoshi	patch
29/2588	Hashjoin fall back to block nested hashloop join	Melanie Plageman, Soumyadeep Chakraborty, Jesse Zhang, David Kimura	patch
29/2628	Implement for window functions	Vik Fearing	patch
29/2509	Improve standby connection denied error message	James Coleman	patch
29/2681	Inserting DEFAULT into generated columns from VALUES RTE	Mikhail Titov	patch
29/2501	JIT expression evaluation improvements	Andres Freund	patch
29/2196	KMS - Internal key management system	Masahiko Sawada, Ibrar Ahmed, Insung Moon	patch
29/1977	Ltree syntax improvement	Dmitry Belyavsky	patch
29/772	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	patch
29/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	patch
29/2693	New statistics for tuning WAL buffer size	Masahiro Ikeda	patch
29/2701	PATCH: Attempt to make dbsize a bit more consistent	Georgios Kokolatos	patch
29/2652	Prefer explicit JOIN syntax over (old) implicit syntax in tutorial	Jürgen Purtz	patch
29/2708	Prepare for deprecate clientcert=no-verify in pg_hba.conf	Kyotaro Horiguchi	patch
29/2597	Problem with RETURNING and update tuple routing	Amit Langote	patch
29/2584	REINDEX/CIC/CLUSTER of partitioned tables	Justin Pryzby	patch
29/2686	Refactor pg_rewind code and make it work against a standby	Heikki Linnakangas	patch
29/2113	Remove page-read callback from XLogReaderState	Kyotaro Horiguchi	patch
29/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
29/2663	Remove useless distinct clauses	Pierre Ducroquet	patch
29/2634	Replace spinlock with lwlock in pg_stat_statements	Fujii Masao	patch
29/2651	Retry Cached Remote Connections for postgres_fdw in case remote backend gets kil...	Bharath Rupireddy	patch
29/2522	Return ERROR on COMMIT instead of silently ROLLBACK	Dave Cramer	patch
29/2570	SEARCH and CYCLE clauses	Peter Eisentraut	patch
29/1708	Shared-memory based stats collector	Kyotaro Horiguchi	patch
29/1574	Transactions involving multiple postgres foreign servers	Masahiko Sawada, Ashutosh Bapat	patch
29/2048	WIP: Temporal primary and foreign keys	Paul Jungwirth	patch
29/2189	Windows could not stat file - over 4GB	Juanjo Santamaria Flecha	patch
29/2520	archive status ".ready" files may be created too early	Nathan Bossart	patch
29/2219	document that psql's FETCH_COUNT does not work with combined (\;) queries	Fabien Coelho	patch
29/2624	fix (partially) pgbench :variable substitution for -M extended and prepared	Fabien Coelho	patch
29/2349	global temporary table	wenjing zeng	patch
29/2661	implement LogicalDecodeMessageCB for pgoutput		patch
29/2692	list of extended statistics on psql	Tatsuro Yamada	patch
29/2600	pg_dump --where option	Surafel Temesgen, Carter Thaxton	patch
29/2096	psql - add SHOW_ALL_RESULTS option	Fabien Coelho	patch
29/1608	schema variables, LET command	Pavel Stehule	patch

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

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author