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
38/3612	Add --schema and --exclude-schema options to vacuumdb	Gilles Darold, Justin Pryzby	✉ H
38/3511	Add non-blocking version of PQcancel	Jelte Fennema	✉ H
38/3046	Allow multiple recursive self-references	Denis Hirn	✉ H
38/3496	Avoid erroring out when unable to remove or parse logical rewrite files to save ...	Nathan Bossart, Bharath Rupireddy	✉ H
38/2897	Faster pglz compression	Andrey Borodin, Владимир Лесков	✉ H
38/3271	KnownAssignedXidsGetAndSetXmin performance	Michail Nikolaev	✉ H
38/2900	On client login event trigger	Konstantin Knizhnik, Greg Nancarrow	✉ H
38/2903	Parallel Hash Full Join	Melanie Plageman	✉ H
38/3597	Specify that the shared locks in pg_dump are actually ACCESS SHARE	Florin Irion	✉ H
38/3608	Unit tests for SLRU	Aleksander Alekseev	✉ H
38/3358	Update relfrozenxmin when truncating temp tables	Greg Stark	✉ H
38/3489	XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Fedor Sigaev, Alexander Korotkov, Aleksander Alekseev, Konstantin Knizhnik, Nikita Glukhov, Yura Sokolov, Maxim Orlov, Pavel Borisov	✉ H
38/2573	pg_dump - read data for some options from external file	Pavel Stehule	✉ H
38/3555	reduce archiving overhead	Nathan Bossart	✉ H
38/3609	use has_privs_of_role() for pg_hba.conf	Nathan Bossart	✉ H
Needs review
38/3478	AcquireExecutorLocks() and run-time pruning	Amit Langote	✉ H
38/3618	Add --{no-,}bypassrls flags to createuser	Shinya Kato	✉ H
38/3594	Add 64-bit XIDs into PostgreSQL 15	Fedor Sigaev, Alexander Korotkov, Aleksander Alekseev, Konstantin Knizhnik, Nikita Glukhov, Yura Sokolov, Maxim Orlov, Pavel Borisov	✉ H
38/3405	Add connection active, idle time to pg_stat_activity	Rafia Sabih, Sergey Dudoladov	✉ H
38/3388	Add foreign-server health checks infrastructure	Hayato Kuroda	✉ H
38/3617	Add index scan progress to pg_stat_progress_vacuum	Sami Imseih	✉ H
38/3634	Add initdb option to initialize cluster with non-standard xid/mxid/mxoff.	Maxim Orlov, Pavel Borisov	✉ H
38/3627	Add internal Numeric to Uint64 conversion function.	Amul Sul	✉ H
38/3464	Add option to check unique constraint in btree indexes into amcheck and pg_amche...	Anastasia Lubennikova, Maxim Orlov, Pavel Borisov	✉ H
38/3644	Add result_types column to pg_prepared_statements view	Dagfinn Ilmari Mannsåker	✉ H
38/3575	Added Windows with MinGW environment in Cirrus CI	Melih Mutlu	✉ H
38/2992	Allow batched insert during cross-partition updates	Amit Langote	✉ H
38/3558	Allow file inclusion in pg_hba and pg_ident files	Julien Rouhaud	✉ H
38/3539	Allow parallel plan for referential integrity checks	Frédéric Yhuel	✉ H
38/3374	Allows database-specific role memberships	Kenaniah Cerny	✉ H
38/3099	Asymmetric partition-wise JOIN	KaiGai Kohei, Andrey Lepikhov	✉ H
38/3347	Atomic rename feature for Windows	Victor Spirin	✉ H
38/3483	BufferAlloc: don't take two simultaneous locks	Yura Sokolov	✉ H
38/3479	CREATE TABLE .. (.. STORAGE .. )	Fedor Sigaev	✉ H
38/3270	Cache tuple routing info during bulk loads into partitioned tables	Amit Langote, Hou Zhijie	✉ H
38/3598	Checking pgwin32_is_junction() errors	Thomas Munro	✉ H
38/3631	Completed unaccent dictionary with many missing characters	Przemysław Sztoch	✉ H
38/3626	Compression dictionaries for JSONB	Aleksander Alekseev	✉ H
38/3633	Costing elided SubqueryScans more nearly correctly	Tom Lane	✉ H
38/3451	Daitch-Mokotoff soundex	Dag Lem	✉ H
38/3623	Data is copied twice when specifying both child and parent table in publication	wei wang, yu Shi	✉ H
38/2377	Do not hide shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metad...	Justin Pryzby	✉ H
38/3586	Doc about how to set max_wal_senders when setting minimal wal_level	Japin Li	✉ H
38/3554	Documentation (mostly) of implementing TRANSFORM FOR TYPE in a PL	Chapman Flack	✉ H
38/3445	Error "initial slot snapshot too large" in create replication slot	Kyotaro Horiguchi, Dilip Kumar	✉ H
38/3563	Expose authenticated identity to extensions and triggers	Jacob Champion	✉ H
38/2831	Extended statistics / estimate Var op Var clauses	Tomas Vondra	✉ H
38/3050	Extended statistics in EXPLAIN	Tomas Vondra	✉ H
38/2601	Fast COPY FROM command for the foreign tables	Andrey Lepikhov	✉ H
38/3224	Fix ExecRTCheckPerms() inefficiency with many prunable partitions	Amit Langote	✉ H
38/2710	Fix behavior of geo_ops when NaN is involved	Kyotaro Horiguchi	✉ H
38/3583	Fix checkpointer sync request queue problems	Thomas Munro	✉ H
38/3607	Fix dsa_free() to re-bin segment	Dongming Liu	✉ H
38/3615	Fix recovery conflict SIGUSR1 handling	Thomas Munro	✉ H
38/2266	Fix up partitionwise join on how equi-join conditions between the partition keys...	Richard Guo	✉ H
38/2863	Function to log backtrace of postgres processes	vignesh C	✉ H
38/3443	GUC to allow logging WAL files during recovery from archive/stream/etc	Bharath Rupireddy	✉ H
38/3274	Gather partial paths for subproblem's topmost scan/join rel	Richard Guo	✉ H
38/3610	Handle infinite recursion in logical replication setup	vignesh C	✉ H
38/3635	Hash index sort performance	Simon Riggs	✉ H
38/2218	Implement INSERT SET syntax	Gareth Palmer	✉ H
38/3642	Implicitly created operator family not listed by pg_event_trigger_ddl_commands	Masahiko Sawada	✉ H
38/3310	Improve logging when using Huge Pages	Noriyoshi Shinoda	✉ H
38/3461	In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ...	Kyotaro Horiguchi	✉ H
38/2138	Incremental Materialized View Maintenance	Yugo Nagata, takuma hoshiai	✉ H
38/3582	Kerberos delegation	Stephen Frost, Peifeng Qiu	✉ H
38/3071	Lazy JIT IR code generation to increase JIT speed with partitions	Luc Vlaming	✉ H
38/3632	Log details for client certificate failures	Jacob Champion	✉ H
38/3142	Logging plan of the currently running query	atsushi torikoshi	✉ H
38/3181	Map WAL segment files on PMEM as WAL buffers	Takashi Menjo	✉ H
38/2627	More scalable multixacts buffers and locking	Kyotaro Horiguchi, Andrey Borodin	✉ H
38/3514	Move SLRU data into the regular buffer pool	Thomas Munro	✉ H
38/2871	New Table Access Methods for Multi and Single Inserts	Bharath Rupireddy	✉ H
38/3536	New [relation] options engine	Nikolay Shaplov	✉ H
38/2918	New default role allowing to change per-role settings	Michael Banck	✉ H
38/3590	Nonreplayable XLog records by means of overflows and >MaxAllocSize lengths	Matthias van de Meent	✉ H
38/3032	PROXY protocol support	Magnus Hagander	✉ H
38/3621	Perform streaming logical transactions by background workers	Hou Zhijie	✉ H
38/3490	Pluggable toaster	Fedor Sigaev, Nikita Glukhov, Oleg Bartunov, Nikita Malakhov	✉ H
38/3245	Postgres picks suboptimal index after building extended statistics	Andrey Lepikhov	✉ H
38/3543	Preventing indirection for IndexPageGetOpaque for known-size page special areas	Matthias van de Meent	✉ H
38/3620	Prohibit RESETing transaction-property GUCs	Masahiko Sawada	✉ H
38/3636	REINDEX syntax usability	Simon Riggs	✉ H
38/3566	Reducing power consumption when idle	Simon Riggs	✉ H
38/3599	Refactor add_path for clarity and extensibility	Nils Dijk	✉ H
38/3645	Refactoring MemSet/memset api usage	Ranier Vilela	✉ H
38/1712	Remove self join on a unique column	Konstantin Knizhnik, Alexander Kuzmenkov, Andrey Lepikhov	✉ H
38/3637	Remove support for Visual Studio 2013	Michael Paquier	✉ H
38/3604	Restructure ALTER TABLE notes to clarify table rewrites and verification scans	James Coleman	✉ H
38/3646	Skip replicating the tables specified in except table option	vignesh C	✉ H
38/3501	Speed up releasing of locks	Andres Freund, David Rowley	✉ H
38/3601	Summary Sort workers Stats in EXPLAIN ANALYZE		✉ H
38/3546	Support custom authentication methods using hooks	Samay Sharma	✉ H
38/3577	Support for grabbing multiple consecutive values with nextval()	Jille Timmermans	✉ H
38/3595	Support logical replication of DDL commands	Zheng Li	✉ H
38/3314	Support pg_ident mapping for LDAP	Jacob Champion	✉ H
38/3520	Suppressing useless wakeups in walreceiver	Thomas Munro	✉ H
38/3559	TAP format output for pg_regress	Daniel Gustafsson	✉ H
38/3628	Teach pg_waldump to extract FPIs from the WAL stream	David Christensen	✉ H
38/3581	Time-delayed logical replication subscriber	Euler Taveira	✉ H
38/3641	USAGE privilege on PUBLICATION	Antonin Houska	✉ H
38/3338	Upgrade pgcrypto to crypt_blowfish 1.3	Daniel Fone	✉ H
38/3629	Use outerPlanState macro instead of referring to lefttree	Richard Guo	✉ H
38/3235	Using each rel as both outer and inner for anti-joins	Richard Guo	✉ H
38/3450	WIN32 pg_import_system_collations	Juanjo Santamaria Flecha	✉ H
38/3206	Write visibility map during CLUSTER/VACUUM FULL	Alexander Korotkov, Justin Pryzby, Anna Akenteva, Anna Akenteva	✉ H
38/3639	Zstandard support for toast compression	Michael Paquier	✉ H
38/3524	[PATCH] Equivalence Class Filters	David Rowley, Andy Fan	✉ H
38/3492	add log messages when replication slots become active and inactive	Bharath Rupireddy	✉ H
38/3647	allow building trusted languages without the untrusted versions	Nathan Bossart	✉ H
38/3619	allow specifying action when standby encounters incompatible parameter settings	Nathan Bossart	✉ H
38/3182	automatically generating node support functions	Peter Eisentraut	✉ H
38/3611	avoid multiple hard links to same WAL file after a crash	Nathan Bossart	✉ H
38/3643	bogus: logical replication rows/cols combinations	Hou Zhijie	✉ H
38/3395	building postgres with meson	Andres Freund	✉ H
38/3434	disallow HEAP_XMAX_COMMITTED and HEAP_XMAX_IS_LOCKED_ONLY	Nathan Bossart	✉ H
38/3648	ecpglib: call newlocale() one per process	Noah Misch	✉ H
38/3409	explain_regress, explain(MACHINE), and default to explain(BUFFERS)	Justin Pryzby, Nikolay Samokhvalov	✉ H
38/3256	functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)	Justin Pryzby	✉ H
38/2482	jsonpath syntax extensions	Nikita Glukhov	✉ H
38/3472	more descriptive message for process termination due to max_slot_wal_keep_size	Kyotaro Horiguchi	✉ H
38/3537	new diagnostic items for the dynamic sql	Dinesh Kumar	✉ H
38/3452	partIndexlist for partitioned tables uniqueness	Arne Roland	✉ H
38/2837	pg_stat_statements and "IN" conditions	Dmitry Dolgov	✉ H
38/3457	pg_stat_toast	Gunnar "Nick" Bluth	✉ H
38/3184	pg_stats and range statistics	Egor Rogov	✉ H
38/3227	pgbench: add multiconnect support	David Christensen	✉ H
38/3260	pgbench: using prepared BEGIN statement in a pipeline could cause an error	Yugo Nagata	✉ H
38/3638	postgres_fdw versus regconfig and similar constants	Tom Lane	✉ H
38/3392	postgres_fdw: commit remote (sub)transactions in parallel during pre-commit	Etsuro Fujita	✉ H
38/3158	pre-allocating WAL files	Nathan Bossart	✉ H
38/3140	psql - refactor echo code	Fabien Coelho	✉ H
38/3295	psql: add xheader_width option to handle very long record lines	Platon Pronko	✉ H
38/3606	remove reset_shared()	Nathan Bossart	✉ H
38/3616	remove unused CalculateMaxmumSafeLSN		✉ H
38/3262	schema change not getting invalidated, both renamed table and new table data wer...	vignesh C	✉ H
38/3528	support for MODULE	Swaha Miller	✉ H
38/3530	wal_sync_method=fdatasync for Windows	Thomas Munro	✉ H
Waiting on Author
38/3571	Add LZ4 compression in pg_dump	Georgios Kokolatos, Rachel Heaton	✉ H
38/3073	Add callback table access method to reset filenode when dropping relation	Mats Kindahl	✉ H
38/2765	Add extra statistics to explain for Nested Loop	Justin Pryzby, Ekaterina Sokolova	✉ H
38/3515	Add last commit LSN to pg_last_committed_xact()	James Coleman	✉ H
38/3561	Add native windows on arm64 support	Niyas Sait	✉ H
38/3164	Add proper planner support for ORDER BY / DISTINCT aggregates	David Rowley	✉ H
38/3272	Add system view tracking shared buffer actions	Melanie Plageman	✉ H
38/3525	Allow pg_upgrade to copy segments of the same relfilenode in parallel	Jaime Casanova	✉ H
38/3316	Asynchronous and "direct" IO support for PostgreSQL	Andres Freund, David Rowley, Thomas Munro	✉ H
38/3106	Avoid orphaned dependencies	Bertrand Drouvot	✉ H
38/3508	Avoid smgrimmedsync() during index build and add unbuffered IO API	Melanie Plageman	✉ H
38/2815	CREATE INDEX CONCURRENTLY on partitioned table	Justin Pryzby	✉ H
38/2851	Consider parallel for LATERAL subqueries having LIMIT/OFFSET	James Coleman	✉ H
38/3469	Extensible RMgr	Jeff Davis	✉ H
38/3523	Fix Windows network event handling	Thomas Munro	✉ H
38/2349	Global temporary table	Wenjing Zeng	✉ H
38/3394	Logical insert/update/delete WAL records for custom table AMs	Jeff Davis	✉ H
38/3222	PITR enhance getRecordTimestamp()	Simon Riggs	✉ H
38/3143	Parallel INSERT SELECT take 2	Greg Nancarrow, Hou Zhijie	✉ H
38/3246	Parallelize correlated subqueries that execute within each worker	James Coleman	✉ H
38/3495	Per-table storage parameters for TableAM/IndexAM extensions	B Sadhu Prasad Patro	✉ H
38/3289	Push down time-related SQLValue functions to foreign server	Alexander Pyhalov	✉ H
38/3533	Teach WaitEventSets to grow automatically	Thomas Munro	✉ H
38/3584	Use "WAL segment" instead of "log segment" consistently in user-facing messages	Bharath Rupireddy	✉ H
38/3396	Use -fvisibility=hidden for shared libraries	Andres Freund	✉ H
38/3389	add checkpoint stats of snapshot and mapping files of pg_logical dir	Bharath Rupireddy	✉ H
38/3499	libpq compression	Konstantin Knizhnik, Daniil Zakhlystov	✉ H
38/3535	postgres_fdw - use TABLESAMPLE when analyzing foreign tables	Tomas Vondra	✉ H
38/3448	reduce impact of lengthy startup and checkpoint tasks	Nathan Bossart	✉ H
38/1608	session variables, LET command	Pavel Stehule	✉ H
38/3556	speed up a logical replication setup (pg_subscriber)	Euler Taveira	✉ H
38/3482	warn if GUC set to an invalid shared library	Justin Pryzby	✉ H

PostgreSQL Patch Tester

Ready for Committer

Needs review

Waiting on Author