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
33/2614	Add table expansion hook	Erik Nordström	patch
33/3114	Allow CustomScan nodes to signal projection support		patch
33/2992	Allow batched insert during cross-partition updates	Amit Langote	patch
33/2694	Automatic HASH and LIST partition creation	Anastasia Lubennikova	patch
33/3115	Bug fixes in alter subscription drop publication	vignesh C	patch
33/3096	CREATE COLLATION - check for duplicate options and error out if found one	Bharath Rupireddy	patch
33/3131	Change internal PRNG (from rand48 to something better, with a cleaner interface)	Fabien Coelho	patch
33/3127	Document the 1GB memory limit for VACUUM	Laurenz Albe	patch
33/3016	Dump public schema ownership, seclabels and comments	Noah Misch	patch
33/2928	EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW	Bharath Rupireddy	patch
33/3103	Enhanced error message to include duplicate option name	vignesh C	patch
33/3107	Extending amcheck to check toast size and compression	Mark Dilger	patch
33/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	patch
33/2971	Fix detection of preadv/pwritev support for OSX.	James Hilliard	patch
33/2860	Hooks on start/end/abort Xact command	Gilles Darold	patch
33/2957	Identify missing publications from publisher while create/alter subscription.	vignesh C	patch
33/3117	Included the actual datatype used in the documentation of logical replication m...	vignesh C	patch
33/3199	Logical Replication message formats documentation inaccuracies regarding binary ...	Brar Piening	patch
33/2968	Minimal logical decoding on standbys (take 6)	Amit Khandekar	patch
33/2807	New wal_level to disable WAL logging	Takamichi Osumi	patch
33/2900	On client connection event trigger	Konstantin Knizhnik	patch
33/2903	Parallel Hash Full Join	Melanie Plageman	patch
33/3088	Reduce lock level for ALTER TABLE ... ADD CHECK .. NOT VALID	Simon Riggs	patch
33/3137	Speed up pg_checksums	Greg Sabino Mullane	patch
33/3085	Use WaitLatch for waiting instead of pg_usleep	Bharath Rupireddy	patch
33/3092	Use simplehash.h instead of dynahash in SMgr	David Rowley	patch
33/3034	Using COPY FREEZE in pgbench	Tatsuo Ishii	patch
33/2539	allow to set a pager for psql's watch command	Pavel Stehule	patch
33/3140	psql - refactor echo code	Fabien Coelho	patch
33/3015	wal_compression = pglz/zlib/lz4/zstd	Andrey Borodin, Justin Pryzby	patch
Needs review
33/2234	A hook for path-removal decision on add_path	KaiGai Kohei	patch
33/3146	A micro-optimisation for ProcSendSignal()	Thomas Munro	patch
33/2602	ALTER SYSTEM READ { ONLY \| WRITE }	Amul Sul	patch
33/3110	ALTER TABLE ... SET ACCESS METHOD	Jeff Davis, Justin Pryzby	patch
33/3079	ATTACH PARTITION locking documentation for DEFAULT partitions	Matthias van de Meent	patch
33/2958	Adaptive query optimization: create extented statistics using auto_explain exten...	Konstantin Knizhnik	patch
33/3152	Add ZSON extension to /contrib/	Aleksander Alekseev	patch
33/3073	Add callback table access method to reset filenode when dropping relation	Mats Kindahl	patch
33/3042	Add common functions regexp_like, regexp_count, regexp_instr, regexp_substr and ...	Gilles Darold	patch
33/2765	Add extra statistics to explain for Nested Loop	Ekaterina Sokolova	patch
33/3054	Add missing function abs (interval)	Isaac Morland	patch
33/3164	Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	patch
33/3027	Add regexp_positions(string text, pattern text, flags text) → setof record (st...	Joel Jacobson	patch
33/3036	Add some tests for pg_stat_statements compatibility verification	Erica Zhang	patch
33/3033	Add system views pg_permissions and pg_ownerships	Joel Jacobson	patch
33/3095	Addition of authenticated ID to pg_stat_activity	Michael Paquier	patch
33/2780	Allow COPY "text" to output a header and add header matching mode to COPY FROM	Rémi Lapeyre	patch
33/3046	Allow multiple recursive self-references	Denis Hirn	patch
33/3148	Allow queries in WHEN expression of FOR EACH STATEMENT triggers	Joe Wildish	patch
33/3099	Asymmetric partition-wise JOIN	KaiGai Kohei, Andrey Lepikhov	patch
33/3198	Automatic notification for top transaction IDs	Gurjeet Singh	patch
33/3188	Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands	Yuzuko Hosoya	patch
33/3106	Avoid orphaned dependencies	Bertrand Drouvot	patch
33/3168	Avoid stuck of pgbench due to skipped transactions	Yugo Nagata	patch
33/2706	Background writer and checkpointer in crash recovery	Thomas Munro	patch
33/3134	Bug in query rewriter - hasModifyingCTE not getting set	Takayuki Tsunakawa	patch
33/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby	patch
33/3069	CREATE SEQUENCE with RESTART option	Bharath Rupireddy	patch
33/3171	Case expression pushdown	Alexander Pyhalov	patch
33/2999	Catalog version access	Vik Fearing	patch
33/3126	Clarify how triggers relate to transactions	Laurenz Albe	patch
33/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	patch
33/3172	Consistent use of SSL/TLS in docs	Daniel Gustafsson	patch
33/3074	Convert contrib SQL functions to new style	Tom Lane	patch
33/2518	Corruption during WAL replay	Teja Mupparti	patch
33/3195	DELETE CASCADE	David Christensen	patch
33/2805	DROP INDEX CONCURRENTLY on partitioned index	Justin Pryzby	patch
33/2603	DROP relation IF EXISTS Docs and Tests - Bug Fix	David Johnston	patch
33/3183	Detectable crashes and unlogged table resets	Jeff Davis	patch
33/3124	Diagnostic comment in LogicalIncreaseXminForSlot	Ashutosh Bapat	patch
33/3190	Doc chapter for Hash Indexes	Simon Riggs	patch
33/3170	Document deadlock caveats in synchronous logical setup	Takamichi Osumi	patch
33/2911	Dynamic result sets from procedures	Peter Eisentraut	patch
33/3058	Eliminating "Permission denied" errors on stat() (on Windows)	Alexander Lakhin	patch
33/3200	Emit namespace in post-copy output	Mike Fiedler	patch
33/3098	Extend portability of client_connection_check_interval	Thomas Munro	patch
33/3180	Extended protocol COPY FROM STDIN fix	Jeff Davis	patch
33/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	patch
33/3050	Extended statistics in EXPLAIN	Tomas Vondra	patch
33/3100	Extensible parsing	Julien Rouhaud	patch
33/2176	FETCH FIRST clause PERCENT option	Surafel Temesgen	patch
33/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	patch
33/2962	Fix DROP TABLESPACE on Windows with ProcSignalBarrier?	Thomas Munro	patch
33/3166	Fix around conn_duration in pgbench	Yugo Nagata	patch
33/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	patch
33/2719	Fix checksum verification in base backups for zero page headers	Michael Banck	patch
33/2685	Fix collation handling in postgres_fdw	Tom Lane	patch
33/3176	Fix documentation and logging for START_REPLICATION	Jeff Davis	patch
33/3175	Fix documentation for COPY protocol flow	Jeff Davis	patch
33/2877	Fix firing of RI triggers during cross-partition updates of partitioned tables	Amit Langote	patch
33/3179	Fix for START_REPLICATION without IDENTIFY_SYSTEM	Jeff Davis	patch
33/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	patch
33/3193	Fix pkg-config file for static linking	Filip Gospodinov	patch
33/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	patch
33/2966	Foreign Key Arrays	Mark Rofail	patch
33/2947	Full support for index LP_DEAD hint bits on standby	Michail Nikolaev	patch
33/3192	Fully WAL logged CREATE DATABASE - No Checkpoints	Dilip Kumar	patch
33/2824	Functions for sorting GiST build of gist_btree types	Andrey Borodin	patch
33/1651	GROUP BY optimization	Fedor Sigaev, Pavel Borisov	patch
33/2402	GUC to disable cancellation of awaiting for synchronous replication	Andrey Borodin	patch
33/3018	Hooks and API to allow loadable wire protocol extensions	Jan Wieck
33/2218	Implement INSERT SET syntax	Gareth Palmer	patch
33/3125	Improve documentation for pg_upgrade, standbys and rsync	Laurenz Albe	patch
33/2959	Improve join selectivity estimation using extended statistics	Konstantin Knizhnik	patch
33/3076	Improve sepgsql logging so it follows the behaviour of selinux's logging.	Dave Page	patch
33/3165	Improving the isolationtester	Tom Lane	patch
33/2973	In psql \copy from, send data to server in larger chunks	Heikki Linnakangas	patch
33/3135	Inaccurate error message when set fdw batch_size to 0	Bharath Rupireddy, hou zhijie	patch
33/3145	Incorrect snapshots while promoting hot standby node when 2PC is used	Michael Paquier	patch
33/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	patch
33/1741	Index Skip Scan	Dmitry Dolgov, Thomas Munro, Jesper Pedersen	patch
33/2952	Introduce ProcessInterrupts_hook for C extensions	Craig Ringer	patch
33/3078	Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncati...	Matthias van de Meent	patch
33/2925	Key management with tests	Stephen Frost, Masahiko Sawada, Bruce Momjian	patch
33/3071	Lazy JIT IR code generation to increase JIT speed with partitions	Luc Vlaming	patch
33/3111	Let's output the right error messages for wrong object types.	Kyotaro Horiguchi	patch
33/3142	Logging plan of the currently running query	atsushi torikoshi	patch
33/3040	Logical Replication - improve error message while adding tables to the publicati...	Bharath Rupireddy	patch
33/3041	Logical replication failure "ERROR: could not map filenode "base/13237/442428" t...	Bertrand Drouvot, Minsoo Oh	patch
33/2829	Make Append Cost aware of some run time partition prune case	Andy Fan	patch
33/772	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	patch
33/3197	Make jsonapi usable from libpq	Jacob Champion	patch
33/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	patch
33/3030	Make relfile tombstone files conditional on WAL level	Thomas Munro	patch
33/3181	Map WAL segment files on PMEM as WAL buffers	Takashi Menjo	patch
33/2909	Maximize page freezing	Simon Riggs	patch
33/3052	Merging statistics from children instead of re-sampling everything	Tomas Vondra	patch
33/2869	Mitigate pg_rewind race condition, if config file is enlarged concurrently.	Heikki Linnakangas	patch
33/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	patch
33/3038	More sort-related specialisation	Thomas Munro	patch
33/3123	Multiple pg_waldump --rmgr options	Heikki Linnakangas	patch
33/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	patch
33/2918	New default role allowing to change per-role/database settings	Michael Banck	patch
33/3147	O_DIRECT on macOS	Thomas Munro	patch
33/2699	Optimizing NULL check on pkey column	Surafel Temesgen	patch
33/3150	Outdated comments about proc->sem in lwlock.c	Thomas Munro	patch
33/3032	PROXY protocol support	Magnus Hagander	patch
33/3143	Parallel INSERT SELECT take 2	Greg Nancarrow, hou zhijie	patch
33/3129	Parallel scan with SubTransGetTopmostTransaction assert coredump	Greg Nancarrow	patch
33/2932	Partial foreign key updates in referential integrity triggers	Paul Martinez	patch
33/2907	PoC Refactor AM analyse API	Denis Smirnov
33/2863	Printing backtrace of postgres processes	vignesh C	patch
33/3169	Procarray.c improvements	Ranier Vilela	patch
33/931	Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	patch
33/3196	Pull general SASL framework out of SCRAM	Jacob Champion	patch
33/3160	Range Merge Join	Thomas Mannhart	patch
33/3082	Reduce exponential cost of pulling up deeply nested views	Tom Lane	patch
33/2817	Reduce the number of special cases to build contrib modules on windows	David Rowley	patch
33/2935	Reduce the time required for a database recovery from archive.	Anna Akenteva, Dmitry Shulga, Ivan Taranov	patch
33/3141	Reducing memory consumption for pending inval messages	Tom Lane	patch
33/3005	Refactor ECPGconnect() and allow IPv6 connection	Hayato Kuroda	patch
33/3151	Refactor parse_subscription_options	Bharath Rupireddy	patch
33/3037	Release SPI plans for referential integrity with DISCARD	Yuzuko Hosoya	patch
33/3097	Remove redundant variable pageSize in gistinitpage	Bharath Rupireddy	patch
33/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	patch
33/3156	Remove unused code from the KnownAssignedTransactionIdes submodule	Zongliang Quan	patch
33/3159	Remove unused function parameter in get_qual_from_partbound()	hou zhijie	patch
33/3189	Remove useless int64 range checks on BIGINT sequence MINVALUE/MAXVALUE values	Greg Nancarrow	patch
33/3035	Removing unused trailing linepointers from heap pages	Matthias van de Meent	patch
33/2943	Rename of triggers for partitioned tables		patch
33/3084	Replace RelationOpenSmgr() with RelationGetSmgr() inline function	Amul Sul	patch
33/3075	Replace pg_depend PIN entries with a fixed range check	Tom Lane	patch
33/2781	Replace polyphase merge with a simple k-way balanced merge	Heikki Linnakangas	patch
33/3139	Replicates changes for the all tables in schema	vignesh C	patch
33/2834	ResourceOwner refactoring	Heikki Linnakangas	patch
33/3029	Rework the sslfiles Makefile target	Jacob Champion	patch
33/2902	SQL/JSON: JSON_TABLE	Nikita Glukhov	patch
33/2901	SQL/JSON: functions	Nikita Glukhov	patch
33/1708	Shared-memory based stats collector	Kyotaro Horiguchi	patch
33/3104	Skip temporary table schema name from explain-verbose output.	Amul Sul	patch
33/2996	Speed up verifying UTF-8	John Naylor	patch
33/2370	Split StdRdOptions into HeapOptions and ToastOptions	Nikolay Shaplov	patch
33/3173	Split xlog.c	Heikki Linnakangas	patch
33/3138	Support for NSS as a libpq TLS backend	Daniel Gustafsson, Jacob Champion	patch
33/3121	Support of time zone patterns - of, tzh and tzm	Nitin Jadhav	patch
33/2979	Support tab completion for upper character inputs in psql	Haiying Tang	patch
33/2955	System catalog accesses in error context callback	Masahiko Sawada, Bharath Rupireddy	patch
33/3128	TAP test for contrib/sslinfo	Daniel Gustafsson	patch
33/3077	Teach pg_size_pretty and pg_size_bytes about higher-order units	David Christensen	patch
33/3102	Toast compression method options	Dilip Kumar	patch
33/2994	Track wal_level drop for backup management	Takamichi Osumi	patch
33/1574	Transactions involving multiple postgres foreign servers	Masahiko Sawada, Ashutosh Bapat	patch
33/2376	UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR	John Dent	patch
33/3162	Update Toast data failure in logical replication	Dilip Kumar	patch
33/3066	Use SIGIO to detect postmaster death	Thomas Munro	patch
33/3163	Use tuple-level SIREAD locks for index-only scans	Thomas Munro	patch
33/3191	Using indexUnchanged with nbtree	Simon Riggs	patch
33/2386	Using multicolumn statistics for more precise join selectivity estimatation	Konstantin Knizhnik	patch
33/2933	WIP: Track relation size in shared memory	Thomas Munro	patch
33/3063	WIP: remove 64K hard limit on rangetable size	Tom Lane	patch
33/2316	WITH SYSTEM VERSIONING Temporal Tables	Surafel Temesgen	patch
33/3186	add argument type to postgres_fdw docs	Shinya Kato	patch
33/3070	add explicit partial union-all and improve parallel subquery costing	Luc Vlaming	patch
33/3161	add pg_ctl option that returns amount of shmem required	Nathan Bossart	patch
33/2520	archive status ".ready" files may be created too early	Nathan Bossart	patch
33/3086	auto_explain log_seqscan	Pavel Stehule	patch
33/3182	automatically generating node support functions	Peter Eisentraut	patch
33/3093	avoid logical replication empty transactions	Euler Taveira, Ajin Cherian	patch
33/3087	badly calculated width of emoji in psql	Laurenz Albe
33/2838	brin: avoid errors processing work item following concurrent reindex	Álvaro Herrera, Justin Pryzby	patch
33/3157	btree_gist: Support bool	Emre Hasegeli	patch
33/3187	change float4 to floating point about type of autovacuum_vacuum_insert_scale_fac...	Shinya Kato	patch
33/2865	create table like: ACCESS METHOD	Justin Pryzby	patch
33/2684	enhancing plpgsql API for debugging and tracing	Pavel Stehule	patch
33/3055	estimating joins using extended statistics	Tomas Vondra	patch
33/3059	fix ICU explorer link in locale documentation	Anton Voloshin	patch
33/3080	generate fractional cheapest paths in generate_orderedappend_paths	Tomas Vondra	patch
33/2349	global temporary table	wenjing zeng	patch
33/2482	jsonpath syntax extensions	Nikita Glukhov	patch
33/2773	libpq compression	Konstantin Knizhnik, Daniil Zakhlystov	patch
33/3155	logical decoding and replication of sequences	Tomas Vondra	patch
33/2914	logical decoding of two-phase transactions	Stas Kelvich, Nikhil Sontakke, Ajin Cherian, Peter Smith	patch
33/3130	more detailed description of tup_returned and tup_fetched	Masahiro Ikeda	patch
33/2981	partial heap only tuples	Nathan Bossart	patch
33/3118	partition_bounds_create: avoid O(N) palloc calls	Justin Pryzby, Nitin Jadhav	patch
33/2573	pg_dump - read data for some options from external file	Pavel Stehule	patch
33/3051	pg_dump new feature: exporting functions only	Lætitia AVROT	patch
33/2377	pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared ...	Justin Pryzby	patch
33/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	patch
33/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	patch
33/3184	pg_stats and range statistics	Egor Rogov	patch
33/3105	pg_upgrade copy the source oldestXid	Bertrand Drouvot	patch
33/2861	pg_upgrade test for binary compatibility of core data types	Justin Pryzby	patch
33/3194	pgbench - allow retries on some errors	Yugo Nagata, Marina Polyakova	patch
33/2839	possibility to rename root namespace in plpgsql	Pavel Stehule	patch
33/3025	postgres-fdw: column option to override foreign types	Dian Fay	patch
33/3112	postgres_fdw - make cached connection functions tests meaningful with debug_inva...	Bharath Rupireddy	patch
33/3122	postgres_fdw - tighten up batch_size, fetch_size options against non-numeric val...	Bharath Rupireddy	patch
33/3144	postgres_fdw: Handle boolean comparison predicates	Emre Hasegeli	patch
33/3158	pre-allocating WAL files	Nathan Bossart	patch
33/2096	psql - add SHOW_ALL_RESULTS option	Fabien Coelho	patch
33/3017	public schema default ACL	Noah Misch	patch
33/1608	schema variables, LET command	Pavel Stehule	patch
33/2948	simplify some RI checks to reduce SPI overhead	Amit Langote	patch
33/2161	standby recovery fails when re-replaying due to missing directory which was remo...	Kyotaro Horiguchi, Paul Guo	patch
33/3062	tablesync early exit	Peter Smith	patch
33/3185	test invalidation of obsolete replslots with active walsender	Álvaro Herrera	patch
33/3178	unnesting multirange data types	Alexander Korotkov	patch
33/3060	use AV work items infrastructure for GIN pending list's cleanup	Jaime Casanova	patch
33/2910	wal_sessioninfo	Simon Riggs	patch
Waiting on Author
33/3090	A test for replay of regression tests	Thomas Munro	patch
33/3026	Add --create-only option to pg_dump/pg_dumpall	Michael Banck	patch
33/3065	Add option --drop-cascade for pg_dump/restore	Wu Haotian	patch
33/2987	Allow setting parallel_workers on partitioned tables	Seamus Abshere	patch
33/2983	Autovacuum dynamic cost_limit, cost_delay	Scott Mead	patch
33/3113	Bug fix for tab completion of ALTER TABLE	David Fetter	patch
33/3043	Built-in connection pooler	Konstantin Knizhnik	patch
33/2800	CLUSTER on partitioned table	Justin Pryzby	patch
33/2433	Erase the distinctClause if the result is unique by definition	Andy Fan	patch
33/2951	Extend comments on signal handling and cross-reference comments on signal handli...	Craig Ringer	patch
33/2953	Extend docs on how to write correct postgres-dialect C including extensions and ...	Craig Ringer	patch
33/2774	Further note require activity aspect of automatic checkpoint and archiving	David Johnston	patch
33/2553	INSERT SELECT: BulkInsertState and table_multi_insert	Justin Pryzby	patch
33/2960	Infrastructure changes to make the code less sensitive to transaction id bit wid...	James Finnerty	patch
33/2920	MERGE SQL command	Álvaro Herrera, Simon Riggs, Pavan Deolasee	patch
33/3120	Rewriting the test of pg_upgrade as a TAP test - take three	Michael Paquier	patch
33/2906	Row filtering for logical replication	Euler Taveira	patch
33/3023	Speeding up GIST index builds using popcount	Amit Khandekar	patch
33/2922	Table AM modifications to accept column projection lists	Jacob Champion, Soumyadeep Chakraborty	patch
33/3056	add link to domain data types section from locale documentation	Jürgen Purtz, Anton Voloshin	patch
33/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	patch
33/2942	increase size of pg_commit_ts buffers	Álvaro Herrera	patch
33/2769	parallel distinct union and aggregate support patch	bucoo hsiao	patch
33/2215	pg_upgrade fails with non-standard ACL	Anastasia Lubennikova, Arthur Zakirov	patch
33/2970	pg_upgrade: set default transactions to read-only at servers start	Denis Laxalde	patch
33/3045	rename column if exists	David Oksman	patch
33/2990	speed up pg_rewind by using copy_file_range() and skipping some fsync	Paul Guo	patch

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

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author