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
42/3464	Add Amcheck option for checking unique constraints in btree indexes	Anastasia Lubennikova, Maxim Orlov, Pavel Borisov	✉ H
42/3688	Add JIT deform_counter	Dmitry Dolgov	✉ H
42/3388	Add foreign-server health checks infrastructure	Hayato Kuroda	✉ H
42/3617	Add index scan progress to pg_stat_progress_vacuum	Sami Imseih	✉ H
42/3511	Add non-blocking version of PQcancel	Jelte Fennema	✉ H
42/3733	Amcheck verification of GiST and GIN	Heikki Linnakangas, Andrey Borodin, Grigory Kryachko	✉ H
42/4201	Configurable iteration count for SCRAM	Daniel Gustafsson	⚠ ✉ H
42/4042	Create visible links for HTML elements that have an id to make them discoverable...	Brar Piening	♲ ✉ H
42/4209	Evaluate arguments of correlated SubPlans in the referencing ExprState	Andres Freund	✉ H
42/4059	Fix progress report of CREATE INDEX for nested partitioned tables	Justin Pryzby, Ilya Gladyshev	✉ H
42/4013	GUC for temporary disabling event triggers	Daniel Gustafsson	✉ H
42/4014	Introduce a new view for checkpointer related stats	Bharath Rupireddy	✉ H
42/2900	On client login event trigger	Konstantin Knizhnik, Greg Nancarrow, Mikhail Gribkov	✉ H
42/2903	Parallel Hash Full Join	Melanie Plageman	♲ ✉ H
42/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	✉ H
42/4223	Refactoring SysCacheGetAttr to know when attr cannot be NULL	Daniel Gustafsson	♲ ✉ H
42/3654	Support % wildcard in extension upgrade scripts	Sandro Santilli	♲ ⚠ ✉ H
42/3679	Support load balancing in libpq	Jelte Fennema	✉ H
42/3837	TAP output format for pg_regress	Daniel Gustafsson	✉ H
42/4046	Test for function error in logrep worker	Anton Melnikov	✉ H
42/4040	Transaction timeout	Andrey Borodin	✉ H
42/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	✉ H
42/3707	Use fadvise in wal replay	Kirill Reshke, Jakub Wartak	✉ H
42/3990	Use the system CA pool for certificate verification	Jacob Champion, Thomas Habets	✉ H
42/3235	Using each rel as both outer and inner for anti-joins	Richard Guo	✉ H
42/4141	WAL Insertion Lock Improvements	Bharath Rupireddy	✉ H
42/4227	[PATCH v2] Time option added to psql prompt (%T)	Kirk Wolak	✉ H
42/2573	pg_dump - read data for some options from external file	Pavel Stehule	✉ H
42/3503	pg_receivewal fail to streams when the partial file to write is not fully initia...	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
42/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	✉ H
42/4166	psql prompt substitution %N	Pavel Stehule	✉ H
42/3448	reduce impact of lengthy startup and checkpoint tasks	Nathan Bossart	✉ H
Needs review
42/3478	AcquireExecutorLocks() and run-time pruning	Amit Langote	✉ H
42/3962	Add EXPLAIN option GENERIC_PLAN for parameterized queries	Laurenz Albe	✉ H
42/3889	Add document is_superuser	Kotaro Kawamoto	✉ H
42/4071	Add function to_oct	Eric Radman	⚠ ✉ H
42/3492	Add log messages when replication slots become active and inactive	Bharath Rupireddy	✉ H
42/4147	Add n_tup_newpage_upd to pg_stat table views	Corey Huinker	✉ H
42/4182	Add offset arrays to various WAL records' string output	Melanie Plageman	✉ H
42/3405	Add pg_stat_session	Rafia Sabih, Sergey Dudoladov	✉ H
42/3838	Add semi-join pushdown to postgres_fdw	Alexander Pyhalov	✉ H
42/4218	Add shared buffer hits to pg_stat_io	Melanie Plageman	✉ H
42/3686	Add sortsupport for range types and btree_gist	Christoph Heiss	✉ H
42/3867	Add the ability to limit the amount of memory that can be allocated to backends.	Reid Thompson	♲ ✉ H
42/3840	Allow logical replication to copy tables in binary format	Melih Mutlu	♲ ✉ H
42/4225	Allow logical replication via inheritance root table	Jacob Champion	♲ ⚠ ✉ H
42/4198	Allow ordered partition scans in more cases	David Rowley	✉ H
42/3665	An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions...	Bharath Rupireddy	✉ H
42/2377	Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing meta...	Justin Pryzby	✉ H
42/4187	BRIN - SK_SEARCHARRAY and scan key preprocessing	Tomas Vondra	✉ H
42/3949	BRIN Sort - sorting using BRIN indexes	Tomas Vondra	✉ H
42/4228	Background psql TAP test helper	Andres Freund	✉ H
42/3817	COPY FROM IGNORE_ERRORS - ignores rows with errors while copying	Damir Belyalov	✉ H
42/3896	COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns	Mingli Zhang	✉ H
42/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby, Alexander Pyhalov	✉ H
42/4189	Canonicalize ICU locales to language tags	Jeff Davis	♲ ✉ H
42/3736	Check consistency of GUC defaults between .sample.conf and pg_settings.boot_val	Kyotaro Horiguchi, Justin Pryzby	✉ H
42/4067	Check lateral references within PHVs for memoize cache keys	Richard Guo	✉ H
42/4128	Clarify the behavior of the system when approaching XID wraparound	Aleksander Alekseev	✉ H
42/3970	Code checks for App Devs, using new options for transaction behavior	Simon Riggs	✉ H
42/3451	Daitch-Mokotoff soundex	Dag Lem	✉ H
42/3623	Data is copied twice when specifying both child and parent table in publication	wei wang, Yu Shi	✉ H
42/3996	Direct I/O (developer-only feature)	Andres Freund, Thomas Munro	♲ ✉ H
42/4190	Doc: Improve note about copying into postgres_fdw foreign tables in batch	Etsuro Fujita	✉ H
42/2911	Dynamic result sets from procedures	Peter Eisentraut	✉ H
42/4005	Enable fine-grained control over what gets logged on connection attempt (reduces...	Sergey Dudoladov	⚠ ✉ H
42/3857	Enable jitlink as an alternative jit linker of legacy Rtdyld and add riscv jitti...	Alex Fan	⚠ ✉ H
42/4065	Exclusion constraints on partitioned tables	Paul Jungwirth	✉ H
42/4149	Fix assertion failure in SnapBuildInitialSnapshot()	Masahiko Sawada	✉ H
42/4148	Fix assertion failure with next_phase_at in snapbuild.c	Masahiko Sawada	✉ H
42/3966	Fix bogus error emitted by pg_recvlogical when interrupted	Bharath Rupireddy	✉ H
42/3607	Fix dsa_free() to re-bin segment	Dongming Liu	✉ H
42/4078	Fix inconsistency in reporting checkpointer stats	Nitin Jadhav	✉ H
42/4186	Fix the description of GUC "max_locks_per_transaction" and "max_pred_locks_per_t...	wei wang	✉ H
42/4120	Flush SLRU counters in checkpointer process	Anthonin Bonnefoy	✉ H
42/2863	Function to log backtrace of postgres processes	vigneshwaran C, Bharath Rupireddy	✉ H
42/4060	Improve WALRead() to suck data directly from WAL buffers when possible	Bharath Rupireddy	✉ H
42/3687	Improve dead tuple storage for lazy vacuum	Masahiko Sawada	✉ H
42/3963	Improve doc for autovacuum on partitioned tables	Laurenz Albe	✉ H
42/4178	Improve pg_bsd_indent's handling of multiline initialization expressions	Tom Lane, Thomas Munro	✉ H
42/3461	In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ...	Kyotaro Horiguchi	✉ H
42/3489	Index SLRUs by 64-bit integers rather than by 32-bit integers	Aleksander Alekseev, Maxim Orlov	✉ H
42/4127	Infinite interval values	Ashutosh Bapat, Joseph Koshakow, jian he	♲ ✉ H
42/4191	Kerberos/GSSAPI Credential Delegation	Stephen Frost	⚠ ✉ H
42/3983	Lockless queue of waiters based on atomic operations for LWLock	Alexander Korotkov, Pavel Borisov	✉ H
42/4168	MERGE ... RETURNING	Dean Rasheed	✉ H
42/4092	MERGE ... WHEN NOT MATCHED BY SOURCE	Dean Rasheed	✉ H
42/4076	MERGE INTO updatable_view	Dean Rasheed	♲ ✉ H
42/4221	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	✉ H
42/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	✉ H
42/3740	Minimal logical decoding on standbys	Bertrand Drouvot	⚠ ✉ H
42/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin, Ivan Lazarev	✉ H
42/3919	Move backup-related code to xlogbackup.c/.h	Bharath Rupireddy	✉ H
42/4123	Named Operators	Gurjeet Singh	✉ H
42/4160	New [relation] options engine	Nikolay Shaplov	♲ ✉ H
42/3735	New hooks in the connection path	Bertrand Drouvot	✉ H
42/4069	Non-replayable WAL records through overflows and >MaxAllocSize lengths	Matthias van de Meent	✉ H
42/4196	Optimize Numeric using fixed buffer reducing pallocs for small numbers	Joel Jacobson	✉ H
42/4099	POC: Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	⚠ ✉ H
42/4019	Partial aggregates push down	Yuki Fujii	✉ H
42/3821	Patch to implement missing join selectivity estimation for range types	Mahmoud SAKR, Diogo Repas, Maxime Schoemans, Zhicheng Luo	✉ H
42/3986	Post-special Page Storage TDE support	David Christensen	♲ ✉ H
42/4199	Preserve subscription relation state during pg_upgrade	Julien Rouhaud	♲ ✉ H
42/3751	Reduce timing overhead of EXPLAIN ANALYZE using rdtsc	Andres Freund, Lukas Fittl, David Geier	✉ H
42/4029	Reduce wakeup on idle for bgwriter & walwriter for >5s	Simon Riggs	✉ H
42/3701	Reducing planning time when tables have many partitions	David Rowley, Yuya Watari	✉ H
42/3993	Refactor relation extension, faster COPY	Andres Freund	♲ ✉ H
42/3782	Refactoring postgres_fdw/connection.c	Fujii Masao	✉ H
42/3894	Remove dead macro exec_subplan_get_plan	Mingli Zhang	⚠ ✉ H
42/4157	Report the query string that caused a memory error under Valgrind	Onur TIRTIR	✉ H
42/3982	ResourceOwner refactoring	Heikki Linnakangas	✉ H
42/3784	Reuse Workers and Replication Slots during Logical Replication	Melih Mutlu	⚠ ✉ H
42/4004	Rework LogicalOutputPluginWriterUpdateProgress	wei wang	✉ H
42/4086	SQL/JSON	Amit Langote, Nikita Glukhov	✉ H
42/4100	Sampling-based timing for EXPLAIN ANALYZE	Lukas Fittl	✉ H
42/3998	SetLatches()	Thomas Munro	♲ ✉ H
42/3646	Skip replicating the tables specified in except table option	vigneshwaran C	♲ ✉ H
42/4119	Some revises in adding sorting path	Richard Guo	✉ H
42/3501	Speed up releasing of locks	Andres Freund, David Rowley	✉ H
42/3595	Support logical replication of DDL commands	Zheng Li, vigneshwaran C, Ajin Cherian, Hou Zhijie, Runqi Tian	⚠ ✉ H
42/3663	Switching XLog source from archive to streaming when primary available	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
42/3729	Testing autovacuum wraparound	Andres Freund, Masahiko Sawada	✉ H
42/4217	Track IO times in pg_stat_io	Melanie Plageman	✉ H
42/4210	Track Oldest Initialized WAL Buffer Page	Bharath Rupireddy	✉ H
42/4233	Use libpq single row mode for FETCH_COUNT when a cursor cannot be used	Daniel Vérité	⚠ ✉ H
42/3988	User functions for building SCRAM secrets	Jonathan Katz	✉ H
42/4216	VACUUM buffer pool size option	Melanie Plageman	✉ H
42/4025	Work around non-atomic read of read of control file on ext4	Thomas Munro	✉ H
42/4150	[BUG] pg_stat_statements and extended query protocol	Sami Imseih	✉ H
42/4192	archive modules loose ends	Nathan Bossart	✉ H
42/3813	asynchronous execution support for Custom Scan	KaiGai Kohei, kazutaka onishi	✉ H
42/4111	basebackup: support zstd long distance matching	Justin Pryzby	✉ H
42/3869	cataloguing NOT NULL constraints	Álvaro Herrera	✉ H
42/4107	clean up permission checks after 599b33b94	Amit Langote	✉ H
42/4231	documentation updates for SQL:2023	Peter Eisentraut	♲ ✉ H
42/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	✉ H
42/3823	logical decoding and replication of sequences, take 2	Tomas Vondra	⚠ ✉ H
42/4153	monitoring usage count distribution	Nathan Bossart	✉ H
42/3672	nbtree performance improvements through specialization on key shape	Matthias van de Meent	⚠ ✉ H
42/4161	pg_dump/pg_restore: Fix stdin/stdout handling of custom format on Win32	Juanjo Santamaria Flecha, Daniel Watzinger	✉ H
42/3874	pg_rewind WAL deletion pitfall	Alexander Kukushkin, Polina Bungina	✉ H
42/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	✉ H
42/4200	pg_upgrade data type check connection overhead reduction	Daniel Gustafsson	✉ H
42/4175	pg_usleep for multisecond delays	Nathan Bossart	✉ H
42/4105	pgbench - adding pl/pgsql versions of tests	Hannu Krosing	✉ H
42/4174	possibility to take name, signature and oid of currently executed function in GE...	Pavel Stehule	✉ H
42/3392	postgres_fdw: commit remote (sub)transactions in parallel during pre-commit	Etsuro Fujita	✉ H
42/4211	psql \watch iteration count	Andrey Borodin	✉ H
42/4116	psql: Add role's membership options to the \du+ command	Pavel Luzanov	✉ H
42/4082	recovery modules	Nathan Bossart	✉ H
42/1608	session variables, LET command	Pavel Stehule	⚠ ✉ H
42/4212	some namespace.c refactoring	Peter Eisentraut	✉ H
42/4159	stopgap fix for signal handling during restore_command	Nathan Bossart	✉ H
42/4215	vacuum reloads config file more often	Melanie Plageman	✉ H
42/2888	zstd compression for pg_dump	Justin Pryzby	✉ H
Waiting on Author
42/3727	ALTER TABLE SET ACCESS METHOD on partitioned tables	Justin Pryzby, Soumyadeep Chakraborty, Soumyadeep Chakraborty	✉ H
42/3659	Add SPLIT PARTITION/MERGE PARTITIONS commands	Dmitry Koval	✉ H
42/4101	Add TAP tests for psql \g piped into program	Daniel Vérité	✉ H
42/3870	Better infrastructure for automated testing of concurrency issues	Alexander Korotkov	♲ ✉ H
42/4074	CAST( ... ON DEFAULT)	Corey Huinker	♲ ✉ H
42/4169	Default to ICU during initdb	Jeff Davis	♲ ✉ H
42/4135	Direct SSL Connections	Greg Stark	⚠ ✉ H
42/3445	Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi, Dilip Kumar	⚠ ✉ H
42/3842	Fix alter subscription concurrency errors	Jelte Fennema	♲ ✉ H
42/4222	Fix improper qual pushdown after applying outer join identity 3	Tom Lane	✉ H
42/3976	Fix order of checking ICU options in initdb and create database	Marina Polyakova	♲ ✉ H
42/3615	Fix recovery conflict SIGUSR1 handling	Thomas Munro	✉ H
42/3890	Fix tab completion MERGE	Kotaro Kawamoto	✉ H
42/4106	Generate pg_stat_get_xact*() functions with Macros	Bertrand Drouvot	♲ ✉ H
42/4208	Improvements to Meson docs	Samay Sharma	✉ H
42/3771	Introduce array_shuffle() and array_sample() functions	Martin Kalcher	♲ ✉ H
42/3716	Let libpq reject unexpected authentication requests	Jacob Champion	⚠ ✉ H
42/3936	Make ON_ERROR_STOP stop on shell script failure	Tatsuhiro Nakamori	♲ ✉ H
42/3490	Pluggable toaster	Fedor Sigaev, Nikita Glukhov, Oleg Bartunov, Nikita Malakhov	♲ ✉ H
42/3978	Prefetch the next tuple's memory during seqscans	David Rowley, Thomas Munro	♲ ✉ H
42/3777	Provide the facility to set binary format output for specific OID's per session	Dave Cramer	♲ ✉ H
42/3764	Push aggregation down to base relations and joins	Yuki Fujii	♲ ✉ H
42/4103	RADIUS tests and improvements	Thomas Munro	✉ H
42/4172	Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEnt...	Bertrand Drouvot	✉ H
42/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrei Lepikhov	♲ ✉ H
42/3984	Split index and table statistics into different types of stats	Bertrand Drouvot	⚠ ✉ H
42/3985	TDE key management patches	Bruce Momjian, David Christensen	♲ ✉ H
42/3718	Transparent column encryption	Peter Eisentraut	♲ ✉ H
42/3310	add guc: hugepages_active	Justin Pryzby, Noriyoshi Shinoda	✉ H
42/3704	explain analyze rows=%.0f	Ibrar Ahmed	✉ H
42/3184	pg_stats and range statistics	Egor Rogov	⚠ ✉ H
42/3739	pg_visibility's pg_check_visible() yields false positive when working in paralle...	Daniel Shelepanov	✉ H
42/3140	psql - refactor echo code	Fabien Coelho	✉ H
42/4035	suppressing useless wakeups in logical/worker.c	Nathan Bossart	✉ H

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author