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
39/3464	Add Amcheck option for checking unique constraints in btree indexes	Anastasia Lubennikova, Maxim Orlov, Pavel Borisov	✉ H
39/3405	Add connection active, idle time to pg_stat_activity	Rafia Sabih, Sergey Dudoladov	✉ H
39/3511	Add non-blocking version of PQcancel	Jelte Fennema	✉ H
39/3713	Allow pageinspect's bt_page_stats function to return a set of rows instead of a ...	Hamid Akhtar	✉ H
39/3496	Avoid erroring out when unable to remove or parse logical rewrite files to save ...	Nathan Bossart, Bharath Rupireddy	✉ H
39/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	✉ H
39/3662	Fix assertion failure with barriers in parallel hash join	Thomas Munro, Melanie Plageman	✉ H
39/3271	KnownAssignedXidsGetAndSetXmin performance	Michail Nikolaev	✉ H
39/2900	On client login event trigger	Konstantin Knizhnik, Greg Nancarrow	✉ H
39/2903	Parallel Hash Full Join	Melanie Plageman	✉ H
39/3608	Unit tests for SLRU	Aleksander Alekseev	✉ H
39/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	✉ H
39/3584	Use "WAL segment" instead of "log segment" consistently in user-facing messages	Bharath Rupireddy	✉ H
39/3489	XID formatting and SLRU refactorings (Independent part of: Add 64-bit XIDs into ...	Fedor Sigaev, Alexander Korotkov, Aleksander Alekseev, Konstantin Knizhnik, Nikita Glukhov, Yura Sokolov, Maxim Orlov, Pavel Borisov	✉ H
39/3704	explain analyze rows=%.0f	Ibrar Ahmed	✉ H
39/2716	fix spinlock contention in LogwrtResult	Álvaro Herrera	✉ H
39/3573	jit_warn_above_fraction parameter	Magnus Hagander	✉ H
39/2573	pg_dump - read data for some options from external file	Pavel Stehule	✉ H
39/3048	pg_stat_statements: Track statement entry timestamp	Andrei Zubkov	✉ H
39/3140	psql - refactor echo code	Fabien Coelho	✉ H
39/3609	use has_privs_of_role() for pg_hba.conf	Nathan Bossart	✉ H
Needs review
39/3727	ALTER TABLE SET ACCESS METHOD on partitioned tables	Soumyadeep Chakraborty, Soumyadeep Chakraborty	✉ H
39/3705	ALTER TABLE fails to use a BulkInsertState for toast tables	Justin Pryzby	✉ H
39/3478	AcquireExecutorLocks() and run-time pruning	Amit Langote	✉ H
39/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
39/3736	Add GUC value check between .sample and pg_settings.boot_val	Kyotaro Horiguchi	✉ H
39/3688	Add JIT deform_counter	Dmitry Dolgov	✉ H
39/3758	Add OR REPLACE option for CREATE OPERATOR	Svetlana Derevyanko	✉ H
39/3659	Add SPLIT PARTITION/MERGE PARTITIONS commands	Dmitry Koval	✉ H
39/3073	Add callback table access method to reset filenode when dropping relation	Mats Kindahl	✉ H
39/3684	Add checks on search_path for IMMUTABLE and SECURITY DEFINER functions	Greg Stark	✉ H
39/3388	Add foreign-server health checks infrastructure	Hayato Kuroda	✉ H
39/3634	Add initdb option to initialize cluster with non-standard xid/mxid/mxoff.	Maxim Orlov, Pavel Borisov	✉ H
39/3627	Add internal Numeric to Uint64 conversion function.	Amul Sul	✉ H
39/3666	Add last failed connection error message to pg_stat_wal_receiver	Bharath Rupireddy	✉ H
39/3756	Add last_vacuum_index_scans in pg_stat_all_tables	Ken Kato	✉ H
39/3561	Add native windows on arm64 support	Niyas Sait	✉ H
39/3787	Add parallel counters to pg_stat_statements	Daymel Bonne, Anthony Sotolongo León	✉ H
39/3272	Add system view tracking shared buffer actions	Melanie Plageman	✉ H
39/3575	Added Windows with MinGW environment in Cirrus CI	Melih Mutlu	✉ H
39/2992	Allow batched insert during cross-partition updates	Amit Langote	✉ H
39/3558	Allow file inclusion in pg_hba and pg_ident files	Julien Rouhaud	✉ H
39/3539	Allow parallel plan for referential integrity checks	Frédéric Yhuel	✉ H
39/3743	Allow specification of custom slot for custom nodes	Alexander Korotkov	✉ H
39/3374	Allows database-specific role memberships	Kenaniah Cerny	✉ H
39/3733	Amcheck verification of GiST and GIN	Heikki Linnakangas, Andrey Borodin, Grigory Kryachko	✉ H
39/3665	An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions...	Bharath Rupireddy	✉ H
39/3347	Atomic rename feature for Windows	Victor Spirin	✉ H
39/3800	Avoid Copying WAL Segments Before Divergence to Speed Up pg_rewind	vignesh ravichandran, Justin Kwan	✉ H
39/3772	BCP 47 locale names for Windows	Thomas Munro	✉ H
39/3483	BufferAlloc: don't take two simultaneous locks	Yura Sokolov	✉ H
39/3767	Bug: Reading from single byte character column type may cause out of bounds memo...		✉ H
39/3709	CI and test improvements	Justin Pryzby	✉ H
39/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby, Alexander Pyhalov	✉ H
39/3693	Clarify Routines and Extension Membership	David Johnston	✉ H
39/3763	Cleaning up historical portability baggage	Thomas Munro	✉ H
39/3762	Compilation issue on Solaris.	Ibrar Ahmed	H
39/3631	Completed unaccent dictionary with many missing characters	Przemysław Sztoch	✉ H
39/3626	Compression dictionaries for JSONB	Aleksander Alekseev	✉ H
39/3776	Create subscription stats entry at CREATE SUBSCRIPTION	Masahiko Sawada	✉ H
39/3781	Cygwin cleanup	Thomas Munro	✉ H
39/3451	Daitch-Mokotoff soundex	Dag Lem	✉ H
39/3586	Doc about how to set max_wal_senders when setting minimal wal_level	Japin Li	✉ H
39/3759	Enables to call UnregisterXactCallback() in CallXactCallback()	Hao Wu	✉ H
39/3445	Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi, Dilip Kumar	✉ H
39/3650	Expand palloc/pg_malloc API	Peter Eisentraut	✉ H
39/3563	Expose authenticated identity to extensions and triggers	Jacob Champion	✉ H
39/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	✉ H
39/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	✉ H
39/3224	Fix ExecRTCheckPerms() inefficiency with many prunable partitions	Amit Langote	✉ H
39/3796	Fix GIN indexes cost estimatiopn	Ronan Dunklau	✉ H
39/3694	Fix description of how the default user name is chosen	David Johnston	✉ H
39/3607	Fix dsa_free() to re-bin segment	Dongming Liu	✉ H
39/2864	Fix pg_rewind race condition just after promotion	Heikki Linnakangas	✉ H
39/3615	Fix recovery conflict SIGUSR1 handling	Thomas Munro	✉ H
39/3657	Fix the statistics gathering in case of commit and chain	Lætitia AVROT	✉ H
39/2863	Function to log backtrace of postgres processes	vignesh C	✉ H
39/3443	GUC to allow logging WAL files during recovery from archive/stream/etc	Bharath Rupireddy	✉ H
39/3807	Generalize ereport_startup_progress infrastructure Inbox	Bharath Rupireddy	✉ H
39/3610	Handle infinite recursion in logical replication setup	vignesh C	✉ H
39/3791	Hash index build performance tweak from sorting, part II	Simon Riggs	✉ H
39/3649	Improve TAP tests of pg_upgrade for cross-version tests	Michael Paquier	✉ H
39/3687	Improve dead tuple storage for lazy vacuum	Masahiko Sawada	✉ H
39/3779	Improve description of XLOG_RUNNING_XACTS	Masahiko Sawada	✉ H
39/3461	In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ...	Kyotaro Horiguchi	✉ H
39/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	✉ H
39/3771	Introduce array_shuffle() and array_sample() functions	Martin Kalcher	✉ H
39/3780	Introduce wait_for_subscription_sync for TAP tests	Masahiko Sawada	✉ H
39/3071	Lazy JIT IR code generation to increase JIT speed with partitions	Luc Vlaming	✉ H
39/3716	Let libpq reject unexpected authentication requests	Jacob Champion	✉ H
39/3142	Logging plan of the currently running query	atsushi torikoshi	✉ H
39/2490	Make message at end-of-recovery less scary	Kyotaro Horiguchi	✉ H
39/3695	Make selectivity example match wording	David Johnston	✉ H
39/3755	Making Vars outer-join aware	Tom Lane	✉ H
39/3802	Making autovacuum logs indicate if insert-based threshold was the triggering con...	Peter Geoghegan	✉ H
39/3785	Maximize page freezing	Simon Riggs	✉ H
39/3806	Minimizing calls to SubTransSetParent()	Simon Riggs	✉ H
39/3799	Missing CFI in iterate_word_similarity()	Robins Tharakan	✉ H
39/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	✉ H
39/3514	Move SLRU data into the regular buffer pool	Thomas Munro	✉ H
39/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	✉ H
39/3536	New [relation] options engine	Nikolay Shaplov	✉ H
39/3590	Nonreplayable XLog records by means of overflows and >MaxAllocSize lengths	Matthias van de Meent	✉ H
39/3676	OAT_POST_CREATE object visibility	Mary Xu	✉ H
39/3568	PQexecParams binary handling example for REAL data type	Mark Wong	✉ H
39/3783	Page compression for OLTP		✉ H
39/3794	Parallel Aggregates for string_agg and array_agg	David Rowley	✉ H
39/3621	Perform streaming logical transactions by background workers	Hou Zhijie	✉ H
39/3490	Pluggable toaster	Fedor Sigaev, Nikita Glukhov, Oleg Bartunov, Nikita Malakhov	✉ H
39/3245	Postgres picks suboptimal index after building extended statistics	Andrey Lepikhov	✉ H
39/3543	Preventing indirection for IndexPageGetOpaque for known-size page special areas	Matthias van de Meent	✉ H
39/3777	Provide the facility to set binary format output for specific OID's per session	Dave Cramer	✉ H
39/3764	Push aggregation down to base relations and joins	Yuki Fujii	✉ H
39/3810	Reduce the chunk header sizes on all memory context types	Andres Freund, David Rowley	✉ H
39/3751	Reduce timing overhead of EXPLAIN ANALYZE using rdtsc	Andres Freund, Lukas Fittl	✉ H
39/3701	Reducing planning time when tables have many partitions	Yuya Watari	✉ H
39/3599	Refactor add_path for clarity and extensibility	Nils Dijk	✉ H
39/3808	Refactor backup related code	Bharath Rupireddy	✉ H
39/3782	Refactoring postgres_fdw/connection.c	Fujii Masao	✉ H
39/3598	Remove pgwin32_is_junction(), add lstat() for Windows	Thomas Munro	✉ H
39/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	✉ H
39/3812	Renumber confusing value for GUC_UNIT_BYTE	Justin Pryzby	H
39/3784	Reuse Workers and Replication Slots during Logical Replication	Melih Mutlu	✉ H
39/3804	SI-read predicate locks on materialized views	Yugo Nagata	✉ H
39/3703	SYSTEM_USER reserved word implementation	Bertrand Drouvot	✉ H
39/2377	Show shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata and...	Justin Pryzby	✉ H
39/3646	Skip replicating the tables specified in except table option	vignesh C	✉ H
39/3501	Speed up releasing of locks	Andres Freund, David Rowley	✉ H
39/3792	Subtrans performance smoothing	Simon Riggs	✉ H
39/3601	Summary Sort workers Stats in EXPLAIN ANALYZE	Jian Guo	✉ H
39/3654	Support % wildcard in extension upgrade scripts	Sandro Santilli	✉ H
39/3679	Support load balancing in libpq	Jelte Fennema	✉ H
39/3748	Support multiple password-based authentication tokens concurrently	Joshua Brindle	✉ H
39/3520	Suppressing useless wakeups in walreceiver	Thomas Munro	✉ H
39/3663	Switching XLog source from archive to streaming when primary available	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
39/3801	Teach VACUUM to disregard long running transactions when determining XID cutoff ...	Peter Geoghegan	✉ H
39/3628	Teach pg_waldump to extract FPIs from the WAL stream	David Christensen	✉ H
39/3729	Testing autovacuum wraparound	Andres Freund, Masahiko Sawada	✉ H
39/3581	Time-delayed logical replication subscriber	Euler Taveira	✉ H
39/3718	Transparent column encryption	Peter Eisentraut	✉ H
39/3641	USAGE privilege on PUBLICATION	Antonin Houska	✉ H
39/3707	Use fadvise in wal replay	Kirill Reshke, Jakub Wartak	✉ H
39/3765	Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher	Onder Kalaci	✉ H
39/3803	Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid ...	Bharath Rupireddy	✉ H
39/3235	Using each rel as both outer and inner for anti-joins	Richard Guo	✉ H
39/3450	WIN32 pg_import_system_collations	Juanjo Santamaria Flecha	✉ H
39/3524	[PATCH] Equivalence Class Filters	David Rowley, Andy Fan	✉ H
39/3389	add checkpoint stats of snapshot and mapping files of pg_logical dir	Bharath Rupireddy	✉ H
39/3492	add log messages when replication slots become active and inactive	Bharath Rupireddy	✉ H
39/3724	add test: pg_rowlocks extension	DongWook Lee	✉ H
39/3813	asynchronous execution support for Custom Scan	KaiGai Kohei, kazutaka onishi	✉ H
39/3434	disallow HEAP_XMAX_COMMITTED and HEAP_XMAX_IS_LOCKED_ONLY	Nathan Bossart	✉ H
39/3790	doc: mention CREATE+ATTACH PARTITION as an alternative to CREATE..PARTITION OF	Justin Pryzby	H
39/3409	explain_regress, explain(MACHINE), and default to explain(BUFFERS)	Justin Pryzby, Nikolay Samokhvalov	✉ H
39/3699	generate_series in selected timezone, date_add in selected timezone, date_trunc ...	Przemysław Sztoch	✉ H
39/3744	grant-level NOINHERIT option	Robert Haas	✉ H
39/3797	improve information about psqlrc on windows	Robert Treat	✉ H
39/3711	making relfilenodes 56 bit	Dilip Kumar	✉ H
39/3472	more descriptive message for process termination due to max_slot_wal_keep_size	Kyotaro Horiguchi	✉ H
39/3672	nbtree performance improvements through specialization on key shape	Matthias van de Meent	✉ H
39/3537	new diagnostic items for the dynamic sql	Dinesh Kumar	✉ H
39/3805	old_snapshot: add test for coverage	DongWook Lee	✉ H
39/3452	partIndexlist for partitioned tables uniqueness	Arne Roland	✉ H
39/3745	pg_auth_members.grantor is bunk	Robert Haas	✉ H
39/3811	pg_get_constraintdef: Schema qualify foreign tables unless pretty printing is en...	Lukas Fittl	✉ H
39/3503	pg_receivewal fail to streams when the partial file to write is not fully initia...	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ H
39/3670	pg_rewind: warn when checkpoint hasn't happened after promotion	James Coleman	✉ H
39/3760	pg_stat_activity: avoid showing state=active with wait_event=ClientRead	Yura Sokolov, Mikhail Zhilin	✉ H
39/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	✉ H
39/3184	pg_stats and range statistics	Egor Rogov	✉ H
39/3739	pg_visibility's pg_check_visible() yields false positive when working in paralle...	Daniel Shelepanov	✉ H
39/3667	pg_walcleaner - new tool to detect, archive and delete the unneeded wal files	Bharath Rupireddy	✉ H
39/3227	pgbench: add multiconnect support	David Christensen	✉ H
39/3260	pgbench: using prepared BEGIN statement in a pipeline could cause an error	Yugo Nagata	✉ H
39/3793	pgstattuple: add test for coverage	DongWook Lee	✉ H
39/3535	postgres_fdw - use TABLESAMPLE when analyzing foreign tables	Tomas Vondra	✉ H
39/3392	postgres_fdw: commit remote (sub)transactions in parallel during pre-commit	Etsuro Fujita	✉ H
39/3448	reduce impact of lengthy startup and checkpoint tasks	Nathan Bossart	✉ H
39/3766	remove_useless_groupby_columns is too enthusiastic	Tom Lane	✉ H
39/3262	schema change not getting invalidated, both renamed table and new table data wer...	vignesh C	✉ H
39/1608	session variables, LET command	Pavel Stehule	✉ H
39/3795	support COPY TO callback functions	Nathan Bossart, Bilva Sanaba	✉ H
Waiting on Author
39/3571	Add LZ4 compression in pg_dump	Georgios Kokolatos, Rachel Heaton	✉ H
39/3677	Add TAP test for auth_delay extension	DongWook Lee	✉ H
39/3680	Add description about using geqo to EXPLAIN or debug log.	masaya kawamoto	✉ H
39/2765	Add extra statistics to explain for Nested Loop	Justin Pryzby, Ekaterina Sokolova	✉ H
39/3678	Allow foreign keys to reference a superset of unique columns	Kaiting Chen	✉ H
39/3749	Allow placeholders in ALTER ROLE w/o superuser	Steve Chávez	✉ H
39/3099	Asymmetric partition-wise JOIN	KaiGai Kohei, Andrey Lepikhov	✉ H
39/3316	Asynchronous and "direct" IO support for PostgreSQL	Andres Freund, David Rowley, Thomas Munro	✉ H
39/3623	Data is copied twice when specifying both child and parent table in publication	wei wang, Yu Shi	✉ H
39/3554	Documentation (mostly) of implementing TRANSFORM FOR TYPE in a PL	Chapman Flack	✉ H
39/3750	Eliminating SPI from RI triggers	Amit Langote	✉ H
39/3523	Fix Windows network event handling	Thomas Munro	✉ H
39/3583	Fix checkpointer sync request queue problems	Thomas Munro	✉ H
39/3582	Kerberos delegation	Stephen Frost, Peifeng Qiu	✉ H
39/3740	Minimal logical decoding on standbys	Bertrand Drouvot	✉ H
39/3735	New hooks in the connection path	Bertrand Drouvot	✉ H
39/3222	PITR enhance getRecordTimestamp()	Simon Riggs	✉ H
39/3752	POC: Lock updated tuples in tuple_update() and tuple_delete()	Alexander Korotkov	✉ H
39/3032	PROXY protocol support	Magnus Hagander	✉ H
39/3746	Patch to address creation of PgStat* contexts with null parent context	Reid Thompson	✉ H
39/3620	Prohibit RESETing transaction-property GUCs	Masahiko Sawada	✉ H
39/3566	Reducing power consumption when idle	Simon Riggs	✉ H
39/3645	Refactoring MemSet/memset api usage	Ranier Vilela	✉ H
39/3726	Select Reference Page - Make Join Syntax More Prominent	David Johnston	✉ H
39/3577	Support for grabbing multiple consecutive values with nextval()	Jille Timmermans	✉ H
39/3595	Support logical replication of DDL commands	Zheng Li	✉ H
39/3722	Temporary file access API	Antonin Houska	✉ H
39/3675	[BUG] Panic due to incorrect missingContrecPtr after promotion	Sami Imseih	✉ H
39/3395	building postgres with meson	Andres Freund	✉ H
39/3774	predefined role(s) for VACUUM and ANALYZE	Nathan Bossart	✉ H
39/3482	warn if GUC set to an invalid shared library	Justin Pryzby	✉ H

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author