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/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/4781	GUC-ify WALSender's MAX_SEND_SIZE constant	Majid Garoosi	✉ H
48/4718	Set log_lock_waits=on by default	Laurenz Albe	✉ H
48/4284	Support Right Semi Join	Richard Guo	✉ H
48/4735	Support a wildcard in backtrace_functions	Jelte Fennema-Nio	⚠ ✉ H
48/4314	Unlinking Parallel Hash Join inner batch files sooner	Thomas Munro	✉ H
48/4390	add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl	Cary Huang	✉ H
48/4645	make pg_ctl more friendly	Zhao Junwang, TianXiang Li	✉ 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
Needs review
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/4934	Add SECURITY.md, CODE_OF_CONDUCT.md, and CONTRIBUTING.md	Nathan Bossart	✉ H
48/4704	Add SQL syntax check	Josef Šimánek	⚠ ✉ 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/4907	Add local interface connection to log_line_prefix	Greg Sabino Mullane	⚠ ✉ H
48/4932	Add memory context type to pg_backend_memory_contexts view	David Rowley	✉ 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/4823	Add test module for verifying backtrace functionality	Bharath Rupireddy	✉ 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/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/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/4555	Build the docs if there are changes in docs and don't run other tasks if the cha...	Nazir Bilal Yavuz	✉ 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	⚠ ✉ 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/4900	Document that typed tables rely on CREATE TYPE	Erik Wienhold	⚠ ✉ H
48/4848	Documentation to upgrade logical replication cluster	vigneshwaran C	♲ ✉ H
48/4881	Eager aggregation, take 3	Richard Guo	✉ H
48/4809	Encoding protection for pgcrypto	shihao zhong	✉ H
48/4679	Extend pgbench partitioning to pgbench_history	Gabriele Bartolini	✉ H
48/4476	Extract numeric field in JSONB more effectively	Andy Fan	✉ H
48/4893	FSM corruption bug	Ronan Dunklau	♲ ✉ H
48/4917	Fix LLVM 18 crash	Thomas Munro	♲ ✉ H
48/4818	Fix buffer tracking on parallel vacuum	Anthonin Bonnefoy	♲ ✉ H
48/4901	Fix for timestamp lag issue from emit_log_hook when GUC log_line_prefix has '%m'	Michael Paquier	♲ ⚠ ✉ H
48/4606	Fix log_line_prefix to display the transaction id (%x) for statements not in a t...	Zongliang Quan	⚠ ✉ H
48/4911	Fix not reset pg_attribute.attnotnull when PK drop indirectly	Tender Wang	⚠ ✉ 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/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/4770	Introduce XID age and inactive timeout based replication slot invalidation	Bharath Rupireddy	⚠ ✉ H
48/4837	JIT compilation per plan node	David Rowley, Melih Mutlu	♲ ⚠ ✉ H
48/4871	KNN-btree	Anton Melnikov	♲ ✉ H
48/4305	Large files for relations	Thomas Munro	♲ ✉ H
48/4746	Libpq Compression	Jacob Burroughs	♲ ✉ H
48/4099	Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	♲ ✉ 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		♲ ✉ H
48/4777	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	♲ ✉ 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/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	⚠ ✉ H
48/4857	Partial aggregates push down	Yuki Fujii	♲ ✉ H
48/4902	Pass sk_attno to GIST consistent function	Michal Kleczek	⚠ ✉ 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/4723	RETURNING OLD/NEW values	Dean Rasheed	♲ ✉ H
48/4816	Race condition in FetchTableStates() breaks synchronization of subscription tabl...	vigneshwaran C	✉ H
48/4908	Recheck foreign key if a referenced collation was nondeterministic	Paul Jungwirth	✉ H
48/4564	Reducing memory consumed by RestrictInfo list translations in partitionwise join...	Ashutosh Bapat	♲ ✉ H
48/3701	Reducing planning time when tables have many partitions	Yuya Watari	♲ ✉ H
48/4927	Remove COMMAND_TAG_NEXTTAG	Ranier Vilela	⚠ ✉ 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/4933	Replace magic constant 3 with NUM_MERGE_MATCH_KINDS	Aleksander Alekseev	⚠ ✉ H
48/4920	Require LLVM 14+ in PostgreSQL 18	Thomas Munro	✉ H
48/4458	Retiring is_pushed_down	Richard Guo	⚠ ✉ 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/4888	Run deferred triggers in the correct security context	Laurenz Albe	⚠ ✉ H
48/4904	SQL Property Graph Queries (SQL/PGQ)	Peter Eisentraut	♲ ✉ H
48/4308	SQL:2011 application time	Paul Jungwirth	✉ H
48/4554	Separate memory contexts for relcache and catcache	Melih Mutlu	⚠ ✉ H
48/4677	Sequence Access Methods, round two	Michael Paquier	♲ ✉ H
48/3998	SetLatches()	Thomas Munro	♲ ✉ H
48/4496	Simplify create_merge_append_path a bit for clarity	Richard Guo	⚠ ✉ H
48/4899	Simplify docs on backslash escapes in jsonpath	Erik Wienhold	⚠ ✉ H
48/4745	Simplify documentation related to Windows builds	Michael Paquier	✉ H
48/4627	Special-case executor expression steps for common combinations	Andres Freund, Daniel Gustafsson	⚠ ✉ 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/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/4690	Teach predtest about IS [NOT] proofs	James Coleman	⚠ ✉ 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/4891	Vectored I/O in bulk_write.c	Thomas Munro	✉ 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		⚠ ✉ 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		✉ H
48/4761	date_trunc function in interval version	Przemysław Sztoch	✉ H
48/4935	fix CPUID check for XGETBV instruction support	Nathan Bossart	⚠ ✉ H
48/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	♲ ✉ H
48/4936	improve performance of pg_dump --binary-upgrade	Nathan Bossart	⚠ ✉ H
48/3823	logical decoding and replication of sequences, take 2	Tomas Vondra	♲ ✉ 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/4573	pg_ctl start may return 0 even if the postmaster has been already started on Win...	Kyotaro Horiguchi	⚠ ✉ H
48/4559	pg_rewind with cascade standby doesn't work well	Masaki Kuwamura	⚠ ✉ 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/4788	psql: Allow editing query results with \gedit	Christoph Berg	✉ 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/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/4658	Add detail regarding resource consumption wrt max_connections	Roberto Mello	⚠ ✉ H
48/4655	Add minimal C example and SQL registration example for custom table access metho...		⚠ ✉ H
48/3686	Add sortsupport for range types and btree_gist	Christoph Heiss	⚠ ✉ 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/4599	Document that triggers can break foreign key constraints	Laurenz Albe	⚠ ✉ H
48/4728	Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s)	Amul Sul	♲ ⚠ ✉ H
48/4710	Fix COPY FROM...CSV importing \. on a line by itself	Daniel Vérité	⚠ ✉ H
48/4622	Index Insert Prefetching	Tomas Vondra	♲ ✉ H
48/4352	Index-only filters without IOS	Tomas Vondra	♲ ⚠ ✉ 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/4544	Reduce size of postgres.bki	Matthias van de Meent	⚠ ✉ H
48/4549	Should consider materializing the cheapest inner path in consider_parallel_nestl...	Tender Wang	⚠ ✉ H
48/3501	Speed up releasing of locks	Andres Freund, David Rowley	♲ ⚠ ✉ H
48/4792	Split index and table statistics into different types of stats	Bertrand Drouvot	♲ ✉ 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.		⚠ ✉ H
48/4252	bytea PL/Perl transform	Ivan Panchenko	⚠ ✉ H
48/4399	pgbench: allow to cancel queries during benchmark	Yugo Nagata	⚠ ✉ H
48/4707	psql JSON output format	Christoph Berg	⚠ ✉ H
48/4738	psql: Rethinking of \du command	Pavel Luzanov	♲ ⚠ ✉ H

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author