Commitfest 2019-03 (2019-03-01 – 2019-03-31)

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 Respect client-initiated CopyDone during logical streaming replication 621 Moved to different CF Not processed Dave Cramer (dcramer), Vladimir Gordiychuk (gordiychuk) Craig Ringer (ringerc) 6 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 Moved to different CF 13 Not processed Nikhil Sontakke (nikkhils) Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos) 13 4 years ago SERIALIZABLE with parallel query 1004 Committed Performance 12 Not processed Thomas Munro (macdice) Masahiko Sawada (masahikosawada), Haribabu Kommi (haribabu), Kevin Grittner (kgrittn) Thomas Munro (macdice) 10 7 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 multivariate MCV lists and histograms 1238 Committed 12 Not processed Tomas Vondra (fuzzycz) David Rowley (davidrowley), Dean Rasheed (deanr) Tomas Vondra (fuzzycz) 9 6 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 Pluggable storage API 1283 Committed 12 Not processed Álvaro Herrera (alvherre), Andres Freund (andresfreund), Alexander Korotkov (smagen), Haribabu Kommi (haribabu) Alexander Korotkov (smagen) Andres Freund (andresfreund) 9 7 years ago Custom compression methods 1294 Moved to different CF 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 Removing [Merge]Append nodes which contain a single subpath 1353 Committed Performance Not processed David Rowley (davidrowley) Álvaro Herrera (alvherre), Tomas Vondra (fuzzycz) Tom Lane (tgl) 8 7 years ago verify ALTER TABLE SET NOT NULL by valid constraints 1389 Committed Performance Not processed Sergei Kornilov (melkij) David Rowley (davidrowley), Vitaly Burovoy (vitaly.burovoy), Ildar Musin (i.musin) Robert Haas (rhaas) 7 7 years ago generated columns 1443 Committed SQL Commands Not processed Peter Eisentraut (petere) Michael Paquier (michael-kun), Pavel Stehule (okbobcz) Peter Eisentraut (petere) 5 6 years ago SQL/JSON: jsonpath 1471 Committed 12 Not processed Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg) Tomas Vondra (fuzzycz) Alexander Korotkov (smagen) 6 7 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 4 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 Moved to different CF 13 Not processed Nikolay Shaplov (nataraj) Álvaro Herrera (alvherre) 8 6 years ago pg_hba.conf : new auth option : clientcert=verify-full 1522 Committed Security Not processed Julian Markwort (markwort) Magnus Hagander (mha), Thomas Munro (macdice) Magnus Hagander (mha) 6 7 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 get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead 1536 Moved to different CF 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 6 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 Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist 1578 Committed Performance Not processed Anastasia Lubennikova (lubennikovaav), Andrei Lepikhov (lepikhov) Heikki Linnakangas (heikki), Alexander Kuzmenkov (akuzmenkov) Heikki Linnakangas (heikki) 6 7 years ago Synchronous replay mode for avoiding stale reads on hot standbys 1589 Moved to different CF 13 Not processed Thomas Munro (macdice) 7 7 years ago chained transactions 1594 Committed SQL Commands Not processed Peter Eisentraut (petere) Fabien Coelho (calvin) Peter Eisentraut (petere) 6 7 years ago GiST VACUUM 1598 Committed Performance 12 Not processed Constantine Kuznetsov (chapaev28), Andrey Borodin (x4m) Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 5 7 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 5 days ago Covering GiST indexes 1615 Committed 12 Not processed Andrey Borodin (x4m) Andreas Karlsson (kandreas) Alexander Korotkov (smagen) 5 7 years ago libpq compression 1635 Returned with feedback Performance Not processed Konstantin Knizhnik (knizhnik) Jeyson Linares (jeysonl) 5 4 years ago GSSAPI encryption support 1647 Committed Security Not processed Robbie Harwood (rharwood) Nicolas Williams (cryptonector) Stephen Frost (sfrost) 5 6 years 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 Moved to different CF 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 Make installcheck-world in a clean environment 1672 Moved to different CF Not processed Alexander Lakhin (law) 6 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 Moved to different CF Performance 13 Not processed Takeshi Ideriha (ideriha) 7 6 years ago Copy function for logical replication slots 1705 Committed Not processed Masahiko Sawada (masahikosawada) Petr Jelínek (pjmodos) Álvaro Herrera (alvherre) 5 7 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 Track the next xid using 64 bits 1718 Committed Refactoring Only 12 Not processed Thomas Munro (macdice) Andres Freund (andresfreund) Thomas Munro (macdice) 4 7 years ago Show size of partitioned table 1731 Committed libpq Not processed Pavel Stehule (okbobcz) Mathias Brossard (mathias) Álvaro Herrera (alvherre) 4 7 years ago Online verification of checksums 1733 Returned with feedback System Administration Not processed Michael Banck (mbanck) Fabien Coelho (calvin) 4 4 years ago Inline Common Table Expressions 1734 Committed Performance 12 Not processed Andreas Karlsson (kandreas), Andrew Gierth (rhodiumtoad), David Fetter (dfetter) Tom Lane (tgl) Tom Lane (tgl) 4 7 years 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 conflict handling for COPY FROM 1745 Returned with feedback SQL Commands Not processed Surafel Temesgen (surafel) Karen Huddleston (khuddlefish), Andrew McElroy (andrew.mcelroy.punchh.com) 4 6 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 FETCH FIRST clause PERCENT option 1759 Returned with feedback SQL Commands Not processed Surafel Temesgen (surafel) Tomas Vondra (fuzzycz), Vik Fearing (xocolatl), Gerdan Santos (gerdan) 4 4 years ago ALTER TABLE on system catalogs 1764 Committed SQL Commands Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 4 7 years ago Strengthen PGSharedMemoryCreate checks for still-attached processes 1767 Moved to different CF Bugfix Not processed Noah Misch (nmisch) Daniel Gustafsson (d_gustafsson), Alexandra Wang (l-wang) Noah Misch (nmisch) 5 6 years ago libpq host/hostaddr consistency 1769 Moved to different CF 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 Speed up planning with partitions 1778 Committed Performance 12 Not processed Amit Langote (amitlan) David Rowley (davidrowley), Dilip Kumar (dilip.kumar), Jesper Pedersen (jpedersen), Yoshikazu Imai (yimai) Tom Lane (tgl) 4 7 years ago CLUSTER command progress monitor 1779 Committed Monitoring Not processed Tatsuro Yamada (tatsuro_yamada) Surafel Temesgen (surafel) Robert Haas (rhaas) 4 7 years ago Progress reporting for pg_verify_checksums 1786 Committed System Administration Not processed Bernd Helmle (psoo), Michael Banck (mbanck) Fabien Coelho (calvin) Michael Paquier (michael-kun) 4 7 years ago Make nbtree keys unique by appending heap TID, suffix truncation 1787 Committed Performance 12 Not processed Peter Geoghegan (pgeoghegan) Heikki Linnakangas (heikki), Andrei Lepikhov (lepikhov) Peter Geoghegan (pgeoghegan) 4 7 years ago documenting signal handling with readme 1796 Moved to different CF Docs Only Not processed Chris Travers (einhverfr) Tom Lane (tgl) 5 6 years ago SERIALIZABLE on standby servers 1799 Moved to different CF 13 Not processed Thomas Munro (macdice) Kevin Grittner (kgrittn) 4 7 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 DNS SRV support for LDAP authentication 1803 Committed 12 Not processed Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) Thomas Munro (macdice) 3 7 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 New vacuum option to do only freezing 1817 Committed Performance 12 Not processed Masahiko Sawada (masahikosawada) Nathan Bossart (bossartn), Darafei Praliaskouski (komzpa) Andres Freund (andresfreund) 3 7 years 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 Avoid creation of the free space map for small tables 1821 Committed 12 Not processed John Naylor (john.naylor) Amit Kapila (amitkapila) Amit Kapila (amitkapila) 3 7 years ago Undo worker and transaction rollback 1828 Moved to different CF 13 Not processed Amit Kapila (amitkapila), Dilip Kumar (dilip.kumar), mithun cy (mithun.cy), Rafia Sabih (rafia.sabih) 5 7 years ago Refactoring the checkpointer's fsync request queue 1829 Committed Refactoring Only Not processed Thomas Munro (macdice), Shawn Debnath (sd) Kevin Grittner (kgrittn), Shawn Debnath (sd) Thomas Munro (macdice) 3 7 years ago pg_dump multi VALUES INSERT 1832 Committed libpq 12 Not processed David Rowley (davidrowley), Surafel Temesgen (surafel) Fabien Coelho (calvin), Gerdan Santos (gerdan) Álvaro Herrera (alvherre) 3 7 years ago ATTACH/DETACH PARTITION CONCURRENTLY 1842 Committed SQL Commands Not processed Álvaro Herrera (alvherre), Robert Haas (rhaas), David Rowley (davidrowley) Robert Haas (rhaas) 3 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 Ordered Partitioned Table Scans 1850 Committed Performance 12 Not processed David Rowley (davidrowley) Julien Rouhaud (rjuju), Antonin Houska (a.houska) Tom Lane (tgl) 3 7 years ago libpq trace log 1854 Moved to different CF libpq 13 Not processed Aya Iwata (iwata.aya) Jacob Champion (jchampion), Jim Doty (doty-pivotal), Ramanarayana M (ramnar) 5 5 years ago pg_dumpall --exclude-database option 1860 Committed libpq 12 Not processed Andrew Dunstan (adunstan) Fabien Coelho (calvin) Andrew Dunstan (adunstan) 3 7 years ago Connection slots reserved for replication 1867 Committed Not processed Alexander Kukushkin (cyberdem0n) Kyotaro Horiguchi (horiguti), Petr Jelínek (pjmodos), Masahiko Sawada (masahikosawada), Oleksii Kliukin (alexk), Surafel Temesgen (surafel) Michael Paquier (michael-kun) 3 7 years ago Detoast Compressed Datum Slice 1868 Committed Performance Not processed Paul Ramsey (pramsey) Andrey Borodin (x4m), Darafei Praliaskouski (komzpa), Regina Obe (reginaobe) Stephen Frost (sfrost) 2 7 years ago Update INSTALL file 1870 Returned with feedback Docs Only Not processed Andreas 'ads' Scherbaum (ads) Stephen Frost (sfrost) 2 7 years ago XML fixes 1872 Committed Bugfix 12 Not processed Pavel Stehule (okbobcz), Chapman Flack (chap) Ryan Lambert (ryanlambert) Álvaro Herrera (alvherre) 2 7 years ago Adding a TAP test checking data consistency on standby with minRecoveryPoint 1873 Committed 12 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 7 years ago support VARIADIC arg for least/greatest functions 1874 Rejected SQL Commands Not processed Pavel Stehule (okbobcz) Chapman Flack (chap) 2 7 years ago Foreign keys referencing partitioned tables 1877 Committed 12 Not processed Álvaro Herrera (alvherre) Jesper Pedersen (jpedersen) Álvaro Herrera (alvherre) 2 7 years ago Prove IS NOT NULL inference for large arrays 1879 Committed Performance Not processed James Coleman (jcole1989) David Rowley (davidrowley), Pavel Stehule (okbobcz) Tom Lane (tgl) 2 7 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 Pass COPT and PROFILE to CXXFLAGS 1886 Committed Not processed Christoph Berg (myon) Tom Lane (tgl), Andres Freund (andresfreund), Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 7 years ago Delay locking partitions during INSERT and UPDATE 1887 Committed Performance Not processed David Rowley (davidrowley) John Naylor (john.naylor) Robert Haas (rhaas) 2 7 years ago idle-in-transaction timeout error does not give a hint 1892 Withdrawn Not processed Tatsuo Ishii (ishii) Takeshi Ideriha (ideriha) 2 7 years ago create and use subscription for nonsuperuser 1893 Returned with feedback 12 Not processed Evgeny Efimkin (efimkine) Andrey Borodin (x4m) 2 7 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 Delay locking partitions during query execution 1897 Withdrawn Performance Not processed David Rowley (davidrowley) 2 7 years ago Add sqlstate output mode to VERBOSITY 1898 Committed libpq 12 Not processed didier gautheron (didier.users.sourceforge.net) Dagfinn Ilmari Mannsåker (ilmari) Tom Lane (tgl) 2 7 years ago psql display of foreign keys 1899 Committed libpq 12 Not processed Álvaro Herrera (alvherre) Peter Eisentraut (petere) Álvaro Herrera (alvherre) 2 7 years ago timeout parameters in libpq 1902 Committed Monitoring 12 Not processed Ryohei Nagaura (nyannyan) Fabien Coelho (calvin), Kirk Jamison (kirkjamison) Michael Paquier (michael-kun) 2 7 years ago Add pg_partition_root to get top-most parent of a partition tree 1906 Committed 12 Not processed Michael Paquier (michael-kun) Amit Langote (amitlan) Michael Paquier (michael-kun) 2 7 years ago Statement-level rollback 1910 Returned with feedback Not processed Álvaro Herrera (alvherre), Takayuki Tsunakawa (maumau) 2 7 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 Making WAL receiver startup rely on GUC context for primary_conninfo and primary_slot_name 1916 Rejected Refactoring Only Not processed Michael Paquier (michael-kun) Sergei Kornilov (melkij), Donald Dong (ddong) 2 7 years ago Add timeline to partial WAL segments 1919 Moved to different CF Not processed David Steele (dsteele) 9 5 years ago Ryu floating point output 1920 Committed Performance 12 Not processed Andrew Gierth (rhodiumtoad) Donald Dong (ddong) Andrew Gierth (rhodiumtoad) 2 7 years ago REINDEX CONCURRENTLY 1921 Committed SQL Commands 12 Not processed Peter Eisentraut (petere) Michael Paquier (michael-kun), Sergei Kornilov (melkij) Peter Eisentraut (petere) 2 7 years ago EXPLAIN with information about modified GUC values 1922 Committed Not processed Tomas Vondra (fuzzycz) Rafia Sabih (rafia.sabih), John Naylor (john.naylor) Tomas Vondra (fuzzycz) 2 7 years ago Log a sample of transactions 1923 Committed Monitoring 12 Not processed Adrien Nayrat (anayrat) Hayato Kuroda (ha-kun) Álvaro Herrera (alvherre) 2 7 years ago Remove "combining diacriticals" in unaccent rules 1924 Committed Bugfix Not processed Hugh Ranalli (hughr) Thomas Munro (macdice) Thomas Munro (macdice) 2 7 years ago block level PRAGMA 1925 Moved to different CF Not processed Pavel Stehule (okbobcz) 3 6 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 DECLARE STATEMENT syntax support in ECPG 1928 Committed libpq 12 Not processed Hayato Kuroda (ha-kun) Michael Meskes (meskes) 2 7 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 A new data type 'bytea' for ECPG host variable 1935 Committed libpq 12 Not processed Ryo Matsumura (ryo) Michael Meskes (meskes) 2 7 years ago Using POPCNT and other advanced bit manipulation instructions 1939 Committed Performance 12 Not processed David Rowley (davidrowley) Tom Lane (tgl) 2 7 years ago pg_upgrade: Pass -j option down to vacuumdb 1943 Returned with feedback System Administration 12 Not processed Jesper Pedersen (jpedersen) Kirk Jamison (kirkjamison), Stefan Petrea (wsdookadr) 2 7 years ago Offline enabling/disabling of checksums 1944 Committed System Administration Not processed Michael Banck (mbanck) Michael Paquier (michael-kun), Fabien Coelho (calvin), Sergei Kornilov (melkij) Michael Paquier (michael-kun) 2 7 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 Triggers on Materialized Views 1948 Returned with feedback 13 Not processed Mi Tar (mitar) 2 7 years ago postgres_fdw: Perform UPPERREL_ORDERED and UPPERREL_FINAL steps remotely 1950 Committed Performance 12 Not processed Etsuro Fujita (efujita) Antonin Houska (a.houska) Etsuro Fujita (efujita) 2 7 years ago Temporary materialized views 1951 Returned with feedback SQL Commands Not processed Mi Tar (mitar) Andreas Karlsson (kandreas) 2 7 years ago insensitive/non-deterministic collations 1952 Committed SQL Commands 12 Not processed Peter Eisentraut (petere) Peter Geoghegan (pgeoghegan), Daniel Vérité (danielverite) Peter Eisentraut (petere) 2 7 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 Moved to different CF 13 Not processed Petr Jelínek (pjmodos) Shaun Thomas (bonesmoses) 4 6 years ago Unified logging system for command-line programs 1963 Committed libpq Not processed Peter Eisentraut (petere) Donald Dong (ddong) Peter Eisentraut (petere) 2 7 years ago monitoring CREATE INDEX [CONCURRENTLY] 1966 Committed Monitoring 12 Not processed Álvaro Herrera (alvherre) Rahila Syed (rahila.syed), Pavan Deolasee (pavan) Álvaro Herrera (alvherre) 2 7 years ago Prevent PREPARE TRANSACTION for transactions involving the session's temporary namespace 1967 Committed Bugfix Not processed Michael Paquier (michael-kun) Masahiko Sawada (masahikosawada) Michael Paquier (michael-kun) 1 7 years ago Document client_min_messages vis. INFO message severity 1968 Committed Docs Only Not processed Karl Pinc (kop) Andrew Gierth (rhodiumtoad) 1 7 years ago Prevent extension creation in temporary schemas 1969 Returned with feedback Bugfix Not processed Michael Paquier (michael-kun) Chris Travers (einhverfr), Hayato Kuroda (ha-kun) 1 7 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 Include all columns in default names for foreign key constraints. 1971 Committed Not processed Paul Martinez (pauljulius) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago use strtof, not strtod, for float4in 1972 Committed Not processed Andrew Gierth (rhodiumtoad) Andrew Gierth (rhodiumtoad) 1 7 years ago Simplify set of flags used by MyXactFlags 1973 Committed Not processed Michael Paquier (michael-kun) Álvaro Herrera (alvarofherrera) Michael Paquier (michael-kun) 1 7 years ago pg_stat_statements should notice FOR UPDATE clauses 1974 Moved to different CF Monitoring Not processed Andrew Gierth (rhodiumtoad), Vik Fearing (xocolatl) Greg Stark (stark), Takayuki Tsunakawa (maumau), Sergei Kornilov (melkij) Andrew Gierth (rhodiumtoad) 2 6 years ago Referential Integrity Checks with Statement Level Triggers 1975 Moved to different CF Performance 13 Not processed Corey Huinker (coreyh) Antonin Houska (a.houska) 2 6 years ago \describe: verbose commands in psql 1976 Moved to different CF 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 ArchiveEntry optional arguments 1978 Committed Refactoring Only Not processed Dmitry Dolgov (erthalion) Álvaro Herrera (alvherre) 1 7 years ago First SVG graphic 1979 Committed Docs Only 12 Not processed Jürgen Purtz (jpurtzwiki) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Log10 and hyperbolic functions for SQL:2016 compliance 1980 Committed SQL Commands 12 Not processed Lætitia AVROT (arkhena) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago Skip table truncation at VACUUM 1981 Committed 12 Not processed Takayuki Tsunakawa (maumau) Julien Rouhaud (rjuju) Fujii Masao (masaofujii) 1 7 years ago Fix DROP FUNCTION IF NOT EXISTS with ambiguous function 1982 Committed Bugfix 12 Not processed David Rowley (davidrowley) Pavel Stehule (okbobcz), Julien Rouhaud (rjuju) Tom Lane (tgl) 1 7 years ago Fix inadequate executor locking of indexes 1983 Committed Bugfix Not processed David Rowley (davidrowley) Julien Rouhaud (rjuju) Tom Lane (tgl) 1 7 years ago Fix performance issue in foreign-key-aware join estimation 1984 Moved to different CF Bugfix 13 Not processed David Rowley (davidrowley) Tom Lane (tgl) David Rowley (davidrowley) 2 6 years ago Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query; 1985 Committed Bugfix Not processed Andreas Karlsson (kandreas) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago add_partial_path() may remove dominated path but still in use 1986 Committed Bugfix Not processed Tom Lane (tgl) 1 7 years ago Inconsistent error handling in the openssl init code 1987 Committed Bugfix Not processed Daniel Gustafsson (d_gustafsson) Michael Paquier (michael-kun) Peter Eisentraut (petere) 1 7 years ago Incorrect value of snapshot_type 1988 Committed Bugfix Not processed Antonin Houska (a.houska) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Fix pgbench tap tests when the path contains a perl special character 1989 Committed Bugfix stable Not processed Fabien Coelho (calvin) Raúl Marín (algunenano) Andrew Dunstan (adunstan) 1 7 years ago SortSupport implementation on inet/cdir 1990 Withdrawn Performance Not processed 1 6 years ago SortSupport implementation on inet/cdir 1991 Moved to different CF Performance 13 Not processed Brandur Leach (brandur) Edmund Horner (ejrh) Peter Geoghegan (pgeoghegan) 2 6 years ago Improve wording of differences between constraint exclusion and partition pruning 1992 Committed Docs Only Not processed David Rowley (davidrowley) Chapman Flack (chap) Michael Paquier (michael-kun) 1 7 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 xlogreader: do not read a file block twice 1994 Committed Bugfix Not processed Artur Zakirov (a.zakirov) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 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 Empty targetlist in a plan for certain inherited updates causes user-facing errors 1996 Committed Bugfix stable Not processed Amit Langote (amitlan) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago Generated as identity field in a temporary table with on commit drop corrupts system catalogs 1997 Moved to different CF Bugfix stable Not processed Michael Paquier (michael-kun) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 6 years ago ECPG: could not use some CREATE TABLE AS syntax 1998 Committed Bugfix Not processed daisuke higuchi (daisukehiguchi) Michael Meskes (meskes) 1 7 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 6 years ago Fix optimization of foreign-key on update actions 2000 Committed SQL Commands Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago A separate table level option to control compression 2001 Returned with feedback 12 Not processed Pavan Deolasee (pavan) Masahiko Sawada (masahikosawada), Andrew Dunstan (adunstan), Shaun Thomas (bonesmoses), Vyacheslav Lenskyy (vyacheslavl) Michael Paquier (michael-kun) 1 7 years ago query logging of prepared statements 2002 Moved to different CF Monitoring 12 Not processed Justin Pryzby (justinpryzby) Artur Zakirov (a.zakirov) 2 7 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 Prepared transaction releasing locks before deregistering its GID 2004 Committed Bugfix Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago clear PGAPPNAME for PostgresNode postmasters 2005 Committed System Administration Not processed Peter Eisentraut (petere) Noah Misch (nmisch) Peter Eisentraut (petere) 1 7 years ago pg_restore supports stdout in --file 2006 Committed libpq 12 Not processed Euler Taveira (eulerto) Yoshikazu Imai (yimai), José Villanova (azlev) Álvaro Herrera (alvherre) 1 7 years ago Shared Ispell dictionaries 2007 Returned with feedback 13 Not processed Artur Zakirov (a.zakirov) Ildus Kurbangaliev (ildus) 1 7 years ago Set fallback_application_name for a walreceiver to cluster_name 2008 Committed 12 Not processed Peter Eisentraut (petere) Euler Taveira (eulerto) Peter Eisentraut (petere) 1 7 years ago COPY FREEZE, PD_VISIBLE_ALL and VM status 2009 Moved to different CF Bugfix Not processed Pavan Deolasee (pavan), Ibrar Ahmed (ibrar) Darafei Praliaskouski (komzpa), Hamid Akhtar (hamidakhtar) Tomas Vondra (fuzzycz) 6 5 years ago psql: add schema size information to \dn+ 2010 Withdrawn libpq 12 Not processed Gilles Darold (darold) Julien Rouhaud (rjuju) 1 7 years ago Optimization of some jsonb functions 2011 Moved to different CF Performance 13 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) Álvaro Herrera (alvherre) 3 6 years ago Handle properly SCRAM channel binding with client and server mismatching OpenSSL versions 2012 Committed Bugfix stable Not processed Michael Paquier (michael-kun) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 7 years ago Don't count parallel worker transactions as commits or rollbacks 2013 Moved to different CF 12 Not processed Haribabu Kommi (haribabu) Rahila Syed (rahila.syed), Kirk Jamison (kirkjamison) Amit Kapila (amitkapila) 2 6 years ago Track checksum failures in pg_stat_database 2014 Committed Monitoring Not processed Magnus Hagander (mha) Julien Rouhaud (rjuju) Magnus Hagander (mha) 1 7 years ago Align timestamps in pg_regress output 2015 Committed Refactoring Only Not processed Christoph Berg (myon) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Show temp table namespace xid in pg_stat_activity 2016 Returned with feedback Monitoring Not processed Magnus Hagander (mha) 1 7 years ago add reserved OID range for development 2017 Committed 12 Not processed John Naylor (john.naylor) Tom Lane (tgl) Tom Lane (tgl) 1 7 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 Lists into arrays 2019 Moved to different CF Performance 13 Not processed Tom Lane (tgl) David Rowley (davidrowley), Jesper Pedersen (jpedersen) Tom Lane (tgl) 2 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 Increase default vacuum_cost_limit setting 2021 Committed System Administration 12 Not processed David Rowley (davidrowley) Andrew Dunstan (adunstan) 1 7 years ago Fix leak in "CREATE...AS" 2022 Committed Bugfix Not processed Jeff Janes (jjanes) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago NOT IN to ANTI JOIN transformation 2023 Moved to different CF Performance 13 Not processed James Finnerty (jimfinnerty), Zheng Li (zhengli) 6 6 years ago move current_logfiles to log_directory or change the permissions of the file to follow data directory 2024 Committed Bugfix Not processed Haribabu Kommi (haribabu) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 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 Document the limitations of row-level security 2027 Returned with feedback Docs Only 12 Not processed Pierre Ducroquet (pinaraf) Peter Eisentraut (petere) 1 7 years ago Flexible partition pruning hook 2028 Moved to different CF Performance 13 Not processed Mike Palmiotto (mpalmiotto) 3 6 years ago Problem with default partition pruning 2029 Moved to different CF Bugfix stable Not processed Yuzuko Hosoya (yuzu) Thibaut MADELAINE (madtibo), Ibrar Ahmed (ibrar), Shawn Wang (shawnwang) Álvaro Herrera (alvherre) 3 6 years ago Oddity with parallel safety test for scan/join target in grouping_planner 2030 Committed Bugfix Not processed Etsuro Fujita (efujita) Tom Lane (tgl) Etsuro Fujita (efujita) 1 7 years ago Improve WAL on COW filesystems 2031 Committed Performance 12 Not processed Jerry Jelinek (jerryj) Álvaro Herrera (alvherre) Thomas Munro (macdice) 1 7 years ago readdir is incorrectly implemented at Windows 2032 Committed Bugfix Not processed Konstantin Knizhnik (knizhnik) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago extension patch to add OR REPLACE clause to CREATE TRIGGER 2033 Withdrawn SQL Commands Not processed 1 9 years ago extension patch of CREATE OR REPLACE TRIGGER 2034 Moved to different CF SQL Commands 13 Not processed Takamichi Osumi (tatatappp) Surafel Temesgen (surafel), Philippe BEAUDOIN (beaud76) 3 5 years ago pgbench state change cleanup 2035 Committed Refactoring Only 12 Not processed Fabien Coelho (calvin) Kirk Jamison (kirkjamison) Álvaro Herrera (alvherre) 1 7 years ago pgbench - improve zipfian documentation about performance 2036 Committed Docs Only stable Not processed Fabien Coelho (calvin) Georgios Kokolatos (gkokolatos) Tom Lane (tgl) 1 7 years ago pgbench - enlarge max args 2037 Committed libpq stable Not processed Simon Riggs (simon), Dagfinn Ilmari Mannsåker (ilmari) David Rowley (davidrowley), Fabien Coelho (calvin) Andrew Dunstan (adunstan) 1 7 years ago Row Level Security, leakproof-ness, and performance implications 2038 Rejected Performance 12 Not processed Joe Conway (jconway) 1 7 years ago Switch current_schema() to PARALLEL UNSAFE 2039 Committed Bugfix Not processed Michael Paquier (michael-kun) Daniel Gustafsson (d_gustafsson) Michael Paquier (michael-kun) 1 7 years ago Optimization of index_deform_tuple 2040 Committed Performance Not processed Konstantin Knizhnik (knizhnik) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago Don't log empty incomplete startup packet 2041 Committed Monitoring 12 Not processed Tom Lane (tgl) Andrew Dunstan (adunstan) 1 7 years ago Add exclusive backup deprecation notes to documentation 2042 Committed Docs Only 12 Not processed David Steele (dsteele) Martín Marqués (mmarques) Robert Haas (rhaas) 1 7 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 Moved to different CF 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 Fix memleaks and error handling in jsonb_plpython 2046 Committed Bugfix stable Not processed Nikita Glukhov (n.glukhov) Michael Paquier (michael-kun) Tom Lane (tgl) 1 7 years ago Tighten error control for OpenTransientFile/CloseTransientFile 2047 Committed 12 Not processed Michael Paquier (michael-kun) Georgios Kokolatos (gkokolatos) Michael Paquier (michael-kun) 1 7 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 CLUSTER command progress monitor 2049 Committed Monitoring 12 Not processed Robert Haas (rhaas) 1 7 years ago Fix unique join costings 2050 Moved to different CF Bugfix stable Not processed David Rowley (davidrowley) Tom Lane (tgl) 9 5 years ago