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
43/3464	Add Amcheck option for checking unique constraints in btree indexes	Anastasia Lubennikova, Maxim Orlov, Pavel Borisov	✉ H
43/3688	Add JIT deform_counter	Dmitry Dolgov	✉ H
43/4262	Add PQsendSyncMessage() to libpq	Anton Kirilov	⚠ ✉ H
43/3659	Add SPLIT PARTITION/MERGE PARTITIONS commands	Dmitry Koval	♲ ✉ H
43/4275	Add argument names to multi-argument aggregates	Dagfinn Ilmari Mannsåker	♲ ✉ H
43/4071	Add function to_oct	Eric Radman	✉ H
43/3617	Add index scan progress to pg_stat_progress_vacuum	Sami Imseih	✉ H
43/4309	Add native windows on arm64 support	Niyas Sait	✉ H
43/3511	Add non-blocking version of PQcancel	Jelte Fennema	♲ ✉ H
43/3733	Amcheck verification of GiST and GIN	Heikki Linnakangas, Andrey Borodin, Grigory Kryachko	♲ ✉ H
43/4259	Autogenerate some wait events code and documentation	Bertrand Drouvot	✉ H
43/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby, Alexander Pyhalov	✉ H
43/4128	Clarify the behavior of the system when approaching XID wraparound	Aleksander Alekseev	✉ H
43/4169	Default to ICU during initdb	Jeff Davis	♲ ✉ H
43/4209	Evaluate arguments of correlated SubPlans in the referencing ExprState	Andres Freund	♲ ✉ H
43/4258	Extend the length of BackgroundWorker.bgw_library_name	Yurii Rashkovskii	✉ H
43/4148	Fix assertion failure with next_phase_at in snapbuild.c	Masahiko Sawada	✉ H
43/4120	Flush SLRU counters in checkpointer process	Anthonin Bonnefoy	✉ H
43/4013	GUC for temporary disabling event triggers	Daniel Gustafsson	✉ H
43/3489	Index SLRUs by 64-bit integers rather than by 32-bit integers	Aleksander Alekseev, Maxim Orlov	✉ H
43/4127	Infinite interval values	Ashutosh Bapat, Joseph Koshakow, jian he	♲ ✉ H
43/4318	Introduce WAIT_EVENT_EXTENSION and WAIT_EVENT_BUFFER_PIN	Bertrand Drouvot	✉ H
43/4014	Introduce a new view for checkpointer related stats	Bharath Rupireddy	✉ H
43/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	✉ H
43/2900	On client login event trigger	Konstantin Knizhnik, Greg Nancarrow, Mikhail Gribkov	✉ H
43/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	♲ ✉ H
43/3821	Patch to implement missing join selectivity estimation for range types	Mahmoud SAKR, Diogo Repas, Maxime Schoemans, Zhicheng Luo	✉ H
43/3654	Support % wildcard in extension upgrade scripts	Sandro Santilli	⚠ ✉ H
43/4274	Tab complete time zone names after AT TIME ZONE	Dagfinn Ilmari Mannsåker	✉ H
43/4312	Tab completion for CREATE SCHEMA AUTHORIZATION in psql	Dagfinn Ilmari Mannsåker	✉ H
43/4040	Transaction timeout	Andrey Borodin	✉ H
43/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	✉ H
43/4141	WAL Insertion Lock Improvements	Bharath Rupireddy	✉ H
43/4107	clean up permission checks after 599b33b94	Amit Langote	✉ H
43/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	✉ H
43/2573	pg_dump - read data for some options from external file	Pavel Stehule	✉ H
43/3503	pg_receivewal fail to streams when the partial file to write is not fully initia...	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
43/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	✉ H
43/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	✉ H
43/4322	pg_upgrade - typo in verbose log	Peter Smith	✉ H
43/4166	psql prompt substitution %N	Pavel Stehule	✉ H
43/4116	psql: Add role's membership options to the \du+ command	Pavel Luzanov	✉ H
Needs review
43/4296	64-bit TOAST value ID	Nikita Malakhov	♲ ✉ H
43/4286	A minor adjustment to get_cheapest_path_for_pathkeys	Richard Guo	⚠ ✉ H
43/4268	A new strategy for pull-up correlated ANY_SUBLINK	Andy Fan	✉ H
43/3705	ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables	Justin Pryzby	♲ ✉ H
43/3478	AcquireExecutorLocks() and run-time pruning	Amit Langote	♲ ✉ H
43/4237	Add CANONICAL option to xmlserialize	Jim Jones	✉ H
43/4101	Add TAP tests for psql \g piped into program	Daniel Vérité	✉ H
43/4257	Add XMLText function (SQL/XML X038)	Jim Jones	✉ H
43/3889	Add document is_superuser	Kotaro Kawamoto	✉ H
43/4236	Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Lukas Fittl	✉ H
43/3388	Add foreign-server health checks infrastructure	Hayato Kuroda	✉ H
43/4278	Add information about command path and version of flex in meson output	Michael Paquier	✉ H
43/4288	Add instrumentation showing if Heap2/PRUNE records came from VACUUM or from oppo...	Peter Geoghegan	♲ ✉ H
43/3492	Add log messages when replication slots become active and inactive	Bharath Rupireddy	✉ H
43/3405	Add pg_stat_session	Rafia Sabih, Sergey Dudoladov	✉ H
43/3838	Add semi-join pushdown to postgres_fdw	Alexander Pyhalov	✉ H
43/4239	Add some checks to avoid stack overflow	Egor Chindyaskin	♲ ✉ H
43/3686	Add sortsupport for range types and btree_gist	Christoph Heiss	✉ H
43/4243	Add support for Distinct in Window aggregates	Ankit Kumar Pandey	♲ ✉ H
43/3867	Add the ability to limit the amount of memory that can be allocated to backends.	Reid Thompson	✉ H
43/4313	Allow direct lookups of SpecialJoinInfo by ojrelid	Richard Guo	♲ ✉ H
43/4198	Allow ordered partition scans in more cases	David Rowley	✉ H
43/4298	Allow pg_archivecleanup to remove backup history files	Atsushi Torikoshi	✉ H
43/4276	Allowing parallel-safe initplans	Tom Lane	✉ H
43/3665	An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions...	Bharath Rupireddy	♲ ✉ H
43/2377	Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing meta...	Justin Pryzby	✉ H
43/4335	Avoid setting restricted token in pg_upgrade	Daniel Gustafsson	✉ H
43/4319	Avoid unnecessary PlaceHolderVars for simple Vars	Richard Guo	✉ H
43/4339	Avoid unused value (src/fe_utils/print.c)	Ranier Vilela	✉ H
43/4187	BRIN - SK_SEARCHARRAY and scan key preprocessing	Tomas Vondra	✉ H
43/3949	BRIN Sort - sorting using BRIN indexes	Tomas Vondra	♲ ✉ H
43/3709	CI and test improvements	Justin Pryzby	♲ ✉ H
43/3817	COPY FROM IGNORE_ERRORS - ignores rows with errors while copying	Damir Belyalov	✉ H
43/3896	COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns	Mingli Zhang	✉ H
43/3736	Check consistency of GUC defaults between .sample.conf and pg_settings.boot_val	Kyotaro Horiguchi, Justin Pryzby	✉ H
43/4250	Check group_clause_relids to see if a clause is computable	Richard Guo	♲ ✉ H
43/4067	Check lateral references within PHVs for memoize cache keys	Richard Guo	✉ H
43/4328	Clarify the "38.10.10. Shared Memory and LWLocks" section	Aleksander Alekseev	✉ H
43/4306	Cleaning up array_in()	Tom Lane	✉ H
43/3626	Compression dictionaries	Aleksander Alekseev	♲ ✉ H
43/4300	Correct the documentation for work_mem	Sami Imseih	✉ H
43/4240	Cross-database SERIALIZABLE safe snapshots	Thomas Munro	♲ ✉ H
43/4331	Cutting support for OpenSSL 1.0.1 and 1.0.2 in 17~?	Michael Paquier	✉ H
43/4272	DecodeInterval fixes	Joseph Koshakow	♲ ✉ H
43/4321	Detect test suite sideeffects in pg_regress	Daniel Gustafsson	♲ ✉ H
43/4135	Direct SSL Connections	Greg Stark	✉ H
43/4332	Doc limitations update proposal: include out-of-line OID usage per TOAST-ed colu...		✉ H
43/4333	Document that server will start even if it's unable to open some TCP/IP ports	Gurjeet Singh	✉ H
43/2911	Dynamic result sets from procedures	Peter Eisentraut	♲ ✉ H
43/4005	Enable fine-grained control over what gets logged on connection attempt (reduces...	Sergey Dudoladov	⚠ ✉ H
43/3445	Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi, Dilip Kumar	⚠ ✉ H
43/4065	Exclusion constraints on partitioned tables	Paul Jungwirth	✉ H
43/4149	Fix assertion failure in SnapBuildInitialSnapshot()	Masahiko Sawada	✉ H
43/3966	Fix bogus error emitted by pg_recvlogical when interrupted	Bharath Rupireddy	✉ H
43/3607	Fix dsa_free() to re-bin segment	Dongming Liu	✉ H
43/4078	Fix inconsistency in reporting checkpointer stats	Nitin Jadhav	✉ H
43/4334	Fix incorrect start up costs for WindowAgg paths	David Rowley	⚠ ✉ H
43/4290	Fix siglen alignment in ltree gist	Alexander Korotkov	♲ ✉ H
43/4270	Fix the miss consideration of tuple_fraction during add_paths_to_append_rel	Andy Fan	✉ H
43/2863	Function to log backtrace of postgres processes	vigneshwaran C, Bharath Rupireddy	✉ H
43/4060	Improve WALRead() to suck data directly from WAL buffers when possible	Bharath Rupireddy	✉ H
43/3963	Improve doc for autovacuum on partitioned tables	Laurenz Albe	✉ H
43/4294	Improve list manipulation in several places	Richard Guo	✉ H
43/4253	Improve the performance of nested loop join in the case of partitioned inner tab...	Alexandr Nikulin	⚠ ✉ H
43/3461	In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ...	Kyotaro Horiguchi	♲ ✉ H
43/4337	Incremental View Maintenance (IVM), take 2		⚠ ✉ H
43/4329	Issue in postgres_fdw causing unnecessary wait for cancel request reply	Fujii Masao	✉ H
43/4325	LLVM 16	Thomas Munro	⚠ ✉ H
43/4305	Large files for relations	Thomas Munro	✉ H
43/4099	Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	♲ ✉ H
43/3983	Lockless queue of waiters based on atomic operations for LWLock	Alexander Korotkov, Pavel Borisov	♲ ✉ H
43/4291	Logging parallel worker draught	Benoit Lobréau	H
43/4168	MERGE ... RETURNING	Dean Rasheed	✉ H
43/4092	MERGE ... WHEN NOT MATCHED BY SOURCE	Dean Rasheed	✉ H
43/4076	MERGE INTO updatable_view	Dean Rasheed	♲ ✉ H
43/4221	Make async slave to wait for lsn to be replayed	Ivan Kartyshov	♲ ✉ H
43/4245	Microsecond-based timeouts	Thomas Munro	♲ ✉ H
43/4283	More OATs for ALTER TABLE	Michael Paquier	⚠ ✉ H
43/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin, Ivan Lazarev	♲ ✉ H
43/3514	Move SLRU data into the regular buffer pool	Thomas Munro	♲ ✉ H
43/4293	Move un-parenthesized syntax docs to "compatibility" for few SQL commands	Melanie Plageman	✉ H
43/4160	New [relation] options engine	Nikolay Shaplov	♲ ✉ H
43/4196	Optimize Numeric using fixed buffer reducing pallocs for small numbers	Joel Jacobson	✉ H
43/4248	Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE	David Geier	✉ H
43/4019	Partial aggregates push down	Yuki Fujii	⚠ ✉ H
43/3961	Periodic burst growth of the checkpoint_req counter on replica.	Anton Melnikov	✉ H
43/4282	Permute underscore separated components of columns before fuzzy matching	Arne Roland	✉ H
43/3986	Post-special Page Storage TDE support	David Christensen	✉ H
43/4199	Preserve subscription relation state during pg_upgrade	Julien Rouhaud	✉ H
43/3764	Push aggregation down to base relations and joins	Antonin Houska, Yuki Fujii	♲ ✉ H
43/3751	Reduce timing overhead of EXPLAIN ANALYZE using rdtsc	Andres Freund, Lukas Fittl, David Geier	✉ H
43/3701	Reducing planning time when tables have many partitions	David Rowley, Yuya Watari	✉ H
43/4336	Refactor SSL tests to not use internal test module function	Daniel Gustafsson	✉ H
43/4323	Refactor pipe_read_line as a more generic interface for reading arbitrary string...	Daniel Gustafsson	✉ H
43/4254	Remove unnecessary unbind in LDAP search+bind mode	Anatoly Zaretsky	✉ H
43/4310	Rename Event Trigger Cache context for easier memory context debugging	Daniel Gustafsson	✉ H
43/4249	Replace known_assigned_xids_lck by memory barrier	Michail Nikolaev	✉ H
43/4244	Requiring recovery.signal or standby.signal when recovering with a backup_label	Michael Paquier	✉ H
43/3784	Reuse Workers and Replication Slots during Logical Replication	Melih Mutlu	♲ ✉ H
43/4285	Revise get_cheapest_parallel_safe_total_inner	Richard Guo	✉ H
43/4004	Rework LogicalOutputPluginWriterUpdateProgress	wei wang	✉ H
43/4308	SQL:2011 application time	Paul Jungwirth	♲ ✉ H
43/3998	SetLatches()	Thomas Munro	♲ ✉ H
43/4301	Skip hidden files in serverside utilities	Daniel Gustafsson	✉ H
43/3646	Skip replicating the tables specified in except table option	vigneshwaran C	♲ ✉ H
43/4315	Slight improvement of worker_spi.c example	Aleksander Alekseev	✉ H
43/3501	Speed up releasing of locks	Andres Freund, David Rowley	♲ ✉ H
43/4327	Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases	Masahiko Sawada	✉ H
43/4284	Support Right Semi Join	Richard Guo	✉ H
43/3663	Switching XLog source from archive to streaming when primary available	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	⚠ ✉ H
43/4263	Teach WaitEventSetWait() to report multiple events on Windows	Thomas Munro	✉ H
43/3729	Testing autovacuum wraparound	Andres Freund, Masahiko Sawada	✉ H
43/4210	Track Oldest Initialized WAL Buffer Page	Bharath Rupireddy	✉ H
43/4279	Trust signalfd on illumos, again.	Thomas Munro	✉ H
43/3641	USAGE privilege on PUBLICATION	Antonin Houska	♲ ✉ H
43/4314	Unlinking Parallel Hash Join inner batch files sooner	Thomas Munro	✉ H
43/4033	Use AF_UNIX for tests on Windows (ie drop fallback TCP code)	Thomas Munro	♲ ⚠ ✉ H
43/4330	Use atomic ops for unlogged LSN	John Morris	✉ H
43/4261	Use variadic macros for syscache lookup functions	Thomas Munro	♲ ✉ H
43/3988	User functions for building SCRAM secrets	Jonathan Katz	♲ ✉ H
43/4025	Work around non-atomic read of read of control file on ext4	Thomas Munro	✉ H
43/4324	XLog size reductions: smaller XLogRecordBlockHeader	Matthias van de Meent	✉ H
43/4280	[BUG #17888] Incorrect memory access in gist__int_ops for an input array with ma...	Ankit Kumar Pandey	✉ H
43/4304	[PATCH] Add support function for containment operators	Kim Johan Andersson	✉ H
43/3310	add guc: hugepages_active	Justin Pryzby, Noriyoshi Shinoda	✉ H
43/4273	allow to upgrade publisher node	Hayato Kuroda	✉ H
43/4192	archive modules loose ends	Nathan Bossart	✉ H
43/3813	asynchronous execution support for Custom Scan	KaiGai Kohei, kazutaka onishi	✉ H
43/4144	bug: ANALYZE progress report with inheritance tables	Justin Pryzby	H
43/4252	bytea PL/Perl transform	Ivan Panchenko	♲ ✉ H
43/4287	constants for tar header offsets	Robert Haas	✉ H
43/4320	doc: Add some OID/TOAST-related limitations to the limits appendix.		✉ H
43/4242	get_extension_version	Pavel Stehule	✉ H
43/3823	logical decoding and replication of sequences, take 2	Tomas Vondra	♲ ⚠ ✉ H
43/4238	optimize several list functions with SIMD intrinsics	Nathan Bossart	✉ H
43/4267	pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value	Yugo Nagata	✉ H
43/4255	pg_dump: don't require SELECT permission for undumped extension table	Jacob Champion	♲ ✉ H
43/3874	pg_rewind WAL deletion pitfall	Alexander Kukushkin, Polina Bungina	✉ H
43/3184	pg_stats and range statistics	Egor Rogov	✉ H
43/4338	pg_upgrade --copy-file-range	Thomas Munro	✉ H
43/4200	pg_upgrade data type check connection overhead reduction	Daniel Gustafsson	♲ ✉ H
43/4105	pgbench - adding pl/pgsql versions of tests	Hannu Krosing	✉ H
43/4082	recovery modules	Nathan Bossart	✉ H
43/1608	session variables, LET command	Pavel Stehule	♲ ⚠ ✉ H
43/4212	some namespace.c refactoring	Peter Eisentraut	✉ H
43/4159	stopgap fix for signal handling during restore_command	Nathan Bossart	✉ H
43/4292	vector search support	Nathan Bossart	♲ ✉ H
43/3482	warn if GUC set to an invalid shared library	Justin Pryzby	✉ H
Waiting on Author
43/3594	64-bit XIDs	Fedor Sigaev, Alexander Korotkov, Aleksander Alekseev, Konstantin Knizhnik, Nikita Glukhov, Yura Sokolov, Maxim Orlov, Pavel Borisov	♲ ✉ H
43/3727	ALTER TABLE SET ACCESS METHOD on partitioned tables	Justin Pryzby, Soumyadeep Chakraborty, Soumyadeep Chakraborty	✉ H
43/4158	Add <> support to sepgsql_restorecon	Ted X Toth	✉ H
43/4269	Allow Postgres to pick an unused port to listen	Yurii Rashkovskii	✉ H
43/4225	Allow logical replication via inheritance root table	Jacob Champion	♲ ⚠ ✉ H
43/3539	Allow parallel plan for referential integrity checks	Frédéric Yhuel	✉ H
43/3750	Eliminating SPI from RI triggers	Amit Langote	♲ ✉ H
43/3857	Enable jitlink as an alternative jit linker of legacy Rtdyld and add riscv jitti...	Alex Fan	⚠ ✉ H
43/3976	Fix order of checking ICU options in initdb and create database	Marina Polyakova	♲ ✉ H
43/3615	Fix recovery conflict SIGUSR1 handling	Thomas Munro	♲ ✉ H
43/3890	Fix tab completion MERGE	Kotaro Kawamoto	✉ H
43/3687	Improve dead tuple storage for lazy vacuum	Masahiko Sawada, John Naylor	♲ ✉ H
43/4208	Improvements to Meson docs	Samay Sharma	♲ ✉ H
43/3936	Make ON_ERROR_STOP stop on shell script failure	Tatsuhiro Nakamori	♲ ✉ H
43/3956	Multi-version ICU	Thomas Munro	♲ ✉ H
43/4123	Named Operators	Gurjeet Singh	✉ H
43/3978	Prefetch the next tuple's memory during seqscans	David Rowley, Thomas Munro	♲ ✉ H
43/3777	Provide the facility to set binary format output for specific OID's per session	Dave Cramer	⚠ ✉ H
43/4103	RADIUS tests and improvements	Thomas Munro	♲ ✉ H
43/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrei Lepikhov	♲ ✉ H
43/3982	ResourceOwner refactoring	Heikki Linnakangas	✉ H
43/4100	Sampling-based timing for EXPLAIN ANALYZE	Lukas Fittl	♲ ✉ H
43/4119	Some revises in adding sorting path	Richard Guo	✉ H
43/3984	Split index and table statistics into different types of stats	Bertrand Drouvot	♲ ⚠ ✉ H
43/3595	Support logical replication of DDL commands	Zheng Li, vigneshwaran C, Ajin Cherian, Hou Zhijie, Runqi Tian	✉ H
43/3985	TDE key management patches	Bruce Momjian, David Christensen	♲ ✉ H
43/4233	Use libpq single row mode for FETCH_COUNT when a cursor cannot be used	Daniel Vérité	♲ ⚠ ✉ H
43/4227	[PATCH v2] Time option added to psql prompt (%T)	Kirk Wolak	✉ H
43/3869	cataloguing NOT NULL constraints	Álvaro Herrera	♲ ⚠ ✉ H
43/3568	doc: PQexecParams binary handling example for REAL data type	Mark Wong	♲ ✉ H
43/3704	explain analyze rows=%.0f	Ibrar Ahmed	⚠ ✉ H
43/3672	nbtree performance improvements through specialization on key shape	Matthias van de Meent	♲ ⚠ ✉ H
43/4175	pg_usleep for multisecond delays	Nathan Bossart	✉ H
43/3739	pg_visibility's pg_check_visible() yields false positive when working in paralle...	Daniel Shelepanov	✉ H
43/4053	psql: Add tab-complete for optional view parameters	Christoph Heiss	✉ H
43/3448	reduce impact of lengthy startup and checkpoint tasks	Nathan Bossart	✉ H
43/4035	suppressing useless wakeups in logical/worker.c	Nathan Bossart	✉ H

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author