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
32/2614	Add table expansion hook	Erik Nordström	patch
32/2835	Allow match a whole DN of a client certificate	Andrew Dunstan	patch
32/2694	Automatic HASH and LIST partition creation	Anastasia Lubennikova	patch
32/2856	Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW	Bharath Rupireddy	patch
32/2603	DROP relation IF EXISTS Docs and Tests - Bug Fix	David Johnston	patch
32/2334	ECPG new statement: DECLARE STATEMENT	Hayato Kuroda	patch
32/2747	Extending the range operators so they can cope with range element and eleme...	Esteban Zimanyi	patch
32/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	patch
32/2569	Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	patch
32/2795	Improve replay pause	dilip kumar	patch
32/2977	Improvements and additions to COPY progress reporting	Matthias vd Meent	patch
32/2777	Introduce view updating options more succinctly	David Johnston	patch
32/2778	Minor variable related cleanup and rewording of plpgsql docs	David Johnston	patch
32/1677	New libpq option to prefer standby for connection	Haribabu Kommi, vignesh C, Greg Nancarrow	patch
32/2807	New wal_level to disable WAL logging	Takamichi Osumi	patch
32/2900	On client connection event trigger	Konstantin Knizhnik	patch
32/2880	Perform COPY FROM encoding conversions in larger chunks	Heikki Linnakangas	patch
32/2867	Protect archive recovery from missing data	Takamichi Osumi	patch
32/2974	Remove FE/BE protocol v2 support	Heikki Linnakangas	patch
32/2770	Wrong statistics for size of XLOG_SWITCH during pg_waldump	movead li	patch
32/2803	cleanup temporary files after crash	Euler Taveira	patch
32/2889	libpq trace log	Aya Iwata	patch
32/2702	pg_read_all_data default role	Stephen Frost	patch
32/2822	pg_wait_backend() and pg_terminate_backend_and_wait() functions with wait and ti...	Bharath Rupireddy	patch
32/1736	pgbench - add pseudo-random permutation function	Fabien Coelho, Hironobu Suzuki	patch
32/1608	schema variables, LET command	Pavel Stehule	patch
32/2613	unicode unescape function	Pavel Stehule	patch
Needs review
32/2750	(ALTER SYSTEM) SET +=/-= operator support	Abhijit Menon-Sen	patch
32/2982	64-bit XIDs in deleted nbtree pages	Peter Geoghegan	patch
32/2234	A hook for path-removal decision on add_path	KaiGai Kohei	patch
32/2991	A qsort template	Thomas Munro	patch
32/2602	ALTER SYSTEM READ { ONLY \| WRITE }	Amul Sul	patch
32/2859	About to add WAL write/fsync statistics to pg_stat_wal view	Masahiro Ikeda	patch
32/2958	Adaptive query optimization: create extented statistics using auto_explain exten...	Konstantin Knizhnik	patch
32/3009	Add --tablespace option to reindexdb	Michael Paquier	patch
32/2713	Add information about generic/custom plan to pg_stat_statements	Atsushi Torikoshi	patch
32/2896	Add is_toplevel flag in pg_stat_statements	Julien Rouhaud	patch
32/2833	Add nullif case for eval_const_expressions	hou zhijie	patch
32/1533	Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT	Matheus Oliveira	patch
32/2541	Additional Chapter "Architecture" for Part "Tutorial"	Jürgen Purtz	patch
32/2780	Allow COPY "text" to output a header and add header matching mode to COPY FROM	Rémi Lapeyre	patch
32/2158	Allow an alias to be attached directly to a JOIN ... USING	Peter Eisentraut	patch
32/2992	Allow batched insert during cross-partition updates	Amit Langote	patch
32/2491	Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	patch
32/2492	Auto-analyze on partitioned tables	Yuzuko Hosoya	patch
32/2983	Autovacuum dynamic cost_limit, cost_delay	Scott Mead	patch
32/2523	BRIN multi-minmax and bloom indexes	Tomas Vondra	patch
32/2706	Background writer and checkpointer in crash recovery	Thomas Munro	patch
32/2707	Boundary value check in lazy_tid_reaped()	Masahiko Sawada	patch
32/2800	CLUSTER on partitioned table	Justin Pryzby	patch
32/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby	patch
32/2999	Catalog version access	Vik Fearing	patch
32/2679	Change return type of EXTRACT to numeric	Peter Eisentraut	patch
32/2921	Clarify that CREATEROLE roles can GRANT default roles	Michael Banck	patch
32/3015	Configurable compression methods for FPIs	Andrey Borodin	patch
32/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	patch
32/2518	Corruption during WAL replay	Teja Mupparti	patch
32/2675	Covering SPGiST index	Pavel Borisov	patch
32/2805	DROP INDEX CONCURRENTLY on partitioned index	Justin Pryzby	patch
32/3002	Deprecate SSL compression	Daniel Gustafsson	patch
32/2919	Discarding DISCARD ALL	Simon Riggs	patch
32/3016	Dump public schema ownership, seclabels and comments	Noah Misch	patch
32/2911	Dynamic result sets from procedures	Peter Eisentraut	patch
32/2928	EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Bharath Rupireddy	patch
32/2611	Enabling data checksums in an online cluster	Magnus Hagander, Daniel Gustafsson	patch
32/2949	Error reporting for multi-line JSON	Simon Riggs, Hamid Akhtar	patch
32/2069	Expose queryid in pg_stat_activity and log_line_prefix	Julien Rouhaud	patch
32/2951	Extend comments on signal handling and cross-reference comments on signal handli...	Craig Ringer	patch
32/2953	Extend docs on how to write correct postgres-dialect C including extensions and ...	Craig Ringer	patch
32/2975	Extend more usecase for planning time partition pruning and init partition pruni...		patch
32/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	patch
32/2832	Extended statistics on expressions	Tomas Vondra	patch
32/2176	FETCH FIRST clause PERCENT option	Surafel Temesgen	patch
32/2986	Fallback table AM for relkinds without storage	Michael Paquier	patch
32/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	patch
32/2946	Feature improvement for CLOSE, FETCH, MOVE tab completion		patch
32/2962	Fix DROP TABLESPACE on Windows with ProcSignalBarrier?	Thomas Munro	patch
32/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	patch
32/2719	Fix checksum verification in base backups for zero page headers	Michael Banck	patch
32/2685	Fix collation handling in postgres_fdw	Tom Lane	patch
32/2971	Fix detection of preadv/pwritev support for OSX.	James Hilliard
32/2877	Fix firing of RI triggers during cross-partition updates of partitioned tables	Amit Langote	patch
32/2930	Fix memory bloat caused by foreign key checking involving partitions	Amit Langote, keisuke kuroda	patch
32/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	patch
32/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
32/3014	Fix use of cursor sensitivity terminology	Peter Eisentraut	patch
32/2995	Freeze the inserted tuples during CTAS	Paul Guo	patch
32/2947	Full support for index LP_DEAD hint bits on standby	Michail Nikolaev	patch
32/2824	Functions for sorting GiST build of gist_btree types	Andrey Borodin	patch
32/2998	GROUP BY DISTINCT	Vik Fearing	patch
32/1651	GROUP BY optimization	Fedor Sigaev, Pavel Borisov	patch
32/2402	GUC to disable cancellation of awaiting for synchronous replication	Andrey Borodin	patch
32/2711	Get memory contexts of an arbitrary backend process	Atsushi Torikoshi	patch
32/2860	Hooks on start/end/abort Xact command	Gilles Darold
32/2553	INSERT SELECT: BulkInsertState and table_multi_insert	Justin Pryzby	patch
32/2957	Identify missing publications from publisher while create/alter subscription.	vignesh C	patch
32/2218	Implement INSERT SET syntax	Gareth Palmer	patch
32/2879	Improve \e, \ef and \ev if the editor is quit	Laurenz Albe	patch
32/2976	Improve amcheck to check UNIQUE constraint in btree index	Anastasia Lubennikova, Pavel Borisov	patch
32/2959	Improve join selectivity estimation using extended statistics	Konstantin Knizhnik	patch
32/2509	Improve standby connection denied error message	James Coleman	patch
32/2973	In psql \copy from, send data to server in larger chunks	Heikki Linnakangas	patch
32/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	patch
32/2960	Infrastructure changes to make the code less sensitive to transaction id bit wid...	James Finnerty	patch
32/2843	Initial mach based shared memory support.	James Hilliard
32/2952	Introduce ProcessInterrupts_hook for C extensions	Craig Ringer	patch
32/2925	Key management with tests	Stephen Frost, Masahiko Sawada, Bruce Momjian	patch
32/2916	Let people set host(no)ssl settings from initdb	David Fetter	patch
32/2978	Log authenticated identity from all auth methods	Jacob Champion	patch
32/2829	Make Append Cost aware of some run time partition prune case	Andy Fan	patch
32/772	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	patch
32/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	patch
32/2917	Make popcount available to SQL	David Fetter	patch
32/2909	Maximize page freezing	Simon Riggs	patch
32/2968	Minimal logical decoding on standbys (take 6)	Amit Khandekar	patch
32/2869	Mitigate pg_rewind race condition, if config file is enlarged concurrently.	Heikki Linnakangas	patch
32/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	patch
32/2893	Move regression tablespace cleanup from makefiles pg_regress? (Occasional tables...	Michael Paquier	patch
32/2898	New IndexAM API controlling index vacuum strategies	Masahiko Sawada	patch
32/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	patch
32/2918	New default role allowing to change per-role/database settings	Michael Banck	patch
32/2615	Non-volatile WAL buffer	Takashi Menjo	patch
32/2810	OpenSSL 3.0.0 compatibility	Daniel Gustafsson	patch
32/2836	Optimising latch signals	Thomas Munro	patch
32/2699	Optimizing NULL check on pkey column	Surafel Temesgen	patch
32/2575	Overhaul UPDATE/DELETE processing	Amit Langote	patch
32/2701	PATCH: Attempt to make dbsize a bit more consistent	Georgios Kokolatos	patch
32/2903	Parallel Hash Full Join	Melanie Plageman	patch
32/2844	Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	patch
32/2841	Parallel Inserts in CREATE TABLE AS	Bharath Rupireddy	patch
32/2932	Partial foreign key updates in referential integrity triggers	Paul Martinez	patch
32/2939	Pg14, pg_dumpall and "password_encryption=true"	Ian Barwick
32/2724	Pipelining/batch mode support for libpq	Álvaro Herrera, Craig Ringer, Matthieu Garrigues	patch
32/2907	PoC Refactor AM analyse API	Denis Smirnov
32/2652	Prefer explicit JOIN syntax over (old) implicit syntax in tutorial	Jürgen Purtz	patch
32/2863	Printing backtrace of postgres processes	vignesh C	patch
32/2597	Problem with RETURNING and update tuple routing	Amit Langote	patch
32/931	Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	patch
32/1247	Push aggregation down to base relations and joins	Antonin Houska	patch
32/2895	REINDEX backend filtering	Julien Rouhaud	patch
32/2733	Reduce PostmasterIsAlive() checks during recovery	Thomas Munro	patch
32/2452	Reduce WaitEventSet system call spam	Thomas Munro	patch
32/2817	Reduce the number of special cases to build contrib modules on windows	David Rowley	patch
32/2935	Reduce the time required for a database recovery from archive.	Anna Akenteva, Dmitry Shulga, Ivan Taranov	patch
32/3005	Refactor ECPGconnect() and allow IPv6 connection	Hayato Kuroda	patch
32/2621	Refactor nodeModifyTable.c to allow lazy opening of result relations	Amit Langote	patch
32/2878	Refactoring HMAC in the core code	Michael Paquier	patch
32/2717	Reloptions for table access methods	Jeff Davis	patch
32/2858	Remove checkpoint_completion_target GUC and turn into a #define	Stephen Frost	patch
32/2113	Remove page-read callback from XLogReaderState	Kyotaro Horiguchi	patch
32/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
32/2943	Rename of triggers for partitioned tables		patch
32/3008	Replace buffer I/O locks with condition variables		patch
32/2781	Replace polyphase merge with a simple k-way balanced merge	Heikki Linnakangas	patch
32/3000	Report text parameter values in errors during typinput	Justin Pryzby	patch
32/2927	Report tranche ID and LWLock pointer in LWLock static tracepoints	Craig Ringer	patch
32/2834	ResourceOwner refactoring	Heikki Linnakangas	patch
32/2522	Return ERROR on COMMIT instead of silently ROLLBACK	Dave Cramer	patch
32/2906	Row filtering for logical replication	Euler Taveira	patch
32/2771	Runtime Partition Prune code refactor	Amit Langote	patch
32/2630	SQL-standard function body	Peter Eisentraut	patch
32/2902	SQL/JSON: JSON_TABLE	Nikita Glukhov	patch
32/2901	SQL/JSON: functions	Nikita Glukhov	patch
32/3010	SSL SNI	Peter Eisentraut	patch
32/1708	Shared-memory based stats collector	Kyotaro Horiguchi	patch
32/2370	Split StdRdOptions into HeapOptions and ToastOptions	Nikolay Shaplov	patch
32/2965	Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax	Japin Li	patch
32/2592	Support for NSS as TLS backend	Daniel Gustafsson	patch
32/2610	Support parallelism for copy command	vignesh C, Bharath Rupireddy	patch
32/2979	Support tab completion for upper character inputs in psql	Haiying Tang	patch
32/2955	System catalog accesses in error context callback	Masahiko Sawada, Bharath Rupireddy	patch
32/2997	TRIM_ARRAY	Vik Fearing	patch
32/2972	TRUNCATE on foreign table	KaiGai Kohei, kazutaka onishi	patch
32/2922	Table AM modifications to accept column projection lists	Jacob Champion, Soumyadeep Chakraborty	patch
32/2994	Track wal_level drop for backup management	Takamichi Osumi	patch
32/1574	Transactions involving multiple postgres foreign servers	Masahiko Sawada, Ashutosh Bapat	patch
32/2913	Tying an object's ownership to datdba	Noah Misch	patch
32/2376	UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR	John Dent	patch
32/2996	Use SSE4 for verifying UTF-8	John Naylor	patch
32/2799	Use posix fadvise to speed up analyze + improve automatic analyze with "avg read...	Stephen Frost, Jakub Wartak	patch
32/2386	Using multicolumn statistics for more precise join selectivity estimatation	Konstantin Knizhnik	patch
32/2410	WAL prefetch (another approach)	Thomas Munro	patch
32/2933	WIP: Track relation size in shared memory	Thomas Munro	patch
32/2862	WIP: macOS SIP workaround	Peter Eisentraut	patch
32/2316	WITH SYSTEM VERSIONING Temporal Tables	Surafel Temesgen	patch
32/2787	allow partial union-all and improve parallel subquery costing	Luc Vlaming	patch
32/2539	allow to set a pager for psql's watch command	Pavel Stehule	patch
32/2520	archive status ".ready" files may be created too early	Nathan Bossart	patch
32/3012	archive_command / pg_stat_archiver & documentation	Benoit Lobréau	patch
32/2870	autovacuum exit on postmaster death when sleeping	Stephen Frost	patch
32/2980	bitwise XOR aggregate functions	Alexey Bashtanov	patch
32/2838	brin: avoid errors processing work item following concurrent reindex	Álvaro Herrera, Justin Pryzby	patch
32/3004	contrib/cube - binary send/recv handlers		patch
32/2865	create table like: TABLE ACCESS METHOD	Justin Pryzby	patch
32/2813	custom compression methods for toast	dilip kumar, Ildus Kurbangaliev	patch
32/2915	document the hook system	David Fetter	patch
32/2993	documentation fix for SET ROLE	Nathan Bossart	patch
32/2684	enhancing plpgsql API for debugging and tracing	Pavel Stehule	patch
32/3013	fix skipping FSM for large tuples and low fillfactors	John Naylor, Floris van Nee	patch
32/2349	global temporary table	wenjing zeng	patch
32/2934	has_column_privilege() issue with attnums and non-existent columns	Ian Barwick	patch
32/2661	implement LogicalDecodeMessageCB for pgoutput	Dave Cramer	patch
32/2891	install path aware subclass of PostgresNode	Andrew Dunstan	patch
32/2938	invalid data in file backup_label problem on windows	Shenhao Wang	patch
32/2482	jsonpath syntax extensions	Nikita Glukhov	patch
32/2773	libpq compression	Konstantin Knizhnik	patch
32/2914	logical decoding of two-phase transactions	Stas Kelvich, Nikhil Sontakke, Ajin Cherian, Peter Smith	patch
32/2769	parallel distinct union and aggregate support patch	bucoo hsiao	patch
32/2081	parse-time support function for "any" datatype	Pavel Stehule	patch
32/2981	partial heap only tuples	Nathan Bossart	patch
32/2573	pg_dump - read data for some options from external file	Pavel Stehule	patch
32/2377	pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ...	Justin Pryzby	patch
32/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	patch
32/3003	pg_upgrade binary version checks	Daniel Gustafsson	patch
32/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Arthur Zakirov	patch
32/2861	pg_upgrade test for binary compatibility of core data types	Justin Pryzby	patch
32/2970	pg_upgrade: set default transactions to read-only at servers start	Denis Laxalde	patch
32/2557	pgbench - add a synchronization barrier when starting	Fabien Coelho	patch
32/3007	pgbench: Bug fix for the -d option	Kota Miyake	patch
32/3011	pgbench: Remove ecnt, a member variable of CState	Kota Miyake	patch
32/2839	possibility to rename root namespace in plpgsql	Pavel Stehule	patch
32/2650	postgres_fdw connection caching enable/disable or timeout feature	Bharath Rupireddy	patch
32/2950	postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)	Matthias vd Meent	patch
32/2812	protocol default result formats setting	Peter Eisentraut	patch
32/2536	psql - possibility to specify where status row should be displayed	Pavel Stehule	patch
32/2788	psql \df choose functions by their arguments	Greg Sabino Mullane	patch
32/3017	public schema default ACL	Noah Misch	patch
32/2964	remove deprecated v8.2 containment operators	Justin Pryzby	patch
32/2948	simplify some RI checks to reduce SPI overhead	Amit Langote	patch
32/2990	speed up pg_rewind by using copy_file_range() and skipping some fsync	Paul Guo	patch
32/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
32/2474	truncating timestamps on arbitrary intervals	John Naylor	patch
32/2910	wal_sessioninfo	Simon Riggs	patch
Waiting on Author
32/2714	ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Álvaro Herrera	patch
32/2857	ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently	Takayuki Tsunakawa	patch
32/2899	Add OID allocation retry log to GetNewOidWithIndex()	tomohiro hiramitsu	patch
32/2654	Add a feature that enables row-wise comparison partition pruning	sho kato	patch
32/2765	Add extra statistics to explain for Nested Loop	Ekaterina Sokolova	patch
32/2956	Add pg_dump --extension to dump specific extensions	Guillaume Lelarge	patch
32/2987	Allow setting parallel_workers on partitioned tables	Seamus Abshere	patch
32/2433	Erase the distinctClause if the result is unique by definition	Andy Fan	patch
32/2966	Foreign Key Arrays	Mark Rofail	patch
32/2774	Further note require activity aspect of automatic checkpoint and archiving	David Johnston	patch
32/2628	Implement for window functions	Vik Fearing	patch
32/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
32/2920	MERGE SQL command	Álvaro Herrera, Simon Riggs, Pavan Deolasee	patch
32/2937	NOT VALID for Unique Indexes	Simon Riggs	patch
32/2908	VACUUM (FAST_FREEZE )	Simon Riggs	patch
32/2890	doc review for v14	Justin Pryzby	patch
32/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	patch
32/2942	increase size of pg_commit_ts buffers	Álvaro Herrera	patch
32/2850	orphaned function	Bertrand Drouvot	patch
32/2827	pgbench stopped supporting large number of client connections on Windows	Marina Polyakova	patch
32/2989	progress reporting for partitioned REINDEX	Justin Pryzby	patch
32/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