PostgreSQL Patch Tester

Current commitfest | Next commitfest | FAQ

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.

Ready for Committer
41/3464	Add Amcheck option for checking unique constraints in btree indexes	Anastasia Lubennikova, Maxim Orlov, Pavel Borisov	✉ H
41/3688	Add JIT deform_counter	Dmitry Dolgov	✉ H
41/3511	Add non-blocking version of PQcancel	Jelte Fennema	✉ H
41/3733	Amcheck verification of GiST and GIN	Heikki Linnakangas, Andrey Borodin, Grigory Kryachko	✉ H
41/4102	Doc: Rework contrib appendix -- informative titles, tweaked sentences	Karl Pinc	✉ H
41/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	✉ H
41/3662	Fix assertion failure with barriers in parallel hash join	Thomas Munro, Melanie Plageman	✉ H
41/4047	Generating code for query jumbling through gen_node_support.pl	Michael Paquier	✉ H
41/4014	Introduce a new view for checkpointer related stats	Bharath Rupireddy	✉ H
41/3716	Let libpq reject unexpected authentication requests	Jacob Champion	✉ H
41/2900	On client login event trigger	Konstantin Knizhnik, Greg Nancarrow, Mikhail Gribkov	✉ H
41/4099	POC: Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	✉ H
41/2903	Parallel Hash Full Join	Melanie Plageman	✉ H
41/3965	Simplify standby state machine a bit in WaitForWALToBecomeAvailable()	Bharath Rupireddy	✉ H
41/3654	Support % wildcard in extension upgrade scripts	Sandro Santilli	✉ H
41/3679	Support load balancing in libpq	Jelte Fennema	✉ H
41/3837	TAP output format for pg_regress	Daniel Gustafsson	✉ H
41/4040	Transaction timeout	Andrey Borodin	✉ H
41/3707	Use fadvise in wal replay	Kirill Reshke, Jakub Wartak	✉ H
41/3990	Use the system CA pool for certificate verification	Jacob Champion, Thomas Habets	✉ H
41/2573	pg_dump - read data for some options from external file	Pavel Stehule	✉ H
41/3503	pg_receivewal fail to streams when the partial file to write is not fully initia...	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
41/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	✉ H
41/3448	reduce impact of lengthy startup and checkpoint tasks	Nathan Bossart	✉ H
Needs review
41/3727	ALTER TABLE SET ACCESS METHOD on partitioned tables	Soumyadeep Chakraborty, Soumyadeep Chakraborty	✉ H
41/3705	ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables	Justin Pryzby	✉ H
41/4023	Ability to reference other extensions by schema in extension scripts	Regina Obe	✉ H
41/3962	Add EXPLAIN option GENERIC_PLAN for parameterized queries	Laurenz Albe	✉ H
41/3758	Add OR REPLACE option for CREATE OPERATOR	Svetlana Derevyanko	✉ H
41/4073	Add SHELL_EXIT_CODE variable to psql	Corey Huinker	✉ H
41/3659	Add SPLIT PARTITION/MERGE PARTITIONS commands	Dmitry Koval	✉ H
41/4101	Add TAP tests for psql \g piped into program	Daniel Vérité	✉ H
41/4096	Add a hook to allow modification of the ldapbindpasswd	Andrew Dunstan, John Naylor	✉ H
41/3889	Add document is_superuser	Kotaro Kawamoto	✉ H
41/3388	Add foreign-server health checks infrastructure	Hayato Kuroda	✉ H
41/4071	Add function to_oct	Eric Radman	✉ H
41/3617	Add index scan progress to pg_stat_progress_vacuum	Sami Imseih	✉ H
41/3492	Add log messages when replication slots become active and inactive	Bharath Rupireddy	✉ H
41/3838	Add semi-join pushdown to postgres_fdw	Alexander Pyhalov	✉ H
41/3686	Add sortsupport for range types and btree_gist	Christoph Heiss	✉ H
41/4064	Add sslmode "no-clientcert" to avoid auth failure in md5/scram connections	Jim Jones	✉ H
41/3822	Add support for DEFAULT specification in COPY FROM	Israel Barth	✉ H
41/3272	Add system view tracking shared buffer actions	Melanie Plageman	✉ H
41/3867	Add the ability to limit the amount of memory that can be allocated to backends.	Reid Thompson	✉ H
41/3840	Allow logical replication to copy tables in binary format	Melih Mutlu	✉ H
41/4075	Allow tailoring of ICU locales with custom rules	Peter Eisentraut	✉ H
41/4051	Allow tests to pass in OpenSSL FIPS mode	Peter Eisentraut	✉ H
41/3665	An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions...	Bharath Rupireddy	✉ H
41/2377	Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing meta...	Justin Pryzby	✉ H
41/3893	Avoid use deprecated Windows Memory API	Ranier Vilela	✉ H
41/3709	CI and test improvements	Justin Pryzby	✉ H
41/3817	COPY FROM IGNORE_ERRORS - ignores rows with errors while copying	Damir Belyalov	✉ H
41/3896	COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns	Mingli Zhang	✉ H
41/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby, Alexander Pyhalov	✉ H
41/3736	Check consistency of GUC defaults between .sample.conf and pg_settings.boot_val	Kyotaro Horiguchi, Justin Pryzby	✉ H
41/4067	Check lateral references within PHVs for memoize cache keys	Richard Guo	✉ H
41/3970	Code checks for App Devs, using new options for transaction behavior	Simon Riggs	✉ H
41/3626	Compression dictionaries for JSONB	Aleksander Alekseev	✉ H
41/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	✉ H
41/3781	Cygwin cleanup	Thomas Munro, Justin Pryzby	✉ H
41/3451	Daitch-Mokotoff soundex	Dag Lem	✉ H
41/3623	Data is copied twice when specifying both child and parent table in publication	wei wang, Yu Shi	✉ H
41/3996	Direct I/O (developer-only feature)	Andres Freund, Thomas Munro	✉ H
41/4012	Disable STARTUP_PROGRESS_TIMEOUT in standby mode	Simon Riggs, Bharath Rupireddy	✉ H
41/2911	Dynamic result sets from procedures	Peter Eisentraut	✉ H
41/3857	Enable jitlink as an alternative jit linker of legacy Rtdyld and add riscv jitti...	Alex Fan	✉ H
41/4065	Exclusion constraints on partitioned tables	Paul Jungwirth	✉ H
41/4085	Exit walsender before confirming remote flush in logical replication	Hayato Kuroda	✉ H
41/4068	Fix ParamPathInfo for union-all AppendPath	Richard Guo	✉ H
41/3966	Fix bogus error emitted by pg_recvlogical when interrupted	Bharath Rupireddy	✉ H
41/3607	Fix dsa_free() to re-bin segment	Dongming Liu	✉ H
41/4078	Fix inconsistency in reporting checkpointer stats	Nitin Jadhav	✉ H
41/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	✉ H
41/2863	Function to log backtrace of postgres processes	vignesh C, Bharath Rupireddy	✉ H
41/3849	HOT chain validation in verify_heapam()	Himanshu Upadhyaya	✉ H
41/4060	Improve WALRead() to suck data directly from WAL buffers when possible	Bharath Rupireddy	✉ H
41/3963	Improve doc for autovacuum on partitioned tables	Laurenz Albe	✉ H
41/3461	In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ...	Kyotaro Horiguchi	✉ H
41/3983	Lockless queue of waiters based on atomic operations for LWLock	Alexander Korotkov, Pavel Borisov	✉ H
41/4004	Logical replication timeout problem	wei wang	✉ H
41/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	✉ H
41/3740	Minimal logical decoding on standbys	Bertrand Drouvot	✉ H
41/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin, Ivan Lazarev	✉ H
41/3919	Move backup-related code to xlogbackup.c/.h	Bharath Rupireddy	✉ H
41/3735	New hooks in the connection path	Bertrand Drouvot	✉ H
41/4069	Non-replayable WAL records through overflows and >MaxAllocSize lengths	Matthias van de Meent	✉ H
41/4018	Operation log for major operations	Dmitry Koval	✉ H
41/4034	Optimizing Node Files Support	Ranier Vilela	✉ H
41/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	✉ H
41/4019	Partial aggregates push down	Yuki Fujii	✉ H
41/3821	Patch to implement missing join selectivity estimation for range types	Mahmoud SAKR, Diogo Repas, Maxime Schoemans, Zhicheng Luo	✉ H
41/3961	Periodic burst growth of the checkpoint_req counter on replica.	Anton Melnikov	✉ H
41/3986	Post-special Page Storage TDE support	David Christensen	✉ H
41/3764	Push aggregation down to base relations and joins	Yuki Fujii	✉ H
41/4011	Re: pg_upgrade test failure	Thomas Munro	✉ H
41/3751	Reduce timing overhead of EXPLAIN ANALYZE using rdtsc	Andres Freund, Lukas Fittl, David Geier	✉ H
41/4029	Reduce wakeup on idle for bgwriter & walwriter for >5s	Simon Riggs	✉ H
41/3701	Reducing planning time when tables have many partitions	Yuya Watari	✉ H
41/3993	Refactor relation extension, faster COPY	Andres Freund	✉ H
41/3782	Refactoring postgres_fdw/connection.c	Fujii Masao	✉ H
41/3894	Remove dead macro exec_subplan_get_plan	Mingli Zhang	✉ H
41/3784	Reuse Workers and Replication Slots during Logical Replication	Melih Mutlu	✉ H
41/3935	Rework collation code	Jeff Davis, Thomas Munro	✉ H
41/4086	SQL/JSON	Amit Langote, Nikita Glukhov	✉ H
41/4100	Sampling-based timing for EXPLAIN ANALYZE	Lukas Fittl	✉ H
41/3998	SetLatches()	Thomas Munro	✉ H
41/3878	Simplify find_my_exec by using realpath(3)	Tom Lane	✉ H
41/3646	Skip replicating the tables specified in except table option	vignesh C	✉ H
41/3501	Speed up releasing of locks	Andres Freund, David Rowley	✉ H
41/3984	Split index and table statistics into different types of stats	Bertrand Drouvot	✉ H
41/4092	Support MERGE ... WHEN NOT MATCHED BY SOURCE	Dean Rasheed	✉ H
41/4076	Support MERGE into views	Dean Rasheed	✉ H
41/3595	Support logical replication of DDL commands	Zheng Li, vignesh C, Ajin Cherian, Hou Zhijie, Runqi Tian	✉ H
41/3663	Switching XLog source from archive to streaming when primary available	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
41/4046	Test for function error in logrep worker	Anton Melnikov	✉ H
41/3581	Time-delayed logical replication subscriber	Euler Taveira	✉ H
41/3718	Transparent column encryption	Peter Eisentraut	✉ H
41/3765	Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Onder Kalaci	✉ H
41/3988	User functions for building SCRAM secrets	Jonathan Katz	✉ H
41/3235	Using each rel as both outer and inner for anti-joins	Richard Guo	✉ H
41/4025	Work around non-atomic read of read of control file on ext4	Thomas Munro	✉ H
41/4088	add PROCESS_MAIN to VACUUM	Nathan Bossart	✉ H
41/3813	asynchronous execution support for Custom Scan	KaiGai Kohei, kazutaka onishi	✉ H
41/3434	disallow HEAP_XMAX_COMMITTED and HEAP_XMAX_IS_LOCKED_ONLY	Nathan Bossart	✉ H
41/3790	doc: mention CREATE+ATTACH PARTITION as an alternative to CREATE..PARTITION OF	Justin Pryzby	H
41/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	✉ H
41/3699	generate_series in selected timezone, date_add in selected timezone	Gurjeet Singh, Przemysław Sztoch	✉ H
41/3823	logical decoding and replication of sequences, take 2	Tomas Vondra	✉ H
41/3672	nbtree performance improvements through specialization on key shape	Matthias van de Meent	✉ H
41/3874	pg_rewind WAL deletion pitfall	Alexander Kukushkin, Polina Bungina	✉ H
41/3670	pg_rewind: warn when checkpoint hasn't happened after promotion	James Coleman	✉ H
41/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	✉ H
41/3260	pgbench: using prepared BEGIN statement in a pipeline could cause an error	Yugo Nagata	✉ H
41/1608	session variables, LET command	Pavel Stehule	✉ H
41/4035	suppressing useless wakeups in logical/worker.c	Nathan Bossart	✉ H
41/3482	warn if GUC set to an invalid shared library	Justin Pryzby	✉ H
Waiting on Author
41/3489	64-bit SLRU page numbers (independent part of 64-bit XIDs)	Fedor Sigaev, Alexander Korotkov, Aleksander Alekseev, Konstantin Knizhnik, Nikita Glukhov, Yura Sokolov, Maxim Orlov, Pavel Borisov	✉ H
41/4038	ANY_VALUE aggregate	Vik Fearing	✉ H
41/3478	AcquireExecutorLocks() and run-time pruning	Amit Langote	✉ H
41/3594	Add 64-bit XIDs into PostgreSQL 16	Fedor Sigaev, Alexander Korotkov, Aleksander Alekseev, Konstantin Knizhnik, Nikita Glukhov, Yura Sokolov, Maxim Orlov, Pavel Borisov	✉ H
41/4022	Add <> support to sepgsql_restorecon		✉ H
41/3571	Add LZ4 compression in pg_dump	Georgios Kokolatos, Rachel Heaton	✉ H
41/3405	Add connection active, idle time to pg_stat_activity	Rafia Sabih, Sergey Dudoladov	✉ H
41/3634	Add initdb option to initialize cluster with non-standard xid/mxid/mxoff.	Maxim Orlov, Pavel Borisov	✉ H
41/3756	Add last_vacuum_index_scans in pg_stat_all_tables	Ken Kato	✉ H
41/3882	Adding CommandID to heap xlog records	Anastasia Lubennikova, Matthias van de Meent	✉ H
41/3949	BRIN Sort - sorting using BRIN indexes	Tomas Vondra	✉ H
41/3870	Better infrastructure for automated testing of concurrency issues	Alexander Korotkov	✉ H
41/4074	CAST( ... ON DEFAULT)	Corey Huinker	✉ H
41/3991	CF App: add "Returned: Needs more interest" close status	Jacob Champion	✉ H
41/3631	Completed unaccent dictionary with many missing characters	Przemysław Sztoch	✉ H
41/4042	Create visible links for HTML elements that have an id to make them discoverable...	Brar Piening	✉ H
41/3750	Eliminating SPI from RI triggers	Amit Langote	✉ H
41/4005	Enable fine-grained control over what gets logged on connection attempt (reduces...	Sergey Dudoladov	✉ H
41/3445	Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi, Dilip Kumar	✉ H
41/3842	Fix alter subscription concurrency errors	Jelte Fennema	✉ H
41/3975	Fix database creation during installchecks for ICU cluster	Marina Polyakova	✉ H
41/3976	Fix order of checking ICU options in initdb and create database	Marina Polyakova	✉ H
41/4059	Fix progress report of CREATE INDEX for nested partitioned tables	Ilya Gladyshev	✉ H
41/3615	Fix recovery conflict SIGUSR1 handling	Thomas Munro	✉ H
41/3890	Fix tab completion MERGE	Kotaro Kawamoto	✉ H
41/4013	GUC for temporary disabling event triggers	Daniel Gustafsson	✉ H
41/3687	Improve dead tuple storage for lazy vacuum	Masahiko Sawada	✉ H
41/3771	Introduce array_shuffle() and array_sample() functions	Martin Kalcher	✉ H
41/3142	Logging plan of the currently running query	atsushi torikoshi	✉ H
41/3936	Make ON_ERROR_STOP stop on shell script failure	Tatsuhiro Nakamori	✉ H
41/3806	Minimizing calls to SubTransSetParent()	Simon Riggs	✉ H
41/3514	Move SLRU data into the regular buffer pool	Thomas Munro	✉ H
41/3956	Multi-version ICU	Thomas Munro	✉ H
41/3536	New [relation] options engine	Nikolay Shaplov	✉ H
41/3783	Page compression for OLTP	Chen huajun	✉ H
41/3621	Perform streaming logical transactions by background workers	Hou Zhijie	✉ H
41/3490	Pluggable toaster	Fedor Sigaev, Nikita Glukhov, Oleg Bartunov, Nikita Malakhov	✉ H
41/3777	Provide the facility to set binary format output for specific OID's per session	Dave Cramer	✉ H
41/3941	Pulling up direct-correlated ANY_SUBLINK	Andy Fan	✉ H
41/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	✉ H
41/3545	Report checkpoint progress with pg_stat_progress_checkpoint	Nitin Jadhav	✉ H
41/3982	ResourceOwner refactoring	Heikki Linnakangas	✉ H
41/3985	TDE key management patches	Bruce Momjian, David Christensen	✉ H
41/3729	Testing autovacuum wraparound	Andres Freund, Masahiko Sawada	✉ H
41/3641	USAGE privilege on PUBLICATION	Antonin Houska	✉ H
41/4090	Underscores in numeric literals	Peter Eisentraut	✉ H
41/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	✉ H
41/4033	Use AF_UNIX for tests on Windows (ie drop fallback TCP code)	Thomas Munro	✉ H
41/3951	Windows filesystem support improvements	Thomas Munro	✉ H
41/3869	cataloguing NOT NULL constraints	Álvaro Herrera	✉ H
41/3987	heapgettup() refactoring	Melanie Plageman	✉ H
41/3184	pg_stats and range statistics	Egor Rogov	✉ H
41/3739	pg_visibility's pg_check_visible() yields false positive when working in paralle...	Daniel Shelepanov	✉ H
41/3227	pgbench: add multiconnect support	David Christensen	✉ H
41/3392	postgres_fdw: commit remote (sub)transactions in parallel during pre-commit	Etsuro Fujita	✉ H
41/3140	psql - refactor echo code	Fabien Coelho	✉ H
41/4053	psql: Add tab-complete for optional view parameters	Christoph Heiss	✉ H
41/4082	recovery modules	Nathan Bossart	✉ H
41/3877	vacuumlo: add test to vacuumlo for test coverage	DongWook Lee	✉ H
41/3833	xml2: add test for coverage	DongWook Lee	✉ H

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author