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
34/3213	Allow providing restore_command as a command line option to pg_rewind	Alexey Kondratov	patch
34/3107	Extending amcheck to check toast size and compression	Mark Dilger	patch
34/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	patch
34/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	patch
34/2957	Identify missing publications from publisher while create/alter subscription.	vignesh C	patch
34/2968	Minimal logical decoding on standbys (take 6)	Amit Khandekar	patch
34/2903	Parallel Hash Full Join	Melanie Plageman	patch
34/3029	Rework the sslfiles Makefile target	Jacob Champion	patch
34/2948	Simplify some RI checks to reduce SPI overhead	Amit Langote	patch
34/3092	Use simplehash.h instead of dynahash in SMgr	David Rowley	patch
34/2684	enhancing plpgsql API for debugging and tracing	Pavel Stehule	patch
34/1608	schema variables, LET command	Pavel Stehule	patch
Needs review
34/2234	A hook for path-removal decision on add_path	KaiGai Kohei	patch
34/2602	ALTER SYSTEM READ { ONLY \| WRITE }	Amul Sul	patch
34/3291	Add PGDLLIMPORT to all direct or indirect GUC variables	Julien Rouhaud	patch
34/3073	Add callback table access method to reset filenode when dropping relation	Mats Kindahl	patch
34/2765	Add extra statistics to explain for Nested Loop	Ekaterina Sokolova	patch
34/3054	Add missing function abs (interval)	Isaac Morland	patch
34/3065	Add option --drop-cascade for pg_dump/restore	Wu Haotian	patch
34/3164	Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	patch
34/3027	Add regexp_positions(string text, pattern text, flags text) → setof record (star...	Joel Jacobson	patch
34/3272	Add system view tracking shared buffer actions	Melanie Plageman	patch
34/3033	Add system views pg_permissions and pg_ownerships	Joel Jacobson	patch
34/2780	Allow COPY "text" to output a header and add header matching mode to COPY FROM	Rémi Lapeyre	patch
34/2992	Allow batched insert during cross-partition updates	Amit Langote	patch
34/3148	Allow queries in WHEN expression of FOR EACH STATEMENT triggers	Joe Wildish	patch
34/3290	Allow special values in GUC configurations	David Christensen	patch
34/3099	Asymmetric partition-wise JOIN	KaiGai Kohei, Andrey Lepikhov	patch
34/3316	Asynchronous and "direct" IO support for PostgreSQL	Andres Freund, David Rowley, Thomas Munro	patch
34/2694	Automatic HASH and LIST partition creation	Anastasia Lubennikova	patch
34/3232	Automatic notification of top transaction IDs	Gurjeet Singh	patch
34/3106	Avoid orphaned dependencies	Bertrand Drouvot	patch
34/3113	Bug fix for tab completion of ALTER TABLE	David Fetter	patch
34/2800	CLUSTER on partitioned table	Justin Pryzby	patch
34/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby	patch
34/3270	Cache tuple routing info during bulk loads into partitioned tables	Amit Langote, hou zhijie	patch
34/2999	Catalog version access	Vik Fearing	patch
34/3228	Cleaning up orphaned files using undo logs	Antonin Houska	patch
34/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	patch
34/3172	Consistent use of SSL/TLS in docs	Daniel Gustafsson	patch
34/2518	Corruption during WAL replay	Teja Mupparti	patch
34/3195	DELETE CASCADE	David Christensen	patch
34/3223	Delegating superuser tasks to new security roles	Mark Dilger	patch
34/3204	Deparsing a rewritten query	Julien Rouhaud	patch
34/3183	Detectable crashes and unlogged table resets	Jeff Davis	patch
34/3124	Diagnostic comment in LogicalIncreaseXminForSlot	Ashutosh Bapat	patch
34/3299	Do not start bgworker processes during binary upgrade	Denis Laxalde	patch
34/3218	Don't block HOT update by BRIN index	Josef Šimánek	patch
34/2911	Dynamic result sets from procedures	Peter Eisentraut	patch
34/2433	Erase the distinctClause if the result is unique by definition	Andy Fan	patch
34/3286	Error out if SKIP LOCKED and WITH TIES are both specified	David Christensen	patch
34/3098	Extend portability of client_connection_check_interval	Thomas Munro	patch
34/3180	Extended protocol COPY FROM STDIN fix	Jeff Davis	patch
34/3050	Extended statistics in EXPLAIN	Tomas Vondra	patch
34/3100	Extensible parsing	Julien Rouhaud	patch
34/3216	Extensible storage manager API - smgr hooks	Anastasia Lubennikova	patch
34/2176	FETCH FIRST clause PERCENT option	Surafel Temesgen	patch
34/3301	Fix ATTACH/DETACH PARTITION to invalidate partitions of table being attached/det...	Álvaro Herrera, Amit Langote	patch
34/2962	Fix DROP TABLESPACE on Windows with ProcSignalBarrier?	Thomas Munro	patch
34/3224	Fix ExecRTCheckPerms() inefficiency with many prunable partitions	Amit Langote	patch
34/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	patch
34/2685	Fix collation handling in postgres_fdw	Tom Lane	patch
34/3175	Fix documentation for COPY protocol flow	Jeff Davis	patch
34/3250	Fix handling of outer GroupingFunc within subqueries	Richard Guo	patch
34/3214	Fix numeric power for negative bases and other corner cases	Dean Rasheed	patch
34/3219	Fix pgbench's exit status and log messages for connection failures	Fabien Coelho, Yugo Nagata	patch
34/3264	Fix postgres_fdw's ORDER BY pushdown handling	Ronan Dunklau	patch
34/3236	Fix uninitialized variable access (freepages)	Ranier Vilela	patch
34/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
34/2947	Full support for index LP_DEAD hint bits on standby	Michail Nikolaev	patch
34/3192	Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	patch
34/2824	Functions for sorting GiST build of gist_btree types	Andrey Borodin	patch
34/1651	GROUP BY optimization	Fedor Sigaev, Pavel Borisov	patch
34/2402	GUC to disable cancellation of awaiting for synchronous replication	Andrey Borodin	patch
34/3274	Gather partial paths for subproblem's topmost scan/join rel	Richard Guo	patch
34/3018	Hooks and API to allow loadable wire protocol extensions	Jan Wieck
34/2218	Implement INSERT SET syntax	Gareth Palmer	patch
34/3125	Improve documentation for pg_upgrade, standbys and rsync	Laurenz Albe	patch
34/3076	Improve sepgsql logging so it follows the behaviour of selinux's logging.	Dave Page	patch
34/3145	Incorrect snapshots while promoting hot standby node when 2PC is used	Michael Paquier	patch
34/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai
34/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
34/2952	Introduce ProcessInterrupts_hook for C extensions	Craig Ringer	patch
34/3265	Kerberos delegation support in libpq and postgres_fdw		patch
34/3271	KnownAssignedXidsGetAndSetXmin performance	Michail Nikolaev	patch
34/3071	Lazy JIT IR code generation to increase JIT speed with partitions	Luc Vlaming	patch
34/3142	Logging plan of the currently running query	atsushi torikoshi	patch
34/3040	Logical Replication - improve error message while adding tables to the publicati...	Bharath Rupireddy	patch
34/3041	Logical replication failure "ERROR: could not map filenode "base/13237/442428" t...	Bertrand Drouvot, Minsoo Oh	patch
34/772	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	patch
34/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	patch
34/3030	Make relfile tombstone files conditional on WAL level	Thomas Munro	patch
34/3181	Map WAL segment files on PMEM as WAL buffers	Takashi Menjo	patch
34/3052	Merging statistics from children instead of re-sampling everything	Tomas Vondra	patch
34/2869	Mitigate pg_rewind race condition, if config file is enlarged concurrently.	Heikki Linnakangas	patch
34/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	patch
34/3038	More sort-related specialisation	Thomas Munro	patch
34/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	patch
34/3292	Non-decimal integer literals	Peter Eisentraut	patch
34/3304	Optimize parallel tuple queue	Dilip Kumar	patch
34/2699	Optimizing NULL check on pkey column	Surafel Temesgen	patch
34/3222	PITR enhance getRecordTimestamp()	Simon Riggs	patch
34/3032	PROXY protocol support	Magnus Hagander	patch
34/3143	Parallel INSERT SELECT take 2	Greg Nancarrow, hou zhijie	patch
34/2907	PoC Refactor AM analyse API	Denis Smirnov
34/3211	PoC: improving join estimates using sampling	Tomas Vondra	patch
34/3245	Postgres picks suboptimal index after building of an extended statistics	Andrey Lepikhov	patch
34/3296	Preserving db/ts/relfilenode OIDs across pg_upgrade	Antonin Houska, Shruthi Gowda	patch
34/2863	Printing backtrace of postgres processes	vignesh C	patch
34/931	Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	patch
34/3289	Push down time-related SQLValue functions to foreign server	Alexander Pyhalov	patch
34/3160	Range Merge Join	Thomas Mannhart	patch
34/2935	Reduce the time required for a database recovery from archive.	Anna Akenteva, Dmitry Shulga, Ivan Taranov	patch
34/2113	Remove page-read callback from XLogReaderState	Kyotaro Horiguchi	patch
34/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
34/2781	Replace polyphase merge with a simple k-way balanced merge	Heikki Linnakangas	patch
34/3120	Rewriting the test of pg_upgrade as a TAP test - take three	Michael Paquier	patch
34/2902	SQL/JSON: JSON_TABLE	Nikita Glukhov	patch
34/2901	SQL/JSON: functions	Nikita Glukhov	patch
34/2048	SQL:2011 application time	Paul Jungwirth, Ibrar Ahmed	patch
34/2970	Set default transactions to read-only at servers start in pg_upgrade	Denis Laxalde	patch
34/3298	Showing I/O timings spent reading/writing temp buffers in EXPLAIN	Masahiko Sawada	patch
34/3205	Skipping logical replication transactions on subscriber side	Masahiko Sawada	patch
34/3308	Some RELKIND macro refactoring	Peter Eisentraut	patch
34/3220	Speed up LockReleaseAll	David Rowley
34/2996	Speed up verifying UTF-8	John Naylor	patch
34/3173	Split xlog.c	Heikki Linnakangas	patch
34/3138	Support for NSS as a libpq TLS backend	Daniel Gustafsson, Jacob Champion	patch
34/3121	Support of time zone patterns - of, tzh and tzm	Nitin Jadhav	patch
34/3314	Support pg_ident mapping for LDAP	Jacob Champion	patch
34/3128	TAP test for contrib/sslinfo	Daniel Gustafsson	patch
34/3293	Tags in errordata	Ronan Dunklau	patch
34/3231	Teach pg_receivewal to use lz4 compression	Georgios Kokolatos	patch
34/3102	Toast compression method options	Dilip Kumar	patch
34/1574	Transactions involving multiple postgres foreign servers	Masahiko Sawada, Ashutosh Bapat	patch
34/3302	Trap SIGCHLD in pg_basebackup to exit early on stream child failure	Daniel Gustafsson	patch
34/3307	UNIQUE null treatment option	Peter Eisentraut	patch
34/3162	Update Toast data failure in logical replication	Dilip Kumar	patch
34/3163	Use tuple-level SIREAD locks for index-only scans	Thomas Munro	patch
34/3235	Using each rel as both outer and inner for anti-joins	Richard Guo	patch
34/3191	Using indexUnchanged with nbtree	Simon Riggs	patch
34/2386	Using multicolumn statistics for more precise join selectivity estimatation	Konstantin Knizhnik	patch
34/3239	Warn if initdb's --sync-only option is mixed with other options	Gurjeet Singh	patch
34/3234	Window function run conditions	David Rowley	patch
34/3256	\dn++ and \dA++ to show sizes of schemas and AMs (and \db++, \l++)	Justin Pryzby	patch
34/3070	add explicit partial union-all and improve parallel subquery costing	Luc Vlaming	patch
34/3161	add pg_ctl option that returns amount of shmem required	Nathan Bossart	patch
34/3093	avoid logical replication empty transactions	Euler Taveira, Ajin Cherian	patch
34/2838	brin: avoid errors processing work item following concurrent reindex	Álvaro Herrera, Justin Pryzby	patch
34/3157	btree_gist: Support bool	Emre Hasegeli	patch
34/3276	disallow external access to MaxBackends	Nathan Bossart	patch
34/3055	estimating joins using extended statistics	Tomas Vondra	patch
34/3080	generate fractional cheapest paths in generate_orderedappend_paths	Tomas Vondra	patch
34/2349	global temporary table	wenjing zeng	patch
34/3285	glossary definitions for auxiliary processes	Álvaro Herrera, Justin Pryzby	patch
34/3267	improve tab-completion behavior when parse text in single quote	Haiying Tang	patch
34/3208	improvements in Unicode tables generation code	Peter Eisentraut	patch
34/2482	jsonpath syntax extensions	Nikita Glukhov	patch
34/3297	mitigate O(n^2) behavior of WAL archiver process	Dipesh Pandit	patch
34/2769	parallel distinct union and aggregate support patch	bucoo hsiao	patch
34/3244	parse_subscription_options - some suggested improvements	Peter Smith	patch
34/2573	pg_dump - read data for some options from external file	Pavel Stehule	patch
34/3288	pg_dump handling of ALTER DEFAULT PRIVILEGES IN SCHEMA	Nathan Bossart	patch
34/2377	pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ...	Justin Pryzby	patch
34/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	patch
34/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	patch
34/3184	pg_stats and range statistics	Egor Rogov	patch
34/3227	pgbench: add multiconnect support	David Christensen	patch
34/3260	pgbench: using prepared BEGIN statement in a pipeline could cause an error	Yugo Nagata	patch
34/2839	possibility to rename root namespace in plpgsql	Pavel Stehule	patch
34/3025	postgres_fdw: suppress explicit casts in text:text comparisons	Dian Fay	patch
34/3158	pre-allocating WAL files	Nathan Bossart	patch
34/2096	psql - add SHOW_ALL_RESULTS option	Fabien Coelho	patch
34/3313	psql: \dl+ to list large objects privileges	Pavel Luzanov	patch
34/3295	psql: add xheader_width option to handle very long record lines	Platon Pronko	patch
34/3262	schema change not getting invalidated, both renamed table and new table data wer...	vignesh C	patch
34/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
34/3062	tablesync early exit	Peter Smith	patch
34/3242	test pgbench time-related features	Fabien Coelho	patch
34/3178	unnesting multirange data types	Alexander Korotkov	patch
Waiting on Author
34/3146	A micro-optimisation for ProcSendSignal()	Thomas Munro	patch
34/3090	A test for replay of regression tests	Thomas Munro	patch
34/2958	Adaptive query optimization: create extented statistics using auto_explain exten...	Konstantin Knizhnik	patch
34/3312	Add JSON logging via jsonlog log_destination	David Fetter, Sehrope Sarkuni	patch
34/3036	Add some tests for pg_stat_statements compatibility verification	Erica Zhang	patch
34/3243	Add statistics refresh materialized view	Yuki Seino	patch
34/3095	Addition of authenticated ID to pg_stat_activity	Michael Paquier	patch
34/3277	Allow escape sequence in application_name	Hayato Kuroda	patch
34/3046	Allow multiple recursive self-references	Denis Hirn	patch
34/3188	Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands	Yuzuko Hosoya	patch
34/2983	Autovacuum dynamic cost_limit, cost_delay	Scott Mead	patch
34/3043	Built-in connection pooler	Konstantin Knizhnik	patch
34/3131	Change internal PRNG (from rand48 to something better, with a cleaner interface)	Fabien Coelho	patch
34/3230	Column filtering in logical replication	Rahila Syed	patch
34/3251	Document pg_encoding_to_char() and pg_char_to_encoding()	Ian Barwick	patch
34/3058	Eliminating "Permission denied" errors on stat() (on Windows)	Alexander Lakhin	patch
34/2951	Extend comments on signal handling and cross-reference comments on signal handli...	Craig Ringer	patch
34/2953	Extend docs on how to write correct postgres-dialect C including extensions and ...	Craig Ringer	patch
34/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	patch
34/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	patch
34/2877	Fix firing of RI triggers during cross-partition updates of partitioned tables	Amit Langote	patch
34/2774	Further note require activity aspect of automatic checkpoint and archiving	David Johnston	patch
34/2553	INSERT SELECT: BulkInsertState and table_multi_insert	Justin Pryzby	patch
34/2959	Improve join selectivity estimation using extended statistics	Konstantin Knizhnik	patch
34/3310	Improve logging when using Huge Pages	Noriyoshi Shinoda	patch
34/2960	Infrastructure changes to make the code less sensitive to transaction id bit wid...	James Finnerty	patch
34/3078	Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncati...	Matthias van de Meent	patch
34/3261	Log the activity of startup process	Nitin Jadhav	patch
34/2829	Make Append Cost aware of some run time partition prune case	Andy Fan	patch
34/2937	NOT VALID for Unique Indexes	Simon Riggs	patch
34/3269	New READ_REPLICATION_SLOT command & usage in pg_receivewal	Ronan Dunklau	patch
34/2918	New default role allowing to change per-role/database settings	Michael Banck	patch
34/2900	On client connection event trigger	Konstantin Knizhnik	patch
34/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	patch
34/2932	Partial foreign key updates in referential integrity triggers	Paul Martinez	patch
34/3088	Reduce lock level for ALTER TABLE ... ADD CHECK	Simon Riggs	patch
34/3005	Refactor ECPGconnect() and allow IPv6 connection	Hayato Kuroda	patch
34/3037	Release SPI plans for referential integrity with DISCARD	Yuzuko Hosoya	patch
34/3229	Remove redundant initializations	Peter Eisentraut	patch
34/3035	Removing unused trailing linepointers from heap pages	Matthias van de Meent	patch
34/3139	Replicates changes for all tables in schema	vignesh C	patch
34/2834	ResourceOwner refactoring	Heikki Linnakangas	patch
34/2906	Row filtering for logical replication	Euler Taveira	patch
34/1708	Shared-memory based stats collector	Kyotaro Horiguchi	patch
34/3023	Speeding up GIST index builds using popcount	Amit Khandekar	patch
34/2370	Split StdRdOptions into HeapOptions and ToastOptions	Nikolay Shaplov	patch
34/2979	Support tab completion for upper character inputs in psql	Haiying Tang	patch
34/3252	Tab completion for CREATE SCHEMA AUTHORIZATION	Dagfinn Ilmari Mannsåker	patch
34/2994	Track wal_level drop for backup management	Takamichi Osumi	patch
34/2376	UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR	John Dent	patch
34/2933	WIP: Track relation size in shared memory	Thomas Munro	patch
34/2316	WITH SYSTEM VERSIONING Temporal Tables	Surafel Temesgen	patch
34/3206	Write visibility map during CLUSTER/VACUUM FULL	Alexander Korotkov	patch
34/3259	corruption of WAL page header is never reported	Yugo Nagata	patch
34/2865	create table like: ACCESS METHOD	Justin Pryzby	patch
34/3059	fix ICU explorer link in locale documentation	Anton Voloshin	patch
34/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	patch
34/2942	increase size of pg_commit_ts buffers	Álvaro Herrera	patch
34/2773	libpq compression	Konstantin Knizhnik, Daniil Zakhlystov	patch
34/3155	logical decoding and replication of sequences	Tomas Vondra	patch
34/2981	partial heap only tuples	Nathan Bossart	patch
34/3051	pg_dump new feature: exporting functions only	Lætitia AVROT	patch
34/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Artur Zakirov	patch
34/2861	pg_upgrade test for binary compatibility of core data types	Justin Pryzby	patch
34/3194	pgbench - allow retries on some errors	Yugo Nagata, Marina Polyakova	patch
34/3144	postgres_fdw: Handle boolean comparison predicates	Emre Hasegeli	patch
34/3258	proposal of adding 2 new diag items related to parsing the dynamic sql statement	Dinesh Chemuduru	patch
34/3140	psql - refactor echo code	Fabien Coelho	patch
34/3045	rename column if exists	David Oksman	patch
34/2990	speed up pg_rewind by using copy_file_range() and skipping some fsync	Paul Guo	patch
34/2910	wal_sessioninfo	Simon Riggs	patch

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

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author