PostgreSQL Patch Tester

Here lives an experimental bot that does this: PostgreSQL Commitfest → Github → ( AppVeyor, Cirrus CI ). The results appear in the following order: apply, Windows check, FreeBSD check-world, Linux check-world + docs, macOS check. The plan is eventually to show them on the Commitfest app.

Current commitfest | Next commitfest

Ready for Committer
31/2614	Add table expansion hook	Erik Nordström	patch
31/2835	Allow match a whole DN of a client certificate	Andrew Dunstan	patch
31/2856	Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Bharath Rupireddy	patch
31/2603	DROP relation IF EXISTS Docs and Tests - Bug Fix	David Johnston	patch
31/2334	ECPG new statement: DECLARE STATEMENT	Hayato Kuroda	patch
31/2747	Extending the range operators so they can cope with range element and eleme...	Esteban Zimanyi	patch
31/2569	Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	patch
31/2777	Introduce view updating options more succinctly	David Johnston	patch
31/2778	Minor variable related cleanup and rewording of plpgsql docs	David Johnston	patch
31/2807	New wal_level to disable WAL logging	Takamichi Osumi	patch
31/2900	On client connection event trigger	Konstantin Knizhnik	patch
31/2834	ResourceOwner refactoring	Heikki Linnakangas	patch
31/2570	SEARCH and CYCLE clauses	Peter Eisentraut	patch
31/2770	Wrong statistics for size of XLOG_SWITCH during pg_waldump	movead li	patch
31/2803	cleanup temporary files after crash	Euler Taveira	patch
31/2702	pg_read_all_data default role	Stephen Frost	patch
31/2822	pg_wait_backend() and pg_terminate_backend_and_wait() functions with wait and ti...	Bharath Rupireddy	patch
31/1736	pgbench - add pseudo-random permutation function	Fabien Coelho, Hironobu Suzuki	patch
31/1608	schema variables, LET command	Pavel Stehule	patch
31/2613	unicode unescape function	Pavel Stehule	patch
Needs review
31/2750	(ALTER SYSTEM) SET +=/-= operator support	Abhijit Menon-Sen	patch
31/2842	A few new options for CHECKPOINT	Nathan Bossart	patch
31/2234	A hook for path-removal decision on add_path	KaiGai Kohei	patch
31/2602	ALTER SYSTEM READ { ONLY \| WRITE }	Amul Sul	patch
31/2859	About to add WAL write/fsync statistics to pg_stat_wal view	Masahiro Ikeda	patch
31/2899	Add OID allocation retry log to GetNewOidWithIndex()	tomohiro hiramitsu	patch
31/2654	Add a feature that enables row-wise comparison partition pruning	sho kato	patch
31/2765	Add extra statistics to explain for Nested Loop	Ekaterina Sokolova	patch
31/2713	Add information about generic/custom plan to pg_stat_statements	Atsushi Torikoshi	patch
31/2896	Add is_toplevel flag in pg_stat_statements	Julien Rouhaud	patch
31/2833	Add nullif case for eval_const_expressions	hou zhijie	patch
31/1533	Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT	Matheus Oliveira	patch
31/2884	Add table access method as an option to pgbench	David Zhang	patch
31/2541	Additional Chapter "Architecture" for Part "Tutorial"	Jürgen Purtz	patch
31/2780	Allow COPY "text" to output a header and add header matching mode to COPY FROM	Rémi Lapeyre	patch
31/2709	Allow CRL "directory" for crl_file	Kyotaro Horiguchi	patch
31/2881	Allow GRANTED BY clause in normal GRANT and REVOKE statements	Peter Eisentraut	patch
31/2269	Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLES...	Justin Pryzby, Alexey Kondratov	patch
31/2158	Allow an alias to be attached directly to a JOIN ... USING	Peter Eisentraut	patch
31/2491	Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	patch
31/2492	Autovacuum on partitioned tables	Yuzuko Hosoya	patch
31/2523	BRIN multi-minmax and bloom indexes	Tomas Vondra	patch
31/2706	Background writer and checkpointer in crash recovery	Thomas Munro	patch
31/2707	Boundary value check in lazy_tid_reaped()	Masahiko Sawada	patch
31/2800	CLUSTER on partitioned table	Justin Pryzby	patch
31/2679	Change return type of EXTRACT to numeric	Peter Eisentraut	patch
31/2921	Clarify that CREATEROLE roles can GRANT default roles	Michael Banck	patch
31/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	patch
31/2675	Covering SPGiST index	Pavel Borisov	patch
31/2805	DROP INDEX CONCURRENTLY on partitioned index	Justin Pryzby	patch
31/2919	Discarding DISCARD ALL	Simon Riggs	patch
31/2698	Dumping/restoring fails on inherited generated column	Masahiko Sawada	patch
31/2911	Dynamic result sets from procedures	Peter Eisentraut	patch
31/2621	Eliminate overheads in executing generic plans	Amit Langote	patch
31/2611	Enabling data checksums in an online cluster	Magnus Hagander, Daniel Gustafsson	patch
31/2069	Expose queryid in pg_stat_activity and log_line_prefix	Julien Rouhaud	patch
31/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	patch
31/2832	Extended statistics on expressions	Tomas Vondra	patch
31/2176	FETCH FIRST clause PERCENT option	Surafel Temesgen	patch
31/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	patch
31/2905	Fix OpenSSL connection setup debug callback	Daniel Gustafsson	patch
31/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	patch
31/2719	Fix checksum verification in base backups for zero page headers	Michael Banck	patch
31/2685	Fix collation handling in postgres_fdw	Tom Lane	patch
31/2877	Fix firing of RI triggers during cross-partition updates of partitioned tables	Amit Langote	patch
31/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	patch
31/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
31/2824	Functions for sorting GiST build of gist_btree types	Andrey Borodin	patch
31/1651	GROUP BY optimization	Fedor Sigaev, Pavel Borisov	patch
31/2402	GUC to disable cancellation of awaiting for synchronous replication	Andrey Borodin	patch
31/2711	Get memory contexts of an arbitrary backend process	Atsushi Torikoshi	patch
31/2860	Hooks on start/end/abort Xact command	Gilles Darold
31/2553	INSERT SELECT: BulkInsertState and table_multi_insert	Justin Pryzby	patch
31/2218	Implement INSERT SET syntax	Gareth Palmer	patch
31/2879	Improve \e, \ef and \ev if the editor is quit	Laurenz Albe	patch
31/2509	Improve standby connection denied error message	James Coleman	patch
31/2742	Incorrect usages of PG_GETARG_UINT32	Ashutosh Bapat
31/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	patch
31/2843	Initial mach based shared memory support.	James Hilliard
31/2925	Key management with tests	Stephen Frost, Masahiko Sawada, Bruce Momjian	patch
31/2916	Let people set host(no)ssl settings from initdb	David Fetter	patch
31/2920	MERGE SQL command	Álvaro Herrera, Simon Riggs, Pavan Deolasee	patch
31/2829	Make Append Cost aware of some run time partition prune case	Andy Fan	patch
31/772	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	patch
31/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	patch
31/2917	Make popcount available to SQL	David Fetter	patch
31/2909	Maximize page freezing	Simon Riggs	patch
31/2869	Mitigate pg_rewind race condition, if config file is enlarged concurrently.	Heikki Linnakangas	patch
31/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	patch
31/2893	Move regression tablespace cleanup from makefiles pg_regress? (Occasional tables...	Michael Paquier	patch
31/2898	New IndexAM API controlling index vacuum strategies	Masahiko Sawada	patch
31/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	patch
31/2918	New default role allowing to change per-role/database settings	Michael Banck	patch
31/2615	Non-volatile WAL buffer	Takashi Menjo
31/2810	OpenSSL 3.0.0 compatibility	Daniel Gustafsson	patch
31/2836	Optimising latch signals	Thomas Munro	patch
31/2699	Optimizing NULL check on pkey column	Surafel Temesgen	patch
31/2575	Overhaul UPDATE/DELETE processing	Amit Langote	patch
31/2701	PATCH: Attempt to make dbsize a bit more consistent	Georgios Kokolatos	patch
31/2903	Parallel Hash Full Join	Melanie Plageman	patch
31/2844	Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	patch
31/2841	Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	patch
31/2880	Perform COPY FROM encoding conversions in larger chunks	Heikki Linnakangas	patch
31/2724	Pipelining/batch mode support for libpq	Craig Ringer, Matthieu Garrigues	patch
31/2907	PoC Refactor AM analyse API	Denis Smirnov
31/2652	Prefer explicit JOIN syntax over (old) implicit syntax in tutorial	Jürgen Purtz	patch
31/2848	Printing LSN made easy	Ashutosh Bapat	patch
31/2863	Printing backtrace of postgres processes	vignesh C	patch
31/2597	Problem with RETURNING and update tuple routing	Amit Langote	patch
31/2867	Protect archive recovery from missing data	Takamichi Osumi	patch
31/931	Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	patch
31/1247	Push aggregation down to base relations and joins	Antonin Houska	patch
31/2895	REINDEX backend filtering	Julien Rouhaud	patch
31/2733	Reduce PostmasterIsAlive() checks during recovery	Thomas Munro	patch
31/2452	Reduce WaitEventSet system call spam	Thomas Munro	patch
31/2817	Reduce the number of special cases to build contrib modules on windows	David Rowley	patch
31/2878	Refactoring HMAC in the core code	Michael Paquier	patch
31/2717	Reloptions for table access methods	Jeff Davis	patch
31/2858	Remove checkpoint_completion_target GUC and turn into a #define	Stephen Frost	patch
31/2113	Remove page-read callback from XLogReaderState	Kyotaro Horiguchi	patch
31/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
31/2781	Replace polyphase merge with a simple k-way balanced merge	Heikki Linnakangas	patch
31/2906	Row filtering for logical replication	Euler Taveira, Onder Kalacı	patch
31/2771	Runtime Partition Prune code refactor	Amit Langote	patch
31/2630	SQL-standard function body	Peter Eisentraut	patch
31/2902	SQL/JSON: JSON_TABLE	Nikita Glukhov	patch
31/2901	SQL/JSON: functions	Nikita Glukhov	patch
31/1708	Shared-memory based stats collector	Kyotaro Horiguchi	patch
31/2868	Some more hackery around cryptohashes (some fixes + SHA1)	Michael Paquier	patch
31/2370	Split StdRdOptions into HeapOptions and ToastOptions	Nikolay Shaplov	patch
31/2610	Support parallelism for copy command	vignesh C, Bharath Rupireddy	patch
31/2922	Table AM modifications to accept column projection lists	Jacob Champion, Soumyadeep Chakraborty	patch
31/2924	Tid scan improvements	David Rowley, Edmund Horner	patch
31/1574	Transactions involving multiple postgres foreign servers	Masahiko Sawada, Ashutosh Bapat	patch
31/2913	Tying an object's ownership to datdba	Noah Misch	patch
31/2376	UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR	John Dent	patch
31/2799	Use posix fadvise to speed up analyze + improve automatic analyze with "avg read...	Stephen Frost, Jakub Wartak	patch
31/2386	Using multicolumn statistics for more precise join selectivity estimatation	Konstantin Knizhnik	patch
31/2410	WAL prefetch (another approach)	Thomas Munro	patch
31/2862	WIP: macOS SIP workaround	Peter Eisentraut	patch
31/2787	allow partial union-all and improve parallel subquery costing	Luc Vlaming	patch
31/2539	allow to set a pager for psql's watch command	Pavel Stehule	patch
31/2520	archive status ".ready" files may be created too early	Nathan Bossart	patch
31/2870	autovacuum exit on postmaster death when sleeping	Stephen Frost	patch
31/2838	brin: avoid errors processing work item following concurrent reindex	Álvaro Herrera, Justin Pryzby	patch
31/2865	create table like: ACCESS METHOD	Justin Pryzby	patch
31/2915	document the hook system	David Fetter	patch
31/2684	enhancing plpgsql API for debugging and tracing	Pavel Stehule	patch
31/2349	global temporary table	wenjing zeng	patch
31/2661	implement LogicalDecodeMessageCB for pgoutput	Dave Cramer	patch
31/2891	install path aware subclass of PostgresNode	Andrew Dunstan
31/2482	jsonpath syntax extensions	Nikita Glukhov	patch
31/2773	libpq compression	Konstantin Knizhnik	patch
31/2914	logical decoding of two-phase transactions	Stas Kelvich, Nikhil Sontakke, Ajin Cherian, Peter Smith	patch
31/2081	parse-time support function for "any" datatype	Pavel Stehule	patch
31/2573	pg_dump - read data for some options from external file	Pavel Stehule	patch
31/2377	pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ...	Justin Pryzby	patch
31/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	patch
31/2861	pg_upgrade test for binary compatibility of core data types	Justin Pryzby	patch
31/2839	possibility to rename root namespace in plpgsql	Pavel Stehule	patch
31/2697	possibility to write window function in PL languages (like PLpgSQL)	Pavel Stehule	patch
31/2650	postgres_fdw connection caching enable/disable or timeout feature	Bharath Rupireddy	patch
31/2620	postgres_fdw insert batching	Takayuki Tsunakawa	patch
31/2812	protocol default result formats setting	Peter Eisentraut	patch
31/2536	psql - possibility to specify where status row should be displayed	Pavel Stehule	patch
31/2788	psql \df choose functions by their arguments	Greg Sabino Mullane	patch
31/2657	shared tempfile was not removed on statement_timeout	Justin Pryzby	patch
31/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
31/2474	truncating timestamps on arbitrary intervals	John Naylor	patch
31/2910	wal_sessioninfo	Simon Riggs	patch
Waiting on Author
31/2714	ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Álvaro Herrera	patch
31/2857	ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently	Takayuki Tsunakawa	patch
31/2872	Add primary keys to system catalogs	Peter Eisentraut	patch
31/2883	Add wait_start column to pg_locks	Atsushi Torikoshi	patch
31/2694	Automatic HASH and LIST partition creation	Anastasia Lubennikova	patch
31/2886	CREATE INDEX CONCURRENTLY does not index prepared xact's data	Andrey Borodin	patch
31/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby	patch
31/2518	Corruption during WAL replay	Teja Mupparti	patch
31/2433	Erase the distinctClause if the result is unique by definition	Andy Fan	patch
31/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	patch
31/2876	Fix comment about generate_gather_paths	hou zhijie	patch
31/2854	Fixes for phrase search with multi-lexeme tokens	Alexander Korotkov	patch
31/2774	Further note require activity aspect of automatic checkpoint and archiving	David Johnston	patch
31/1062	Generic type subscripting	Dmitry Dolgov	patch
31/2628	Implement for window functions	Vik Fearing	patch
31/2795	Improve replay pause	dilip kumar	patch
31/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
31/1677	New libpq option to prefer standby for connection	Haribabu Kommi, Greg Nancarrow	patch
31/2522	Return ERROR on COMMIT instead of silently ROLLBACK	Dave Cramer	patch
31/2592	Support for NSS as TLS backend	Daniel Gustafsson	patch
31/2908	VACUUM (FAST_FREEZE )	Simon Riggs	patch
31/2316	WITH SYSTEM VERSIONING Temporal Tables	Surafel Temesgen	patch
31/2644	avoid bitmapOR-ing indexes for scan conditions implied by partition constraint	Justin Pryzby, Soumyadeep Chakraborty, Soumyadeep Chakraborty	patch
31/2310	bitmap cost should account for correlated indexes	Justin Pryzby	patch
31/2813	custom compression methods for toast	dilip kumar, Ildus Kurbangaliev	patch
31/2890	doc review for v14	Justin Pryzby	patch
31/2670	extend amcheck module to check heaps	Mark Dilger	patch
31/2819	faster execution of CALL statement from plpgsql	Pavel Stehule	patch
31/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	patch
31/2889	libpq trace log	Aya Iwata	patch
31/2801	list of extended statistics on psql	Tatsuro Yamada	patch
31/2850	orphaned function	Bertrand Drouvot	patch
31/2769	parallel distinct union and aggregate support patch	bucoo hsiao	patch
31/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Arthur Zakirov	patch
31/2557	pgbench - add a synchronization barrier when starting	Fabien Coelho	patch
31/2827	pgbench stopped supporting large number of client connections on Windows	Marina Polyakova	patch
31/2798	remove deprecated v8.2 containment operators	Justin Pryzby	patch
31/2888	zstd compression for pg_dump	Justin Pryzby	patch

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

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author