Commitfest 2023-07
Status summary: Committed: 88. Moved to next CF: 227. Withdrawn: 6. Rejected: 1. Returned with Feedback: 28. Total: 350.
Closed patches
| Patch | ID | Status | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | ||||||||||
| pg_visibility's pg_check_visible() yields false positive when working in parallel with autovacuum | 3739 | Committed | 17 | Not processed | Daniel Shelepanov (dshelepanov) | Alexander Korotkov (smagen) | 6 | 1 year ago | ||
| clean up permission checks after 599b33b94 | 4107 | Committed | 16 | Not processed | Amit Langote (amitlan) | Amit Langote (amitlan) | 2 | 1 year ago | ||
| Fix assertion failure in SnapBuildInitialSnapshot() | 4149 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | 5 | 1 year ago | ||||
| stopgap fix for signal handling during restore_command | 4159 | Moved to next CF | stable | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 4 | 1 year ago | ||
| Fix improper qual pushdown after applying outer join identity 3 | 4222 | Committed | 16 | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 1 year ago | ||
| Check group_clause_relids to see if a clause is computable | 4250 | Committed | Not processed | Tom Lane (tgl), Richard Guo (richardguo) | Tom Lane (tgl) | 1 | 1 year ago | |||
| Why enable_hashjoin Completely disables HashJoin | 4265 | Withdrawn | Not processed | Zongliang Quan (quanzl) | 1 | 2 years ago | ||||
| [BUG #17888] Incorrect memory access in gist__int_ops for an input array with many elements | 4280 | Committed | Not processed | Ankit Kumar Pandey (ankitkpandey) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| prevent underflow in KeepLogSeg() | 4297 | Committed | stable | Not processed | Kyotaro Horiguchi (horiguti) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Find dangling membership roles in pg_dumpall | 4299 | Committed | Not processed | Andreas 'ads' Scherbaum (ads), Artur Zakirov (a.zakirov) | Daniel Gustafsson (d_gustafsson) | 1 | 1 year ago | |||
| Tighten checks on multidimensional arrays being returned from PL/Python | 4303 | Committed | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 1 year ago | |||
| Adjust the order of callback registration to avoid accessing invalid memory | 4311 | Committed | Not processed | Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 1 | 1 year ago | |||
| Restrict usage of PSQL_WATCH_PAGER | 4316 | Committed | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 1 year ago | |||
| Subscription statistics are not dropped at DROP SUBSCRIPTION in some cases | 4327 | Committed | Not processed | Masahiko Sawada (masahikosawada) | Masahiko Sawada (masahikosawada) | 1 | 1 year ago | |||
| hstore: Fix parsing on Mac OS X: isspace() is locale specific | 4341 | Committed | Not processed | Michael Paquier (michael-kun) | 1 | 1 year ago | ||||
| Remove old_snapshot_threshold? | 4363 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 2 | 1 year ago | |||
| fix cache lookup hazards in ff9618e | 4364 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| pg_get_indexdef modification to access catalog based on the TxnSnapshot | 4369 | Moved to next CF | Not processed | vigneshwaran C (vignesh.postgres) | 4 | 1 year ago | ||||
| Fix bugs in SSI when using btree scans and bitmap heap scans | 4378 | Committed | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 1 | 1 year ago | |||
| Unlogged relations and WAL-logging | 4396 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 2 | 1 year ago | |||
| Creation of an empty table is not fsync'd at checkpoint | 4397 | Committed | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 1 | 1 year ago | |||
| Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index | 4404 | Committed | stable | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 1 year ago | ||
| revert MAINTAIN and pg_maintain | 4422 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Clients | ||||||||||
| Add new protocol message to make GUC_REPORT configurable and use it for psql prompt substitution of %N with the current user | 4166 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 5 | 1 year ago | ||||
| Documentation | ||||||||||
| doc: PQexecParams binary handling example for REAL data type | 3568 | Returned with feedback | Not processed | Mark Wong (markwkm) | 6 | 1 year ago | ||||
| PGDOCS - replica identity quotes | 4241 | Committed | Not processed | Peter Smith (smithpb2250) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| Correct the documentation for work_mem | 4300 | Moved to next CF | 16 | Not processed | Sami Imseih (simseih) | Bruce Momjian (bmomjian) | 3 | 1 year ago | ||
| doc: Add some OID/TOAST-related limitations to the limits appendix. | 4320 | Withdrawn | stable | Not processed | 1 | 8 months ago | ||||
| Wrong syntax in feature description | 4360 | Committed | Not processed | Peter Smith (smithpb2250) | Daniel Gustafsson (d_gustafsson) | 1 | 1 year ago | |||
| harmonize password reuse in vacuumdb, clusterdb, and reindexdb | 4414 | Committed | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Miscellaneous | ||||||||||
| get_extension_version | 4242 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 3 | 2 years ago | ||||
| Add missing tab-completions for new SUBSCRIPTION options | 4266 | Committed | 16 | Not processed | Peter Smith (smithpb2250) | Amit Kapila (amitkapila) | 1 | 2 years ago | ||
| Clean up hba.c of code freeing regexps | 4277 | Committed | 17 | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 2 years ago | ||
| Trust signalfd on illumos, again. | 4279 | Committed | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 1 | 2 years ago | |||
| vector search support | 4292 | Moved to next CF | 17 | Not processed | Nathan Bossart (bossartn) | 3 | 1 year ago | |||
| Unlinking Parallel Hash Join inner batch files sooner | 4314 | Moved to next CF | Not processed | Thomas Munro (macdice) | 9 | 6 months ago | ||||
| improve more permissions-related error messages | 4317 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| pg_upgrade - typo in verbose log | 4322 | Moved to next CF | Not processed | Peter Smith (smithpb2250) | Michael Paquier (michael-kun) | 2 | 1 year ago | |||
| add non-option reordering to in-tree getopt_long | 4354 | Committed | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Remove distprep | 4357 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 3 | 1 year ago | |||
| Consider fillfactor in heapam_estimate_rel_size | 4370 | Committed | Not processed | Tomas Vondra (fuzzycz) | 1 | 1 year ago | ||||
| Changing types of block and chunk sizes in memory context | 4400 | Committed | Not processed | Melih Mutlu (melihmutlu) | David Rowley (davidrowley) | 1 | 1 year ago | |||
| Meson build updates | 4410 | Moved to next CF | Not processed | Tristan Partin (tristan957) | 2 | 1 year ago | ||||
| Monitoring & Control | ||||||||||
| Fix inconsistency in reporting checkpointer stats | 4078 | Moved to next CF | Not processed | Nitin Jadhav (nitinjadhav11) | 6 | 6 months ago | ||||
| bug: ANALYZE progress report with inheritance tables | 4144 | Moved to next CF | stable | Not processed | Justin Pryzby (justinpryzby) | Heikki Linnakangas (heikki) | 3 | 1 year ago | ||
| Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment | 4236 | Moved to next CF | Not processed | Lukas Fittl (lfittl) | 2 | 1 week ago | ||||
| Performance | ||||||||||
| More scalable multixacts buffers and locking | 2627 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | Álvaro Herrera (alvherre) | 20 | 1 year ago | |||
| nbtree performance improvements through specialization on key shape | 3672 | Moved to next CF | Not processed | Matthias van de Meent (mmeent) | 14 | 5 months ago | ||||
| Improve dead tuple storage for lazy vacuum | 3687 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada), John Naylor (john.naylor) | Masahiko Sawada (masahikosawada) | 10 | 1 year ago | |||
| Eliminating SPI from RI triggers | 3750 | Returned with feedback | Not processed | Amit Langote (amitlan) | 6 | 1 year ago | ||||
| asynchronous execution support for Custom Scan | 3813 | Moved to next CF | Not processed | KaiGai Kohei (kaigai), kazutaka onishi (onishi) | 8 | 1 year ago | ||||
| Prefetch the next tuple's memory during seqscans | 3978 | Moved to next CF | Not processed | David Rowley (davidrowley), Thomas Munro (macdice) | 7 | 1 year ago | ||||
| Lockless queue of waiters based on atomic operations for LWLock | 3983 | Moved to next CF | Not processed | Alexander Korotkov (smagen), Pavel Borisov (pborisov) | 7 | 1 year ago | ||||
| Partial aggregates push down | 4019 | Moved to next CF | Not processed | Yuki Fujii (fujiiyuki) | 6 | 8 months ago | ||||
| Improve the performance of nested loop join in the case of partitioned inner table | 4253 | Returned with feedback | Not processed | Alexandr Nikulin (anikulin) | 1 | 1 year ago | ||||
| Improve list manipulation in several places | 4294 | Committed | Not processed | Richard Guo (richardguo) | Peter Eisentraut (petere) | 1 | 1 year ago | |||
| Fix incorrect start up costs for WindowAgg paths | 4334 | Moved to next CF | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 2 | 1 year ago | |||
| Remove WindowClause PARTITION BY items belonging to redundant pathkeys | 4349 | Committed | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 1 | 1 year ago | |||
| Index Prefetching | 4351 | Moved to next CF |
7/7
|
+4395−192 | Tomas Vondra (fuzzycz) | 11 | 3 days ago | |||
| XLog size reductions: Reduced XLog record header size | 4386 | Moved to next CF | Not processed | Matthias van de Meent (mmeent) | 6 | 10 months ago | ||||
| Add GUC to tune glibc's malloc behaviour | 4387 | Returned with feedback | 17 | Not processed | Ronan Dunklau (rdunklau) | 1 | 1 year ago | |||
| Remove trailing zero words from Bitmapset | 4391 | Committed | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 1 | 1 year ago | |||
| Use ReadRecentBuffer() for btree root page | 4419 | Moved to next CF | Not processed | Thomas Munro (macdice) | 7 | 1 year ago | ||||
| Split out tiebreaker comparisons from comparetup_* functions | 4424 | Moved to next CF | Not processed | John Naylor (john.naylor) | John Naylor (john.naylor) | 2 | 1 year ago | |||
| Optimise index range scan by performing first check with upper page boundary | 4434 | Moved to next CF | 17 | Not processed | Konstantin Knizhnik (knizhnik) | Alexander Korotkov (smagen) | 3 | 1 year ago | ||
| Refactoring | ||||||||||
| SetLatches() | 3998 | Moved to next CF | Not processed | Thomas Munro (macdice) | 12 | 5 months ago | ||||
| Rework LogicalOutputPluginWriterUpdateProgress | 4004 | Moved to next CF | Not processed | wei wang (wangwei) | 6 | 1 year ago | ||||
| Use AF_UNIX for tests on Windows (ie drop fallback TCP code) | 4033 | Moved to next CF | Not processed | Thomas Munro (macdice) | 6 | 1 year ago | ||||
| Some revises in adding sorting path | 4119 | Moved to next CF | Not processed | Richard Guo (richardguo) | David Rowley (davidrowley) | 5 | 1 year ago | |||
| New [relation] options engine | 4160 | Moved to next CF | Not processed | Nikolay Shaplov (nataraj) | 4 | 1 month ago | ||||
| some namespace.c refactoring | 4212 | Moved to next CF | Not processed | Peter Eisentraut (petere) | 5 | 1 year ago | ||||
| Fix comments in gistxlogDelete, xl_heap_freeze_page and xl_btree_delete | 4235 | Committed | stable | Not processed | Bertrand Drouvot (bertranddrouvot.pg) | Robert Haas (rhaas) | 1 | 2 years ago | ||
| Microsecond-based timeouts | 4245 | Returned with feedback | Not processed | Thomas Munro (macdice) | 1 | 2 years ago | ||||
| Simplify some codes in pgoutput | 4251 | Committed | Not processed | Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 1 | 2 years ago | |||
| Teach WaitEventSetWait() to report multiple events on Windows | 4263 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 2 | 1 year ago | |||
| Pass heaprel to GlobalVisTestFor() in vacuumRedirectAndPlaceholder() | 4264 | Committed | 16 | Not processed | Bertrand Drouvot (bertranddrouvot.pg) | Peter Geoghegan (pgeoghegan) | 1 | 2 years ago | ||
| Add two missing tests in 035_standby_logical_decoding.pl | 4295 | Committed | 16 | Not processed | Bertrand Drouvot (bertranddrouvot.pg) | Amit Kapila (amitkapila) | 1 | 1 year ago | ||
| Rename Event Trigger Cache context for easier memory context debugging | 4310 | Committed | Not processed | Daniel Gustafsson (d_gustafsson) | Daniel Gustafsson (d_gustafsson) | 1 | 1 year ago | |||
| LLVM 16 and 17 | 4325 | Moved to next CF | Not processed | Dmitry Dolgov (erthalion), Thomas Munro (macdice) | Thomas Munro (macdice) | 3 | 1 year ago | |||
| Cleaning up threading code | 4356 | Committed | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 1 | 8 months ago | |||
| Refactor fork+exec code | 4376 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 5 | 9 months ago | |||
| Unified file access using virtual file descriptors | 4420 | Moved to next CF | 17 | Not processed | John Morris (coyotebush) | 4 | 1 year ago | |||
| Revises for the check of parameterized partial paths | 4425 | Moved to next CF | Not processed | Richard Guo (richardguo) | Richard Guo (richardguo) | 6 | 8 months ago | |||
| Replication & Recovery | ||||||||||
| Add log messages when replication slots become active and inactive | 3492 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila) | 10 | 1 year ago | |||
| pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory | 3503 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | 11 | 1 year ago | ||||
| An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication | 3665 | Returned with feedback | Not processed | Bharath Rupireddy (bharathrupireddy) | 6 | 1 year ago | ||||
| Optimize walsender handling invalid messages of 'drop publication' | 4393 | Moved to next CF | 13 | Not processed | Bowen Shi (zxwsbg) | 3 | 1 year ago | |||
| Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL | 4415 | Committed | Not processed | Hayato Kuroda (ha-kun) | Amit Kapila (amitkapila) | 1 | 1 year ago | |||
| Security | ||||||||||
| USAGE privilege on PUBLICATION | 3641 | Moved to next CF | Not processed | Antonin Houska (a.houska) | 9 | 2 years ago | ||||
| User functions for building SCRAM secrets | 3988 | Moved to next CF | Not processed | Jonathan Katz (jkatz05) | 7 | 1 year ago | ||||
| Server Features | ||||||||||
| Update relfrozenxmin when truncating temp tables | 3358 | Moved to next CF | 16 | Not processed | Greg Stark (stark) | 12 | 1 year ago | |||
| Enable jitlink as an alternative jit linker of legacy Rtdyld and add riscv jitting support | 3857 | Moved to next CF | Not processed | Alex Fan (alexfanqi) | 6 | 2 years ago | ||||
| Add the ability to limit the amount of memory that can be allocated to backends. | 3867 | Moved to next CF | Not processed | Reid Thompson (jreidthompsoncd), John Morris (coyotebush) | 11 | 1 year ago | ||||
| Multi-version ICU | 3956 | Moved to next CF | Not processed | Thomas Munro (macdice) | 10 | 1 year ago | ||||
| Post-special Page Storage TDE support (aka Reserved Page Size) | 3986 | Moved to next CF | Not processed | David Christensen (davidchristensen) | 12 | 3 months ago | ||||
| Named Operators | 4123 | Returned with feedback | Not processed | Gurjeet Singh (gurjeet) | 2 | 1 year ago | ||||
| Remove last traces of SCM credential auth from libpq? | 4247 | Committed | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 2 years ago | |||
| More OATs for ALTER TABLE | 4283 | Moved to next CF | 17 | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 2 | 1 year ago | ||
| ltree hash functions | 4375 | Moved to next CF | Not processed | Tommy Pavlicek (tommyp) | Tom Lane (tgl) | 5 | 1 year ago | |||
| Variable Block Size | 4429 | Moved to next CF | 17 | Not processed | David Christensen (davidchristensen) | 4 | 1 year ago | |||
| pg_stat_logmsg | 4431 | Moved to next CF | Not processed | Joe Conway (jconway) | 7 | 9 months ago | ||||
| Multiple passwords, interval expirations | 4432 | Moved to next CF | Not processed | Gurjeet Singh (gurjeet), Joshua Brindle (joshuab) | 4 | 1 year ago | ||||
| SQL Commands | ||||||||||
| Dynamic result sets from procedures | 2911 | Moved to next CF | Not processed | Peter Eisentraut (petere) | 12 | 2 years ago | ||||
| Add support for Distinct in Window aggregates | 4243 | Returned with feedback | 17 | Not processed | Ankit Kumar Pandey (ankitkpandey) | 1 | 1 year ago | |||
| Incremental View Maintenance (IVM), take 2 | 4337 | Moved to next CF | Needs rebase! | Yugo Nagata (yugo.nagata) | 11 | 8 months ago | ||||
| Mark a transaction uncommittable | 4342 | Moved to next CF | 17 | Not processed | Gurjeet Singh (gurjeet) | 2 | 1 year ago | |||
| Remaining sql/json patches | 4377 | Moved to next CF | Not processed | Amit Langote (amitlan), Nikita Glukhov (n.glukhov) | Amit Langote (amitlan) | 5 | 1 year ago | |||
| System Administration | ||||||||||
| recovery modules | 4082 | Moved to next CF | 18 | Not processed | Nathan Bossart (bossartn) | 8 | 9 months ago | |||
| rename some createuser options | 4326 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Should we remove db_user_namespace? | 4430 | Committed | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Testing | ||||||||||
| CI and test improvements | 3709 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | 14 | 5 months ago | ||||
| Testing autovacuum wraparound | 3729 | Moved to next CF | Not processed | Andres Freund (andresfreund), Masahiko Sawada (masahikosawada) | Masahiko Sawada (masahikosawada) | 8 | 1 year ago | |||
| Add TAP tests for psql \g piped into program | 4101 | Moved to next CF | Not processed | Daniel Vérité (danielverite) | Heikki Linnakangas (heikki) | 5 | 1 year ago | |||
| Use role name "system_user" instead of "user" for unsafe_tests | 4271 | Withdrawn | Not processed | Aleksander Alekseev (a.alekseev) | 1 | 2 years ago | ||||
| Fix a test case in 035_standby_logical_decoding.pl | 4302 | Committed | Not processed | Yu Shi (shiy.fnst) | Amit Kapila (amitkapila) | 1 | 1 year ago | |||
| Detect test suite sideeffects in pg_regress | 4321 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | 5 | 1 year ago | ||||
| Remove incidental md5() function uses from several tests | 4359 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 1 year ago | |||
| test_extensions: make meson.build consistent with Makefile. | 4374 | Committed | 16 | Not processed | Jeff Davis (jdavis) | Jeff Davis (jdavis) | 1 | 1 year ago | ||
| Honor PG_TEST_NOCLEAN for temporary directories | 4411 | Committed | Not processed | Jacob Champion (jchampion) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||