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/amd64 check, FreeBSD/amd64 check-world, Linux/aarch64 check-world + docs, macOS/amd64 check. The plan is eventually to show them on the Commitfest app.

Current commitfest | Next commitfest

Ready for Committer
35/3213	Allow providing restore_command as a command line option to pg_rewind	Alexey Kondratov	patch
35/3327	Avoid eval R/O expression mutiple times (src/backend/executor/execExpr.c)	Ranier Vilela	patch
35/3113	Bug fix for tab completion of ALTER TABLE	David Fetter	patch
35/3107	Extending amcheck to check toast size and compression	Mark Dilger	patch
35/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	patch
35/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	patch
35/2957	Identify missing publications from publisher while create/alter subscription.	vignesh C	patch
35/2968	Minimal logical decoding on standbys (take 6)	Amit Khandekar	patch
35/2903	Parallel Hash Full Join	Melanie Plageman	patch
35/2948	Simplify some RI checks to reduce SPI overhead	Amit Langote	patch
35/2684	enhancing plpgsql API for debugging and tracing	Pavel Stehule	patch
35/3297	mitigate O(n^2) behavior of WAL archiver process	Nathan Bossart, Dipesh Pandit	patch
35/2573	pg_dump - read data for some options from external file	Pavel Stehule	patch
35/1608	schema variables, LET command	Pavel Stehule	patch
Needs review
35/2602	ALTER SYSTEM READ { ONLY \| WRITE }	Amul Sul	patch
35/3355	Accommodate startup process in a separate ProcState array slot instead of in Max...	Bharath Rupireddy	patch
35/3291	Add PGDLLIMPORT to all direct or indirect GUC variables	Julien Rouhaud	patch
35/3073	Add callback table access method to reset filenode when dropping relation	Mats Kindahl	patch
35/2765	Add extra statistics to explain for Nested Loop	Ekaterina Sokolova	patch
35/3065	Add option --drop-cascade for pg_dump/restore	Wu Haotian	patch
35/3353	Add planner support function for starts_with()	Tom Lane	patch
35/3164	Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	patch
35/3272	Add system view tracking shared buffer actions	Melanie Plageman	patch
35/3033	Add system views pg_permissions and pg_ownerships	Joel Jacobson	patch
35/3336	Added TRANSFORM FOR for COMMENT tab completion	Ken Kato	patch
35/2780	Allow COPY "text" to output a header and add header matching mode to COPY FROM	Rémi Lapeyre	patch
35/2992	Allow batched insert during cross-partition updates	Amit Langote	patch
35/3277	Allow escape sequence in application_name	Hayato Kuroda	patch
35/3290	Allow special values in GUC configurations	David Christensen	patch
35/3368	Assorted improvements in pg_dump	Tom Lane	patch
35/3099	Asymmetric partition-wise JOIN	KaiGai Kohei, Andrey Lepikhov	patch
35/3316	Asynchronous and "direct" IO support for PostgreSQL	Andres Freund, David Rowley, Thomas Munro	patch
35/3347	Atomic rename feature for Windows	Victor Spirin	patch
35/2694	Automatic HASH and LIST partition creation	Anastasia Lubennikova	patch
35/3232	Automatic notification of top transaction IDs	Gurjeet Singh	patch
35/3106	Avoid orphaned dependencies	Bertrand Drouvot	patch
35/3343	Bugfix of tab completion for PostgreSQL parameters of enum		patch
35/2800	CLUSTER on partitioned table	Justin Pryzby	patch
35/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby	patch
35/3270	Cache tuple routing info during bulk loads into partitioned tables	Amit Langote, Hou Zhijie	patch
35/2999	Catalog version access	Vik Fearing	patch
35/3131	Change internal PRNG (from rand48 to something better, with a cleaner interface)	Fabien Coelho	patch
35/3326	Check for STATUS_DELETE_PENDING on Windows	Thomas Munro	patch
35/3228	Cleaning up orphaned files using undo logs	Antonin Houska	patch
35/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	patch
35/3172	Consistent use of SSL/TLS in docs	Daniel Gustafsson	patch
35/3318	Correct handling of blank/commented lines in PSQL interactive-mode history	Greg Nancarrow	patch
35/2518	Corruption during WAL replay	Teja Mupparti	patch
35/3195	DELETE CASCADE	David Christensen	patch
35/3323	Deduplicate code updating ControleFile	Amul Sul	patch
35/3223	Delegating superuser tasks to new security roles	Mark Dilger	patch
35/3204	Deparsing a rewritten query	Julien Rouhaud	patch
35/3183	Detectable crashes and unlogged table resets	Jeff Davis	patch
35/3299	Do not start bgworker processes during binary upgrade	Denis Laxalde	patch
35/3329	Document atthasmissing default optimization avoids verification table scan	James Coleman	patch
35/3218	Don't block HOT update by BRIN index	Josef Šimánek	patch
35/2911	Dynamic result sets from procedures	Peter Eisentraut	patch
35/3328	Empty string in lexeme for tsvector	Jean-Christophe Arnu	patch
35/2433	Erase the distinctClause if the result is unique by definition	Andy Fan	patch
35/3098	Extend portability of client_connection_check_interval	Thomas Munro	patch
35/3180	Extended protocol COPY FROM STDIN fix	Jeff Davis	patch
35/3050	Extended statistics in EXPLAIN	Tomas Vondra	patch
35/3100	Extensible parsing	Julien Rouhaud	patch
35/3216	Extensible storage manager API - smgr hooks	Anastasia Lubennikova	patch
35/2962	Fix DROP TABLESPACE on Windows with ProcSignalBarrier?	Thomas Munro	patch
35/3224	Fix ExecRTCheckPerms() inefficiency with many prunable partitions	Amit Langote	patch
35/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	patch
35/3175	Fix documentation for COPY protocol flow	Jeff Davis	patch
35/2877	Fix firing of RI triggers during cross-partition updates of partitioned tables	Amit Langote	patch
35/3250	Fix handling of outer GroupingFunc within subqueries	Richard Guo	patch
35/3219	Fix pgbench's exit status and log messages for connection failures	Fabien Coelho, Yugo Nagata	patch
35/3264	Fix postgres_fdw's ORDER BY pushdown handling	Ronan Dunklau	patch
35/3236	Fix uninitialized variable access (freepages)	Ranier Vilela	patch
35/2947	Full support for index LP_DEAD hint bits on standby	Michail Nikolaev	patch
35/3192	Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	patch
35/2824	Functions for sorting GiST build of gist_btree types	Andrey Borodin	patch
35/1651	GROUP BY optimization	Fedor Sigaev, Pavel Borisov	patch
35/3274	Gather partial paths for subproblem's topmost scan/join rel	Richard Guo	patch
35/3333	Harden against premature discarding of WAL segments in TAP tests	Mark Dilger	patch
35/3361	Hidden/invisible columns	Gilles Darold	patch
35/2218	Implement INSERT SET syntax	Gareth Palmer	patch
35/3125	Improve documentation for pg_upgrade, standbys and rsync	Laurenz Albe	patch
35/3310	Improve logging when using Huge Pages	Noriyoshi Shinoda	patch
35/3076	Improve sepgsql logging so it follows the behaviour of selinux's logging.	Dave Page	patch
35/3351	Improve the HINT message of the ALTER command for postgres_fdw	Kosei masumura	patch
35/3357	Inconsistency in startup process's MyBackendId and procsignal array registration...		patch
35/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	patch
35/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
35/3265	Kerberos delegation support in libpq and postgres_fdw		patch
35/3071	Lazy JIT IR code generation to increase JIT speed with partitions	Luc Vlaming	patch
35/3142	Logging plan of the currently running query	atsushi torikoshi	patch
35/3040	Logical Replication - improve error message while adding tables to the publicati...	Bharath Rupireddy	patch
35/3366	Logical Replication failing if the DateStyle is different in Publisher & Subscri...	Japin Li	patch
35/3041	Logical replication failure "ERROR: could not map filenode "base/13237/442428" t...	Bertrand Drouvot, Minsoo Oh	patch
35/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	patch
35/3030	Make relfile tombstone files conditional on WAL level	Thomas Munro	patch
35/3181	Map WAL segment files on PMEM as WAL buffers	Takashi Menjo	patch
35/3052	Merging statistics from children instead of re-sampling everything	Tomas Vondra	patch
35/2869	Mitigate pg_rewind race condition, if config file is enlarged concurrently.	Heikki Linnakangas	patch
35/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	patch
35/3038	More sort-related specialisation	Thomas Munro	patch
35/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	patch
35/3292	Non-decimal integer literals	Peter Eisentraut	patch
35/2900	On client connection event trigger	Konstantin Knizhnik	patch
35/3304	Optimize parallel tuple queue	Dilip Kumar	patch
35/3222	PITR enhance getRecordTimestamp()	Simon Riggs	patch
35/3032	PROXY protocol support	Magnus Hagander	patch
35/3143	Parallel INSERT SELECT take 2	Greg Nancarrow, Hou Zhijie	patch
35/3349	Parallel vacuum workers prevent the oldest xmin from advancing	Masahiko Sawada	patch
35/3211	PoC: improving join estimates using sampling	Tomas Vondra	patch
35/3245	Postgres picks suboptimal index after building of an extended statistics	Andrey Lepikhov	patch
35/3362	Prefer getenv("HOME") to find the UNIX home directory	Anders Kaseorg	patch
35/3296	Preserving db/ts/relfilenode OIDs across pg_upgrade	Antonin Houska, Shruthi Gowda	patch
35/3289	Push down time-related SQLValue functions to foreign server	Alexander Pyhalov	patch
35/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
35/3139	Replicates changes for all tables in schema	vignesh C	patch
35/3344	Reserve prefixes for loaded libraries	Florin Irion	patch
35/3364	ResourceOwner refactoring	Heikki Linnakangas	patch
35/3356	Reword docs of GUCs restart_after_crash and remove_temp_files_after_crash	Bharath Rupireddy	patch
35/3120	Rewriting the test of pg_upgrade as a TAP test - take three	Michael Paquier	patch
35/2902	SQL/JSON: JSON_TABLE	Nikita Glukhov	patch
35/2901	SQL/JSON: functions	Nikita Glukhov	patch
35/2970	Set default transactions to read-only at servers start in pg_upgrade	Denis Laxalde	patch
35/3298	Showing I/O timings spent reading/writing temp buffers in EXPLAIN	Masahiko Sawada	patch
35/3205	Skipping logical replication transactions on subscriber side	Masahiko Sawada	patch
35/3308	Some RELKIND macro refactoring	Peter Eisentraut	patch
35/2996	Speed up verifying UTF-8	John Naylor	patch
35/3138	Support for NSS as a libpq TLS backend	Daniel Gustafsson, Jacob Champion	patch
35/3341	Support for Visual Studio 2022 when building PostgreSQL on Windows	Hans Buschmann	patch
35/3121	Support of time zone patterns - of, tzh and tzm	Nitin Jadhav	patch
35/3314	Support pg_ident mapping for LDAP	Jacob Champion	patch
35/3128	TAP test for contrib/sslinfo	Daniel Gustafsson	patch
35/3293	Tags in errordata	Ronan Dunklau	patch
35/3302	Trap SIGCHLD in pg_basebackup to exit early on stream child failure	Daniel Gustafsson	patch
35/3307	UNIQUE null treatment option	Peter Eisentraut	patch
35/3325	Undocumented AT TIME ZONE INTERVAL syntax	Corey Huinker	patch
35/3162	Update Toast data failure in logical replication	Dilip Kumar	patch
35/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	patch
35/3338	Upgrade pgcrypto to crypt_blowfish 1.3	Daniel Fone	patch
35/3163	Use tuple-level SIREAD locks for index-only scans	Thomas Munro	patch
35/3235	Using each rel as both outer and inner for anti-joins	Richard Guo	patch
35/3234	Window function run conditions	David Rowley	patch
35/3070	add explicit partial union-all and improve parallel subquery costing	Luc Vlaming	patch
35/3354	add subscription TAP test option "vcregress subscriptioncheck" for MSVC builds	Bharath Rupireddy	patch
35/3352	allow users with a predefined role to access pg_backend_memory_contexts view, pg...	Bharath Rupireddy	patch
35/3182	automatically generating node support functions	Peter Eisentraut	patch
35/3093	avoid logical replication empty transactions	Euler Taveira, Ajin Cherian	patch
35/2838	brin: avoid errors processing work item following concurrent reindex	Álvaro Herrera, Justin Pryzby	patch
35/3157	btree_gist: Support bool	Emre Hasegeli	patch
35/3360	dfmgr additional ABI version field	Peter Eisentraut	patch
35/3276	disallow external access to MaxBackends	Nathan Bossart	patch
35/3320	document need to analyze partitioned tables	Justin Pryzby	patch
35/3331	drop tablespace failed when location contains .. on win32		patch
35/3055	estimating joins using extended statistics	Tomas Vondra	patch
35/3330	extended statistics on partitioned tables	Tomas Vondra	patch
35/3367	fix psql pattern handling	Mark Dilger	patch
35/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	patch
35/3080	generate fractional cheapest paths in generate_orderedappend_paths	Tomas Vondra	patch
35/2349	global temporary table	wenjing zeng	patch
35/3267	improve tab-completion behavior when parse text in single quote	Haiying Tang	patch
35/2482	jsonpath syntax extensions	Nikita Glukhov	patch
35/3340	lax reloptions parsing for views	Mark Dilger	patch
35/3155	logical decoding and replication of sequences	Tomas Vondra	patch
35/2769	parallel distinct union and aggregate support patch	bucoo hsiao	patch
35/3244	parse_subscription_options - some suggested improvements	Peter Smith	patch
35/3288	pg_dump handling of ALTER DEFAULT PRIVILEGES IN SCHEMA	Masahiko Sawada, Nathan Bossart	patch
35/2377	pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ...	Justin Pryzby	patch
35/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	patch
35/3184	pg_stats and range statistics	Egor Rogov	patch
35/3227	pgbench: add multiconnect support	David Christensen	patch
35/3260	pgbench: using prepared BEGIN statement in a pipeline could cause an error	Yugo Nagata	patch
35/2839	possibility to rename root namespace in plpgsql	Pavel Stehule	patch
35/3158	pre-allocating WAL files	Nathan Bossart	patch
35/3363	preserve timestamps when installing headers	Alexander Kuzmenkov	patch
35/3337	provide tooling for improving archival rate	Nathan Bossart	patch
35/3140	psql - refactor echo code	Fabien Coelho	patch
35/3313	psql: \dl+ to list large objects privileges	Pavel Luzanov	patch
35/3295	psql: add xheader_width option to handle very long record lines	Platon Pronko	patch
35/3262	schema change not getting invalidated, both renamed table and new table data wer...	vignesh C	patch
35/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
35/3062	tablesync early exit	Peter Smith	patch
35/3242	test pgbench time-related features	Fabien Coelho	patch
35/3365	using an end-of-recovery record in all cases	Robert Haas, Amul Sul	patch
Waiting on Author
35/3146	A micro-optimisation for ProcSendSignal()	Thomas Munro	patch
35/3090	A test for replay of regression tests	Thomas Munro	patch
35/2958	Adaptive query optimization: create extented statistics using auto_explain exten...	Konstantin Knizhnik	patch
35/3312	Add JSON logging via jsonlog log_destination	David Fetter, Sehrope Sarkuni	patch
35/3054	Add missing function abs (interval)	Isaac Morland	patch
35/3027	Add regexp_positions(string text, pattern text, flags text) → setof record (star...	Joel Jacobson	patch
35/3046	Allow multiple recursive self-references	Denis Hirn	patch
35/3230	Column filtering in logical replication	Rahila Syed	patch
35/3058	Eliminating "Permission denied" errors on stat() (on Windows)	Alexander Lakhin	patch
35/2953	Extend docs on how to write correct postgres-dialect C including extensions and ...	Craig Ringer	patch
35/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	patch
35/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	patch
35/2774	Further note require activity aspect of automatic checkpoint and archiving	David Johnston	patch
35/2553	INSERT SELECT: BulkInsertState and table_multi_insert	Justin Pryzby	patch
35/3078	Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncati...	Matthias van de Meent	patch
35/3261	Log the activity of startup process	Nitin Jadhav	patch
35/2829	Make Append Cost aware of some run time partition prune case	Andy Fan	patch
35/2918	New default role allowing to change per-role/database settings	Michael Banck	patch
35/3348	PQcancel does not use tcp_user_timeout, connect_timeout and keepalive settings	Jelte Fennema	patch
35/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	patch
35/2932	Partial foreign key updates in referential integrity triggers	Paul Martinez	patch
35/2863	Printing backtrace of postgres processes	vignesh C	patch
35/3160	Range Merge Join	Thomas Mannhart	patch
35/3088	Reduce lock level for ALTER TABLE ... ADD CHECK	Simon Riggs	patch
35/3035	Removing unused trailing linepointers from heap pages	Matthias van de Meent	patch
35/2906	Row filtering for logical replication	Euler Taveira	patch
35/2048	SQL:2011 application time	Paul Jungwirth, Ibrar Ahmed	patch
35/3220	Speed up LockReleaseAll	David Rowley
35/3173	Split xlog.c	Heikki Linnakangas	patch
35/2979	Support tab completion for upper character inputs in psql	Haiying Tang	patch
35/3324	TAP test for recovery_end_command	Amul Sul	patch
35/3252	Tab completion for CREATE SCHEMA AUTHORIZATION	Dagfinn Ilmari Mannsåker	patch
35/3231	Teach pg_receivewal to use lz4 compression	Georgios Kokolatos	patch
35/3092	Use simplehash.h instead of dynahash in SMgr	David Rowley	patch
35/2316	WITH SYSTEM VERSIONING Temporal Tables	Surafel Temesgen	patch
35/3206	Write visibility map during CLUSTER/VACUUM FULL	Alexander Korotkov	patch
35/3059	fix ICU explorer link in locale documentation	Anton Voloshin	patch
35/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	patch
35/2942	increase size of pg_commit_ts buffers	Álvaro Herrera	patch
35/2773	libpq compression	Konstantin Knizhnik, Daniil Zakhlystov	patch
35/2981	partial heap only tuples	Nathan Bossart	patch
35/3051	pg_dump new feature: exporting functions only	Lætitia AVROT	patch
35/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	patch
35/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Artur Zakirov	patch
35/2861	pg_upgrade test for binary compatibility of core data types	Justin Pryzby	patch
35/3025	postgres_fdw: suppress explicit casts in text:text comparisons	Dian Fay	patch
35/3258	proposal of adding 2 new diag items related to parsing the dynamic sql statement	Dinesh Chemuduru	patch
35/2096	psql - add SHOW_ALL_RESULTS option	Fabien Coelho	patch
35/3045	rename column if exists	David Oksman	patch

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

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author