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/3389	Add checkpoint stats of snapshot and mapping files of pg_logical dir	Bharath Rupireddy	✉ H
39/3405	Add connection active, idle time to pg_stat_activity	Rafia Sabih, Sergey Dudoladov	✉ 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/2903	Parallel Hash Full Join	Melanie Plageman	✉ H
39/3839	Summary function for pg_buffercache	Melih Mutlu	✉ H
39/3836	Tracking last scan time	Dave Page	✉ H
39/3608	Unit tests for SLRU	Aleksander Alekseev	✉ H
39/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	✉ H
39/3803	Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid ...	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/2573	pg_dump - read data for some options from external file	Pavel Stehule	✉ H
39/3503	pg_receivewal fail to streams when the partial file to write is not fully initia...	Bharath Rupireddy, SATYANARAYANA NARLAPURAM	✉ 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/3830	ALTER TABLE ... SET STORAGE default	Aleksander Alekseev	✉ H
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/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/3443	Add WAL recovery info such as current WAL file and WAL source to server logs	Bharath Rupireddy	✉ 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/3756	Add last_vacuum_index_scans in pg_stat_all_tables	Ken Kato	✉ H
39/3492	Add log messages when replication slots become active and inactive	Bharath Rupireddy	✉ H
39/3561	Add native windows on arm64 support	Niyas Sait	✉ H
39/3845	Add peer authentication TAP test	Bertrand Drouvot	✉ H
39/3838	Add semi-join pushdown to postgres_fdw	Alexander Pyhalov	✉ H
39/3686	Add sortsupport for range types and btree_gist	Christoph Heiss	✉ H
39/3822	Add support for DEFAULT specification in COPY FROM	Israel Barth	✉ H
39/3272	Add system view tracking shared buffer actions	Melanie Plageman	✉ H
39/3867	Add the ability to limit the amount of memory that can be allocated to backends.	Reid Thompson	✉ H
39/3865	Add tracking of backend memory allocated to pg_stat_activity	Reid Thompson	✉ 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/3840	Allow logical replication to copy tables in binary format	Melih Mutlu	✉ 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/3862	Allow usage of archive .backup files as backup_label	Michael Banck	✉ 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/3870	Better infrastructure for automated testing of concurrency issues	Alexander Korotkov	✉ H
39/3483	BufferAlloc: don't take two simultaneous locks	Yura Sokolov	✉ H
39/3817	COPY FROM IGNORE_ERRORS - ignores rows with errors while copying	Damir Belyalov	✉ H
39/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby, Alexander Pyhalov	✉ H
39/3736	Check consistency of GUC defaults between .sample.conf and pg_settings.boot_val	Kyotaro Horiguchi	✉ 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/3623	Data is copied twice when specifying both child and parent table in publication	wei wang, Yu Shi	✉ H
39/3586	Doc about how to set max_wal_senders when setting minimal wal_level	Japin Li	✉ H
39/3750	Eliminating SPI from RI triggers	Amit Langote	✉ H
39/3857	Enable jitlink as an alternative jit linker of legacy Rtdyld and add riscv jitti...	Alex Fan	H
39/3445	Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi, Dilip Kumar	✉ 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 estimation	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/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/3829	Improve hints for missing-column and missing-table cases	Tom Lane	✉ 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/3071	Lazy JIT IR code generation to increase JIT speed with partitions	Luc Vlaming	✉ 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/3806	Minimizing calls to SubTransSetParent()	Simon Riggs	✉ 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/3536	New [relation] options engine	Nikolay Shaplov	✉ H
39/3735	New hooks in the connection path	Bertrand Drouvot	✉ H
39/3843	New strategies for freezing, advancing relfrozenxid early	Peter Geoghegan	✉ 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/2900	On client login event trigger	Konstantin Knizhnik, Greg Nancarrow	✉ H
39/3783	Page compression for OLTP	Chen huajun	✉ H
39/3794	Parallel Aggregates for string_agg and array_agg	David Rowley	✉ H
39/3821	Patch to implement missing join selectivity estimation for range types	Mahmoud SAKR, Diogo Repas, Maxime Schoemans, Zhicheng Luo	✉ 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/3818	Provide sigaction() for Windows	Thomas Munro	✉ 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/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/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/3873	Report checkpoint progress with pg_stat_progress_checkpoint	Nitin Jadhav	✉ 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/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/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/3850	Support tls-exporter as channel binding for TLSv1.3	Michael Paquier, Jacob Champion	✉ 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/3837	TAP output format for pg_regress	Daniel Gustafsson	✉ 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/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/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/3828	[BUG] Logical replica crash if there was an error in a function.	Maxim Orlov, Anton Melnikov	✉ H
39/3524	[PATCH] Equivalence Class Filters	David Rowley, Andy Fan	✉ H
39/3774	allow granting VACUUM and ANALYZE privileges on relations	Nathan Bossart	✉ H
39/3868	allowing for control over SET ROLE	Robert Haas	✉ H
39/3813	asynchronous execution support for Custom Scan	KaiGai Kohei, kazutaka onishi	✉ H
39/3395	building postgres with meson	Andres Freund	✉ H
39/3434	disallow HEAP_XMAX_COMMITTED and HEAP_XMAX_IS_LOCKED_ONLY	Nathan Bossart	✉ H
39/3568	doc: PQexecParams binary handling example for REAL data type	Mark Wong	✉ H
39/3790	doc: mention CREATE+ATTACH PARTITION as an alternative to CREATE..PARTITION OF	Justin Pryzby	H
39/3699	generate_series in selected timezone, date_add in selected timezone, date_trunc ...	Przemysław Sztoch	✉ H
39/3853	introduce bufmgr hooks	Nathan Bossart	✉ H
39/3823	logical decoding and replication of sequences, take 2	Tomas Vondra	✉ H
39/3824	make use of regular expressions for the username in pg_hba.conf	Bertrand Drouvot	✉ H
39/3711	making relfilenodes 56 bit	Dilip Kumar	✉ 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/3835	pg_basebackup: add test about zstd compress option	DongWook Lee	✉ H
39/3811	pg_get_constraintdef: Schema qualify foreign tables unless pretty printing is en...	Lukas Fittl	✉ H
39/3874	pg_rewind WAL deletion pitfall	Alexander Kukushkin, Polina Bungina	✉ 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/3872	pg_upgrade allows itself to be run twice (initdb)	Justin Pryzby	✉ H
39/3739	pg_visibility's pg_check_visible() yields false positive when working in paralle...	Daniel Shelepanov	✉ 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/3863	plpgsql-trigger.html: more concise wording for TG_ variables	Christoph Berg	✉ 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/3262	schema change not getting invalidated, both renamed table and new table data wer...	vignesh C	✉ H
39/3795	support COPY TO callback functions	Nathan Bossart, Bilva Sanaba	✉ H
39/3833	xml2: add test for coverage	DongWook Lee	✉ H
Waiting on Author
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/3666	Add last failed connection error message to pg_stat_wal_receiver	Bharath Rupireddy	✉ H
39/3511	Add non-blocking version of PQcancel	Jelte Fennema	✉ H
39/3787	Add parallel counters to pg_stat_statements	Daymel Bonne, Anthony Sotolongo León	✉ H
39/3678	Allow foreign keys to reference a superset of unique columns	Kaiting Chen	✉ H
39/3713	Allow pageinspect's bt_page_stats function to return a set of rows instead of a ...	Hamid Akhtar	✉ 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/3709	CI and test improvements	Justin Pryzby	✉ H
39/3820	Clarify the comments about varlena header encoding	Aleksander Alekseev	✉ H
39/3554	Documentation (mostly) of implementing TRANSFORM FOR TYPE in a PL	Chapman Flack	✉ H
39/3842	Fix alter subscription concurrency errors		✉ H
39/3583	Fix checkpointer sync request queue problems	Thomas Munro	✉ H
39/3807	Generalize ereport_startup_progress infrastructure	Bharath Rupireddy	✉ H
39/3849	HOT chain validation in verify_heapam()	Himanshu Upadhyaya	✉ H
39/3791	Hash index build performance tweak from sorting, part II	Simon Riggs	✉ H
39/3582	Kerberos delegation	Stephen Frost, Peifeng Qiu	✉ H
39/3740	Minimal logical decoding on standbys	Bertrand Drouvot	✉ H
39/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	✉ 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/3864	Query Jumbling for CALL and SET utility statements	Bertrand Drouvot	✉ 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/3851	Tracking the compression effect	Ken Kato	H
39/3409	explain_regress, explain(MACHINE), and default to explain(BUFFERS)	Justin Pryzby, Nikolay Samokhvalov	✉ H
39/3841	improve large object handling in pg_upgrade	Nathan Bossart, Jan Wieck	✉ H
39/3573	jit_warn_above_fraction parameter	Magnus Hagander	✉ H
39/3871	num_sa_scans in genericcostestimate	Jeff Janes	✉ H
39/3452	partIndexlist for partitioned tables uniqueness	Arne Roland	✉ H
39/3852	pg_checksum: add test for coverage	DongWook Lee	✉ H
39/3766	remove_useless_groupby_columns is too enthusiastic	Tom Lane	✉ H
39/1608	session variables, LET command	Pavel Stehule	✉ 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