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, needs rebase but previous build was successful, = working.

Ready for Committer

51/5405 Add 'make check-tests' behavior to the meson based builds Nazir Bilal Yavuz  ✉ D H        
51/4921 allow changing autovacuum_max_workers without restarting Nathan Bossart  D H        
51/4319 Avoid unnecessary PlaceHolderVars for simple Vars Richard Guo  ⚠ ✉ D H        
51/5052 better error message when --single is not the first arg to postgres executable Nathan Bossart, Greg Sabino Mullane  ✉ D H        
51/4240 Cross-database SERIALIZABLE safe snapshots Thomas Munro ♲ ✉ D H
51/5295 deprecate md5 passwords Nathan Bossart  D H        
51/5379 Fix bug with accessing to temporary tables of other sessions Daniil Davydov  ✉ D H        
51/4884 Fix rare recovery shutdown hang Thomas Munro ♲ ✉ D H        
51/4627 Special-case executor expression steps for common combinations Andres Freund, Daniel Gustafsson  ✉ D H        
51/5027 Track the amount of time waiting due to cost_delay Bertrand Drouvot  ✉ D H        
51/5162 Use read streams in autoprewarm Nazir Bilal Yavuz  D H        

Needs review

51/5406 [Fix] Heap Use After Free in parallel_vacuum_reset_dead_items Function Vallimaharajan G  ✉ D H        
51/3478 AcquireExecutorLocks() and run-time pruning Amit Langote ♲ ✉ D H        
51/4909 Add a attopt to disable MCV when estimating for Var = Const Andy Fan ♲ ✉ D H        
51/5229 Add ExprState hashing for GROUP BY and hashed SubPlans David Rowley  D H        
51/4913 Add extension_destdir GUC Christoph Berg, David Wheeler  ✉ D H        
51/5362 Add missing tab completions Kirill Reshke  ✉ D H        
51/5396 Add Option to Check All Addresses For Matching target_session_attr Andrew Jackson  ✉ D H        
51/3405 Add pg_stat_session Rafia Sabih, Sergey Dudoladov  ✉ D H        
51/5407 Add Pipelining support to psql Anthonin Bonnefoy  ✉ D H        
51/5382 Adding compression of temporary files Filip Januš  ✉ D H        
51/5347 Additional function inlining for slow_deform_heap_tuple David Rowley  ✉ D H        
51/5387 Allow PGSERVICEFILE to be specified as part of the connection string Torsten Foertsch  ✉ D H        
51/5246 Allow SQL functions use CachedPlan machinery Alexander Pyhalov ♲ ⚠ ✉ D H        
51/3705 ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables Justin Pryzby  ✉ D H        
51/5129 Asynchronous MergeAppend Execution Alexander Pyhalov ♲ ✉ D H        
51/5393 attempt multibyte-aware truncation of database names Nathan Bossart, Bertrand Drouvot  ⚠ ✉ D H        
51/5395 Auto Vacuum optimisation wenhui qiu  ✉ D H        
51/5385 clean up create|alter domain stmt incompatiable constraint error case and add re...  ✉ D H        
51/4412 Client authentication via OAuth 2.0 Jacob Champion  ⚠ ✉ D H        
51/5391 Code cleanup for detoast a expanded datum. Andy Fan  ✉ D H        
51/5378 Conflict detection for update_deleted in logical replication Hou Zhijie  ✉ D H        
51/5231 Consider the number of columns in the sort cost model Andrei Lepikhov  ⚠ D H        
51/5368 Convert contrib SQL functions to new style Tom Lane, Ronan Dunklau ♲ ✉ D H        
51/4992 Convert sepgsql tests to TAP Peter Eisentraut  ✉ D H        
51/5377 Converting SetOp to read its two inputs separately Tom Lane  ✉ D H        
51/4620 CRC32C Parallel Computation Optimization on ARM xiang gao ♲ ✉ D H        
51/4912 CSN snapshots in hot standby Heikki Linnakangas  ⚠ D H        
51/5284 database-specific role memberships Denis Laxalde, Kenaniah Cerny  ⚠ ✉ D H        
51/1608 declarative session variables, LET command Pavel Stehule ♲ D H        
51/5410 Disable installcheck for tap and regress tests for injection_points module Michail Nikolaev  ⚠ ✉ D H        
51/5086 Document NULL Concepts and Behaviors David Johnston  D H        
51/5366 Eagerly scan all-visible pages to amortize aggressive vacuum Melanie Plageman  ✉ D H        
51/5363 enable pg_recvlogical to use temporary slots Torsten Foertsch  ✉ D H        
51/5282 Enhance file_fdw to report processed and skipped tuples in COPY progress Fujii Masao  ✉ D H        
51/5262 ensure we have a snapshot when dropping an index concurrently Nathan Bossart  D H        
51/5381 explain pgstatindex fragmentation Frédéric Yhuel  ✉ D H        
51/4476 Extract numeric field in JSONB more effectively Andy Fan  ✉ D H        
51/5365 Fix creation of empty .log files during log rotation Arseny Kositsin  ✉ D H        
51/5384 fix deprecation mention for age() and mxid_age() Bertrand Drouvot ♲ ✉ D H
51/5394 Fix jsonb comparison for raw scalar pseudo arrays Jack Yan  ⚠ ✉ D H        
51/5402 Heap Use After Free in Window Aggregate Execution & custom malloc allocator impl... Jayesh Dehankar ♲ ⚠ ✉ D H        
51/5375 If the psql process is idle, the user is not able to know that the server is not... srinath reddy ♲ ✉ D H
51/4460 Implement row pattern recognition feature Tatsuo Ishii  ⚠ ✉ D H        
51/5269 Improve statistics estimation considering GROUP-BY as a 'uniqueiser' Andrei Lepikhov  D H        
51/5401 Improve the error message for logical replication of regular column to generated... Shubham Khanna ♲ ✉ D H        
51/5100 Improved crc32c performance with AVX-512 algorithm. Paul Amonson ♲ D H        
51/5388 Improved psql tab completion for joins Andreas Karlsson  ✉ D H        
51/5195 Index AM API cleanup Mark Dilger  ✉ D H        
51/4351 Index Prefetching Tomas Vondra ♲ ✉ D H        
51/5413 INSERT ... ON CONFLICT DO SELECT [FOR ...] Andreas Karlsson, Marko Tiikkaja  ⚠ ✉ D H        
51/5299 Limiting overshoot in nbtree SAOP parallel index scans Matthias van de Meent ♲ ✉ D H        
51/5408 local and inherited NOT NULL constraints on non-local columsn Ashutosh Bapat  ✉ D H        
51/5386 Log LSN before table is dropped Andrey Borodin, Nikolay Samokhvalov, Kirk Wolak  ✉ D H        
51/5330 Logging plan of the currently running query Atsushi Torikoshi  ✉ D H        
51/5361 Make add_paths_to_append_rel consider fractional paths for valid tuple fraction  ✉ D H        
51/5097 Make tuple deformation faster David Rowley  D H        
51/5411 Memory leak in WAL sender with pgoutput (v10~) Michael Paquier  ✉ D H
51/5114 MergeJoin beats HashJoin in the case of multiple hash clauses Andrei Lepikhov  ✉ D H        
51/5081 nbtree skip scan Peter Geoghegan  D H        
51/4638 nbtree: downlink right separator/HIKEY optimization Matthias van de Meent ♲ ✉ D H        
51/5285 NOT ENFORCED constraint feature Amul Sul ♲ ✉ D H        
51/5369 optimize file transfer in pg_upgrade Nathan Bossart ♲ ✉ D H        
51/5376 pageinspect - bug in brin_page_items Tomas Vondra  ✉ D H        
51/5398 Parallel index build for BRIN Egor Rogov  ✉ D H        
51/5380 Parametrization minimum password length Emanuele Musella  ✉ D H        
51/4974 pg_stat_activity: make slow/hanging authentication more visible Jacob Champion  D H        
51/5409 postgres_fdw could deparse ArrayCoerceExpr Alexander Pyhalov  ✉ D H        
51/4564 Reducing memory consumed by RestrictInfo list translations in partitionwise join... Ashutosh Bapat  ✉ D H        
51/5031 Remove dependence on integer wrapping Joseph Koshakow  ⚠ ✉ D H        
51/5043 Remove self join on a unique column Andrei Lepikhov ♲ ✉ D H        
51/5283 Replace IN VALUES with ANY in WHERE clauses during optimization Andrei Lepikhov, Alena Rybakina  ⚠ ✉ D H        
51/5397 revamp row-security tracking Nathan Bossart ♲ ✉ D H        
51/4971 Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements Michail Nikolaev  D H        
51/5412 Rework subscription-related code for psql and pg_dump Michael Paquier  ✉ D H        
51/5390 Sampling in pg_stat_statements Ilia Evdokimov  ✉ D H        
51/5404 Self contradictory examining on rel's baserestrictinfo  ⚠ ✉ D H        
51/4759 shared detoast datum Andy Fan ♲ ✉ D H
51/5358 Shave a few cycles off our ilog10 implementation David Fetter  ✉ D H        
51/5313 simplify regular expression locale global variables Peter Eisentraut  ✉ D H        
51/4904 SQL Property Graph Queries (SQL/PGQ) Peter Eisentraut, Ashutosh Bapat ♲ ✉ D H        
51/4308 SQL:2011 application time Paul Jungwirth  ✉ D H        
51/4538 Statistics Import and Export Corey Huinker  ⚠ ✉ D H        
51/5089 Streaming Vacuum Thomas Munro, Melanie Plageman  ✉ D H        
51/5209 Support POSITION with nondeterministic collations Peter Eisentraut  ✉ D H        
51/5318 System views for versions reporting Dmitry Dolgov  ⚠ ✉ D H        
51/5414 Tab completion for ALTER USER RESET Robins Tharakan  ✉ D H        
51/4690 Teach predtest about IS [NOT] <boolean> proofs James Coleman  ✉ D H        
51/5371 TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' Aleksander Alekseev  ✉ D H        
51/5320 Trigger more frequent autovacuums for insert-heavy tables Melanie Plageman ♲ ✉ D H        
51/5272 Truncate logs by max_log_size Kirill Gavrilov  ✉ D H        
51/5373 Tweak access BufferDescriptors array codes in BufferGetLSNAtomic() Tender Wang  ✉ D H        
51/4938 Use <stdint.h> for int64_t and other exact-width integer types Thomas Munro  ✉ D H        
51/5321 use a non-locking initial test in TAS_SPIN on AArch64 Nathan Bossart  ✉ D H        
51/5327 Use read_stream in index vacuum Andrey Borodin  ✉ D H        
51/5364 Using Expanded Objects other than Arrays from plpgsql Tom Lane  ✉ D H        
51/4388 UUID v7 Andrey Borodin  ✉ D H        
51/5117 VACUUM FULL / CLUSTER CONCURRENTLY Antonin Houska ♲ ⚠ ✉ D H        
51/5012 Vacuum statistics Andrei Lepikhov, Andrei Zubkov, Alena Rybakina  ⚠ ✉ D H        
51/4972 Virtual generated columns Peter Eisentraut  ✉ D H        
51/5399 Windows pg_basebackup unable to create >2GB pg_wal.tar tarballs ("could not clos... Thomas Munro, Jakub Wartak ♲ ✉ D H

Waiting on Author

51/5131 add log_transaction GUC setting Sergey Solovev  ⚠ ✉ D H        
51/5325 Add sortsupport for range types and btree_gist Bernd Helmle, Christoph Heiss, jian he  ⚠ D H        
51/5227 AIO Andres Freund  ✉ D H        
51/5128 Allow partition-wise join when whole row var is needed Ashutosh Bapat, Alexander Pyhalov ♲ ⚠ D H        
51/5174 Call rm_redo in a temporary memory context Heikki Linnakangas  ⚠ ✉ D H        
51/5319 Changing shared_buffers without restart Dmitry Dolgov ♲ ✉ D H
51/3709 CI and test improvements Justin Pryzby ♲ ✉ D H        
51/4810 COPY ON_ERROR 'NULL' jian he  ⚠ ✉ D H        
51/3461 In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with ... Kyotaro Horiguchi ♲ ✉ D H        
51/4337 Incremental View Maintenance (IVM), take 2 Yugo Nagata ♲ ⚠ ✉ D H        
51/4871 KNN-btree Nikita Glukhov, Anton Melnikov ♲ ⚠ ✉ D H        
51/5166 Make ECPG locale usage thread-safe Thomas Munro ♲ ✉ D H        
51/3672 nbtree performance improvements through specialization on key shape Matthias van de Meent ♲ ✉ D H
51/4635 nbtree: implement dynamic prefix truncation Matthias van de Meent ♲ ✉ D H        
51/5061 New function rand_array() to contrib/tablefunc Andy Fan  ✉ D H        
51/4966 Parallel CREATE INDEX for GIN indexes Tomas Vondra ♲ ⚠ ✉ D H        
51/5026 Parallel CREATE INDEX for GiST indexes Tomas Vondra ♲ ✉ D H        
51/5326 Parallel heap vacuum Masahiko Sawada  D H        
51/5206 pg_upgrade: Support for upgrading to checksums enabled Peter Eisentraut  ✉ D H        
51/5153 Prohibit to use EphemeralNamedRelation in materialized views Yugo Nagata  ✉ D H        
51/3701 Reducing planning time when tables have many partitions Yuya Watari  ✉ D H        
51/5007 relfilenode statistics Bertrand Drouvot ♲ ⚠ ✉ D H        
51/5359 Showing applied extended statistics in explain Part2 Tatsuro Yamada  ✉ D H         
51/5036 Sort functions with specialized comparators Andrey Borodin, Stepan Neretin  ✉ D H        
51/5214 SQL:2023 JSON simplified accessor support Alexandra Wang  ⚠ ✉ D H        
51/5334 Support regular expressions with nondeterministic collations Peter Eisentraut ♲ ⚠ ✉ D H        
51/4956 Test to dump and restore objects left behind by regression Ashutosh Bapat  ✉ D H        
51/5170 Thread-safe nl_langinfo(), localeconv(), check_locale() Thomas Munro ♲ ✉ D H