PostgreSQL Patch Tester

Current commitfest | Next commitfest | FAQ | Statistics | Highlights

Here lives an experimental bot that converts email threads that are registered in the Commitfest system into branches on Github, and collates test results from Cirrus CI. Key: or = new/recently changed, or = stable, = working.

Ready for Committer
48/4934	Add SECURITY.md, CODE_OF_CONDUCT.md, and CONTRIBUTING.md	Nathan Bossart	✉ H
48/4240	Cross-database SERIALIZABLE safe snapshots	Thomas Munro	♲ ✉ H
48/4209	Evaluate arguments of correlated SubPlans in the referencing ExprState	Andres Freund	♲ ✉ H
48/4683	Fix comment about cross-checking the varnullingrels	Richard Guo	✉ H
48/4920	Require LLVM 14+ in PostgreSQL 18	Thomas Munro	✉ H
48/4718	Set log_lock_waits=on by default	Laurenz Albe	✉ H
48/4284	Support Right Semi Join	Richard Guo	✉ H
48/4314	Unlinking Parallel Hash Join inner batch files sooner	Thomas Munro	✉ H
48/4933	Use macro to define the number of enum values (was: Replace magic constant ...)	Aleksander Alekseev	✉ H
48/4978	Use pgstat_kind_infos to read fixed shared stats structs	Tristan Partin	✉ H
48/4969	add --no-sync to pg_upgrade's calls to pg_dump and pg_dumpall	Nathan Bossart	✉ H
48/4390	add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl	Cary Huang	✉ H
48/4936	improve performance of pg_dump --binary-upgrade	Nathan Bossart	✉ H
48/4791	meson: Specify -Wformat as a common warning flag for extensions	Kouhei Sutou	✉ H
48/3874	pg_rewind WAL deletion pitfall	Alexander Kukushkin, Polina Bungina	♲ ✉ H
48/1608	session variables, LET command	Pavel Stehule	✉ H
48/4996	simplify pg_sequences system view	Nathan Bossart	✉ H
Needs review
48/4987	-Wmissing-variable-declarations	Peter Eisentraut	✉ H
48/4703	64-bit XIDs	Fedor Sigaev, Alexander Korotkov, Aleksander Alekseev, Konstantin Knizhnik, Nikita Glukhov, Yura Sokolov, Maxim Orlov, Pavel Borisov	♲ ✉ H
48/4768	A infrastructure to detect misuse of spin lock easier	Andy Fan	✉ H
48/3705	ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables	Justin Pryzby	♲ ✉ H
48/4237	Add CANONICAL option to xmlserialize	Jim Jones	♲ ✉ H
48/4909	Add a attopt to disable MCV when estimating for Var = Const	Andy Fan	✉ H
48/4882	Add a pg_truncate_freespace_map function	Ronan Dunklau	⚠ ✉ H
48/4913	Add extension_destdir GUC	Christoph Berg, David Wheeler	✉ H
48/3388	Add foreign-server health checks infrastructure	Hayato Kuroda	✉ H
48/4355	Add last_commit_lsn to pg_stat_database	James Coleman	✉ H
48/4932	Add memory context type to pg_backend_memory_contexts view	David Rowley	✉ H
48/4973	Add minimal C example and SQL registration example for custom table access metho...	Phil Eaton	✉ H
48/4736	Add new protocol message to change GUCs to be able to change protocol extension ...	Jelte Fennema-Nio	♲ ✉ H
48/3405	Add pg_stat_session	Rafia Sabih, Sergey Dudoladov	✉ H
48/4480	Add pg_wait_for_lockers() function	Will Mortensen	✉ H
48/4990	Add privileges test for pg_stat_statements to improve coverage	Keisuke Kuroda	✉ H
48/4709	Add the page header to each SLRU page.	Rishu Bagga, Yong Li	♲ ⚠ ✉ H
48/4829	Add trim_trailing_whitespace to editorconfig file	Jelte Fennema-Nio	✉ H
48/4994	Add verifier LLVM pass	Thomas Munro	✉ H
48/4764	Adding comments to help understand psql hidden queries	David Christensen, Greg Sabino Mullane	♲ ⚠ ✉ H
48/4711	Adjust tuples estimate for appendrel	Richard Guo	✉ H
48/4922	Allow non-superuser to cancel superuser tasks.	Kirill Reshke, Anthony Leung	✉ H
48/4867	Async commit support for 2PC (twophase) transactions		✉ H
48/4835	Avoid mixing custom and OpenSSL BIO functions	David Benjamin	♲ ✉ H
48/4942	Avoid orphaned objects dependencies, take 3	Bertrand Drouvot	✉ H
48/4319	Avoid unnecessary PlaceHolderVars for simple Vars	Richard Guo	✉ H
48/4874	BitmapHeapScan table AM violation removal (and use streaming read API)	Melanie Plageman	♲ ✉ H
48/4898	Building with meson on NixOS/nixpkgs	Wolfgang Walther	✉ H
48/4810	COPY ON_ERROR 'NULL'	jian he	♲ ✉ H
48/4716	COPY TO json	Joe Conway	♲ ✉ H
48/4620	CRC32C Parallel Computation Optimization on ARM	xiang gao	♲ ✉ H
48/4886	CREATE DATABASE ... STRATEGY=FILE_CLONE	Thomas Munro, Nazir Bilal Yavuz	✉ H
48/4876	CREATE DATABASE ... STRICT_UNICODE	Jeff Davis	♲ ✉ H
48/4529	CREATE SUBSCRIPTION ... SERVER	Jeff Davis	♲ ✉ H
48/4912	CSN snapshots in hot standby	Heikki Linnakangas	✉ H
48/4763	Change prefetch and read strategies to use range in pg_prewarm	Cédric Villemain	✉ H
48/4067	Check lateral references within PHVs for memoize cache keys	Richard Guo	✉ H
48/4868	Checkpoint extension hook	Jeff Davis	✉ H
48/4412	Client authentication via OAuth 2.0	Jacob Champion	♲ ⚠ ✉ H
48/4918	Convert internals documentation to Markdown	Daniel Gustafsson	♲ ✉ H
48/4992	Convert sepgsql tests to TAP	Peter Eisentraut	✉ H
48/4848	Documentation to upgrade logical replication cluster	vigneshwaran C	✉ H
48/4939	ECPG cleanup and fix for clang compile-time problem	Tom Lane	✉ H
48/4881	Eager aggregation, take 3	Richard Guo	♲ ✉ H
48/4809	Encoding protection for pgcrypto	shihao zhong	✉ H
48/4980	Expand applicability of aggregate's sortop optimization	Matthias van de Meent	✉ H
48/4945	Extend ALTER DEFAULT PRIVILEGES for large objects	Yugo Nagata	✉ H
48/4476	Extract numeric field in JSONB more effectively	Andy Fan	✉ H
48/4959	Fix BackgroundPsql to report error on query timeout rather than calling die	Daniel Gustafsson	♲ ✉ H
48/4979	Fix extract(interval) for week and quarter fields	Tom Lane	✉ H
48/2266	Fix partitionwise join with partially-redundant join clauses	Richard Guo	✉ H
48/4884	Fix rare recovery shutdown hang	Thomas Munro	✉ H
48/4453	Flush disk write caches by default on macOS and Windows	Thomas Munro	✉ H
48/4937	Identify huge pages accessibility using madvise	Dmitry Dolgov	✉ H
48/4460	Implement row pattern recognition feature	Tatsuo Ishii	♲ ✉ H
48/4849	Implementing OCSP Stapling for Server certificate status verification	David Zhang	⚠ ✉ H
48/3461	In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ...	Kyotaro Horiguchi	♲ ✉ H
48/4337	Incremental View Maintenance (IVM), take 2	Yugo Nagata	✉ H
48/4351	Index Prefetching	Tomas Vondra	♲ ✉ H
48/4948	Internal error codes triggered by tests	Michael Paquier	♲ ✉ H
48/4770	Introduce XID age and inactive timeout based replication slot invalidation	Bharath Rupireddy	✉ H
48/4777	Introduce new multi insert Table AM and improve performance of various SQL comma...	Bharath Rupireddy	✉ H
48/4837	JIT compilation per plan node	David Rowley, Melih Mutlu	♲ ⚠ ✉ H
48/4871	KNN-btree	Anton Melnikov	♲ ✉ H
48/4099	Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	♲ ✉ H
48/4988	Log details for stats dropped more than once	Bertrand Drouvot	✉ H
48/4345	Logging plan of the currently running query	Atsushi Torikoshi	♲ ✉ H
48/4905	MIN/MAX aggregates for a record	Aleksander Alekseev	✉ H
48/4681	Make COPY format extendable: Extract COPY TO format implementations	Kouhei Sutou	✉ H
48/4643	Make it possible to add custom options to EXPLAIN	Konstantin Knizhnik	♲ ✉ H
48/4870	Make query cancellation keys longer	Heikki Linnakangas	♲ ✉ H
48/4646	Mark search_path as GUC_REPORT	Alexander Kukushkin, Jelte Fennema-Nio	✉ H
48/4748	Network failure may prevent promotion	Kyotaro Horiguchi	♲ ✉ H
48/4688	New [relation] options engine	Nikolay Shaplov	♲ ✉ H
48/4750	Not to invalidate CatalogSnapshot for local invalidation messages	Xiaoran Wang	✉ H
48/4930	Optimize numeric.c mul_var() using the Karatsuba algorithm	Joel Jacobson	✉ H
48/4825	Optimize planner memory consumption for huge arrays	Andrei Lepikhov	✉ H
48/4966	Parallel CREATE INDEX for GIN indexes	Tomas Vondra	✉ H
48/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	✉ H
48/4857	Partial aggregates push down	Yuki Fujii	♲ ✉ H
48/4946	Partitioned tables and [un]loggedness	Michael Paquier	✉ H
48/4902	Pass sk_attno to GIST consistent function	Michal Kleczek	✉ H
48/4993	Performance improvement for pg_dump in binary upgrade mode	Daniel Gustafsson	✉ H
48/4282	Permute underscore separated components of columns before fuzzy matching	Arne Roland	✉ H
48/3986	Post-special Page Storage TDE support (aka Reserved Page Size)	David Christensen	♲ ⚠ ✉ H
48/4774	Postgres and --config-file option	Aleksander Alekseev	✉ H
48/4877	Propagate sanity checks of ProcessUtility() to standard_ProcessUtility()?	Michael Paquier	✉ H
48/4955	Proposal to have INCLUDE/EXCLUDE options for altering option values	Ayush Vatsa	✉ H
48/4723	RETURNING OLD/NEW values	Dean Rasheed	♲ ✉ H
48/4908	Recheck foreign key if a referenced collation was nondeterministic	Paul Jungwirth	✉ H
48/4964	Reduce the log spam by excluding certain SQLSTATEs	Laurenz Albe	✉ H
48/4564	Reducing memory consumed by RestrictInfo list translations in partitionwise join...	Ashutosh Bapat	♲ ✉ H
48/4915	Remove support for OpenSSL older than 1.1.1	Daniel Gustafsson	✉ H
48/4751	Remove useless GROUP BY columns considering unique index	Mingli Zhang	♲ ✉ H
48/4828	Rename constants in preparation of variableness	David Christensen	♲ ✉ H
48/4787	Reordering DISTINCT keys to match input path's pathkeys	Richard Guo	♲ ✉ H
48/4450	Replace a large number of OR clauses with ANY expression	Andrei Lepikhov, Alena Rybakina	⚠ ✉ H
48/4458	Retiring is_pushed_down	Richard Guo	✉ H
48/4997	Return pg_control from pg_backup_stop().	David Steele	✉ H
48/4553	Reuse child_relids in try_partitionwise_join	Ashutosh Bapat	♲ ✉ H
48/4285	Revise get_cheapest_parallel_safe_total_inner	Richard Guo	✉ H
48/4425	Revises for the check of parameterized partial paths	Richard Guo	✉ H
48/4971	Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Michail Nikolaev	✉ H
48/4888	Run deferred triggers in the correct security context	Laurenz Albe	✉ H
48/4904	SQL Property Graph Queries (SQL/PGQ)	Peter Eisentraut	♲ ✉ H
48/4554	Separate memory contexts for relcache and catcache	Melih Mutlu	✉ H
48/4677	Sequence Access Methods, round two	Michael Paquier	♲ ✉ H
48/4984	Serverside SNI for SSL connections	Daniel Gustafsson	✉ H
48/4991	Set appropriate processing mode for auxiliary processes.		⚠ ✉ H
48/3998	SetLatches()	Thomas Munro	♲ ✉ H
48/4954	Short-circuit sort_inner_and_outer if there are no mergejoin clauses	Richard Guo	✉ H
48/4549	Should consider materializing the cheapest inner path in consider_parallel_nestl...	Tender Wang	✉ H
48/4950	Show WAL stats on pg_stat_io	Nazir Bilal Yavuz	✉ H
48/4496	Simplify create_merge_append_path a bit for clarity	Richard Guo	✉ H
48/4627	Special-case executor expression steps for common combinations	Andres Freund, Daniel Gustafsson	✉ H
48/4985	Speed up Hash Join by teaching ExprState about hashing	David Rowley	✉ H
48/4914	Speed up clean meson builds by ~25%	Jelte Fennema-Nio	✉ H
48/4890	Spurious pgstat_drop_replslot() call	Bertrand Drouvot	♲ ✉ H
48/4538	Statistics Import and Export	Corey Huinker	✉ H
48/4965	Support LIKE with nondeterministic collations	Peter Eisentraut	✉ H
48/4650	Support for named parsed statement in psql	Anthonin Bonnefoy	✉ H
48/4518	Support prepared statement invalidation when result or argument types change	Jelte Fennema-Nio	✉ H
48/4512	Support run-time partition pruning for hash join	Richard Guo	♲ ✉ H
48/4896	Support wildcards in LISTEN command	Alexander Cheshev	✉ H
48/4926	SupportRequestRows support function for generate_series_timestamptz	David Rowley	✉ H
48/3663	Switching XLog source from archive to streaming when primary available	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
48/4769	System username in pg_stat_activity	Magnus Hagander	✉ H
48/4866	Table AM Interface Enhancements	Alexander Korotkov	♲ ⚠ ✉ H
48/4958	Table Access Method Enhancements	Alexander Korotkov	♲ ✉ H
48/4690	Teach predtest about IS [NOT] proofs	James Coleman	✉ H
48/4956	Test to dump and restore objects left behind by regression	Ashutosh Bapat	⚠ ✉ H
48/4839	The Prepare statement with the skewed parameter uses the custom plan	Zongliang Quan	⚠ ✉ H
48/4388	UUID v7	Andrey Borodin	♲ ✉ H
48/4715	Union Replacement of OR logic		♲ ⚠ ✉ H
48/4952	Use WALReadFromBuffers in more places	Bharath Rupireddy	✉ H
48/4941	Use XLOG_CONTROL_FILE macro everywhere	Anton Melnikov	✉ H
48/4968	Use generation memory context for tuplestore.c	David Rowley	♲ ✉ H
48/4983	Use pgBufferUsage for block reporting in analyze	Anthonin Bonnefoy	✉ H
48/4947	Use read streams in CREATE DATABASE command when the strategy is wal_log	Nazir Bilal Yavuz	♲ ✉ H
48/4891	Vectored I/O in bulk_write.c	Thomas Munro	✉ H
48/4972	Virtual generated columns	Peter Eisentraut	♲ ✉ H
48/4986	WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts		✉ H
48/4324	XLog size reductions: smaller XLogRecordBlockHeader	Matthias van de Meent	✉ H
48/4797	add COPY option REJECT_LIMIT	Atsushi Torikoshi	♲ ✉ H
48/4924	add multiple client certificate selection feature	Cary Huang	✉ H
48/4921	allow changing autovacuum_max_workers without restarting	Nathan Bossart	✉ H
48/4929	apply_scanjoin_target_to_paths and partitionwise join	Ashutosh Bapat	✉ H
48/3718	automatic client-side column-level encryption	Peter Eisentraut	♲ ✉ H
48/4744	change regexp_substr first argument make tests more easier to understand	jian he	✉ H
48/4845	confirmed flush lsn seems to be move backward in certain error cases	vigneshwaran C	✉ H
48/4766	data loss bug in initial sync of logical replication	Tomas Vondra	✉ H
48/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	♲ ✉ H
48/4967	improve performance of pg_dump with many sequences	Nathan Bossart	✉ H
48/3823	logical decoding and replication of sequences, take 2	Tomas Vondra	♲ ✉ H
48/4645	make pg_ctl more friendly	Zhao Junwang, TianXiang Li	✉ H
48/3672	nbtree performance improvements through specialization on key shape	Matthias van de Meent	♲ ✉ H
48/4638	nbtree: downlink right separator/HIKEY optimization	Matthias van de Meent	✉ H
48/4635	nbtree: implement dynamic prefix truncation	Matthias van de Meent	✉ H
48/4817	on_error table, saving error info to a table	jian he	♲ ✉ H
48/4995	optimizing pg_upgrade's once-in-each-database steps	Nathan Bossart	✉ H
48/4573	pg_ctl start may return 0 even if the postmaster has been already started on Win...	Kyotaro Horiguchi	✉ H
48/4975	pg_parse_json: don't leak token copies on failure	Jacob Champion	⚠ ✉ H
48/4559	pg_rewind with cascade standby doesn't work well	Masaki Kuwamura	✉ H
48/4974	pg_stat_activity: make slow/hanging authentication more visible	Jacob Champion	✉ H
48/4431	pg_stat_logmsg	Joe Conway	H
48/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	✉ H
48/4456	pg_tracing	Anthonin Bonnefoy	⚠ ✉ H
48/4814	psql meta-command conninfo+	Maiquel Grassi	✉ H
48/4963	queryId not reported in pg_stat_activity with Extended Query Protocol	Sami Imseih	✉ H
48/4082	recovery modules	Nathan Bossart	✉ H
48/4928	s/shm_mq_iovec/struct iovec/	Thomas Munro	✉ H
48/4759	shared detoast datum	Andy Fan	⚠ ✉ H
48/4982	support tid range scan in parallel	Cary Huang	✉ H
48/4951	teach pg_combinebackup to detect deleted files where possible	Robert Haas	⚠ ✉ H
48/4865	type cache cleanup improvements	Fedor Sigaev	♲ ⚠ ✉ H
48/4873	unaccent: understand ancient Greek "oxia" and other codepoints merged by Unicode	Thomas Munro	✉ H
48/3482	warn if GUC set to an invalid shared library	Justin Pryzby	✉ H
Waiting on Author
48/4720	"unexpected duplicate for tablespace" problem in logical replication	Shenhao Wang	✉ H
48/3478	AcquireExecutorLocks() and run-time pruning	Amit Langote	♲ ⚠ ✉ H
48/4754	Add LSN <-> time conversion facility	Melanie Plageman	♲ ⚠ ✉ H
48/4907	Add local interface connection to log_line_prefix	Greg Sabino Mullane	✉ H
48/4655	Add minimal C example and SQL registration example for custom table access metho...	Phil Eaton	✉ H
48/3686	Add sortsupport for range types and btree_gist	Christoph Heiss	✉ H
48/4823	Add test module for verifying backtrace functionality	Bharath Rupireddy	⚠ ✉ H
48/3867	Add the ability to limit the amount of memory that can be allocated to backends.	Reid Thompson, John Morris	♲ ✉ H
48/4617	Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING	Marko Tiikkaja	✉ H
48/3733	Amcheck verification of GiST and GIN	Heikki Linnakangas, Andrey Borodin, Grigory Kryachko	♲ ✉ H
48/3709	CI and test improvements	Justin Pryzby	✉ H
48/4428	Custom storage managers (SMGR), redux	Matthias van de Meent, Tristan Partin	♲ ✉ H
48/4332	Doc limitations update proposal: include out-of-line OID usage per TOAST-ed colu...	Jakub Wartak	✉ H
48/4900	Document that typed tables rely on CREATE TYPE	Erik Wienhold	✉ H
48/4710	Fix COPY FROM...CSV importing \. on a line by itself	Daniel Vérité	✉ H
48/4606	Fix log_line_prefix to display the transaction id (%x) for statements not in a t...	Zongliang Quan	✉ H
48/4622	Index Insert Prefetching	Tomas Vondra	♲ ✉ H
48/4352	Index-only filters without IOS	Tomas Vondra	♲ ⚠ ✉ H
48/4305	Large files for relations	Thomas Munro	♲ ✉ H
48/4291	Logging parallel worker draught	Benoit Lobréau	H
48/4221	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	♲ ⚠ ✉ H
48/4583	Mark expressions nullable by grouping sets	Richard Guo	✉ H
48/3956	Multi-version ICU	Thomas Munro	♲ ✉ H
48/4384	Opportunistically pruning page before insert	James Coleman	♲ ⚠ ✉ H
48/4248	Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE	David Geier	⚠ ✉ H
48/4379	Parent/child context relation in pg_get_backend_memory_contexts()	Melih Mutlu	♲ ✉ H
48/3701	Reducing planning time when tables have many partitions	Yuya Watari	♲ ✉ H
48/4792	Split index and table statistics into different types of stats	Bertrand Drouvot	♲ ✉ H
48/4735	Support a wildcard in backtrace_functions	Jelte Fennema-Nio	♲ ✉ H
48/4938	Use for int64_t and other exact-width integer types	Thomas Munro	♲ ✉ H
48/4419	Use ReadRecentBuffer() for btree root page	Thomas Munro	♲ ✉ H
48/4581	Various small unrelated doc patches: plpgsql, schemas, permissions, oidvector	Karl Pinc	♲ ✉ H
48/4743	add function argument names to regex* functions.	jian he	♲ ✉ H
48/4252	bytea PL/Perl transform	Ivan Panchenko	✉ H
48/4761	date_trunc function in interval version	Przemysław Sztoch	✉ H
48/4977	elog/ereport VS misleading backtrace_function function address	Jakub Wartak	✉ H
48/4399	pgbench: allow to cancel queries during benchmark	Yugo Nagata	✉ H
48/4738	psql: Rethinking of \du command	Pavel Luzanov	♲ ⚠ ✉ H

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author