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
36/3073	Add callback table access method to reset filenode when dropping relation	Mats Kindahl	patch
36/2780	Allow COPY "text" to output a header and add header matching mode to COPY FROM	Rémi Lapeyre	patch
36/2992	Allow batched insert during cross-partition updates	Amit Langote	patch
36/3213	Allow providing restore_command as a command line option to pg_rewind	Alexey Kondratov	patch
36/3368	Assorted improvements in pg_dump	Tom Lane	patch
36/3113	Bug fix for tab completion of ALTER TABLE	David Fetter	patch
36/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	patch
36/3426	Correct error message for end-of-recovery record TLI	Amul Sul	patch
36/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	patch
36/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	patch
36/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	patch
36/2947	Full support for index LP_DEAD hint bits on standby	Michail Nikolaev	patch
36/2957	Identify missing publications from publisher while create/alter subscription.	vignesh C	patch
36/2869	Mitigate pg_rewind race condition, if config file is enlarged concurrently.	Heikki Linnakangas	patch
36/2900	On client connection event trigger	Konstantin Knizhnik	patch
36/2863	Printing backtrace of postgres processes	vignesh C	patch
36/3424	Remove redundant initialization of brin memtuple	Richard Guo	patch
36/3364	ResourceOwner refactoring	Heikki Linnakangas	patch
36/3302	Trap SIGCHLD in pg_basebackup to exit early on stream child failure	Daniel Gustafsson	patch
36/3276	disallow external access to MaxBackends	Nathan Bossart	patch
36/3385	enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary pro...	Bharath Rupireddy	patch
36/2684	enhancing plpgsql API for debugging and tracing	Pavel Stehule	patch
36/3244	parse_subscription_options - some suggested improvements	Peter Smith	patch
36/2573	pg_dump - read data for some options from external file	Pavel Stehule	patch
36/3051	pg_dump new feature: exporting functions only	Lætitia AVROT	patch
36/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	patch
36/3363	preserve timestamps when installing headers	Alexander Kuzmenkov	patch
36/3313	psql: \dl+ to list large objects privileges	Pavel Luzanov	patch
36/3384	use has_privs_for_role for predefined roles	Joshua Brindle	patch
Needs review
36/2602	ALTER SYSTEM READ { ONLY \| WRITE }	Amul Sul	patch
36/3355	Accommodate startup process in a separate ProcState array slot instead of in Max...	Bharath Rupireddy	patch
36/3398	Add CI	Andres Freund	patch
36/3312	Add JSON logging via jsonlog log_destination	Michael Paquier, Sehrope Sarkuni	patch
36/3291	Add PGDLLIMPORT to all direct or indirect GUC variables	Julien Rouhaud	patch
36/3405	Add connection active, idle time to pg_stat_activity	Rafia Sabih	patch
36/2765	Add extra statistics to explain for Nested Loop	Ekaterina Sokolova	patch
36/3388	Add foreign-server health checks infrastructure	Hayato Kuroda	patch
36/3439	Add id's to various elements in protocol.sgml	Brar Piening	patch
36/3164	Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	patch
36/3272	Add system view tracking shared buffer actions	Melanie Plageman	patch
36/3033	Add system views pg_permissions and pg_ownerships	Joel Jacobson	patch
36/3277	Allow escape sequence in application_name	Hayato Kuroda	patch
36/3046	Allow multiple recursive self-references	Denis Hirn	patch
36/3379	Allow root ownership of client certificate key	David Steele	patch
36/3290	Allow special values in GUC configurations	David Christensen	patch
36/3374	Allows database-specific role memberships	Kenaniah Cerny	patch
36/3099	Asymmetric partition-wise JOIN	KaiGai Kohei, Andrey Lepikhov	patch
36/3316	Asynchronous and "direct" IO support for PostgreSQL	Andres Freund, David Rowley, Thomas Munro	patch
36/3347	Atomic rename feature for Windows	Victor Spirin	patch
36/3409	BUFFERS enabled by default in EXPLAIN	Justin Pryzby, Nikolay Samokhvalov	patch
36/3417	BUG #17268: Possible corruption in toast index after reindex index concurrently	Michael Paquier	patch
36/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby	patch
36/3370	CREATE ROLE IF NOT EXISTS	David Christensen	patch
36/3270	Cache tuple routing info during bulk loads into partitioned tables	Amit Langote, Hou Zhijie	patch
36/2999	Catalog version access	Vik Fearing, Nathan Bossart	patch
36/3326	Check for STATUS_DELETE_PENDING on Windows	Thomas Munro	patch
36/3228	Cleaning up orphaned files using undo logs	Antonin Houska	patch
36/3230	Column filtering in logical replication	Rahila Syed	patch
36/3172	Consistent use of SSL/TLS in docs	Daniel Gustafsson	patch
36/2518	Corruption during WAL replay	Teja Mupparti	patch
36/3195	DELETE CASCADE	David Christensen	patch
36/3204	Deparsing a rewritten query	Julien Rouhaud	patch
36/3183	Detectable crashes and unlogged table resets	Jeff Davis	patch
36/3299	Do not start bgworker processes during binary upgrade	Denis Laxalde	patch
36/3329	Document atthasmissing default optimization avoids verification table scan	James Coleman	patch
36/3438	Dubious usage of TYPCATEGORY_STRING	Tom Lane	patch
36/2911	Dynamic result sets from procedures	Peter Eisentraut	patch
36/3410	Emit a warning if the extension's GUC is set incorrectly	Shinya Kato	patch
36/2433	Erase the distinctClause if the result is unique by definition	Andy Fan	patch
36/3440	ExecTypeSetColNames is fundamentally broken	Tom Lane	patch
36/3098	Extend portability of client_connection_check_interval	Thomas Munro	patch
36/3050	Extended statistics in EXPLAIN	Tomas Vondra	patch
36/3100	Extensible parsing	Julien Rouhaud	patch
36/3216	Extensible storage manager API - smgr hooks	Anastasia Lubennikova	patch
36/3420	FUNCAPI tuplestore helper function	Melanie Plageman	patch
36/2962	Fix DROP TABLESPACE on Windows with ProcSignalBarrier?	Thomas Munro	patch
36/3224	Fix ExecRTCheckPerms() inefficiency with many prunable partitions	Amit Langote	patch
36/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	patch
36/2877	Fix firing of RI triggers during cross-partition updates of partitioned tables	Amit Langote	patch
36/3250	Fix handling of outer GroupingFunc within subqueries	Richard Guo	patch
36/3264	Fix postgres_fdw's ORDER BY pushdown handling	Ronan Dunklau	patch
36/3236	Fix uninitialized variable access (freepages)	Ranier Vilela	patch
36/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
36/3192	Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	patch
36/1651	GROUP BY optimization	Fedor Sigaev, Pavel Borisov	patch
36/3274	Gather partial paths for subproblem's topmost scan/join rel	Richard Guo	patch
36/3413	Granting SET and ALTER SYSTE privileges for GUCs	Mark Dilger	patch
36/2218	Implement INSERT SET syntax	Gareth Palmer	patch
36/3411	Improve PID XXXX is not a PostgreSQL server process message	Bharath Rupireddy	patch
36/3125	Improve documentation for pg_upgrade, standbys and rsync	Laurenz Albe	patch
36/3310	Improve logging when using Huge Pages	Noriyoshi Shinoda	patch
36/3076	Improve sepgsql logging so it follows the behaviour of selinux's logging.	Dave Page	patch
36/3357	Inconsistency in startup process's MyBackendId and procsignal array registration...	Bharath Rupireddy	patch
36/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	patch
36/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
36/3271	KnownAssignedXidsGetAndSetXmin performance	Michail Nikolaev	patch
36/3071	Lazy JIT IR code generation to increase JIT speed with partitions	Luc Vlaming	patch
36/3142	Logging plan of the currently running query	atsushi torikoshi	patch
36/3394	Logical insert/update/delete WAL records for custom table AMs	Jeff Davis	patch
36/3041	Logical replication failure "ERROR: could not map filenode "base/13237/442428" t...	Bertrand Drouvot, Minsoo Oh	patch
36/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	patch
36/3181	Map WAL segment files on PMEM as WAL buffers	Takashi Menjo	patch
36/3052	Merging statistics from children instead of re-sampling everything	Tomas Vondra	patch
36/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	patch
36/3038	More sort-related specialisation	Thomas Munro	patch
36/3383	Multi-column list partitioning	Nitin Jadhav	patch
36/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	patch
36/2918	New default role allowing to change per-role/database settings	Michael Banck	patch
36/3414	Non-superuser subscription owners		patch
36/3407	Optionally automatically disable subscription on error	Mark Dilger	patch
36/3222	PITR enhance getRecordTimestamp()	Simon Riggs	patch
36/3032	PROXY protocol support	Magnus Hagander	patch
36/3143	Parallel INSERT SELECT take 2	Greg Nancarrow, Hou Zhijie	patch
36/3400	Parameter for planner estimates of recursive queries	Simon Riggs	patch
36/3369	Partial aggregates push down	Alexander Pyhalov	patch
36/3245	Postgres picks suboptimal index after building of an extended statistics	Andrey Lepikhov	patch
36/3362	Prefer getenv("HOME") to find the UNIX home directory	Anders Kaseorg	patch
36/3296	Preserving db/ts/relfilenode OIDs across pg_upgrade	Antonin Houska, Shruthi Gowda	patch
36/3289	Push down time-related SQLValue functions to foreign server	Alexander Pyhalov	patch
36/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
36/3433	Removing more vacuumlazy.c special cases, relfrozenxid optimizations	Peter Geoghegan	patch
36/3356	Reword docs of GUCs restart_after_crash and remove_temp_files_after_crash	Bharath Rupireddy	patch
36/3423	SKIP LOCKED Assert() triggered	Simon Riggs, Álvaro Herrera	patch
36/2902	SQL/JSON: JSON_TABLE	Nikita Glukhov	patch
36/2901	SQL/JSON: functions	Nikita Glukhov	patch
36/2048	SQL:2011 application time	Paul Jungwirth, Ibrar Ahmed	patch
36/3298	Showing I/O timings spent reading/writing temp buffers in EXPLAIN	Masahiko Sawada	patch
36/2948	Simplify some RI checks to reduce SPI overhead	Amit Langote	patch
36/3205	Skipping logical replication transactions on subscriber side	Masahiko Sawada	patch
36/2996	Speed up verifying UTF-8	John Naylor	patch
36/3138	Support for NSS as a libpq TLS backend	Daniel Gustafsson, Jacob Champion	patch
36/3121	Support of time zone patterns - of, tzh and tzm	Nitin Jadhav	patch
36/3314	Support pg_ident mapping for LDAP	Jacob Champion	patch
36/2979	Support tab completion for upper character inputs in psql	Haiying Tang	patch
36/3427	TAP test to cover "EndOfLogTLI != replayTLI" case	Amul Sul	patch
36/3293	Tags in errordata	Ronan Dunklau	patch
36/3307	UNIQUE null treatment option	Peter Eisentraut	patch
36/3431	Unifying VACUUM VERBOSE and log_autovacuum_min_duration output	Peter Geoghegan	patch
36/3162	Update Toast data failure in logical replication	Dilip Kumar	patch
36/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	patch
36/3338	Upgrade pgcrypto to crypt_blowfish 1.3	Daniel Fone	patch
36/3396	Use -fvisibility=hidden for shared libraries	Andres Freund	patch
36/3381	Use generation context to speed up tuplesorts	David Rowley	patch
36/3235	Using each rel as both outer and inner for anti-joins	Richard Guo	patch
36/3234	Window function run conditions	David Rowley	patch
36/3206	Write visibility map during CLUSTER/VACUUM FULL	Alexander Korotkov, Justin Pryzby, Anna Akenteva, Anna Akenteva	patch
36/3354	add subscription TAP test option "vcregress subscriptioncheck" for MSVC builds	Bharath Rupireddy	patch
36/3337	archive modules	Nathan Bossart	patch
36/3182	automatically generating node support functions	Peter Eisentraut	patch
36/3093	avoid logical replication empty transactions	Euler Taveira, Ajin Cherian	patch
36/3395	building postgres with meson	Andres Freund	patch
36/3401	default to log_checkpoints=on,log_autovacuum_min_duration=10min	Bharath Rupireddy	patch
36/3434	disallow HEAP_XMAX_COMMITTED and HEAP_XMAX_IS_LOCKED_ONLY	Nathan Bossart	patch
36/3320	document need to analyze partitioned tables	Justin Pryzby	patch
36/3055	estimating joins using extended statistics	Tomas Vondra	patch
36/3330	extended statistics on partitioned tables	Tomas Vondra	patch
36/3367	fix psql pattern handling	Mark Dilger	patch
36/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	patch
36/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	patch
36/3080	generate fractional cheapest paths in generate_orderedappend_paths	Tomas Vondra	patch
36/2349	global temporary table	wenjing zeng	patch
36/3430	improve CREATE EXTENSION error message	Nathan Bossart	patch
36/2482	jsonpath syntax extensions	Nikita Glukhov	patch
36/3340	lax reloptions parsing for views	Mark Dilger	patch
36/3155	logical decoding and replication of sequences	Tomas Vondra	patch
36/2377	pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ...	Justin Pryzby	patch
36/3425	pg_replslotdata - a tool for displaying replication slot information	Bharath Rupireddy	patch
36/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	patch
36/3184	pg_stats and range statistics	Egor Rogov	patch
36/3419	pg_walinspect - a new extension to get raw WAL data and WAL stats	Bharath Rupireddy	patch
36/3227	pgbench: add multiconnect support	David Christensen	patch
36/3260	pgbench: using prepared BEGIN statement in a pipeline could cause an error	Yugo Nagata	patch
36/2839	possibility to rename root namespace in plpgsql	Pavel Stehule	patch
36/3158	pre-allocating WAL files	Nathan Bossart	patch
36/3140	psql - refactor echo code	Fabien Coelho	patch
36/3295	psql: add xheader_width option to handle very long record lines	Platon Pronko	patch
36/3436	remove exclusive backup mode	David Steele, Nathan Bossart	patch
36/3262	schema change not getting invalidated, both renamed table and new table data wer...	vignesh C	patch
36/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
36/3408	support for MERGE	Álvaro Herrera, Simon Riggs, Amit Langote, Pavan Deolasee	patch
36/3062	tablesync early exit	Peter Smith	patch
36/3365	using an end-of-recovery record in all cases	Robert Haas, Amul Sul	patch
Waiting on Author
36/3146	A micro-optimisation for ProcSendSignal()	Thomas Munro	patch
36/3090	A test for replay of regression tests	Thomas Munro	patch
36/3106	Avoid orphaned dependencies	Bertrand Drouvot	patch
36/2800	CLUSTER on partitioned table	Justin Pryzby	patch
36/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	patch
36/2824	Functions for sorting GiST build of gist_btree types	Andrey Borodin	patch
36/3078	Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncati...	Matthias van de Meent	patch
36/2968	Minimal logical decoding on standbys (take 6)	Amit Khandekar	patch
36/3292	Non-decimal integer literals	Peter Eisentraut	patch
36/3348	PQcancel does not use tcp_user_timeout, connect_timeout and keepalive settings	Jelte Fennema	patch
36/2903	Parallel Hash Full Join	Melanie Plageman	patch
36/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	patch
36/2932	Partial foreign key updates in referential integrity triggers	Paul Martinez	patch
36/3211	PoC: improving join estimates using sampling	Tomas Vondra	patch
36/3397	Prefetching in recovery, take II	Thomas Munro	patch
36/3160	Range Merge Join	Thomas Mannhart	patch
36/2906	Row filtering for logical replication	Euler Taveira	patch
36/3376	Start WAL receiver eagerly	Konstantin Knizhnik, Asim Rama Praveen, Ashwin Agrawal, Soumyadeep Chakraborty	patch
36/3393	Synchronize logical replication slots from primary to standby	Peter Eisentraut	patch
36/3325	Undocumented AT TIME ZONE INTERVAL syntax	Corey Huinker	patch
36/3389	add checkpoint stats of snapshot and mapping files of pg_logical dir	Bharath Rupireddy	patch
36/3437	document an example to set multiple libraries in shared_preload_libraries	Bharath Rupireddy	patch
36/3331	drop tablespace failed when location contains .. on win32	Shenhao Wang	patch
36/3392	postgres_fdw: commit remote (sub)transactions in parallel during pre-commit	Etsuro Fujita	patch
36/2096	psql - add SHOW_ALL_RESULTS option	Fabien Coelho	patch
36/3045	rename column if exists	David Oksman	patch
36/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