Commitfest 2021-07

Shortcuts
Text Status Target version Author (type to search) Reviewer (type to search)
Clear


Status summary: Committed: 81. Moved to next CF: 233. Withdrawn: 20. Returned with Feedback: 2. Rejected: 6. Total: 342.

Closed patches

Patch ID Status Ver CI status Stats Author Reviewers Committer Num cfs Latest mail
Bug Fixes
standby recovery fails when re-replaying due to missing directory which was removed in previous replay. 2161 Moved to next CF stable Not processed Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) Michael Paquier (michael-kun) Álvaro Herrera (alvherre) 16 2 years ago
pg_upgrade fails with non-standard ACL 2215 Moved to next CF Not processed Anastasia Lubennikova (lubennikovaav), Artur Zakirov (a.zakirov) Grigory Smolkin (g.smolkin.postgrespro.ru) Noah Misch (nmisch) 12 3 years ago
Corruption during WAL replay 2518 Moved to next CF stable Not processed Teja Mupparti (tejam) Robert Haas (rhaas), Daniel Shelepanov (dshelepanov) Robert Haas (rhaas) 10 3 years ago
archive status ".ready" files may be created too early 2520 Moved to next CF stable Not processed Nathan Bossart (bossartn) Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 7 3 years ago
DROP relation IF EXISTS Docs and Tests - Bug Fix 2603 Moved to next CF Not processed David Johnston (polobo) Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com) 7 3 years ago
Fix collation handling in postgres_fdw 2685 Moved to next CF Not processed Tom Lane (tgl) Etsuro Fujita (efujita) 6 3 years ago
Fix checksum verification in base backups for zero page headers 2719 Moved to next CF Not processed Michael Banck (mbanck) Anastasia Lubennikova (lubennikovaav), David Steele (dsteele) 6 3 years ago
brin: avoid errors processing work item following concurrent reindex 2838 Moved to next CF stable Not processed Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby) Gurjeet Singh (gurjeet) 5 3 years ago
Fix firing of RI triggers during cross-partition updates of partitioned tables 2877 Moved to next CF Not processed Amit Langote (amitlan) Masahiko Sawada (masahikosawada) Álvaro Herrera (alvherre) 7 3 years ago
Fix DROP TABLESPACE on Windows with ProcSignalBarrier? 2962 Moved to next CF Not processed Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) Thomas Munro (macdice) 6 3 years ago
Set default transactions to read-only at servers start in pg_upgrade 2970 Moved to next CF Not processed Denis Laxalde (dlax) Julien Rouhaud (rjuju) 4 3 years ago
Autovacuum dynamic cost_limit, cost_delay 2983 Moved to next CF Not processed Scott Mead (meads-amazon) Masahiko Sawada (masahikosawada) 3 3 years ago
Removing unused trailing linepointers from heap pages 3035 Moved to next CF Not processed Matthias van de Meent (mmeent) 3 3 years ago
Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 3041 Moved to next CF Not processed Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) Amit Kapila (amitkapila) 7 2 years ago
Eliminating "Permission denied" errors on stat() (on Windows) 3058 Moved to next CF Not processed Alexander Lakhin (law) 4 3 years ago
generate fractional cheapest paths in generate_orderedappend_paths 3080 Moved to next CF Not processed Tomas Vondra (fuzzycz) Arne Roland (harks) Tomas Vondra (fuzzycz) 4 3 years ago
badly calculated width of emoji in psql 3087 Moved to next CF Not processed Jacob Champion (jchampion) Pavel Stehule (okbobcz) John Naylor (john.naylor) 2 3 years ago
pg_upgrade: copy the source oldestXid 3105 Moved to next CF stable Not processed Bertrand Drouvot (bdrouvot) Bruce Momjian (bmomjian) 2 3 years ago
psql: exclude valid constraints in tab-complete for ALTER TABLE .. VALIDATE CONSTRAINT 3113 Moved to next CF Not processed David Fetter (dfetter) Aleksander Alekseev (aalekseev) Tom Lane (tgl) 4 3 years ago
Support of time zone patterns - of, tzh and tzm 3121 Moved to next CF Not processed Nitin Jadhav (nitinjadhav11) David Zhang (david.z) Robert Haas (rhaas) 5 3 years ago
Parallel scan with SubTransGetTopmostTransaction assert coredump 3129 Moved to next CF Not processed Robert Haas (rhaas), Greg Nancarrow (gregn1234), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Pavel Borisov (pborisov) Robert Haas (rhaas) 2 3 years ago
Bug in query rewriter - hasModifyingCTE not getting set 3134 Moved to next CF 15 Not processed Takayuki Tsunakawa (maumau) Tom Lane (tgl) 2 3 years ago
Incorrect snapshots while promoting hot standby node when 2PC is used 3145 Moved to next CF stable Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 3 years ago
Update Toast data failure in logical replication 3162 Moved to next CF Not processed Dilip Kumar (dilip.kumar) Euler Taveira (eulerto), Haiying Tang (tanghy) Amit Kapila (amitkapila) 5 3 years ago
Fix around conn_duration in pgbench 3166 Moved to next CF 14 Not processed Yugo Nagata (yugo.nagata) Asif Rehman (asifrana) Fujii Masao (masaofujii) 2 3 years ago
Avoid stuck of pgbench due to skipped transactions 3168 Moved to next CF stable Not processed Yugo Nagata (yugo.nagata) Greg Sabino Mullane (greg) Fujii Masao (masaofujii) 2 3 years ago
Extended protocol COPY FROM STDIN fix 3180 Moved to next CF Not processed Jeff Davis (jdavis) 3 3 years ago
Fix pkg-config file for static linking 3193 Moved to next CF Not processed Filip Gospodinov (fil) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 3 years ago
Fix numeric power for negative bases and other corner cases 3214 Moved to next CF Not processed Dean Rasheed (deanr) Yugo Nagata (yugo.nagata) Dean Rasheed (deanr) 3 3 years ago
Fix pgbench's exit status and log messages for connection failures 3219 Moved to next CF stable Not processed Fabien Coelho (calvin), Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii) 3 3 years ago
ECPG bug fix: allow using connection-associated prepared_name 3233 Moved to next CF Not processed Hayato Kuroda (ha-kun) Michael Meskes (meskes) 2 3 years ago
Clients
psql - add SHOW_ALL_RESULTS option 2096 Moved to next CF Not processed Fabien Coelho (calvin) Peter Eisentraut (petere) Peter Eisentraut (petere) 13 3 years ago
pg_dump - read data for some options from external file 2573 Moved to next CF Not processed Pavel Stehule (okbobcz) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v) Daniel Gustafsson (d_gustafsson) 18 1 year ago
libpq compression 2773 Moved to next CF 15 Not processed Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag) 6 3 years ago
Support tab completion for upper character inputs in psql 2979 Moved to next CF Not processed Haiying Tang (tanghy) Tom Lane (tgl), Peter Eisentraut (petere) Tom Lane (tgl) 5 3 years ago
Refactor ECPGconnect() and allow IPv6 connection 3005 Moved to next CF Not processed Hayato Kuroda (ha-kun) 3 3 years ago
Using COPY FREEZE in pgbench 3034 Moved to next CF 15 Not processed Tatsuo Ishii (ishii) Fabien Coelho (calvin) Tatsuo Ishii (ishii) 2 3 years ago
pg_dump new feature: exporting functions only 3051 Moved to next CF 15 Not processed Lætitia AVROT (arkhena) ahsan hadi (ahsan.hadi), Ryan Lambert (ryanlambert) 5 3 years ago
Add option --drop-cascade for pg_dump/restore 3065 Moved to next CF Not processed Wu Haotian (whtsky) Greg Sabino Mullane (greg) 3 3 years ago
pgbench - allow retries on some errors 3194 Moved to next CF 15 Not processed Yugo Nagata (yugo.nagata), Marina Polyakova (whipping.top1991) Fabien Coelho (calvin) 2 3 years ago
Emit namespace in post-copy output 3200 Moved to next CF Not processed Mike Fiedler (miketheman) Daniel Gustafsson (d_gustafsson), Corey Huinker (coreyh) Daniel Gustafsson (d_gustafsson) 2 3 years ago
Code Comments
Extend comments on signal handling and cross-reference comments on signal handling functions 2951 Moved to next CF Not processed Craig Ringer (ringerc) Mark Dilger (mark.dilger) 3 3 years ago
Documentation
Further note require activity aspect of automatic checkpoint and archiving 2774 Moved to next CF Not processed David Johnston (polobo) 6 3 years ago
Extend docs on how to write correct postgres-dialect C including extensions and bgworkers 2953 Moved to next CF Not processed Craig Ringer (ringerc) Laurenz Albe (laurenz) 4 3 years ago
fix ICU explorer link in locale documentation 3059 Moved to next CF Not processed Anton Voloshin (a.voloshin) Laurenz Albe (laurenz) Bruce Momjian (bmomjian) 3 3 years ago
Improve documentation for pg_upgrade, standbys and rsync 3125 Moved to next CF 15 Not processed Laurenz Albe (laurenz) David Fetter (dfetter) 5 3 years ago
Clarify how triggers relate to transactions 3126 Moved to next CF 15 Not processed Laurenz Albe (laurenz) Simon Riggs (simon) Tom Lane (tgl) 2 3 years ago
Document the 1GB memory limit for VACUUM 3127 Moved to next CF 15 Not processed David Rowley (davidrowley), Laurenz Albe (laurenz) Greg Sabino Mullane (greg) David Rowley (davidrowley) 2 3 years ago
Consistent use of SSL/TLS in docs 3172 Moved to next CF Not processed Daniel Gustafsson (d_gustafsson) Robert Haas (rhaas), Lætitia AVROT (arkhena) Daniel Gustafsson (d_gustafsson) 5 3 years ago
Fix documentation for COPY protocol flow 3175 Moved to next CF Not processed Jeff Davis (jdavis) 3 3 years ago
Miscellaneous
Add table expansion hook 2614 Moved to next CF Not processed Erik Nordström (enordstr) Euler Taveira (eulerto), Aleksander Alekseev (aalekseev) 7 3 years ago
Fix behavior of geo_ops when NaN is involved 2710 Moved to next CF Not processed Kyotaro Horiguchi (horiguti) Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) 10 3 years ago
Reduce the number of special cases to build contrib modules on windows 2817 Moved to next CF Not processed David Rowley (davidrowley) David Rowley (davidrowley) 5 3 years ago
Functions for sorting GiST build of gist_btree types 2824 Moved to next CF Not processed Andrey Borodin (x4m) Heikki Linnakangas (heikki), Emre Hasegeli (hasegeli) Heikki Linnakangas (heikki) 7 3 years ago
move pg_upgrade test.sh kludges to a SQL script 2861 Moved to next CF Not processed Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 6 3 years ago
Function to log backtrace of postgres processes 2863 Moved to next CF Not processed vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) Christoph Berg (myon), Maciek Sakrejda (msakrejda) 17 1 year ago
Introduce ProcessInterrupts_hook for C extensions 2952 Moved to next CF Not processed Craig Ringer (ringerc) 3 3 years ago
postgres_fdw: suppress explicit casts in text:text comparisons 3025 Moved to next CF Not processed Dian Fay (dmfay) Tom Lane (tgl), Georgios Kokolatos (gkokolatos) Tom Lane (tgl) 4 3 years ago
Add some tests for pg_stat_statements compatibility verification 3036 Moved to next CF Not processed Erica Zhang (zerica) Julien Rouhaud (rjuju) Michael Paquier (michael-kun) 3 3 years ago
Allow multiple recursive self-references 3046 Moved to next CF Not processed Denis Hirn (brainy) Peter Eisentraut (petere) 6 2 years ago
use AV work items infrastructure for GIN pending list's cleanup 3060 Moved to next CF 15 Not processed Jaime Casanova (jcasanov) Masahiko Sawada (masahikosawada) 2 3 years ago
Avoid orphaned dependencies 3106 Moved to next CF 16 Not processed Bertrand Drouvot (bdrouvot) Ronan Dunklau (rdunklau) 6 3 years ago
Extending amcheck to check toast size and compression 3107 Moved to next CF Not processed Mark Dilger (mark.dilger) Greg Stark (stark), Aleksander Alekseev (aalekseev) Michael Paquier (michael-kun) 3 3 years ago
Rewriting the test of pg_upgrade as a TAP test - take three 3120 Moved to next CF Not processed Michael Paquier (michael-kun) 3 3 years ago
TAP test for contrib/sslinfo 3128 Moved to next CF Not processed Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) Daniel Gustafsson (d_gustafsson) 3 3 years ago
Change internal PRNG (from rand48 to something better, with a cleaner interface) 3131 Moved to next CF 15 Not processed Fabien Coelho (calvin) Aleksander Alekseev (aalekseev) Tom Lane (tgl) 3 3 years ago
btree_gist: Support bool 3157 Moved to next CF Not processed Emre Hasegeli (hasegeli) Tomas Vondra (fuzzycz) 3 3 years ago
Use tuple-level SIREAD locks for index-only scans 3163 Moved to next CF Not processed Thomas Munro (macdice) 3 3 years ago
Fully WAL logged CREATE DATABASE - No Checkpoints 3192 Moved to next CF Not processed Dilip Kumar (dilip.kumar) Ashutosh Sharma (ashu_coek) Robert Haas (rhaas) 5 3 years ago
Expose get_query_def() 3204 Moved to next CF Not processed Julien Rouhaud (rjuju) Pavel Stehule (okbobcz), Gilles Darold (darold) Tom Lane (tgl) 5 3 years ago
pgbench: add multiconnect support 3227 Moved to next CF 16 Not processed David Christensen (davidchristensen) Jelte Fennema-Nio (jeltef) 9 2 years ago
Monitoring & Control
Shared-memory based stats collector 1708 Moved to next CF Not processed Kyotaro Horiguchi (horiguti) Tomas Vondra (fuzzycz), Antonin Houska (a.houska) 17 3 years ago
Add extra statistics to explain for Nested Loop 2765 Moved to next CF Not processed Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) 10 2 years ago
pg_stat_statements and "IN" conditions 2837 Moved to next CF 6/7 +945−23 Dmitry Dolgov (erthalion) Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih) Álvaro Herrera (alvherre) 22 3 weeks ago
Track wal_level drop for backup management 2994 Moved to next CF Not processed Takamichi Osumi (tatatappp) 3 3 years ago
Add system views pg_permissions and pg_ownerships 3033 Moved to next CF Not processed Joel Jacobson (joeljacobson) 5 6 months ago
pg_stat_statements: Track statement entry timestamp 3048 Moved to next CF 17 Not processed Andrei Zubkov (zubkov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 13 1 year ago
Logging plan of the currently running query 3142 Moved to next CF 16 Not processed atsushi torikoshi (atorik) Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) 9 1 week ago
Performance
Protect syscache from bloating with negative cache entries 931 Moved to next CF Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha) 23 4 years ago
GROUP BY optimization 1651 Moved to next CF 15 Not processed Fedor Sigaev (sigaev), Pavel Borisov (pborisov) Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 12 1 year ago
Remove self join on a unique column 1712 Moved to next CF Not processed Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 27 1 week ago
Using multicolumn statistics for more precise join selectivity estimatation 2386 Moved to next CF Not processed Konstantin Knizhnik (knizhnik) Yugo Nagata (yugo.nagata) 9 3 years ago
Erase the distinctClause if the result is unique by definition 2433 Moved to next CF Not processed Andy Fan (andyf) David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Zhijie Hou (houzj) 11 3 years ago
INSERT SELECT: BulkInsertState and table_multi_insert 2553 Moved to next CF 15 Not processed Justin Pryzby (justinpryzby) 8 3 years ago
Fast COPY FROM command for the foreign tables 2601 Moved to next CF Not processed Andrei Lepikhov (lepikhov) Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) Etsuro Fujita (efujita) 13 2 years ago
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
Optimizing NULL check on pkey column 2699 Moved to next CF Not processed Surafel Temesgen (surafel) Ashutosh Bapat (ashutoshbapat) 6 3 years ago
fix spinlock contention in LogwrtResult 2716 Moved to next CF Not processed Álvaro Herrera (alvherre) 11 1 year ago
parallel distinct union and aggregate support patch 2769 Moved to next CF Not processed bucoo hsiao (bucoo) 6 3 years ago
Replace polyphase merge with a simple k-way balanced merge 2781 Moved to next CF Not processed Heikki Linnakangas (heikki) John Naylor (john.naylor) Heikki Linnakangas (heikki) 6 3 years ago
Make Append Cost aware of some run time partition prune case 2829 Moved to next CF Not processed Andy Fan (andyf) 5 3 years ago
Consider parallel for LATERAL subqueries having LIMIT/OFFSET 2851 Moved to next CF Not processed James Coleman (jcole1989) Greg Nancarrow (gregn1234) 11 2 years ago
Faster pglz compression 2897 Moved to next CF Not processed Andrey Borodin (x4m), Владимир Лесков (tinsane) Mark Dilger (mark.dilger) Tomas Vondra (fuzzycz) 12 2 years ago
Parallel Hash Full Join 2903 Moved to next CF 16 Not processed Melanie Plageman (melanieplageman) Thomas Munro (macdice) Thomas Munro (macdice) 12 2 years ago
WIP: Track relation size in shared memory 2933 Moved to next CF Not processed Thomas Munro (macdice) 3 3 years ago
increase size of pg_commit_ts buffers 2942 Moved to next CF Not processed Álvaro Herrera (alvherre) Noah Misch (nmisch) Álvaro Herrera (alvherre) 4 3 years ago
Full support for index LP_DEAD hint bits on standby 2947 Moved to next CF Not processed Michail Nikolaev (nkey) Antonin Houska (a.houska) 6 3 years ago
Simplify some RI checks to reduce SPI overhead 2948 Moved to next CF Not processed Amit Langote (amitlan) Tom Lane (tgl), Corey Huinker (coreyh) Álvaro Herrera (alvherre) 6 3 years ago
Adaptive query optimization: create extented statistics using auto_explain extension 2958 Moved to next CF Not processed Konstantin Knizhnik (knizhnik) 4 3 years ago
Improve join selectivity estimation using extended statistics 2959 Moved to next CF Not processed Konstantin Knizhnik (knizhnik) 3 3 years ago
partial heap only tuples 2981 Moved to next CF 15 Not processed Nathan Bossart (bossartn) 4 3 years ago
Allow setting parallel_workers on partitioned tables 2987 Moved to next CF Not processed Seamus Abshere (seamusabshere) Amit Langote (amitlan), Laurenz Albe (laurenz), Zhijie Hou (houzj) 3 3 years ago
speed up pg_rewind by using copy_file_range() and skipping some fsync 2990 Moved to next CF Not processed Paul Guo (paulguo-vmware) Michael Paquier (michael-kun) 3 3 years ago
Speed up verifying UTF-8 2996 Moved to next CF Not processed John Naylor (john.naylor) Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan) John Naylor (john.naylor) 5 3 years ago
Speeding up GIST index builds using popcount 3023 Moved to next CF Not processed Amit Khandekar (amitdkhan) John Naylor (john.naylor) 3 3 years ago
Make relfile tombstone files conditional on WAL level 3030 Moved to next CF Not processed Thomas Munro (macdice) 3 2 years ago
More sort-related specialisation 3038 Moved to next CF Not processed Thomas Munro (macdice) John Naylor (john.naylor) John Naylor (john.naylor) 5 3 years ago
Built-in connection pooler 3043 Moved to next CF Not processed Konstantin Knizhnik (knizhnik) Antonin Houska (a.houska) 2 3 years ago
add explicit partial union-all and improve parallel subquery costing 3070 Moved to next CF Not processed Luc Vlaming (luc.vlaming) Ronan Dunklau (rdunklau) 3 3 years ago
Lazy JIT IR code generation to increase JIT speed with partitions 3071 Moved to next CF Not processed David Geier (geidav), Luc Vlaming (luc.vlaming) Dmitry Dolgov (erthalion) 9 2 years ago
Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation 3078 Moved to next CF 15 Not processed Matthias van de Meent (mmeent) 4 3 years ago
Use simplehash.h instead of dynahash in SMgr 3092 Moved to next CF Not processed David Rowley (davidrowley) Yura Sokolov (funny_falcon) 3 3 years ago
Toast compression method options 3102 Moved to next CF Not processed Dilip Kumar (dilip.kumar) 3 3 years ago
Reducing memory consumption for pending inval messages 3141 Moved to next CF Not processed Tom Lane (tgl) Nathan Bossart (bossartn) Tom Lane (tgl) 2 3 years ago
Parallel INSERT SELECT take 2 3143 Moved to next CF Not processed Greg Nancarrow (gregn1234), Zhijie Hou (houzj) 6 2 years ago
pre-allocating WAL files 3158 Moved to next CF 16 Not processed Nathan Bossart (bossartn) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) 6 2 years ago
Add proper planner support for ORDER BY / DISTINCT aggregates 3164 Moved to next CF Not processed David Rowley (davidrowley) Ronan Dunklau (rdunklau), Richard Guo (richardguo) David Rowley (davidrowley) 7 2 years ago
Map WAL segment files on PMEM as WAL buffers 3181 Moved to next CF Not processed Takashi Menjo (tmenjo) 6 3 years ago
Using indexUnchanged with nbtree 3191 Moved to next CF 15 Not processed Simon Riggs (simon) 2 3 years ago
Write visibility map during CLUSTER/VACUUM FULL 3206 Moved to next CF Not processed Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva) Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) 6 2 years ago
Don't block HOT update by BRIN index 3218 Moved to next CF Not processed Josef Šimánek (retro) Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 3 3 years ago
Speed up LockReleaseAll 3220 Moved to next CF Not processed David Rowley (davidrowley) 3 1 year ago
Fix ExecRTCheckPerms() inefficiency with many prunable partitions 3224 Moved to next CF 16 Not processed Amit Langote (amitlan) Álvaro Herrera (alvherre), Tom Lane (tgl) Álvaro Herrera (alvherre) 8 1 year ago
Window function run conditions 3234 Moved to next CF Not processed David Rowley (davidrowley) David Rowley (davidrowley) 5 3 years ago
Procedural Languages
declarative session variables, LET command 1608 Moved to next CF 6/7 +9966−64 Pavel Stehule (okbobcz) Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), newtglobal postgresql_contributors (newtpostgrescontributors) 36 1 week ago
UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR 2376 Moved to next CF Not processed John Dent (denty) Daniel Vérité (danielverite) 9 3 years ago
enhancing plpgsql API for debugging and tracing 2684 Moved to next CF Not processed Pavel Stehule (okbobcz) Aleksander Alekseev (aalekseev) Tom Lane (tgl) 9 3 years ago
possibility to rename root namespace in plpgsql 2839 Moved to next CF Not processed Pavel Stehule (okbobcz) Julien Rouhaud (rjuju) 7 3 years ago
Refactoring
Remove page-read callback from XLogReaderState 2113 Moved to next CF Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Antonin Houska (a.houska), Takashi Menjo (tmenjo) Thomas Munro (macdice) 13 3 years ago
Split StdRdOptions into HeapOptions and ToastOptions 2370 Moved to next CF Not processed Nikolay Shaplov (nataraj) 10 3 years ago
ResourceOwner refactoring 2834 Moved to next CF Not processed Heikki Linnakangas (heikki) Aleksander Alekseev (a.alekseev) 4 1 year ago
PoC Refactor AM analyse API 2907 Moved to next CF Not processed Denis Smirnov (darthunix) Heikki Linnakangas (heikki) 4 3 years ago
Infrastructure changes to make the code less sensitive to transaction id bit width 2960 Moved to next CF Not processed James Finnerty (jimfinnerty) 3 3 years ago
Rework the sslfiles Makefile target 3029 Moved to next CF Not processed Jacob Champion (jchampion) Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 3 3 years ago
Extend portability of client_connection_check_interval 3098 Moved to next CF Not processed Thomas Munro (macdice) Maksim Milyutin (maksm90) Thomas Munro (macdice) 5 3 years ago
psql - refactor echo code 3140 Moved to next CF Not processed Fabien Coelho (calvin) Pavel Stehule (okbobcz), Peter Eisentraut (petere) 10 2 years ago
A micro-optimisation for ProcSendSignal() 3146 Moved to next CF Not processed Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) Thomas Munro (macdice) 4 3 years ago
procarray.c: two refactorings 3169 Moved to next CF Not processed Ranier Vilela (raniervilela) Aleksander Alekseev (aalekseev) Fujii Masao (masaofujii) 2 3 years ago
Split xlog.c 3173 Moved to next CF Not processed Heikki Linnakangas (heikki) 3 3 years ago
automatically generating node support functions 3182 Moved to next CF Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 6 2 years ago
improvements in Unicode tables generation code 3208 Moved to next CF Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 3 3 years ago
Extensible storage manager API - smgr hooks 3216 Moved to next CF Not processed Anastasia Lubennikova (lubennikovaav) 5 3 years ago
Remove redundant initializations 3229 Moved to next CF Not processed Peter Eisentraut (petere) Noah Misch (nmisch) 2 3 years ago
Replication & Recovery
Make async slave to wait for lsn to be replayed 772 Moved to next CF Not processed Ivan Kartyshov (fenimorkin) Thomas Munro (macdice), Dmitry Ivanov (funbringer), Anna Akenteva (a.akenteva), Alexandra Pervushina (a.pervushina) 14 4 years ago
Make message at end-of-recovery less scary 2490 Moved to next CF Not processed Kyotaro Horiguchi (horiguti) Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) 20 1 year ago
Background writer and checkpointer in crash recovery 2706 Moved to next CF Not processed Thomas Munro (macdice) Aleksander Alekseev (aalekseev) Thomas Munro (macdice) 6 3 years ago
Row filtering for logical replication 2906 Moved to next CF 15 Not processed Euler Taveira (eulerto), Peter Smith (smithpb), Ajin Cherian (ajinc), Zhijie Hou (houzj) Dilip Kumar (dilip.kumar), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Zhijie Hou (houzj), Rahila Syed (rahila) Amit Kapila (amitkapila) 7 3 years ago
wal_sessioninfo 2910 Moved to next CF Not processed Simon Riggs (simon) Cleysson Lima (cleyssonlima) 4 3 years ago
logical decoding of two-phase transactions 2914 Moved to next CF 15 Not processed Stas Kelvich (kelvich), Nikhil Sontakke (nikkhils), Ajin Cherian (ajinc), Peter Smith (smithpb2250) Amit Kapila (amitkapila), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) Amit Kapila (amitkapila) 4 3 years ago
Reduce the time required for a database recovery from archive. 2935 Moved to next CF Not processed Anna Akenteva (a.akenteva), Dmitry Shulga (d.shulga), Ivan Taranov (i.taranov) 3 4 years ago
Identify missing publications from publisher while create/alter subscription. 2957 Moved to next CF Not processed vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Euler Taveira (eulerto), Ashutosh Sharma (ashu_coek), Japin Li (japin), Bharath Rupireddy (bharathrupireddy) Amit Kapila (amitkapila) 6 3 years ago
Minimal logical decoding on standbys (take 6) 2968 Moved to next CF Not processed Amit Khandekar (amitdkhan) Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) 5 2 years ago
Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 3040 Moved to next CF Not processed Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson), vigneshwaran C (vignesh.postgres) Daniel Gustafsson (d_gustafsson) 3 3 years ago
tablesync early exit 3062 Moved to next CF 15 Not processed Peter Smith (smithpb2250) 6 3 years ago
A test for replay of regression tests 3090 Moved to next CF Not processed Thomas Munro (macdice) Anastasia Lubennikova (lubennikovaav) Thomas Munro (macdice) 4 3 years ago
avoid logical replication empty transactions 3093 Moved to next CF 15 Not processed Euler Taveira (eulerto), Ajin Cherian (ajinc) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb), Greg Nancarrow (gregn1234) Amit Kapila (amitkapila) 5 3 years ago
Diagnostic comment in LogicalIncreaseXminForSlot 3124 Moved to next CF Not processed Ashutosh Bapat (ashutoshbapat) Masahiko Sawada (masahikosawada) Amit Kapila (amitkapila) 2 3 years ago
Replicates changes for all tables in schema 3139 Moved to next CF 15 Not processed vigneshwaran C (vignesh.postgres) Greg Nancarrow (gregn1234), Haiying Tang (tanghy), Mark Dilger (mark.dilger), Zhijie Hou (houzj), Rahila Syed (rahila) Amit Kapila (amitkapila) 3 3 years ago
Detectable crashes and unlogged table resets 3183 Moved to next CF Not processed Jeff Davis (jdavis) 5 3 years ago
Skipping logical replication transactions on subscriber side 3205 Moved to next CF Not processed Masahiko Sawada (masahikosawada) vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Mark Dilger (mark.dilger), Zhijie Hou (houzj) Amit Kapila (amitkapila) 5 3 years ago
Allow providing restore_command as a command line option to pg_rewind 3213 Moved to next CF Not processed Alexey Kondratov (ololobus) Andrey Borodin (x4m) 5 3 years ago
PITR enhance getRecordTimestamp() 3222 Moved to next CF Not processed Simon Riggs (simon) 8 3 years ago
Column filtering in logical replication 3230 Moved to next CF 15 Not processed Álvaro Herrera (alvherre), Rahila Syed (rahila.syed), Tomas Vondra (fuzzycz) Álvaro Herrera (alvherre), Peter Eisentraut (petere), vigneshwaran C (vignesh.postgres) Tomas Vondra (fuzzycz) 5 3 years ago
Teach pg_receivewal to use lz4 compression 3231 Moved to next CF 15 Not processed Georgios Kokolatos (gkokolatos) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 3 years ago
Security
public schema default ACL 3017 Moved to next CF Not processed Noah Misch (nmisch) Peter Eisentraut (petere) Noah Misch (nmisch) 3 3 years ago
Convert contrib SQL functions to new style 3074 Moved to next CF Not processed Tom Lane (tgl) 2 3 months ago
Improve sepgsql logging so it follows the behaviour of selinux's logging. 3076 Moved to next CF Not processed Dave Page (dpage) Jacob Champion (jchampion) Tom Lane (tgl) 4 3 years ago
Support for NSS as a libpq TLS backend 3138 Moved to next CF Not processed Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) Joshua Brindle (joshuab) 5 3 years ago
Delegating superuser tasks to new security roles 3223 Moved to next CF 15 Not processed Mark Dilger (mark.dilger) Andrew Dunstan (adunstan), Nathan Bossart (bossartn) 3 3 years ago
Server Features
Transactions involving multiple postgres foreign servers 1574 Moved to next CF Not processed Masahiko Sawada (masahikosawada), Ashutosh Bapat (ashutoshbapat) Takayuki Tsunakawa (maumau), Ashutosh Bapat (ashutoshbapat), Chris Travers (einhverfr), Muhammad Usama (muhammad_usama), Masahiro Ikeda (masahiro.ikeda) 18 3 years ago
Index Skip Scan 1741 Moved to next CF 16 Not processed Dmitry Dolgov (erthalion), Thomas Munro (macdice), Jesper Pedersen (jpedersen) Peter Geoghegan (pgeoghegan), Dilip Kumar (dilip.kumar), Thomas Munro (macdice), Chris Travers (einhverfr), James Coleman (jcole1989), Cristiano Duarte (cunha17), Andy Fan (andyf), Yuming Wang (yumwang), Jet Zhang (thinkj), Alexandre Felipe (bob.tpro) 19 3 years ago
A hook for path-removal decision on add_path 2234 Moved to next CF Not processed KaiGai Kohei (kaigai) 11 2 years ago
Fix partitionwise join with partially-redundant join clauses 2266 Moved to next CF Not processed Richard Guo (richardguo) Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) Richard Guo (richardguo) 16 8 months ago
Global temporary table 2349 Moved to next CF 16 Not processed Wenjing Zeng (wenjing.zwj) Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) 13 2 years ago
GUC to disable cancellation of awaiting for synchronous replication 2402 Moved to next CF Not processed Andrey Borodin (x4m) Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev) 9 3 years ago
jsonpath syntax extensions 2482 Moved to next CF 15 Not processed Nikita Glukhov (n.glukhov) 12 3 years ago
ALTER SYSTEM READ { ONLY | WRITE } 2602 Moved to next CF Not processed Amul Sul (sulamul) 9 3 years ago
Extended statistics / estimate Var op Var clauses 2831 Moved to next CF Not processed Tomas Vondra (fuzzycz) Dean Rasheed (deanr), Mark Dilger (mark.dilger) 9 2 years ago
Xact event callback at command start 2860 Moved to next CF Not processed Gilles Darold (darold) Julien Rouhaud (rjuju) 4 3 years ago
New Table Access Methods for Multi and Single Inserts 2871 Moved to next CF Not processed Bharath Rupireddy (bharathrupireddy) 9 5 months ago
On client login event trigger 2900 Moved to next CF 17 Not processed Konstantin Knizhnik (knizhnik), Greg Nancarrow (gregn1234), Mikhail Gribkov (youzhick) Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234) Alexander Korotkov (smagen) 15 1 year ago
SQL/JSON: functions 2901 Moved to next CF 15 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) 7 3 years ago
SQL/JSON: JSON_TABLE 2902 Moved to next CF 15 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) 7 3 years ago
Allow batched insert during cross-partition updates 2992 Moved to next CF Not processed Amit Langote (amitlan) Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Zhijie Hou (houzj) Etsuro Fujita (efujita) 10 2 years ago
Hooks and API to allow loadable wire protocol extensions 3018 Moved to next CF Not processed Jan Wieck (wieck) 3 4 years ago
Add regexp_positions(string text, pattern text, flags text) → setof record (starts integer[], lengths integer[]) 3027 Moved to next CF Not processed Joel Jacobson (joeljacobson) Tom Lane (tgl) 3 3 years ago
PROXY protocol support 3032 Moved to next CF Not processed Magnus Hagander (mha) Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) 7 2 years ago
Add common functions regexp_like, regexp_count, regexp_instr, regexp_substr and regexp_replace 3042 Moved to next CF Not processed Gilles Darold (darold) Tom Lane (tgl) Tom Lane (tgl) 2 3 years ago
Extended statistics in EXPLAIN 3050 Moved to next CF Not processed Tomas Vondra (fuzzycz) Tatsuro Yamada (tatsuro_yamada) 6 3 years ago
Merging statistics from children instead of re-sampling everything 3052 Moved to next CF Not processed Tomas Vondra (fuzzycz) 5 3 years ago
Add missing function abs (interval) 3054 Moved to next CF Not processed Isaac Morland (ijmorlan) Tom Lane (tgl) 3 3 years ago
estimating joins using extended statistics 3055 Moved to next CF Not processed Tomas Vondra (fuzzycz) Andy Fan (andyf) 4 3 years ago
Remove 64K hard limit on rangetable size 3063 Moved to next CF Not processed Tom Lane (tgl) Aleksander Alekseev (a.alekseev) Tom Lane (tgl) 2 3 years ago
Add callback table access method to reset filenode when dropping relation 3073 Moved to next CF Not processed Mats Kindahl (matski) Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) 7 2 years ago
Addition of authenticated ID to pg_stat_activity 3095 Moved to next CF 15 Not processed Michael Paquier (michael-kun) Aleksander Alekseev (aalekseev) 2 3 years ago
Asymmetric partition-wise JOIN 3099 Moved to next CF 15 Not processed KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) Alexander Pyhalov (a.pyhalov) 7 3 years ago
Extensible parsing 3100 Moved to next CF 15 Not processed Julien Rouhaud (rjuju) 4 3 years ago
postgres_fdw: Handle boolean comparison predicates 3144 Moved to next CF Not processed Emre Hasegeli (hasegeli) Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat), Cary Huang (cary) 2 3 years ago
logical decoding and replication of sequences 3155 Moved to next CF Not processed Tomas Vondra (fuzzycz) Peter Eisentraut (petere) Tomas Vondra (fuzzycz) 5 2 years ago
Range Merge Join 3160 Moved to next CF 15 Not processed Thomas Mannhart (thomasmannhart97) 4 3 years ago
unnesting multirange data types 3178 Moved to next CF 14 Not processed Alexander Korotkov (smagen) Justin Pryzby (justinpryzby), Jonathan Katz (jkatz05) Alexander Korotkov (smagen) 2 3 years ago
pg_stats and range statistics 3184 Moved to next CF 17 Not processed Egor Rogov (egorius) Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) Alexander Korotkov (smagen) 13 1 year ago
Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands 3188 Moved to next CF Not processed Yuzuko Hosoya (yuzu) 2 3 years ago
PoC: improving join estimates using sampling 3211 Moved to next CF Not processed Tomas Vondra (fuzzycz) 5 3 years ago
Cleaning up orphaned files using undo logs 3228 Moved to next CF Not processed Antonin Houska (a.houska) Dmitry Dolgov (erthalion) 4 3 years ago
Automatic notification of top transaction IDs 3232 Moved to next CF Not processed Gurjeet Singh (gurjeet) Cary Huang (cary) 3 3 years ago
SQL Commands
SQL:2011 application time 2048 Moved to next CF Not processed Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) Peter Eisentraut (petere) 12 3 weeks ago
Incremental Materialized View Maintenance 2138 Moved to next CF 16 Not processed Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) 17 2 years ago
FETCH FIRST clause PERCENT option 2176 Moved to next CF Not processed Surafel Temesgen (surafel) 12 3 years ago
Implement INSERT SET syntax 2218 Moved to next CF Not processed Gareth Palmer (gareth) Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj) 15 2 years ago
WITH SYSTEM VERSIONING Temporal Tables 2316 Moved to next CF Not processed Surafel Temesgen (surafel) Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre) 11 3 years ago
Automatic HASH and LIST partition creation 2694 Moved to next CF Not processed Anastasia Lubennikova (lubennikovaav) Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) 7 3 years ago
Allow COPY "text" to output a header and add header matching mode to COPY FROM 2780 Moved to next CF Not processed Rémi Lapeyre (remilapeyre) Peter Eisentraut (petere) Peter Eisentraut (petere) 8 3 years ago
CLUSTER on partitioned table 2800 Moved to next CF 15 Not processed Justin Pryzby (justinpryzby) Matthias van de Meent (mmeent) Álvaro Herrera (alvherre) 8 3 years ago
CREATE INDEX CONCURRENTLY on partitioned table 2815 Moved to next CF Not processed Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) 15 5 months ago
create table like: ACCESS METHOD 2865 Moved to next CF 15 Not processed Justin Pryzby (justinpryzby) Simon Riggs (simon) 4 3 years ago
Dynamic result sets from procedures 2911 Moved to next CF Not processed Peter Eisentraut (petere) 12 2 years ago
MERGE SQL command 2920 Moved to next CF 15 Not processed Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) 4 3 years ago
Partial foreign key updates in referential integrity triggers 2932 Moved to next CF 15 Not processed Paul Martinez (pauljulius) Peter Eisentraut (petere) Peter Eisentraut (petere) 5 3 years ago
NOT VALID for Unique Indexes 2937 Moved to next CF Not processed Simon Riggs (simon) 3 3 years ago
Foreign Key Arrays 2966 Moved to next CF Not processed Mark Rofail (markmoheb) Joel Jacobson (joeljacobson), Justin Pryzby (justinpryzby) 3 3 years ago
Release SPI plans for referential integrity with DISCARD 3037 Moved to next CF Not processed Yuzuko Hosoya (yuzu) 2 3 years ago
rename column if exists 3045 Moved to next CF Not processed David Oksman (oks) Yagiz Nizipli (yagiznizipli) 4 3 years ago
Allow queries in WHEN expression of FOR EACH STATEMENT triggers 3148 Moved to next CF Not processed Joe Wildish (joewildish) 2 3 years ago
DELETE CASCADE 3195 Moved to next CF 15 Not processed David Christensen (davidchristensen) 4 3 years ago
System Administration
Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) 2377 Moved to next CF Not processed Justin Pryzby (justinpryzby) Fabien Coelho (calvin) 21 1 year ago
Fix pg_rewind race condition just after promotion 2864 Moved to next CF Not processed Heikki Linnakangas (heikki) Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) Heikki Linnakangas (heikki) 12 2 years ago
Mitigate pg_rewind race condition, if config file is enlarged concurrently. 2869 Moved to next CF Not processed Heikki Linnakangas (heikki) Daniel Gustafsson (d_gustafsson), Cary Huang (cary) Daniel Gustafsson (d_gustafsson) 7 3 years ago
New default role allowing to change per-role settings 2918 Moved to next CF Not processed Michael Banck (mbanck) Stephen Frost (sfrost), Shinya Kato (kato-shinya) 8 3 years ago
Catalog version access 2999 Moved to next CF Not processed Vik Fearing (xocolatl), Nathan Bossart (bossartn) Nathan Bossart (bossartn) 5 3 years ago
Add --create-only option to pg_dump/pg_dumpall 3026 Moved to next CF Not processed Michael Banck (mbanck) Cary Huang (cary), Nitin Jadhav (nitinjadhav11) 3 3 years ago
Reduce lock level for ALTER TABLE ... ADD CHECK 3088 Moved to next CF 15 Not processed Simon Riggs (simon) Greg Sabino Mullane (greg) 3 3 years ago
add pg_ctl option that returns amount of shmem required 3161 Moved to next CF Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 2 years ago