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