Commitfest 2021-09 (2021-09-01 – 2021-09-30)

Make async slave to wait for lsn to be replayed 772 Returned with feedback Not processed Ivan Kartyshov (fenimorkin) Thomas Munro (macdice), Dmitry Ivanov (funbringer), Anna Akenteva (a.akenteva), Alexandra Pervushina (a.pervushina) 14 5 years ago Protect syscache from bloating with negative cache entries 931 Returned with feedback Performance Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha) 23 5 years ago Transactions involving multiple postgres foreign servers 1574 Returned with feedback 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 4 years ago declarative session variables, LET command 1608 Moved to different CF DDL 10/10 +3003−37 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), Jim Jones (jimus), newtglobal postgresql_contributors (newtpostgrescontributors) 40 2 days ago GROUP BY optimization 1651 Moved to different CF Performance 15 Not processed Fedor Sigaev (sigaev), Pavel Borisov (pborisov) Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 12 2 years ago Shared-memory based stats collector 1708 Returned with feedback Monitoring Not processed Kyotaro Horiguchi (horiguti) Tomas Vondra (fuzzycz), Antonin Houska (a.houska) 17 3 years ago Remove self join on a unique column 1712 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 27 11 months ago Index Skip Scan 1741 Moved to different 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 4 years ago SQL:2011 application time 2048 Moved to different CF SQL Commands Not processed Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) Peter Eisentraut (petere) 12 10 months ago psql - add SHOW_ALL_RESULTS option 2096 Moved to different CF libpq Not processed Fabien Coelho (calvin) Peter Eisentraut (petere) Peter Eisentraut (petere) 13 3 years ago Remove page-read callback from XLogReaderState 2113 Moved to different CF Refactoring Only Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Antonin Houska (a.houska), Takashi Menjo (tmenjo) Thomas Munro (macdice) 13 4 years ago Incremental Materialized View Maintenance 2138 Moved to different CF SQL Commands 16 Not processed Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) 17 3 years ago standby recovery fails when re-replaying due to missing directory which was removed in previous replay. 2161 Moved to different CF Bugfix stable Not processed Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) Michael Paquier (michael-kun) Álvaro Herrera (alvherre) 16 3 years ago FETCH FIRST clause PERCENT option 2176 Returned with feedback SQL Commands Not processed Surafel Temesgen (surafel) 12 4 years ago pg_upgrade fails with non-standard ACL 2215 Moved to different CF Bugfix Not processed Anastasia Lubennikova (lubennikovaav), Artur Zakirov (a.zakirov) Grigory Smolkin (g.smolkin.postgrespro.ru) Noah Misch (nmisch) 12 4 years ago Implement INSERT SET syntax 2218 Moved to different CF SQL Commands Not processed Gareth Palmer (gareth) Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj) 15 3 years ago A hook for path-removal decision on add_path 2234 Returned with feedback Not processed KaiGai Kohei (kaigai) 11 3 years ago Fix partitionwise join with partially-redundant join clauses 2266 Moved to different CF Not processed Richard Guo (richardguo) Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) Richard Guo (richardguo) 16 1 year ago WITH SYSTEM VERSIONING Temporal Tables 2316 Moved to different CF SQL Commands Not processed Surafel Temesgen (surafel) Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre) 11 4 years ago Global temporary table 2349 Moved to different CF 16 Not processed Wenjing Zeng (wenjing.zwj) Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) 13 3 years ago Split StdRdOptions into HeapOptions and ToastOptions 2370 Moved to different CF Refactoring Only Not processed Nikolay Shaplov (nataraj) 10 4 years ago UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR 2376 Returned with feedback Not processed John Dent (denty) Daniel Vérité (danielverite) 9 4 years ago Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) 2377 Moved to different CF System Administration Not processed Justin Pryzby (justinpryzby) Fabien Coelho (calvin) 21 2 years ago Using multicolumn statistics for more precise join selectivity estimatation 2386 Returned with feedback Performance Not processed Konstantin Knizhnik (knizhnik) Yugo Nagata (yugo.nagata) 9 4 years ago GUC to disable cancellation of awaiting for synchronous replication 2402 Returned with feedback Not processed Andrey Borodin (x4m) Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev) 9 4 years ago Erase the distinctClause if the result is unique by definition 2433 Moved to different CF Performance Not processed Andy Fan (andyf) David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Zhijie Hou (houzj) 11 4 years ago jsonpath syntax extensions 2482 Moved to different CF 15 Not processed Nikita Glukhov (n.glukhov) 12 4 years ago Make message at end-of-recovery less scary 2490 Moved to different CF Not processed Kyotaro Horiguchi (horiguti) Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) 20 2 years ago Corruption during WAL replay 2518 Moved to different CF Bugfix stable Not processed Teja Mupparti (tejam) Robert Haas (rhaas), Daniel Shelepanov (dshelepanov) Robert Haas (rhaas) 10 4 years ago archive status ".ready" files may be created too early 2520 Committed Bugfix stable Not processed Nathan Bossart (bossartn) Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 7 4 years ago INSERT SELECT: BulkInsertState and table_multi_insert 2553 Moved to different CF Performance 15 Not processed Justin Pryzby (justinpryzby) 8 4 years ago pg_dump - read data for some options from external file 2573 Moved to different CF libpq Not processed Pavel Stehule (okbobcz) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v) Daniel Gustafsson (d_gustafsson) 18 2 years ago Fast COPY FROM command for the foreign tables 2601 Moved to different CF Performance Not processed Andrei Lepikhov (lepikhov) Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) Etsuro Fujita (efujita) 13 3 years ago ALTER SYSTEM READ { ONLY | WRITE } 2602 Moved to different CF Not processed Amul Sul (sulamul) 9 4 years ago DROP relation IF EXISTS Docs and Tests - Bug Fix 2603 Withdrawn Bugfix Not processed David Johnston (polobo) Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com) 7 4 years ago Add table expansion hook 2614 Returned with feedback Not processed Erik Nordström (enordstr) Euler Taveira (eulerto), Aleksander Alekseev (aalekseev) 7 4 years ago More scalable multixacts buffers and locking 2627 Moved to different CF Performance Not processed Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) Álvaro Herrera (alvherre) 20 1 year ago enhancing plpgsql API for debugging and tracing 2684 Moved to different CF Not processed Pavel Stehule (okbobcz) Aleksander Alekseev (aalekseev) Tom Lane (tgl) 9 4 years ago Fix collation handling in postgres_fdw 2685 Returned with feedback Bugfix Not processed Tom Lane (tgl) Etsuro Fujita (efujita) 6 4 years ago Automatic HASH and LIST partition creation 2694 Moved to different CF SQL Commands Not processed Anastasia Lubennikova (lubennikovaav) Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) 7 4 years ago Optimizing NULL check on pkey column 2699 Returned with feedback Performance Not processed Surafel Temesgen (surafel) Ashutosh Bapat (ashutoshbapat) 6 4 years ago Background writer and checkpointer in crash recovery 2706 Committed Not processed Thomas Munro (macdice) Aleksander Alekseev (aalekseev) Thomas Munro (macdice) 6 4 years ago Fix behavior of geo_ops when NaN is involved 2710 Moved to different CF Not processed Kyotaro Horiguchi (horiguti) Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) 10 4 years ago fix spinlock contention in LogwrtResult 2716 Moved to different CF Performance Not processed Álvaro Herrera (alvherre) 11 1 year ago Fix checksum verification in base backups for zero page headers 2719 Returned with feedback Bugfix Not processed Michael Banck (mbanck) Anastasia Lubennikova (lubennikovaav), David Steele (dsteele) 6 4 years ago Add extra statistics to explain for Nested Loop 2765 Moved to different CF Monitoring 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 3 years ago parallel distinct union and aggregate support patch 2769 Moved to different CF Performance Not processed bucoo hsiao (bucoo) 6 4 years ago libpq compression 2773 Moved to different CF libpq 15 Not processed Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag) 6 4 years ago Further note require activity aspect of automatic checkpoint and archiving 2774 Moved to different CF Docs Only Not processed David Johnston (polobo) 6 4 years ago Allow COPY "text" to output a header and add header matching mode to COPY FROM 2780 Moved to different CF SQL Commands Not processed Rémi Lapeyre (remilapeyre) Peter Eisentraut (petere) Peter Eisentraut (petere) 8 4 years ago Replace polyphase merge with a simple k-way balanced merge 2781 Moved to different CF Performance Not processed Heikki Linnakangas (heikki) John Naylor (john.naylor) Heikki Linnakangas (heikki) 6 4 years ago CLUSTER on partitioned table 2800 Moved to different CF SQL Commands 15 Not processed Justin Pryzby (justinpryzby) Matthias van de Meent (mmeent) Álvaro Herrera (alvherre) 8 4 years ago CREATE INDEX CONCURRENTLY on partitioned table 2815 Moved to different CF SQL Commands Not processed Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) 15 9 months ago Reduce the number of special cases to build contrib modules on windows 2817 Committed Not processed David Rowley (davidrowley) David Rowley (davidrowley) 5 4 years ago Functions for sorting GiST build of gist_btree types 2824 Moved to different CF Not processed Andrey Borodin (x4m) Heikki Linnakangas (heikki), Emre Hasegeli (hasegeli) Heikki Linnakangas (heikki) 7 4 years ago Make Append Cost aware of some run time partition prune case 2829 Moved to different CF Performance Not processed Andy Fan (andyf) 5 4 years ago Extended statistics / estimate Var op Var clauses 2831 Moved to different CF Not processed Tomas Vondra (fuzzycz) Dean Rasheed (deanr), Mark Dilger (mark.dilger) 9 3 years ago ResourceOwner refactoring 2834 Returned with feedback Refactoring Only Not processed Heikki Linnakangas (heikki) Aleksander Alekseev (a.alekseev) 4 2 years ago pg_stat_statements and "IN" conditions 2837 Moved to different CF Monitoring 6/7 +945−23 Dmitry Dolgov (erthalion) Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih) Álvaro Herrera (alvherre) 22 1 year ago brin: avoid errors processing work item following concurrent reindex 2838 Moved to different CF Bugfix stable Not processed Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby) Gurjeet Singh (gurjeet) 5 4 years ago possibility to rename root namespace in plpgsql 2839 Moved to different CF Not processed Pavel Stehule (okbobcz) Julien Rouhaud (rjuju) 7 4 years ago Consider parallel for LATERAL subqueries having LIMIT/OFFSET 2851 Moved to different CF Performance Not processed James Coleman (jcole1989) Greg Nancarrow (gregn1234) 11 3 years ago Xact event callback at command start 2860 Rejected Not processed Gilles Darold (darold) Julien Rouhaud (rjuju) 4 4 years ago move pg_upgrade test.sh kludges to a SQL script 2861 Moved to different CF Not processed Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 6 4 years ago Function to log backtrace of postgres processes 2863 Moved to different CF Not processed vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) Christoph Berg (myon), Maciek Sakrejda (msakrejda) 17 2 years ago Fix pg_rewind race condition just after promotion 2864 Moved to different CF System Administration Not processed Heikki Linnakangas (heikki) Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) Heikki Linnakangas (heikki) 12 3 years ago create table like: ACCESS METHOD 2865 Returned with feedback SQL Commands 15 Not processed Justin Pryzby (justinpryzby) Simon Riggs (simon) 4 4 years ago Mitigate pg_rewind race condition, if config file is enlarged concurrently. 2869 Moved to different CF System Administration Not processed Heikki Linnakangas (heikki) Daniel Gustafsson (d_gustafsson), Cary Huang (cary) Daniel Gustafsson (d_gustafsson) 7 4 years ago New Table Access Methods for Multi and Single Inserts 2871 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) 9 1 year ago Fix firing of RI triggers during cross-partition updates of partitioned tables 2877 Moved to different CF Bugfix Not processed Amit Langote (amitlan) Masahiko Sawada (masahikosawada) Álvaro Herrera (alvherre) 7 4 years ago Faster pglz compression 2897 Moved to different CF Performance Not processed Andrey Borodin (x4m), Владимир Лесков (tinsane) Mark Dilger (mark.dilger) Tomas Vondra (fuzzycz) 12 3 years ago On client login event trigger 2900 Moved to different 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 2 years ago SQL/JSON: functions 2901 Moved to different CF 15 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) 7 3 years ago SQL/JSON: JSON_TABLE 2902 Moved to different CF 15 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) 7 3 years ago Parallel Hash Full Join 2903 Moved to different CF Performance 16 Not processed Melanie Plageman (melanieplageman) Thomas Munro (macdice) Thomas Munro (macdice) 12 2 years ago Row filtering for logical replication 2906 Moved to different 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 4 years ago PoC Refactor AM analyse API 2907 Returned with feedback Refactoring Only Not processed Denis Smirnov (darthunix) Heikki Linnakangas (heikki) 4 4 years ago wal_sessioninfo 2910 Returned with feedback Not processed Simon Riggs (simon) Cleysson Lima (cleyssonlima) 4 4 years ago Dynamic result sets from procedures 2911 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) 12 3 years ago logical decoding of two-phase transactions 2914 Committed 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 4 years ago New default role allowing to change per-role settings 2918 Moved to different CF System Administration Not processed Michael Banck (mbanck) Stephen Frost (sfrost), Shinya Kato (kato-shinya) 8 4 years ago MERGE SQL command 2920 Returned with feedback SQL Commands 15 Not processed Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) 4 4 years ago Partial foreign key updates in referential integrity triggers 2932 Moved to different CF SQL Commands 15 Not processed Paul Martinez (pauljulius) Peter Eisentraut (petere) Peter Eisentraut (petere) 5 4 years ago WIP: Track relation size in shared memory 2933 Returned with feedback Performance Not processed Thomas Munro (macdice) 3 4 years ago Reduce the time required for a database recovery from archive. 2935 Returned with feedback Not processed Anna Akenteva (a.akenteva), Dmitry Shulga (d.shulga), Ivan Taranov (i.taranov) 3 5 years ago NOT VALID for Unique Indexes 2937 Returned with feedback SQL Commands Not processed Simon Riggs (simon) 3 4 years ago increase size of pg_commit_ts buffers 2942 Moved to different CF Performance Not processed Álvaro Herrera (alvherre) Noah Misch (nmisch) Álvaro Herrera (alvherre) 4 4 years ago Full support for index LP_DEAD hint bits on standby 2947 Moved to different CF Performance Not processed Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Antonin Houska (a.houska) 6 4 years ago Simplify some RI checks to reduce SPI overhead 2948 Moved to different CF Performance Not processed Amit Langote (amitlan) Tom Lane (tgl), Corey Huinker (coreyh) Álvaro Herrera (alvherre) 6 3 years ago Extend comments on signal handling and cross-reference comments on signal handling functions 2951 Returned with feedback Comments Only Not processed Craig Ringer (ringerc) Mark Dilger (mark.dilger) 3 4 years ago Introduce ProcessInterrupts_hook for C extensions 2952 Returned with feedback Not processed Craig Ringer (ringerc) 3 4 years ago Extend docs on how to write correct postgres-dialect C including extensions and bgworkers 2953 Moved to different CF Docs Only Not processed Craig Ringer (ringerc) Laurenz Albe (laurenz) 4 4 years ago Identify missing publications from publisher while create/alter subscription. 2957 Moved to different 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 4 years ago Adaptive query optimization: create extented statistics using auto_explain extension 2958 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) 4 4 years ago Improve join selectivity estimation using extended statistics 2959 Returned with feedback Performance Not processed Konstantin Knizhnik (knizhnik) 3 4 years ago Infrastructure changes to make the code less sensitive to transaction id bit width 2960 Returned with feedback Refactoring Only Not processed James Finnerty (jimfinnerty) 3 4 years ago Fix DROP TABLESPACE on Windows with ProcSignalBarrier? 2962 Moved to different CF Bugfix Not processed Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) Thomas Munro (macdice) 6 4 years ago Foreign Key Arrays 2966 Returned with feedback SQL Commands Not processed Mark Rofail (markmoheb) Joel Jacobson (joeljacobson), Justin Pryzby (justinpryzby) 3 4 years ago Minimal logical decoding on standbys (take 6) 2968 Moved to different CF Not processed Amit Khandekar (amitdkhan) Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) 5 2 years ago Set default transactions to read-only at servers start in pg_upgrade 2970 Moved to different CF Bugfix Not processed Denis Laxalde (dlax) Julien Rouhaud (rjuju) 4 4 years ago Support tab completion for upper character inputs in psql 2979 Moved to different CF libpq Not processed Haiying Tang (tanghy) Tom Lane (tgl), Peter Eisentraut (petere) Tom Lane (tgl) 5 4 years ago partial heap only tuples 2981 Moved to different CF Performance 15 Not processed Nathan Bossart (bossartn) 4 4 years ago Autovacuum dynamic cost_limit, cost_delay 2983 Returned with feedback Bugfix Not processed Scott Mead (meads-amazon) Masahiko Sawada (masahikosawada) 3 4 years ago Allow setting parallel_workers on partitioned tables 2987 Returned with feedback Performance Not processed Seamus Abshere (seamusabshere) Amit Langote (amitlan), Laurenz Albe (laurenz), Zhijie Hou (houzj) 3 4 years ago speed up pg_rewind by using copy_file_range() and skipping some fsync 2990 Returned with feedback Performance Not processed Paul Guo (paulguo-vmware) Michael Paquier (michael-kun) 3 4 years ago Allow batched insert during cross-partition updates 2992 Moved to different CF Not processed Amit Langote (amitlan) Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Zhijie Hou (houzj) Etsuro Fujita (efujita) 10 3 years ago Track wal_level drop for backup management 2994 Returned with feedback Monitoring Not processed Takamichi Osumi (tatatappp) 3 4 years ago Speed up verifying UTF-8 2996 Moved to different CF Performance Not processed John Naylor (john.naylor) Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan) John Naylor (john.naylor) 5 4 years ago Catalog version access 2999 Moved to different CF System Administration Not processed Vik Fearing (xocolatl), Nathan Bossart (bossartn) Nathan Bossart (bossartn) 5 4 years ago Refactor ECPGconnect() and allow IPv6 connection 3005 Returned with feedback libpq Not processed Hayato Kuroda (ha-kun) 3 4 years ago public schema default ACL 3017 Committed Security Not processed Noah Misch (nmisch) Peter Eisentraut (petere) Noah Misch (nmisch) 3 4 years ago Hooks and API to allow loadable wire protocol extensions 3018 Returned with feedback Not processed Jan Wieck (wieck) 3 5 years ago Speeding up GIST index builds using popcount 3023 Returned with feedback Performance Not processed Amit Khandekar (amitdkhan) John Naylor (john.naylor) 3 4 years ago postgres_fdw: suppress explicit casts in text:text comparisons 3025 Moved to different CF Not processed Dian Fay (dmfay) Tom Lane (tgl), Georgios Kokolatos (gkokolatos) Tom Lane (tgl) 4 4 years ago Add --create-only option to pg_dump/pg_dumpall 3026 Returned with feedback System Administration Not processed Michael Banck (mbanck) Cary Huang (cary), Nitin Jadhav (nitinjadhav11) 3 4 years ago Add regexp_positions(string text, pattern text, flags text) → setof record (starts integer[], lengths integer[]) 3027 Moved to different CF Not processed Joel Jacobson (joeljacobson) Tom Lane (tgl) 3 4 years ago Rework the sslfiles Makefile target 3029 Moved to different CF Refactoring Only Not processed Jacob Champion (jchampion) Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 3 4 years ago Make relfile tombstone files conditional on WAL level 3030 Moved to different CF Performance Not processed Thomas Munro (macdice) 3 3 years ago PROXY protocol support 3032 Moved to different CF Not processed Magnus Hagander (mha) Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) 7 3 years ago Add system views pg_permissions and pg_ownerships 3033 Moved to different CF Monitoring Not processed Joel Jacobson (joeljacobson) 5 1 year ago Using COPY FREEZE in pgbench 3034 Committed libpq 15 Not processed Tatsuo Ishii (ishii) Fabien Coelho (calvin) Tatsuo Ishii (ishii) 2 4 years ago Removing unused trailing linepointers from heap pages 3035 Moved to different CF Bugfix Not processed Matthias van de Meent (mmeent) 3 3 years ago Add some tests for pg_stat_statements compatibility verification 3036 Moved to different CF Not processed Erica Zhang (zerica) Julien Rouhaud (rjuju) Michael Paquier (michael-kun) 3 4 years ago Release SPI plans for referential integrity with DISCARD 3037 Returned with feedback SQL Commands Not processed Yuzuko Hosoya (yuzu) 2 4 years ago More sort-related specialisation 3038 Moved to different CF Performance Not processed Thomas Munro (macdice) John Naylor (john.naylor) John Naylor (john.naylor) 5 4 years ago Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 3040 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson), vigneshwaran C (vignesh.postgres) Daniel Gustafsson (d_gustafsson) 3 4 years ago Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 3041 Moved to different CF Bugfix Not processed Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) Amit Kapila (amitkapila) 7 3 years ago Add common functions regexp_like, regexp_count, regexp_instr, regexp_substr and regexp_replace 3042 Committed Not processed Gilles Darold (darold) Tom Lane (tgl) Tom Lane (tgl) 2 4 years ago Built-in connection pooler 3043 Returned with feedback Performance Not processed Konstantin Knizhnik (knizhnik) Antonin Houska (a.houska) 2 4 years ago rename column if exists 3045 Moved to different CF SQL Commands Not processed David Oksman (oks) Yagiz Nizipli (yagiznizipli) 4 4 years ago Allow multiple recursive self-references 3046 Moved to different CF Not processed Denis Hirn (brainy) Peter Eisentraut (petere) 6 3 years ago pg_stat_statements: Track statement entry timestamp 3048 Moved to different CF Monitoring 17 Not processed Andrei Zubkov (zubkov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 13 2 years ago Extended statistics in EXPLAIN 3050 Moved to different CF Not processed Tomas Vondra (fuzzycz) Tatsuro Yamada (tatsuro_yamada) 6 4 years ago pg_dump new feature: exporting functions only 3051 Moved to different CF libpq 15 Not processed Lætitia AVROT (arkhena) ahsan hadi (ahsan.hadi), Ryan Lambert (ryanlambert) 5 3 years ago Merging statistics from children instead of re-sampling everything 3052 Moved to different CF Not processed Tomas Vondra (fuzzycz) 5 4 years ago Add missing function abs (interval) 3054 Moved to different CF Not processed Isaac Morland (ijmorlan) Tom Lane (tgl) 3 4 years ago estimating joins using extended statistics 3055 Moved to different CF Not processed Tomas Vondra (fuzzycz) Andy Fan (andyf) 4 4 years ago Eliminating "Permission denied" errors on stat() (on Windows) 3058 Moved to different CF Bugfix Not processed Alexander Lakhin (law) 4 4 years ago fix ICU explorer link in locale documentation 3059 Moved to different CF Docs Only Not processed Anton Voloshin (a.voloshin) Laurenz Albe (laurenz) Bruce Momjian (bmomjian) 3 4 years ago use AV work items infrastructure for GIN pending list's cleanup 3060 Returned with feedback 15 Not processed Jaime Casanova (jcasanov) Masahiko Sawada (masahikosawada) 2 4 years ago tablesync early exit 3062 Moved to different CF 15 Not processed Peter Smith (smithpb2250) 6 4 years ago Remove 64K hard limit on rangetable size 3063 Committed Not processed Tom Lane (tgl) Aleksander Alekseev (a.alekseev) Tom Lane (tgl) 2 4 years ago Add option --drop-cascade for pg_dump/restore 3065 Moved to different CF libpq Not processed Wu Haotian (whtsky) Greg Sabino Mullane (greg) 3 4 years ago add explicit partial union-all and improve parallel subquery costing 3070 Moved to different CF Performance Not processed Luc Vlaming (luc.vlaming) Ronan Dunklau (rdunklau) 3 4 years ago Lazy JIT IR code generation to increase JIT speed with partitions 3071 Moved to different CF Performance Not processed David Geier (geidav), Luc Vlaming (luc.vlaming) Dmitry Dolgov (erthalion) 9 3 years ago Add callback table access method to reset filenode when dropping relation 3073 Moved to different CF Not processed Mats Kindahl (matski) Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) 7 3 years ago Convert contrib SQL functions to new style 3074 Returned with feedback Security Not processed Tom Lane (tgl) 2 1 year ago Improve sepgsql logging so it follows the behaviour of selinux's logging. 3076 Moved to different CF Security Not processed Dave Page (dpage) Jacob Champion (jchampion) Tom Lane (tgl) 4 4 years ago Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation 3078 Moved to different CF Performance 15 Not processed Matthias van de Meent (mmeent) 4 4 years ago generate fractional cheapest paths in generate_orderedappend_paths 3080 Moved to different CF Bugfix Not processed Tomas Vondra (fuzzycz) Arne Roland (harks) Tomas Vondra (fuzzycz) 4 4 years ago badly calculated width of emoji in psql 3087 Committed Bugfix Not processed Jacob Champion (jchampion) Pavel Stehule (okbobcz) John Naylor (john.naylor) 2 4 years ago Reduce lock level for ALTER TABLE ... ADD CHECK 3088 Moved to different CF System Administration 15 Not processed Simon Riggs (simon) Greg Sabino Mullane (greg) 3 4 years ago A test for replay of regression tests 3090 Moved to different CF Not processed Thomas Munro (macdice) Anastasia Lubennikova (lubennikovaav) Thomas Munro (macdice) 4 4 years ago Use simplehash.h instead of dynahash in SMgr 3092 Moved to different CF Performance Not processed David Rowley (davidrowley) Yura Sokolov (funny_falcon) 3 4 years ago avoid logical replication empty transactions 3093 Moved to different CF 15 Not processed Euler Taveira (eulerto), Ajin Cherian (ajinc) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb), Greg Nancarrow (gregn1234) Amit Kapila (amitkapila) 5 4 years ago Addition of authenticated ID to pg_stat_activity 3095 Returned with feedback 15 Not processed Michael Paquier (michael-kun) Aleksander Alekseev (aalekseev) 2 4 years ago Extend portability of client_connection_check_interval 3098 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) Maksim Milyutin (maksm90) Thomas Munro (macdice) 5 4 years ago Asymmetric partition-wise JOIN 3099 Moved to different CF 15 Not processed KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) Alexander Pyhalov (a.pyhalov) 7 4 years ago Extensible parsing 3100 Moved to different CF 15 Not processed Julien Rouhaud (rjuju) 4 4 years ago Toast compression method options 3102 Moved to different CF Performance Not processed Dilip Kumar (dilip.kumar) 3 4 years ago pg_upgrade: copy the source oldestXid 3105 Committed Bugfix stable Not processed Bertrand Drouvot (bdrouvot) Bruce Momjian (bmomjian) 2 4 years ago Avoid orphaned dependencies 3106 Moved to different CF 16 Not processed Bertrand Drouvot (bdrouvot) Ronan Dunklau (rdunklau) 6 4 years ago Extending amcheck to check toast size and compression 3107 Moved to different CF Not processed Mark Dilger (mark.dilger) Greg Stark (stark), Aleksander Alekseev (aalekseev) Michael Paquier (michael-kun) 3 4 years ago psql: exclude valid constraints in tab-complete for ALTER TABLE .. VALIDATE CONSTRAINT 3113 Moved to different CF Bugfix Not processed David Fetter (dfetter) Aleksander Alekseev (aalekseev) Tom Lane (tgl) 4 4 years ago Rewriting the test of pg_upgrade as a TAP test - take three 3120 Moved to different CF Not processed Michael Paquier (michael-kun) 3 4 years ago Support of time zone patterns - of, tzh and tzm 3121 Moved to different CF Bugfix Not processed Nitin Jadhav (nitinjadhav11) David Zhang (david.z) Robert Haas (rhaas) 5 4 years ago Diagnostic comment in LogicalIncreaseXminForSlot 3124 Committed Not processed Ashutosh Bapat (ashutoshbapat) Masahiko Sawada (masahikosawada) Amit Kapila (amitkapila) 2 4 years ago Improve documentation for pg_upgrade, standbys and rsync 3125 Moved to different CF Docs Only 15 Not processed Laurenz Albe (laurenz) David Fetter (dfetter) 5 3 years ago Clarify how triggers relate to transactions 3126 Committed Docs Only 15 Not processed Laurenz Albe (laurenz) Simon Riggs (simon) Tom Lane (tgl) 2 4 years ago Document the 1GB memory limit for VACUUM 3127 Committed Docs Only 15 Not processed David Rowley (davidrowley), Laurenz Albe (laurenz) Greg Sabino Mullane (greg) David Rowley (davidrowley) 2 4 years ago TAP test for contrib/sslinfo 3128 Moved to different CF Not processed Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) Daniel Gustafsson (d_gustafsson) 3 4 years ago Parallel scan with SubTransGetTopmostTransaction assert coredump 3129 Committed Bugfix Not processed Robert Haas (rhaas), Greg Nancarrow (gregn1234), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Pavel Borisov (pborisov) Robert Haas (rhaas) 2 4 years ago Change internal PRNG (from rand48 to something better, with a cleaner interface) 3131 Moved to different CF 15 Not processed Fabien Coelho (calvin) Aleksander Alekseev (aalekseev) Tom Lane (tgl) 3 4 years ago Bug in query rewriter - hasModifyingCTE not getting set 3134 Returned with feedback Bugfix 15 Not processed Takayuki Tsunakawa (maumau) Tom Lane (tgl) 2 4 years ago Support for NSS as a libpq TLS backend 3138 Moved to different CF Security Not processed Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) Joshua Brindle (joshuab) 5 4 years ago Replicates changes for all tables in schema 3139 Moved to different 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 4 years ago psql - refactor echo code 3140 Moved to different CF Refactoring Only Not processed Fabien Coelho (calvin) Pavel Stehule (okbobcz), Peter Eisentraut (petere) 10 3 years ago Reducing memory consumption for pending inval messages 3141 Committed Performance Not processed Tom Lane (tgl) Nathan Bossart (bossartn) Tom Lane (tgl) 2 4 years ago Logging plan of the currently running query 3142 Moved to different CF Monitoring 16 Not processed atsushi torikoshi (atorik) Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) 9 2 weeks ago Parallel INSERT SELECT take 2 3143 Moved to different CF Performance Not processed Greg Nancarrow (gregn1234), Zhijie Hou (houzj) 6 3 years ago postgres_fdw: Handle boolean comparison predicates 3144 Returned with feedback Not processed Emre Hasegeli (hasegeli) Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat), Cary Huang (cary) 2 4 years ago Incorrect snapshots while promoting hot standby node when 2PC is used 3145 Moved to different CF Bugfix stable Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 4 years ago A micro-optimisation for ProcSendSignal() 3146 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) Thomas Munro (macdice) 4 4 years ago Allow queries in WHEN expression of FOR EACH STATEMENT triggers 3148 Withdrawn SQL Commands Not processed Joe Wildish (joewildish) 2 4 years ago logical decoding and replication of sequences 3155 Moved to different CF Not processed Tomas Vondra (fuzzycz) Peter Eisentraut (petere) Tomas Vondra (fuzzycz) 5 3 years ago btree_gist: Support bool 3157 Moved to different CF Not processed Emre Hasegeli (hasegeli) Tomas Vondra (fuzzycz) 3 4 years ago pre-allocating WAL files 3158 Moved to different CF Performance 16 Not processed Nathan Bossart (bossartn) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) 6 3 years ago Range Merge Join 3160 Moved to different CF 15 Not processed Thomas Mannhart (thomasmannhart97) 4 4 years ago add pg_ctl option that returns amount of shmem required 3161 Committed System Administration Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 3 years ago Update Toast data failure in logical replication 3162 Moved to different CF Bugfix Not processed Dilip Kumar (dilip.kumar) Euler Taveira (eulerto), Haiying Tang (tanghy) Amit Kapila (amitkapila) 5 4 years ago Use tuple-level SIREAD locks for index-only scans 3163 Moved to different CF Not processed Thomas Munro (macdice) 3 4 years ago Add proper planner support for ORDER BY / DISTINCT aggregates 3164 Moved to different CF Performance Not processed David Rowley (davidrowley) Ronan Dunklau (rdunklau), Richard Guo (richardguo) David Rowley (davidrowley) 7 3 years ago Fix around conn_duration in pgbench 3166 Committed Bugfix 14 Not processed Yugo Nagata (yugo.nagata) Asif Rehman (asifrana) Fujii Masao (masaofujii) 2 4 years ago Avoid stuck of pgbench due to skipped transactions 3168 Committed Bugfix stable Not processed Yugo Nagata (yugo.nagata) Greg Sabino Mullane (greg) Fujii Masao (masaofujii) 2 4 years ago procarray.c: two refactorings 3169 Committed Refactoring Only Not processed Ranier Vilela (raniervilela) Aleksander Alekseev (aalekseev) Fujii Masao (masaofujii) 2 4 years ago Consistent use of SSL/TLS in docs 3172 Moved to different CF Docs Only Not processed Daniel Gustafsson (d_gustafsson) Robert Haas (rhaas), Lætitia AVROT (arkhena) Daniel Gustafsson (d_gustafsson) 5 4 years ago Split xlog.c 3173 Moved to different CF Refactoring Only Not processed Heikki Linnakangas (heikki) 3 4 years ago Fix documentation for COPY protocol flow 3175 Moved to different CF Docs Only Not processed Jeff Davis (jdavis) 3 4 years ago unnesting multirange data types 3178 Returned with feedback 14 Not processed Alexander Korotkov (smagen) Justin Pryzby (justinpryzby), Jonathan Katz (jkatz05) Alexander Korotkov (smagen) 2 4 years ago Extended protocol COPY FROM STDIN fix 3180 Moved to different CF Bugfix Not processed Jeff Davis (jdavis) 3 4 years ago Map WAL segment files on PMEM as WAL buffers 3181 Moved to different CF Performance Not processed Takashi Menjo (tmenjo) 6 4 years ago automatically generating node support functions 3182 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 6 3 years ago Detectable crashes and unlogged table resets 3183 Moved to different CF Not processed Jeff Davis (jdavis) 5 4 years ago pg_stats and range statistics 3184 Moved to different CF 17 Not processed Egor Rogov (egorius) Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) Alexander Korotkov (smagen) 13 2 years ago Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands 3188 Returned with feedback Not processed Yuzuko Hosoya (yuzu) 2 4 years ago Using indexUnchanged with nbtree 3191 Returned with feedback Performance 15 Not processed Simon Riggs (simon) 2 4 years ago Fully WAL logged CREATE DATABASE - No Checkpoints 3192 Moved to different CF Not processed Dilip Kumar (dilip.kumar) Ashutosh Sharma (ashu_coek) Robert Haas (rhaas) 5 4 years ago Fix pkg-config file for static linking 3193 Committed Bugfix Not processed Filip Gospodinov (fil) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 4 years ago pgbench - allow retries on some errors 3194 Returned with feedback libpq 15 Not processed Yugo Nagata (yugo.nagata), Marina Polyakova (whipping.top1991) Fabien Coelho (calvin) 2 4 years ago DELETE CASCADE 3195 Moved to different CF SQL Commands 15 Not processed David Christensen (davidchristensen) 4 4 years ago Emit namespace in post-copy output 3200 Committed libpq Not processed Mike Fiedler (miketheman) Daniel Gustafsson (d_gustafsson), Corey Huinker (coreyh) Daniel Gustafsson (d_gustafsson) 2 4 years ago Expose get_query_def() 3204 Moved to different CF Not processed Julien Rouhaud (rjuju) Pavel Stehule (okbobcz), Gilles Darold (darold) Tom Lane (tgl) 5 4 years ago Skipping logical replication transactions on subscriber side 3205 Moved to different 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 Write visibility map during CLUSTER/VACUUM FULL 3206 Moved to different CF Performance Not processed Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva) Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) 6 3 years ago improvements in Unicode tables generation code 3208 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 3 4 years ago PoC: improving join estimates using sampling 3211 Moved to different CF Not processed Tomas Vondra (fuzzycz) 5 4 years ago Allow providing restore_command as a command line option to pg_rewind 3213 Moved to different CF Not processed Alexey Kondratov (ololobus) Andrey Borodin (x4m) 5 3 years ago Fix numeric power for negative bases and other corner cases 3214 Moved to different CF Bugfix Not processed Dean Rasheed (deanr) Yugo Nagata (yugo.nagata) Dean Rasheed (deanr) 3 4 years ago Extensible storage manager API - smgr hooks 3216 Moved to different CF Refactoring Only Not processed Anastasia Lubennikova (lubennikovaav) 5 4 years ago Don't block HOT update by BRIN index 3218 Moved to different CF Performance Not processed Josef Šimánek (retro) Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 3 4 years ago Fix pgbench's exit status and log messages for connection failures 3219 Moved to different CF Bugfix stable Not processed Fabien Coelho (calvin), Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii) 3 4 years ago Speed up LockReleaseAll 3220 Moved to different CF Performance Not processed David Rowley (davidrowley) 3 2 years ago PITR enhance getRecordTimestamp() 3222 Moved to different CF Not processed Simon Riggs (simon) 8 4 years ago Delegating superuser tasks to new security roles 3223 Moved to different CF Security 15 Not processed Mark Dilger (mark.dilger) Andrew Dunstan (adunstan), Nathan Bossart (bossartn) 3 4 years ago Fix ExecRTCheckPerms() inefficiency with many prunable partitions 3224 Moved to different CF Performance 16 Not processed Amit Langote (amitlan) Álvaro Herrera (alvherre), Tom Lane (tgl) Álvaro Herrera (alvherre) 8 2 years ago pgbench: add multiconnect support 3227 Moved to different CF 16 Not processed David Christensen (davidchristensen) Jelte Fennema-Nio (jeltef) 9 3 years ago Cleaning up orphaned files using undo logs 3228 Moved to different CF Not processed Antonin Houska (a.houska) Dmitry Dolgov (erthalion) 4 4 years ago Remove redundant initializations 3229 Returned with feedback Refactoring Only Not processed Peter Eisentraut (petere) Noah Misch (nmisch) 2 4 years ago Column filtering in logical replication 3230 Moved to different 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 4 years ago Teach pg_receivewal to use lz4 compression 3231 Moved to different CF 15 Not processed Georgios Kokolatos (gkokolatos) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 4 years ago Automatic notification of top transaction IDs 3232 Moved to different CF Not processed Gurjeet Singh (gurjeet) Cary Huang (cary) 3 4 years ago ECPG bug fix: allow using connection-associated prepared_name 3233 Committed Bugfix Not processed Hayato Kuroda (ha-kun) Michael Meskes (meskes) 2 4 years ago Window function run conditions 3234 Moved to different CF Performance Not processed David Rowley (davidrowley) David Rowley (davidrowley) 5 3 years ago Using each rel as both outer and inner for anti-joins 3235 Moved to different CF Performance Not processed Richard Guo (richardguo) Ronan Dunklau (rdunklau) Tom Lane (tgl) 9 2 years ago Fix uninitialized variable access (freepages) 3236 Moved to different CF Bugfix 15 Not processed Ranier Vilela (raniervilela) Greg Nancarrow (gregn1234), David Zhang (david.z) 4 4 years ago Use optimized single-datum tuplesort in ExecSort 3237 Committed Performance 15 Not processed Ronan Dunklau (rdunklau) James Coleman (jcole1989), Ranier Vilela (raniervilela) David Rowley (davidrowley) 1 4 years ago Slightly improve initdb --sync-only option's help message 3238 Committed System Administration Not processed Gurjeet Singh (gurjeet) Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn) Daniel Gustafsson (d_gustafsson) 1 4 years ago Warn if initdb's --sync-only option is mixed with other options 3239 Returned with feedback System Administration Not processed Gurjeet Singh (gurjeet) Daniel Gustafsson (d_gustafsson) 1 4 years ago when the blocksize is 32k, the function page_header of pageinspect returns negative numbers. 3240 Committed Bugfix Not processed Zongliang Quan (quanzl) Michael Paquier (michael-kun) 1 4 years ago [bug] Logical Decoding of relation rewrite with toast does not reset toast_hash 3241 Committed Bugfix stable Not processed Bertrand Drouvot (bdrouvot) David Zhang (david.z) Amit Kapila (amitkapila) 1 4 years ago test pgbench time-related features 3242 Moved to different CF libpq 15 Not processed Fabien Coelho (calvin) 2 4 years ago Add statistics refresh materialized view 3243 Returned with feedback Monitoring Not processed Yuki Seino (seinoyu) Fujii Masao (masaofujii) 1 4 years ago parse_subscription_options - some suggested improvements 3244 Moved to different CF 15 Not processed Peter Smith (smithpb2250) Nathan Bossart (bossartn) Michael Paquier (michael-kun) 3 4 years ago Postgres picks suboptimal index after building extended statistics 3245 Moved to different CF Performance 14 Not processed Andrei Lepikhov (lepikhov) 7 3 years ago Parallelize correlated subqueries that execute within each worker 3246 Moved to different CF Performance Not processed James Coleman (jcole1989) Akshat Jaimini (akshatj) 15 1 year ago Small documentation improvement for ALTER SUBSCRIPTION 3247 Committed Docs Only Not processed Masahiko Sawada (masahikosawada) Peter Eisentraut (petere) Daniel Gustafsson (d_gustafsson) 1 4 years ago CREATE SUBSCRIPTION option list order 3248 Committed Docs Only 15 Not processed Peter Smith (smithpb2250) Euler Taveira (eulerto) Amit Kapila (amitkapila) 1 4 years ago psql tab auto-complete for CREATE PUBLICATION 3249 Committed 15 Not processed Peter Smith (smithpb2250) vigneshwaran C (vignesh.postgres) Fujii Masao (masaofujii) 1 4 years ago Fix handling of outer GroupingFunc within subqueries 3250 Moved to different CF Bugfix Not processed Richard Guo (richardguo) Tom Lane (tgl), Platon Pronko (rogach) Tom Lane (tgl) 4 4 years ago Document pg_encoding_to_char() and pg_char_to_encoding() 3251 Moved to different CF Docs Only 15 Not processed Ian Barwick (barwick) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 4 years ago Tab completion for CREATE SCHEMA AUTHORIZATION 3252 Moved to different CF libpq Not processed Dagfinn Ilmari Mannsåker (ilmari) Suraj Khamkar (suraj.khamkar) 2 2 years ago Use lfoo_node(...) instead of castNode(..., lfoo(...)) 3253 Committed Refactoring Only Not processed Dagfinn Ilmari Mannsåker (ilmari) Peter Eisentraut (petere) 1 4 years ago Remove repeated PQfnumber() in pg_dump 3254 Committed Performance Not processed Zhijie Hou (houzj) Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn) Daniel Gustafsson (d_gustafsson) 1 4 years ago Use WaitLatch for {pre, post}_auth_delay instead of pg_usleep 3255 Rejected Refactoring Only Not processed Bharath Rupireddy (bharathrupireddy) Nathan Bossart (bossartn) 1 4 years ago functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) 3256 Moved to different CF libpq Not processed Justin Pryzby (justinpryzby) David Christensen (davidchristensen) 16 1 year ago Dissallow sending SI messages when excuting ROLLBACK PREPARED command 3257 Committed Not processed huailing liu (haylee) Michael Paquier (michael-kun) 1 4 years ago proposal of adding 2 new diag items related to parsing the dynamic sql statement 3258 Moved to different CF Not processed Dinesh Chemuduru (dineshc) Pavel Stehule (okbobcz) 2 3 years ago corruption of WAL page header is never reported 3259 Moved to different CF Bugfix stable Not processed Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 4 years ago pgbench: using prepared BEGIN statement in a pipeline could cause an error 3260 Moved to different CF Bugfix 15 Not processed Yugo Nagata (yugo.nagata) Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege) Álvaro Herrera (alvherre) 9 3 years ago Log the activity of startup process 3261 Moved to different CF Monitoring 15 Not processed Nitin Jadhav (nitinjadhav) Justin Pryzby (justinpryzby), Bharath Rupireddy (bharathrupireddy) Robert Haas (rhaas) 2 3 years ago schema change not getting invalidated, both renamed table and new table data were getting replicated 3262 Moved to different CF Not processed vigneshwaran C (vignesh.postgres) Tom Lane (tgl) Tom Lane (tgl) 8 3 years ago Added documentation for cascade and restrict option of drop statistics 3263 Committed Docs Only Not processed vigneshwaran C (vignesh.postgres) Michael Paquier (michael-kun) 1 4 years ago Fix postgres_fdw's ORDER BY pushdown handling 3264 Moved to different CF Bugfix Not processed Ronan Dunklau (rdunklau) Tom Lane (tgl), David Zhang (david.z) Tom Lane (tgl) 4 4 years ago Kerberos delegation support in libpq and postgres_fdw 3265 Moved to different CF Security Not processed Peifeng Qiu (pqiu) 2 2 years ago Stored Procedure Triggered by Logical Replication is Unable to use Notification Events 3266 Committed Bugfix 15 Not processed Artur Zakirov (a.zakirov) Tom Lane (tgl) Tom Lane (tgl) 1 4 years ago improve tab-completion behavior when parse text in single quote 3267 Moved to different CF libpq Not processed Haiying Tang (tanghy) 2 4 years ago Add tab-complete for full name backslash commands 3268 Committed libpq Not processed Haiying Tang (tanghy) Dagfinn Ilmari Mannsåker (ilmari) Tom Lane (tgl) 1 4 years ago New READ_REPLICATION_SLOT command & usage in pg_receivewal 3269 Returned with feedback Not processed Ronan Dunklau (rdunklau) Michael Paquier (michael-kun), Bharath Rupireddy (bharathrupireddy) 1 4 years ago Cache tuple routing info during bulk loads into partitioned tables 3270 Moved to different CF Performance Not processed David Rowley (davidrowley), Amit Langote (amitlan), Zhijie Hou (houzj) Álvaro Herrera (alvherre), David Rowley (davidrowley) David Rowley (davidrowley) 6 3 years ago KnownAssignedXidsGetAndSetXmin performance 3271 Moved to different CF Performance Not processed Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Kirill Reshke (reshke), Andrey Borodin (x4mmm) 6 3 years ago Add system view tracking shared buffer actions 3272 Moved to different CF Monitoring 16 Not processed Melanie Plageman (melanieplageman) Justin Pryzby (justinpryzby) Andres Freund (andresfreund) 9 3 years ago wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION 3273 Committed Bugfix Not processed Zhijie Hou (houzj) Amit Kapila (amitkapila) 1 4 years ago Gather partial paths for subproblem's topmost scan/join rel 3274 Moved to different CF Not processed Richard Guo (richardguo) Antonin Houska (a.houska) Tom Lane (tgl) 5 3 years ago Skip useless paren-captures in regexps 3275 Committed Performance Not processed Tom Lane (tgl) Mark Dilger (hornschnorter) Tom Lane (tgl) 1 4 years ago disallow external access to MaxBackends 3276 Moved to different CF Not processed Nathan Bossart (bossartn) Greg Sabino Mullane (greg) Michael Paquier (michael-kun) 4 3 years ago Allow escape sequence in application_name 3277 Moved to different CF libpq Not processed Hayato Kuroda (ha-kun) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 3 4 years ago perlcritic: prohibit map and grep in void conext 3278 Committed Not processed Dagfinn Ilmari Mannsåker (ilmari) Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 1 4 years ago Tab completion for EXECUTE after EXPLAIN 3279 Committed libpq Not processed Dagfinn Ilmari Mannsåker (ilmari) Michael Paquier (michael-kun) 1 4 years ago Tab completion for ALTER TABLE … ADD … 3280 Committed libpq Not processed Dagfinn Ilmari Mannsåker (ilmari) Michael Paquier (michael-kun) 1 4 years ago use regular expressions to simplify less_greater and not_equals 3281 Rejected Refactoring Only Not processed Fan Xiaojian (funnyxj.qq.com), Shihao Sun (sunshihao.ssh.alibaba-inc.com) Tom Lane (tgl) 1 4 years ago Support reset of Shared objects statistics 3282 Committed Bugfix Not processed B Sadhu Prasad Patro (sadhuprasad) Mahendra Singh Thalor (mahithalor) Fujii Masao (masaofujii) 1 4 years ago Failed Assertion in ReorderBufferChangeMemoryUpdate() 3283 Committed Bugfix stable Not processed Bertrand Drouvot (bdrouvot) Amit Kapila (amitkapila) 1 4 years ago Native spinlock support on RISC-V 3284 Committed Performance Not processed Marek Szuba (mkszuba) Tom Lane (tgl) 1 4 years ago glossary definitions for auxiliary processes 3285 Committed Docs Only 15 Not processed Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby) Álvaro Herrera (alvherre) 1 4 years ago Error out if SKIP LOCKED and WITH TIES are both specified 3286 Moved to different CF Bugfix stable Not processed David Christensen (davidchristensen) Álvaro Herrera (alvherre) 2 4 years ago Remove obsolete macro CHECKFLOATVAL in contrib/btree_gist 3287 Committed Refactoring Only Not processed Haiying Tang (tanghy) Michael Paquier (michael-kun) 1 4 years ago pg_dump handling of ALTER DEFAULT PRIVILEGES IN SCHEMA 3288 Moved to different CF Bugfix stable Not processed Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn) Muhammad Usama (muhammad_usama) Tom Lane (tgl) 2 4 years ago Push down time-related SQLValue functions to foreign server 3289 Moved to different CF Performance 15 Not processed Alexander Pyhalov (a.pyhalov) 5 4 years ago Allow special values in GUC configurations 3290 Moved to different CF 16 Not processed David Christensen (davidchristensen) Cary Huang (cary) 4 4 years ago Add PGDLLIMPORT to all direct or indirect GUC variables 3291 Moved to different CF 15 Not processed Robert Haas (rhaas), Julien Rouhaud (rjuju) Robert Haas (rhaas) 4 3 years ago Non-decimal integer literals 3292 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) John Naylor (john.naylor) Peter Eisentraut (petere) 6 3 years ago Tags in errordata 3293 Moved to different CF 15 Not processed Ronan Dunklau (rdunklau) Greg Stark (stark), Justin Pryzby (justinpryzby) 4 3 years ago Separate out FileSet from SharedFileSet 3294 Committed Refactoring Only Not processed Dilip Kumar (dilip.kumar) Masahiko Sawada (masahikosawada) Amit Kapila (amitkapila) 1 4 years ago psql: add xheader_width option to handle very long record lines 3295 Moved to different CF libpq Not processed Platon Pronko (rogach) Andrew Dunstan (adunstan) Andrew Dunstan (adunstan) 5 3 years ago Preserving db/ts/relfilenode OIDs across pg_upgrade 3296 Moved to different CF Not processed Antonin Houska (a.houska), Shruthi Gowda (shruthi) Robert Haas (rhaas), Rushabh Lathia (rlathia) Robert Haas (rhaas) 4 3 years ago mitigate O(n^2) behavior of WAL archiver process 3297 Moved to different CF Performance 15 Not processed Nathan Bossart (bossartn), Dipesh Pandit (dpandit) Nathan Bossart (bossartn) Robert Haas (rhaas) 2 4 years ago Showing I/O timings spent reading/writing temp buffers in EXPLAIN 3298 Moved to different CF 15 Not processed Masahiko Sawada (masahikosawada) Julien Rouhaud (rjuju), Melanie Plageman (melanieplageman), Georgios Kokolatos (gkokolatos) Michael Paquier (michael-kun) 4 3 years ago Do not start bgworker processes during binary upgrade 3299 Moved to different CF Bugfix Not processed Denis Laxalde (dlax) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju) 4 4 years ago AIX: Symbols are missing in libpq.a 3300 Committed 14 Not processed Tony Reix (trex58) Noah Misch (nmisch) Noah Misch (nmisch) 1 4 years ago Fix ATTACH/DETACH PARTITION to invalidate partitions of table being attached/detached 3301 Moved to different CF Bugfix stable Not processed Álvaro Herrera (alvherre), Amit Langote (amitlan) Maxim Orlov (m.orlov), Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) Álvaro Herrera (alvherre) 2 4 years ago Trap SIGCHLD in pg_basebackup to exit early on stream child failure 3302 Moved to different CF Monitoring Not processed Daniel Gustafsson (d_gustafsson) Magnus Hagander (mha), Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson) 4 4 years ago \dP and \dX use ::regclass without "pg_catalog." 3303 Committed Bugfix 12 Not processed Justin Pryzby (justinpryzby) Álvaro Herrera (alvherre) 1 4 years ago Optimize parallel tuple queue 3304 Moved to different CF Performance Not processed Dilip Kumar (dilip.kumar) Robert Haas (rhaas) 2 4 years ago Fix erroneous parallel execution when modifying CTE is present in rewritten query 3305 Committed Bugfix 15 Not processed Greg Nancarrow (gregn1234) Tom Lane (tgl) Tom Lane (tgl) 1 4 years ago Remove Value node struct 3306 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 4 years ago UNIQUE null treatment option 3307 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) Vik Fearing (xocolatl), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Peter Eisentraut (petere) 4 4 years ago Some RELKIND macro refactoring 3308 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) Michael Paquier (michael-kun) Peter Eisentraut (petere) 3 4 years ago Patch: shouldn't timezone(text, timestamp[tz]) be STABLE? 3309 Committed Bugfix Not processed Aleksander Alekseev (aalekseev) Tom Lane (tgl) Tom Lane (tgl) 1 4 years ago add guc: hugepages_active 3310 Moved to different CF System Administration Not processed Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda) Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) 7 2 years ago Invalidations were missing in case of for all tables publication 3311 Committed Not processed Amit Kapila (amitkapila) 1 4 years ago Add JSON logging via jsonlog log_destination 3312 Moved to different CF System Administration 15 Not processed Michael Paquier (michael-kun), Sehrope Sarkuni (sehrope) Michael Paquier (michael-kun) 3 4 years ago psql: \dl+ to list large objects privileges 3313 Moved to different CF libpq Not processed Pavel Luzanov (pluzanov) Daniel Gustafsson (d_gustafsson), Georgios Kokolatos (gkokolatos) Tom Lane (tgl) 3 4 years ago Support pg_ident mapping for LDAP 3314 Moved to different CF Not processed Jacob Champion (jchampion) Magnus Hagander (mha) 5 4 years ago improve pg_receivewal code 3315 Committed Refactoring Only Not processed Bharath Rupireddy (bharathrupireddy) Ronan Dunklau (rdunklau) Michael Paquier (michael-kun) 1 4 years ago Asynchronous and "direct" IO support for PostgreSQL 3316 Moved to different CF Performance Not processed Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice) 6 3 years ago pg_receivewal: remove extra conn = NULL; in StreamLog 3317 Committed Refactoring Only Not processed Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 1 4 years ago Check for STATUS_DELETE_PENDING on Windows 3326 Moved to different CF Bugfix Not processed Thomas Munro (macdice) Thomas Munro (macdice) 3 4 years ago