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

Fix the optimization to skip WAL-logging on table created in same transaction 528 Moved to different CF Bugfix 13 Not processed Heikki Linnakangas (heikki), Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti) Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti), Noah Misch (nmisch), satyanarayana Narlapuram (snarlap), Sameer Arora (sameera), Hüseyin Demir (huseyin.demir) Noah Misch (nmisch) 19 6 years ago Protect syscache from bloating with negative cache entries 931 Moved to different CF Performance Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha) 23 5 years ago Logical decoding of two-phase transactions 944 Returned with feedback 13 Not processed Nikhil Sontakke (nikkhils) Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos) 13 4 years ago Generic type subscripting 1062 Moved to different CF 14 Not processed Dmitry Dolgov (erthalion) Tom Lane (tgl), Pavel Stehule (okbobcz), Artur Zakirov (a.zakirov) Alexander Korotkov (smagen) 19 5 years ago Incremental sort 1124 Moved to different CF Performance Not processed Alexander Korotkov (smagen), Tomas Vondra (fuzzycz), James Coleman (jcole1989) Tomas Vondra (fuzzycz), Antonin Houska (a.houska), James Coleman (jcole1989), Diego - (galponcio) Tomas Vondra (fuzzycz) 11 5 years ago Push aggregation down to base relations and joins 1247 Moved to different CF Not processed Antonin Houska (a.houska) Tom Lane (tgl), Ashutosh Bapat (ashutoshbapat), Richard Guo (richardguo), Andy Fan (andyf) 19 5 years ago Restricting maximum keep segments by repslots 1260 Moved to different CF 13 Not processed Kyotaro Horiguchi (horiguti) Masahiko Sawada (masahikosawada), Greg Stark (stark), Jehan-Guillaume de Rorthais (ioguix) 12 6 years ago Custom compression methods 1294 Returned with feedback Not processed Ildus Kurbangaliev (ildus) 10 5 years ago pgbench - another attempt at tap test for time-related options 1306 Moved to different CF libpq Not processed Fabien Coelho (calvin) 14 5 years ago BRIN bloom and multi-minmax indexes 1348 Moved to different CF Not processed Tomas Vondra (fuzzycz) 11 5 years ago SQL/JSON: functions 1472 Moved to different CF SQL Commands Not processed Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg) Pavel Stehule (okbobcz), Andrew Dunstan (adunstan), Gerdan Santos (gerdan), Andrew Alsup (ahalsup) 13 3 years ago SQL/JSON: JSON_TABLE 1473 Moved to different CF SQL Commands Not processed Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg) Pavel Stehule (okbobcz), Andrew Dunstan (adunstan) 12 4 years ago Add enum relation option type 1489 Committed 13 Not processed Nikolay Shaplov (nataraj) Álvaro Herrera (alvherre) 8 6 years ago postgres.exe doesn't output crash dump when it crashes before main() 1525 Moved to different CF Bugfix Not processed Takayuki Tsunakawa (maumau) Haribabu Kommi (haribabu) 9 6 years ago Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT 1533 Moved to different CF SQL Commands Not processed Matheus Oliveira (matheus.oliveira) Gerdan Santos (gerdan), Ashutosh Bapat (ashutoshbapat), José Villanova (azlev), Lucas Viecelli (lucasviecelli), Cleysson Lima (cleyssonlima) 15 4 years ago get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead 1536 Returned with feedback Refactoring Only Not processed Nikolay Shaplov (nataraj) John Dent (denty) 8 6 years ago Advanced partition matching for partition-wise join 1553 Moved to different CF 13 Not processed Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat) Etsuro Fujita (efujita), Amul Sul (sulamul), Ashutosh Bapat (ashutoshbapat), Mark Dilger (mark.dilger) Etsuro Fujita (efujita) 11 5 years ago Transactions involving multiple postgres foreign servers 1574 Moved to different 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 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 4 days ago Undo logs 1649 Moved to different CF 13 Not processed Dilip Kumar (dilip.kumar), Thomas Munro (macdice) Amit Kapila (amitkapila) 8 6 years ago Evaluate immutable functions during planning (in FROM clause) 1664 Committed Performance Not processed Alexander Kuzmenkov (akuzmenkov), Aleksandr Parfenov (a.parfenov) Antonin Houska (a.houska), Anastasia Lubennikova (lubennikovaav), Anthony Bykov (anthonyb) Tom Lane (tgl) 7 6 years ago New libpq option to prefer standby for connection 1677 Moved to different CF libpq Not processed Haribabu Kommi (haribabu), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) Laurenz Albe (laurenz), Takayuki Tsunakawa (maumau), Peter Smith (smithpb) Tom Lane (tgl) 15 5 years ago Psql patch to show access methods info 1689 Moved to different CF libpq 13 Not processed Alik Khilazhev (alikhil), Sergey Cherkashin (cherkashins) Kyotaro Horiguchi (horiguti), Nikita Glukhov (n.glukhov), vigneshwaran C (vignesh.postgres) Alexander Korotkov (smagen) 10 6 years ago Global shared meta cache 1695 Returned with feedback Performance 13 Not processed Takeshi Ideriha (ideriha) 7 6 years ago Shared-memory based stats collector 1708 Moved to different CF Monitoring Not processed Kyotaro Horiguchi (horiguti) Tomas Vondra (fuzzycz), Antonin Houska (a.houska) 17 4 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 1 year ago pgbench - add pseudo-random permutation function 1736 Moved to different CF libpq Not processed Fabien Coelho (calvin), Hironobu Suzuki (suzuki_hironobu) Muhammad Usama (muhammad_usama) Dean Rasheed (deanr) 14 5 years 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 Autoprepare: implicitly replace literals with parameters and store generalized plan 1747 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) Ryo Yamaji (ryamaji), Ryohei Nagaura (nyannyan) 10 5 years ago Tid range scan 1755 Moved to different CF Performance 13 Not processed Edmund Horner (ejrh) David Rowley (davidrowley), Shawn Wang (shawnwang) David Rowley (davidrowley) 7 5 years ago libpq host/hostaddr consistency 1769 Committed libpq Not processed Fabien Coelho (calvin) Artur Zakirov (a.zakirov) Álvaro Herrera (alvherre) 6 6 years ago Block level parallel vacuum 1774 Moved to different CF Performance Not processed Masahiko Sawada (masahikosawada) Dilip Kumar (dilip.kumar), Sergei Kornilov (melkij) Amit Kapila (amitkapila) 8 6 years ago documenting signal handling with readme 1796 Returned with feedback Docs Only Not processed Chris Travers (einhverfr) Tom Lane (tgl) 5 6 years ago amcheck verification for GiST 1800 Moved to different CF 13 Not processed Andrey Borodin (x4m) Peter Geoghegan (pgeoghegan) Peter Geoghegan (pgeoghegan) 6 6 years ago KNN for B-tree 1804 Moved to different CF Performance Not processed Nikita Glukhov (n.glukhov) Alexander Korotkov (smagen), Anastasia Lubennikova (lubennikovaav) Alexander Korotkov (smagen) 8 1 year ago Allow AddForeignUpdateTargets to add extra target expressions other than columns 1819 Moved to different CF Bugfix Not processed Etsuro Fujita (efujita), Kyotaro Horiguchi (horiguti) Etsuro Fujita (efujita) 6 6 years ago Undo worker and transaction rollback 1828 Withdrawn 13 Not processed Amit Kapila (amitkapila), Dilip Kumar (dilip.kumar), mithun cy (mithun.cy), Rafia Sabih (rafia.sabih) 5 7 years ago FETCH FIRST clause WITH TIES option 1844 Moved to different CF SQL Commands Not processed Surafel Temesgen (surafel) Tomas Vondra (fuzzycz), Vik Fearing (xocolatl) Álvaro Herrera (alvherre) 8 6 years ago pg_rewind: options to use restore_command from recovery.conf or command line 1849 Moved to different CF 13 Not processed Alexey Kondratov (ololobus) Andrey Borodin (x4m) Michael Paquier (michael-kun) 8 6 years ago libpq trace log 1854 Returned with feedback libpq 13 Not processed Aya Iwata (iwata.aya) Jacob Champion (jchampion), Jim Doty (doty-pivotal), Ramanarayana M (ramnar) 5 5 years ago Cleaning up orphaned files using undo logs 1863 Moved to different CF Not processed Thomas Munro (macdice) 5 4 years ago Add Hook Functions for Disk Quota Extension 1883 Moved to different CF Not processed Haozhou Wang (hawang), Hubert Zhang (hubertz), Hao Wu (hwu) Raymond Martin (ramarti) 8 5 years ago online change primary_conninfo 1896 Moved to different CF 13 Not processed Sergei Kornilov (melkij) Fujii Masao (masaofujii) Álvaro Herrera (alvherre) 7 6 years ago anycompatible and anycompatiblearray polymorphic types 1911 Moved to different CF Not processed Pavel Stehule (okbobcz) Tom Lane (tgl) Tom Lane (tgl) 7 6 years ago Remove deprecated exclusive backup mode 1913 Moved to different CF Not processed David Steele (dsteele) Magnus Hagander (mha) 9 5 years ago Add timeline to partial WAL segments 1919 Moved to different CF Not processed David Steele (dsteele) 9 5 years ago logical streaming for large in-progress transactions 1927 Moved to different CF Not processed Amit Kapila (amitkapila), Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos), Dilip Kumar (dilip.kumar) Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres) Amit Kapila (amitkapila) 9 5 years ago Log bind parameter values on error 1934 Moved to different CF Monitoring 13 Not processed Alexey Bashtanov (bashtanov) Álvaro Herrera (alvherre) 6 6 years ago Implement NULL-related checks in object address functions to prevent cache lookup errors, take two 1947 Moved to different CF Not processed Michael Paquier (michael-kun) Daniel Gustafsson (d_gustafsson) Michael Paquier (michael-kun) 8 5 years ago Support huge_pages on AIX 1960 Moved to different CF System Administration 13 Not processed Thomas Munro (macdice) Thomas Munro (macdice) 6 6 years ago Synchronizing slots from primary to standby 1961 Returned with feedback 13 Not processed Petr Jelínek (pjmodos) Shaun Thomas (bonesmoses) 4 6 years ago Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (version 9.6 or earlier). 1970 Moved to different CF System Administration Not processed daisuke higuchi (daisukehiguchi), Ramanarayana M (ramnar) Takayuki Tsunakawa (maumau) 4 6 years ago \describe: verbose commands in psql 1976 Withdrawn libpq 13 Not processed Corey Huinker (coreyh) Ibrar Ahmed (ibrar) 3 6 years ago Ltree syntax improvement 1977 Moved to different CF Not processed Dmitry Belyavsky (beldmit) Nikolay Shaplov (nataraj), Nikita Glukhov (n.glukhov), Aleksandr Sorokin (mustiks) 8 5 years ago Speed up transaction completion faster after many relations are accessed in a transaction 1993 Moved to different CF Performance 13 Not processed Takayuki Tsunakawa (maumau) Takayuki Tsunakawa (maumau) David Rowley (davidrowley) 5 2 years ago Replica with large recovery_min_apply_delay is not receiving changes from master after restart until this delay is expired 1995 Moved to different CF Not processed Konstantin Knizhnik (knizhnik) Martín Marqués (mmarques) 7 5 years ago Planning counters in pg_stat_statements 1999 Moved to different CF Monitoring Not processed Fujii Masao (masaofujii), Julien Rouhaud (rjuju), Thomas Munro (macdice), PAscal L (pascall) Greg Stark (stark), Yoshikazu Imai (yimai), PAscal L (pascall) Fujii Masao (masaofujii) 6 5 years ago Fix Deadlock Issue in Single User Mode When IO Failure Occurs 2003 Moved to different CF Bugfix stable Not processed Chengchao Yu (allelujava) Amit Kapila (amitkapila), Kyotaro Horiguchi (horiguti) 5 6 years ago Optimization of some jsonb functions 2011 Committed Performance 13 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) Álvaro Herrera (alvherre) 3 6 years ago pg_basebackup to adjust existing data directory permissions 2018 Moved to different CF Not processed Haribabu Kommi (haribabu) Martín Marqués (mmarques) 4 6 years ago Convert NOT IN to anti-joins when possible 2020 Moved to different CF Performance 13 Not processed David Rowley (davidrowley) Antonin Houska (a.houska) 4 6 years ago NOT IN to ANTI JOIN transformation 2023 Moved to different CF Performance 13 Not processed James Finnerty (jimfinnerty), Zheng Li (zhengli) 6 5 years ago SimpleLruTruncate() mutual exclusion (data loss from lack thereof) 2025 Moved to different CF Bugfix stable Not processed Noah Misch (nmisch) 5 6 years ago Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) 2026 Moved to different CF Bugfix stable Not processed Noah Misch (nmisch) Andrey Borodin (x4m) Noah Misch (nmisch) 10 5 years ago Flexible partition pruning hook 2028 Returned with feedback Performance 13 Not processed Mike Palmiotto (mpalmiotto) 3 6 years ago Problem with default partition pruning 2029 Committed Bugfix stable Not processed Yuzuko Hosoya (yuzu) Thibaut MADELAINE (madtibo), Ibrar Ahmed (ibrar), Shawn Wang (shawnwang) Álvaro Herrera (alvherre) 3 6 years ago extension patch of CREATE OR REPLACE TRIGGER 2034 Returned with feedback SQL Commands 13 Not processed Takamichi Osumi (tatatappp) Surafel Temesgen (surafel), Philippe BEAUDOIN (beaud76) 3 5 years ago Bloom index cost model 2043 Moved to different CF Performance 13 Not processed Jeff Janes (jjanes) Julien Rouhaud (rjuju) 4 6 years ago propagating replica identity to partitions 2044 Returned with feedback Bugfix 13 Not processed Álvaro Herrera (alvherre) 3 6 years ago [WIP] Temporal query processing with range types - Temporal Normalization 2045 Moved to different CF SQL Commands 13 Not processed Peter Moser (pemoser), Anton Dignös (dignoes) Ibrar Ahmed (ibrar) 5 6 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 Fix unique join costings 2050 Moved to different CF Bugfix stable Not processed David Rowley (davidrowley) Tom Lane (tgl) 9 5 years ago DOC: Document encode() and decode() base64 encoding 2051 Moved to different CF Docs Only Not processed Karl Pinc (kop) Fabien Coelho (calvin) Tom Lane (tgl) 3 6 years ago NOTIFY options + COLLAPSE (make deduplication optional) 2053 Committed Not processed Filip Rembiałkowski (filiprem) Tom Lane (tgl) 2 6 years ago fix for BUG #3720: wrong results at using ltree 2054 Moved to different CF Bugfix Not processed Filip Rembiałkowski (filiprem) Tom Lane (tgl), Ibrar Ahmed (ibrar), Benjie Gillam (benjie) Tom Lane (tgl) 5 6 years ago DROP DATABASE FORCE 2055 Moved to different CF System Administration Not processed Pavel Stehule (okbobcz), Filip Rembiałkowski (filiprem) Amit Kapila (amitkapila), Ibrar Ahmed (ibrar), Anthony Nowocien (anthonyn), vigneshwaran C (vignesh.postgres), Cleysson Lima (cleyssonlima), Federico Campoli (rotellaro) Amit Kapila (amitkapila) 4 6 years ago suppress errors thrown by to_reg*() 2060 Returned with feedback Not processed takuma hoshiai (hoshiai) Tom Lane (tgl) 2 6 years ago [WIP] Show a human-readable n_distinct in pg_stats view 2061 Withdrawn 13 Not processed Maxence Ahlouche (maahl) Laurenz Albe (laurenz) 2 7 years ago Unaccent extension python script Issue in Windows 2062 Committed Bugfix Not processed Hugh Ranalli (hughr), Ramanarayana M (ramnar) Álvaro Herrera (alvherre) 2 6 years ago src/test/modules/dummy_index -- way to test reloptions from inside of access method 2064 Committed Not processed Nikolay Shaplov (nataraj) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 6 years ago Built-in connection proxy 2067 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) Koichi Suzuki (koichi) 7 4 years ago Expose queryid in pg_stat_activity and log_line_prefix 2069 Moved to different CF Monitoring Not processed Julien Rouhaud (rjuju) atsushi torikoshi (atorik), Evgeny Efimkin (efimkine), Nitin Jadhav (nitinjadhav11) Bruce Momjian (bmomjian) 10 4 years ago Avoid full GIN index scan when possible 2071 Moved to different CF Performance 13 Not processed Julien Rouhaud (rjuju), Nikita Glukhov (n.glukhov) Tom Lane (tgl) Alexander Korotkov (smagen) 4 6 years ago Change ereport level for QueuePartitionConstraintValidation 2076 Committed Not processed Sergei Kornilov (melkij) Tom Lane (tgl) Tom Lane (tgl) 2 6 years ago parse-time support function for "any" datatype 2081 Moved to different CF Not processed Pavel Stehule (okbobcz) 10 5 years ago Mingw: Fix import library extension, build actual static libraries 2082 Returned with feedback Not processed Sandro Mani (sandrom) Peter Eisentraut (petere) 2 6 years ago Implement uuid_version() 2084 Returned with feedback 13 Not processed Jose Luis Tallon (jltallon) Fabien Coelho (calvin) 2 6 years ago pgbench - extend initialization phase control 2086 Moved to different CF libpq Not processed Fabien Coelho (calvin) Fujii Masao (masaofujii), Ibrar Ahmed (ibrar), Anna Endo (btannaendo) Fujii Masao (masaofujii) 3 6 years ago Problem during Windows service start 2087 Withdrawn Bugfix Not processed Ramanarayana M (ramnar) 2 6 years ago Contribution to Perldoc for TestLib module in Postgres 2088 Committed Comments Only Not processed Ramanarayana M (ramnar) Andrew Dunstan (adunstan), Daniel Gustafsson (d_gustafsson) Álvaro Herrera (alvherre) 2 6 years ago pgbench - implement strict TPC-B benchmark 2090 Moved to different CF libpq Not processed Fabien Coelho (calvin) 3 6 years ago pgbench - add \aset to store results of combined queries (\;) 2091 Moved to different CF libpq Not processed Fabien Coelho (calvin) Ibrar Ahmed (ibrar) Michael Paquier (michael-kun) 5 6 years ago Trigger autovacuum on tuple insertion 2093 Moved to different CF Performance Not processed Laurenz Albe (laurenz) David Rowley (davidrowley), Laurenz Albe (laurenz), Justin Pryzby (justinpryzby) David Rowley (davidrowley) 5 6 years ago pg_upgrade version and path checking 2095 Returned with feedback Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 5 years 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 4 years ago Avoid duplication of code to read XLOG page 2098 Moved to different CF Refactoring Only Not processed Antonin Houska (a.houska) Michael Paquier (michael-kun) Álvaro Herrera (alvherre) 3 6 years ago Improve Append/MergeAppend EXPLAIN output when all subplans are pruned. 2102 Moved to different CF Not processed David Rowley (davidrowley) 3 6 years ago Data at rest encryption 2104 Moved to different CF 13 Not processed Antonin Houska (a.houska), Ants Aasma (antsaasma) Shawn Wang (shawnwang) 3 6 years ago Make pg_waldump and xact_desc() report the detail information like GID about PREPARE TRANSACTION record 2105 Moved to different CF Not processed Fujii Masao (masaofujii) Julien Rouhaud (rjuju) Fujii Masao (masaofujii) 3 6 years ago Two new options for pg_rewind (1. Ensure clean shutdown 2. Add recovery conf information); Also extract common code of pg_rewind and pg_basebackup. 2106 Committed 13 Not processed Ashwin Agrawal (ashwinstar), Paul Guo (paulguo), Jimmy Yih (jyih) Payal Singh (payal) Álvaro Herrera (alvherre) 2 6 years ago Parallel-aware file_fdw 2108 Returned with feedback Performance Not processed Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) 2 6 years ago accounting for memory used for BufFile during hash joins 2109 Moved to different CF Performance Not processed Tomas Vondra (fuzzycz) Melanie Plageman (melanieplageman) 3 6 years ago range_agg / multiranges 2112 Moved to different CF SQL Commands 14 Not processed Paul Jungwirth (pjungwir) Pavel Stehule (okbobcz), Jeff Davis (jdavis) Alexander Korotkov (smagen) 9 5 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 Use memcpy in pglz decompression 2119 Moved to different CF Performance Not processed Andrey Borodin (x4m), Владимир Лесков (tinsane) Peter Eisentraut (petere) Tomas Vondra (fuzzycz) 4 6 years ago tableam vs. TOAST 2120 Moved to different CF 13 Not processed Robert Haas (rhaas) Peter Eisentraut (petere) Robert Haas (rhaas) 4 6 years ago Introduce spgist quadtree @<(point,circle) operator 2124 Returned with feedback 13 Not processed Matwey V. Kornilov (matwey) 2 6 years ago Use heap_multi_insert for catalog relations 2125 Moved to different CF Performance Not processed Daniel Gustafsson (d_gustafsson) Michael Paquier (michael-kun) 4 5 years ago Rearrange postmaster startup order to improve logging behavior 2126 Committed Not processed Tom Lane (tgl) Tom Lane (tgl) 2 6 years ago Fix issues with "x SIMILAR TO y ESCAPE NULL" 2128 Committed Bugfix 13 Not processed Tom Lane (tgl) Tom Lane (tgl) 2 6 years ago ALTER TABLE restructuring 2130 Moved to different CF Bugfix Not processed Tom Lane (tgl) Álvaro Herrera (alvherre) Tom Lane (tgl) 4 6 years ago Support for jsonpath .datetime() method 2133 Moved to different CF Not processed Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov) Peter Eisentraut (petere), Anastasia Lubennikova (lubennikovaav) Alexander Korotkov (smagen) 3 6 years ago Optimized partial TOAST decompression 2135 Moved to different CF Performance Not processed Xiao Bao (djydewang) Andrey Borodin (x4m) Tomas Vondra (fuzzycz) 3 6 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 Improve search for missing parent downlinks in amcheck 2140 Moved to different CF System Administration 13 Not processed Alexander Korotkov (smagen) Peter Geoghegan (pgeoghegan) Alexander Korotkov (smagen) 5 6 years ago Avoiding deadlock errors in CREATE INDEX CONCURRENTLY 2141 Moved to different CF Not processed Dhruv Goel (goeldhru) Yoshikazu Imai (yimai) 3 6 years ago Reduce overhead of NOTIFY with many databases 2142 Committed Performance Not processed Martijn van Oosterhout (martijnvoosterhout) Tom Lane (tgl) Tom Lane (tgl) 2 6 years ago Fix runtime errors from -fsanitize=undefined 2144 Rejected Not processed Peter Eisentraut (petere) Fabien Coelho (calvin), didier gautheron (didier.users.sourceforge.net) 2 6 years ago Speedup truncates of relation forks 2145 Committed Performance Not processed Kirk Jamison (kirkjamison) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 6 years ago Parallel grouping sets 2147 Moved to different CF Performance Not processed Richard Guo (richardguo) 6 5 years ago vacuumlo: report the number of large objects going to be removed 2148 Returned with feedback Not processed Timur Birsh (taem) 2 6 years ago Add the capability to logical replication to transfer base types using binary 2152 Moved to different CF Not processed Dave Cramer (dcramer) Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) 6 5 years ago Allow an alias to be attached directly to a JOIN ... USING 2158 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 10 5 years ago Multi insert in CTAS/MatView 2160 Moved to different CF Performance Not processed Paul Guo (paulguo), Taylor Vesely (tvesely) Asim Rama Praveen (apraveen) 6 5 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 allow to set log_statement_sample_limit - maximal duration for sampling 2163 Moved to different CF Monitoring Not processed Pavel Stehule (okbobcz) Adrien Nayrat (anayrat) 3 6 years ago progress report for ANALYZE 2164 Moved to different CF Monitoring 13 Not processed Álvaro Herrera (alvherre), Vinayak Pokale (vinayak), Tatsuro Yamada (tatsuro_yamada) Julien Rouhaud (rjuju), Amit Langote (amitlan) Álvaro Herrera (alvherre) 4 6 years ago Shared Memory Context 2166 Returned with feedback 13 Not processed Takeshi Ideriha (ideriha) Thomas Munro (macdice) 2 6 years ago unlogged sequences 2167 Moved to different CF Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 3 4 years ago Remove HeapTuple and Buffer dependency for predicate locking functions 2169 Moved to different CF Refactoring Only 13 Not processed Ashwin Agrawal (ashwinstar) Thomas Munro (macdice) Thomas Munro (macdice) 4 6 years ago using explicit_bzero 2170 Committed Security Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 2 6 years ago Run-time pruning for ModifyTable 2173 Moved to different CF Performance Not processed David Rowley (davidrowley) Amit Langote (amitlan), sho kato (kato-sho) 5 6 years ago Reduce size of core scanner transition array 2174 Moved to different CF Refactoring Only 13 Not processed John Naylor (john.naylor) Tom Lane (tgl) Tom Lane (tgl) 4 6 years ago socket_timeout in interfaces/libpq 2175 Moved to different CF Monitoring 13 Not processed Ryohei Nagaura (nyannyan) 5 5 years ago FETCH FIRST clause PERCENT option 2176 Moved to different CF SQL Commands Not processed Surafel Temesgen (surafel) 12 4 years ago errbacktrace 2177 Moved to different CF Not processed Álvaro Herrera (alvherre), Peter Eisentraut (petere) Álvaro Herrera (alvherre) 3 6 years ago Fix support for hypothetical indexes using BRIN access method 2179 Moved to different CF Bugfix Not processed Julien Rouhaud (rjuju) Heikki Linnakangas (heikki), Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 6 years ago Optimize pglz compression 2180 Withdrawn Performance Not processed Andrey Borodin (x4m), Владимир Лесков (tinsane) 2 6 years ago Opclass parameters 2183 Moved to different CF 13 Not processed Nikita Glukhov (n.glukhov) 3 6 years ago conflict handling for COPY FROM 2186 Moved to different CF SQL Commands Not processed Surafel Temesgen (surafel) Alexey Kondratov (ololobus), Anthony Nowocien (anthonyn), Takanori Asaba (takanori.asaba) 5 6 years ago Duplicated LSN in ReorderBuffer 2187 Committed Bugfix Not processed Ildar Musin (i.musin) Masahiko Sawada (masahikosawada) Álvaro Herrera (alvherre) 2 6 years ago psql - sort by size 2188 Withdrawn libpq Not processed Pavel Stehule (okbobcz) Fabien Coelho (calvin) 2 6 years ago Windows could not stat file - over 4GB 2189 Moved to different CF Bugfix Not processed Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com) Emil Iggland (emiliggland) Tom Lane (tgl) 8 5 years ago ALTER STATISTICS ... SET STATISTICS ... 2190 Committed 13 Not processed Tomas Vondra (fuzzycz) Kirk Jamison (kirkjamison) Tomas Vondra (fuzzycz) 2 6 years ago allow_system_table_mods stuff 2191 Moved to different CF Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 4 6 years ago base backup client as auxiliary backend process 2192 Moved to different CF Not processed Peter Eisentraut (petere) 5 6 years ago de-TOAST'ing using a iterator 2194 Moved to different CF Performance Not processed Xiao Bao (djydewang) 8 5 years ago OpenSSL specific value under USE_SSL instead of USE_OPENSSL 2195 Committed Security Not processed Daniel Gustafsson (d_gustafsson) Bruce Momjian (bmomjian) 1 6 years ago KMS - Internal key management system 2196 Moved to different CF Not processed Masahiko Sawada (masahikosawada), Ibrar Ahmed (ibrar), Insung Moon (tsukiwamoon) Cary Huang (cary) 6 5 years ago standardize integer parsing in front-end utilities 2197 Moved to different CF Refactoring Only Not processed Surafel Temesgen (surafel), Joe Nelson (begriffs) Daniel Gustafsson (d_gustafsson) 4 6 years ago Extra quote_all_identifiers in _dumpOptions 2198 Committed Refactoring Only 13 Not processed Artur Zakirov (a.zakirov) Bruce Momjian (bmomjian) 1 6 years ago Remove "master"/"slave" usage from PL/pgSQL tests 2199 Committed Not processed Dagfinn Ilmari Mannsåker (ilmari) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 6 years ago Adding a test for speculative wait case 2200 Moved to different CF Not processed Ashwin Agrawal (ashwinstar), Melanie Plageman (melanieplageman) Andres Freund (andresfreund) 4 6 years ago Memory-Bounded Hash Aggregation 2201 Moved to different CF Performance Not processed Jeff Davis (jdavis) Jeff Davis (jdavis) 4 6 years ago B-tree deduplication 2202 Moved to different CF Performance Not processed Anastasia Lubennikova (lubennikovaav) Peter Geoghegan (pgeoghegan), Antonin Houska (a.houska) Peter Geoghegan (pgeoghegan) 4 6 years ago Add test case for sslinfo 2203 Returned with feedback Not processed 1 6 years ago List of Available Figures/Graphics in the Documentation 2204 Returned with feedback Docs Only 13 Not processed Jürgen Purtz (juergen@purtz.de) 1 6 years ago CVE-2017-7484-induced bugs, or, btree cmp functions are not leakproof? 2205 Moved to different CF Bugfix Not processed Dilip Kumar (dilip.kumar), Amit Langote (amitlan) Dilip Kumar (dilip.kumar), Amit Langote (amitlan) Tom Lane (tgl) 2 6 years ago REINDEX filtering in the backend 2206 Returned with feedback 13 Not processed Julien Rouhaud (rjuju) Peter Eisentraut (petere) 1 6 years ago Update misleading comment in tuplesort_set_bound 2207 Committed Comments Only Not processed James Coleman (jcole1989) Álvaro Herrera (alvherre) 1 6 years ago Add --include-foreign-data option to pg_dump to dump the data of foreign tables 2208 Moved to different CF System Administration 13 Not processed Luis M Carril (lmcarril) Daniel Gustafsson (d_gustafsson), Ashutosh Bapat (ashutoshbapat), vigneshwaran C (vignesh.postgres) Álvaro Herrera (alvherre) 4 6 years ago Use PageIndexTupleOverwrite() within nbtsort.c 2209 Committed Performance Not processed Peter Geoghegan (pgeoghegan) Anastasia Lubennikova (lubennikovaav) Peter Geoghegan (pgeoghegan) 1 6 years ago Removing unneeded downlink field from nbtree stack struct 2210 Committed Refactoring Only Not processed Peter Geoghegan (pgeoghegan) Anastasia Lubennikova (lubennikovaav) Peter Geoghegan (pgeoghegan) 1 6 years ago Resume vacuum and autovacuum from interruption and cancellation 2211 Moved to different CF Not processed Masahiko Sawada (masahikosawada) Rafia Sabih (rafia.sabih), Ibrar Ahmed (ibrar) 4 5 years ago Allow simplehash to use already-calculated hash values 2212 Committed Performance Not processed Jeff Davis (jdavis) Jeff Davis (jdavis) 1 6 years ago Add FOREIGN to ALTER TABLE in pg_dump when the target is a foreign table 2213 Moved to different CF System Administration 13 Not processed Luis M Carril (lmcarril) Daniel Gustafsson (d_gustafsson), vigneshwaran C (vignesh.postgres) Álvaro Herrera (alvherre) 4 6 years ago Improve performance of old_snapshot_threshold checks 2214 Committed Performance Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 6 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 Memory Accounting at Block Level 2216 Moved to different CF Performance Not processed Jeff Davis (jdavis) Melanie Plageman (melanieplageman), Soumyadeep Chakraborty (soumyadeep2007) Tomas Vondra (fuzzycz) 2 6 years ago pgbench - allow to create partitioned "account" tables 2217 Moved to different CF libpq Not processed Fabien Coelho (calvin) Asif Rehman (asifrana) Amit Kapila (amitkapila) 2 6 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 document that psql's FETCH_COUNT does not work with combined (\;) queries 2219 Moved to different CF Docs Only Not processed Fabien Coelho (calvin) Gerdan Santos (gerdan), David Johnston (polobo) 6 5 years ago Add mandatory access control for TRUNCATE 2220 Withdrawn Bugfix 13 Not processed 1 6 years ago Add mandatory access control for TRUNCATE 2221 Moved to different CF Security 13 Not processed Yulian Khodorkovskiy (ykhodo) KaiGai Kohei (kaigai), Mike Palmiotto (mpalmiotto) Joe Conway (jconway) 2 6 years ago Redacting information from logs 2222 Withdrawn Monitoring Not processed Jeff Davis (jdavis) 1 6 years ago Adding column "mem_usage" to view pg_prepared_statements 2223 Returned with feedback Monitoring 13 Not processed Daniel Migowski (dmigowski) Peter Eisentraut (petere) 1 6 years ago Race condition in logical walsender causes long postgresql shutdown delay 2224 Moved to different CF Bugfix stable Not processed Craig Ringer (ringerc) Álvaro Herrera (alvherre) 2 6 years ago get current and recovery timeline 2225 Moved to different CF Monitoring 13 Not processed Jehan-Guillaume de Rorthais (ioguix) Kyotaro Horiguchi (horiguti), Fujii Masao (masaofujii) 3 6 years ago Store FullTransactionId in TwoPhaseFileHeader/GlobalTransactionData 2226 Withdrawn Refactoring Only 13 Not processed vigneshwaran C (vignesh.postgres) 1 6 years ago More refactoring for BuildIndexInfo 2227 Committed Refactoring Only Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 6 years ago Refactoring code stripping trailing \n and \r from strings 2228 Committed Refactoring Only Not processed Michael Paquier (michael-kun) Bruce Momjian (bmomjian) Michael Paquier (michael-kun) 1 6 years ago Patch to clean Query after rewrite-and-analyze 2229 Withdrawn Performance Not processed 1 6 years ago pgrename_temp() – concurrent rename of temporary files on Windows 2230 Moved to different CF Not processed Alexander Korotkov (smagen) 4 6 years ago Prevent an illegal memory access in DecodeTimeOnly 2231 Committed Bugfix Not processed Alexander Lakhin (law) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 6 years ago Add "password_protocol" connection parameter to libpq 2232 Committed Security Not processed Jeff Davis (jdavis) Michael Paquier (michael-kun) Jeff Davis (jdavis) 1 6 years ago Global temporary tables 2233 Moved to different CF Not processed Konstantin Knizhnik (knizhnik) 3 6 years ago A hook for path-removal decision on add_path 2234 Moved to different CF Not processed KaiGai Kohei (kaigai) 11 3 years ago Remove IndexBuildCallback's dependency on HeapTuple 2235 Moved to different CF Refactoring Only Not processed Ashwin Agrawal (ashwinstar) Andres Freund (andresfreund) 2 6 years ago pgbench - improve variable management performance 2236 Moved to different CF Refactoring Only Not processed Fabien Coelho (calvin) 6 5 years ago Unix-domain socket support on Windows 2237 Moved to different CF Not processed Peter Eisentraut (petere) Andrew Dunstan (adunstan) Peter Eisentraut (petere) 4 6 years ago Use data directory inode number for IPC keys 2238 Committed Not processed Tom Lane (tgl) Peter Eisentraut (petere) Tom Lane (tgl) 1 6 years ago remove "msg" parameter from convert_tuples_by_name 2239 Committed Refactoring Only Not processed Álvaro Herrera (alvherre) Peter Eisentraut (petere) Álvaro Herrera (alvherre) 1 6 years ago allocation limit for encoding conversion 2240 Moved to different CF Not processed Álvaro Herrera (alvherre) Tom Lane (tgl) Tom Lane (tgl) 2 6 years ago New GUC prepared_statement_limit to limit memory used by prepared statements 2241 Moved to different CF System Administration Not processed Daniel Migowski (dmigowski) Ibrar Ahmed (ibrar) 2 6 years ago Ltree, lquery, and ltxtquery binary protocol support 2242 Moved to different CF Not processed Nino Floris (nino) Alexander Korotkov (smagen) Tom Lane (tgl) 4 6 years ago Add index AM callback to adjust opfamily member dependencies 2243 Moved to different CF Not processed Tom Lane (tgl) Alexander Korotkov (smagen), Hamid Akhtar (hamidakhtar) Tom Lane (tgl) 5 5 years ago Allow cluster owner to bypass authentication 2244 Moved to different CF Security Not processed Peter Eisentraut (petere) 4 6 years ago Plug-in common/logging.h with vacuumlo and oid2name 2245 Committed Refactoring Only Not processed Michael Paquier (michael-kun) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 6 years ago Remove pg_pltemplate, add trustable extensions instead 2246 Moved to different CF Not processed Tom Lane (tgl) Peter Eisentraut (petere) Tom Lane (tgl) 3 6 years ago Tab completion for CREATE OR REPLACE 2247 Committed libpq Not processed Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 6 years ago Refactoring of connection with password prompt loop for frontends 2248 Returned with feedback Refactoring Only 13 Not processed Michael Paquier (michael-kun) 1 6 years ago Asymmetric partition-wise JOIN 2249 Moved to different CF Not processed KaiGai Kohei (kaigai) Andrei Lepikhov (lepikhov) 7 4 years ago pageinspect function to decode infomasks 2250 Committed Not processed Craig Ringer (ringerc), Masahiko Sawada (masahikosawada) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 6 years ago Hooks for session start and end, take two 2251 Moved to different CF 13 Not processed Michael Paquier (michael-kun) Fabrízio Mello (fabriziomello) Michael Paquier (michael-kun) 2 6 years ago Cleanup isolation specs from unused steps 2252 Committed 13 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 6 years ago Take skip header out of a loop in COPY FROM 2253 Returned with feedback Performance Not processed Surafel Temesgen (surafel) 1 6 years ago Amcheck: check B-tree leftlink-rightlink invariant on standby 2254 Moved to different CF Monitoring Not processed Andrey Borodin (x4m) Georgy Rylov (godjan) Peter Geoghegan (pgeoghegan) 4 5 years ago Allow to_date() and to_timestamp() to accept localized names 2255 Moved to different CF SQL Commands 13 Not processed Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com) Tom Lane (tgl) Tom Lane (tgl) 4 6 years ago ICU for global collation 2256 Moved to different CF Not processed Peter Eisentraut (petere) Julien Rouhaud (rjuju) Peter Eisentraut (petere) 4 4 years ago Increasing regression test coverage based on GCOV analysis 2257 Withdrawn Not processed 1 6 years ago Increasing regression test coverage based on GCOV analysis 2258 Committed stable Not processed movead li (movead.li) Michael Paquier (michael-kun) 1 6 years ago Startup Centralization 2259 Moved to different CF 13 Not processed Mike Palmiotto (mpalmiotto), Yulian Khodorkovskiy (ykhodo) Mike Palmiotto (mpalmiotto) 2 5 years ago Online checksums - take 3 2260 Moved to different CF System Administration Not processed Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) 4 5 years ago pg_get_databasebyid(oid) 2261 Returned with feedback SQL Commands Not processed Sergei Kornilov (melkij) Vik Fearing (xocolatl), Ibrar Ahmed (ibrar) 1 6 years ago psql - improve code coverage 2262 Moved to different CF libpq Not processed Fabien Coelho (calvin) Gerdan Santos (gerdan) 5 5 years ago seccomp-bpf support 2263 Moved to different CF 13 Not processed Joe Conway (jconway) Monk Dead (monkd) 3 5 years ago Update PL/pgSQL sample loop function 2264 Committed Docs Only 13 Not processed Ian Barwick (barwick) Amit Kapila (amitkapila) 1 6 years ago Bug #15977: fix "AND CHAIN" inconsistency 2265 Committed Bugfix 12 Not processed Fabien Coelho (calvin) Peter Eisentraut (petere) 1 6 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 Consolidate code that makes a sorted array unique. 2267 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) Thomas Munro (macdice) 2 6 years ago psql: add tab completion for \df slash command suffixes 2268 Returned with feedback libpq stable Not processed Ian Barwick (barwick) Kuntal Ghosh (kuntal_ghosh) 1 6 years ago Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLESPACE 2269 Moved to different CF SQL Commands Not processed Justin Pryzby (justinpryzby), Alexey Kondratov (ololobus) Justin Pryzby (justinpryzby), Cleysson Lima (cleyssonlima) Michael Paquier (michael-kun) 9 5 years ago Row filtering for logical replication 2270 Moved to different CF 13 Not processed Euler Taveira (eulerto) Amit Langote (amitlan), Gerdan Santos (gerdan), movead li (movead.li) 4 4 years ago Introduce xid8 and xid8_current() etc, for 64 bit transaction IDs. 2271 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) Takao Fujii (t-fujii) Thomas Munro (macdice) 4 6 years ago share string to *int64 functions, take two 2272 Moved to different CF Refactoring Only 13 Not processed Michael Paquier (michael-kun), Fabien Coelho (calvin) 2 6 years ago Write visibility map during CLUSTER/VACUUM FULL 2273 Moved to different CF Performance Not processed Alexander Korotkov (smagen) Shawn Wang (shawnwang), Anna Akenteva (a.akenteva) 2 3 years ago Invalid permission check in pg_stats for functional indexes 2274 Moved to different CF Bugfix 13 Not processed Pierre Ducroquet (pinaraf) Kuntal Ghosh (kuntal_ghosh) 5 5 years ago Add a reset_computed_values function in pg_stat_statements 2275 Moved to different CF Monitoring Not processed Pierre Ducroquet (pinaraf) Julien Rouhaud (rjuju), Euler Taveira (eulerto) 2 6 years ago