Commitfest 2019-01 (2019-01-01 – 2019-01-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 pgbench - allow to store query results into variables 669 Committed libpq Not processed Fabien Coelho (calvin) Stephen Frost (sfrost), Amit Langote (amitlan), Rafia Sabih (rafia.sabih) Álvaro Herrera (alvherre) 12 7 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 Moved to different CF 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 XML XPath default namespace support 1085 Rejected Not processed Pavel Stehule (okbobcz) Kyotaro Horiguchi (horiguti) 8 7 years ago Add and report the new "session_read_only" GUC pseudo-variable. 1090 Returned with feedback Not processed Elvis Pranskevichus (elprans) Melanie Plageman (melanieplageman) 3 7 years ago multivariate MCV lists and histograms 1238 Moved to different CF 12 Not processed Tomas Vondra (fuzzycz) David Rowley (davidrowley), Dean Rasheed (deanr) Tomas Vondra (fuzzycz) 9 7 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 GnuTLS support 1277 Returned with feedback Security Not processed Andreas Karlsson (kandreas), Peter Eisentraut (petere) 8 7 years ago Pluggable storage API 1283 Moved to different CF 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 Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs 1319 Returned with feedback Security Not processed Nicolas Williams (cryptonector) Álvaro Herrera (alvherre), Robbie Harwood (rharwood) 5 7 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 Moved to different CF 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 Moved to different CF Performance Not processed Sergei Kornilov (melkij) David Rowley (davidrowley), Vitaly Burovoy (vitaly.burovoy), Ildar Musin (i.musin) Robert Haas (rhaas) 7 7 years ago Flexible configuration for full-text search 1421 Returned with feedback Not processed Aleksandr Parfenov (a.parfenov) Aleksander Alekseev (a.alekseev) 6 7 years ago generated columns 1443 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) Michael Paquier (michael-kun), Pavel Stehule (okbobcz) Peter Eisentraut (petere) 5 7 years ago MERGE 1446 Returned with feedback SQL Commands Not processed Pavan Deolasee (pavan) 6 7 years ago Sample values for pg_stat_statements 1460 Returned with feedback Monitoring Not processed Vik Fearing (xocolatl) Tomas Vondra (fuzzycz), Haribabu Kommi (haribabu), Greg Stark (stark), Julian Markwort (markwort) 6 7 years ago Shared Ispell dictionaries 1461 Returned with feedback Not processed Artur Zakirov (a.zakirov) Tomas Vondra (fuzzycz), Ildus Kurbangaliev (ildus) Tomas Vondra (fuzzycz) 6 7 years ago SQL/JSON: jsonpath 1471 Moved to different CF 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 Applying PMDK to WAL operations for persistent memory 1485 Returned with feedback Not processed yoshimi ichiyanagi (yoshimiyana) Heikki Linnakangas (heikki) 5 7 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 macOS Secure Transport SSL Support 1490 Returned with feedback Security Not processed Daniel Gustafsson (d_gustafsson) Heikki Linnakangas (heikki) 5 7 years ago pg_hba.conf : new auth option : clientcert=verify-full 1522 Moved to different CF 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 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 5 years ago Online enabling of checksums 1535 Returned with feedback System Administration Not processed Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) Tomas Vondra (fuzzycz), Andrey Borodin (x4m), Michael Banck (mbanck), Sergei Kornilov (melkij) Magnus Hagander (mha) 5 7 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 ICU as default collation provider 1543 Returned with feedback Not processed Marina Polyakova (whipping.top1991) Peter Geoghegan (pgeoghegan), Daniel Vérité (danielverite), Andrey Borodin (x4m) 5 7 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 Changing the autovacuum launcher scheduling; oldest table first algorithm 1573 Returned with feedback System Administration Not processed Masahiko Sawada (masahikosawada) Anastasia Lubennikova (lubennikovaav) 5 7 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 Moved to different CF 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 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) Fabien Coelho (calvin) Peter Eisentraut (petere) 6 7 years ago GiST VACUUM 1598 Moved to different CF Performance 12 Not processed Constantine Kuznetsov (chapaev28), Andrey Borodin (x4m) Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 5 7 years ago Two pass check for deadlock 1602 Returned with feedback Performance Not processed Yura Sokolov (funny_falcon) Masahiko Sawada (masahikosawada), Ashutosh Bapat (ashutoshbapat) 4 7 years ago Implement ASSERTIONs per the SQL standard. 1604 Returned with feedback Not processed Joe Wildish (joewildish) 4 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 Moved to different CF 12 Not processed Andrey Borodin (x4m) Andreas Karlsson (kandreas) Alexander Korotkov (smagen) 5 7 years ago de-deduplicate code in DML execution hooks in postgres_fdw 1619 Committed Refactoring Only Not processed Ashutosh Bapat (ashutoshbapat) Etsuro Fujita (efujita) Etsuro Fujita (efujita) 4 7 years ago generalized expression syntax for partition bounds 1620 Committed SQL Commands Not processed Tom Lane (tgl), Kyotaro Horiguchi (horiguti), Amit Langote (amitlan) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 7 years ago Range phrase operator in tsquery 1624 Returned with feedback Not processed Aleksandr Parfenov (a.parfenov) Dmitry Ivanov (funbringer) 4 7 years ago Replace conversion_create.sql with normal data entries 1626 Committed Refactoring Only Not processed John Naylor (john.naylor) Tom Lane (tgl) Tom Lane (tgl) 4 7 years ago hostorder and failover_timeout for libpq 1631 Returned with feedback libpq Not processed Ildar Musin (i.musin) Surafel Temesgen (surafel) 4 7 years ago libpq compression 1635 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) Jeyson Linares (jeysonl) 5 4 years ago Add --include-table-data-where option to pg_dump, to export only a subset of table data 1644 Returned with feedback libpq Not processed Carter Thaxton (carter.thaxton) Gerdan Santos (gerdan), Surafel Temesgen (surafel) 4 7 years ago GSSAPI encryption support 1647 Moved to different CF Security Not processed Robbie Harwood (rharwood) Nicolas Williams (cryptonector) Stephen Frost (sfrost) 5 7 years ago WIP: Precalculate stable functions 1648 Returned with feedback Performance Not processed Artur Zakirov (a.zakirov), Marina Polyakova (whipping.top1991) 4 7 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 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 Global snapshots 1662 Returned with feedback Not processed Stas Kelvich (kelvich), Konstantin Knizhnik (knizhnik) Andrey Borodin (x4m) 4 7 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 Moving relation extension locks out of heavyweight lock manager 1666 Returned with feedback Performance Not processed Masahiko Sawada (masahikosawada) 4 7 years ago Support optional message in backend cancellation/termination 1670 Returned with feedback System Administration Not processed Daniel Gustafsson (d_gustafsson) Pavel Stehule (okbobcz) 4 7 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 Fix cancelled queries when hot_standby_feedback = on 1683 Returned with feedback Bugfix Not processed Ivan Kartyshov (fenimorkin) Alexander Korotkov (smagen) 4 7 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 SQL/JSON: documentation 1704 Returned with feedback Docs Only Not processed Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg) 4 7 years ago Copy function for logical replication slots 1705 Moved to different CF Not processed Masahiko Sawada (masahikosawada) Petr Jelínek (pjmodos) Álvaro Herrera (alvherre) 5 7 years ago cost_sort improvement 1706 Returned with feedback Performance Not processed Fedor Sigaev (sigaev) 4 7 years ago pg_stat_statements_reset() update to reset specific statement statistics 1707 Committed System Administration Not processed Haribabu Kommi (haribabu) Fujii Masao (masaofujii), Sergei Kornilov (melkij) Amit Kapila (amitkapila) 4 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 Moved to different CF Refactoring Only 12 Not processed Thomas Munro (macdice) Andres Freund (andresfreund) Thomas Munro (macdice) 4 7 years ago Show size of partitioned table 1731 Moved to different CF libpq Not processed Pavel Stehule (okbobcz) Mathias Brossard (mathias) Álvaro Herrera (alvherre) 4 7 years ago Online verification of checksums 1733 Moved to different CF System Administration Not processed Michael Banck (mbanck) Fabien Coelho (calvin) 4 4 years ago Inline Common Table Expressions 1734 Moved to different CF 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 improve documentation about default privileges 1739 Committed Docs Only Not processed Fabien Coelho (calvin) Bradley DeJong (bd) Tom Lane (tgl) 3 7 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 Moved to different CF 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 Moved to different CF 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 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 4 7 years ago Detect shared buffer access violations using mprotect() 1765 Returned with feedback Not processed Asim Rama Praveen (apraveen) 3 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 Moved to different CF 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 Moved to different CF Monitoring Not processed Tatsuro Yamada (tatsuro_yamada) Surafel Temesgen (surafel) Robert Haas (rhaas) 4 7 years ago Allow has_table_previlege to return false when user has no previlege on namespace 1783 Returned with feedback Security Not processed Yugo Nagata (yugo.nagata) Gerdan Santos (gerdan) 3 7 years ago Progress reporting for pg_verify_checksums 1786 Moved to different CF 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 Moved to different CF Performance 12 Not processed Peter Geoghegan (pgeoghegan) Heikki Linnakangas (heikki), Andrei Lepikhov (lepikhov) Peter Geoghegan (pgeoghegan) 4 7 years ago Add extension options to control TAP and isolation tests (Makefile rules) 1789 Committed Refactoring Only Not processed Michael Paquier (michael-kun) Nikolay Shaplov (nataraj) Michael Paquier (michael-kun) 2 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 Retail IndexTuple Deletion 1802 Returned with feedback Performance Not processed Andrei Lepikhov (lepikhov) 2 7 years ago DNS SRV support for LDAP authentication 1803 Moved to different CF 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 Implement predicate propagation for non-equivalence clauses. 1807 Returned with feedback Not processed Richard Guo (richardguo) Alexander Kuzmenkov (akuzmenkov) 2 7 years ago Clean .ready and .done files for missing WAL segments at recovery 1810 Committed Bugfix Not processed Michael Paquier (michael-kun) Nathan Bossart (bossartn), Ibrar Ahmed (ibrar) Michael Paquier (michael-kun) 2 7 years ago New vacuum option to do only freezing 1817 Moved to different CF 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 NOTIFY and pg_notify performance when deduplicating notifications 1820 Returned with feedback Performance Not processed Julien Demoor (jdemoor) Catalin Iacob (cataliniacob) 2 7 years ago Avoid creation of the free space map for small tables 1821 Moved to different CF 12 Not processed John Naylor (john.naylor) Amit Kapila (amitkapila) Amit Kapila (amitkapila) 3 7 years ago Support custom socket directory in pg_upgrade 1822 Committed System Administration Not processed Daniel Gustafsson (d_gustafsson) Hironobu Suzuki (suzuki_hironobu) Tom Lane (tgl) 2 7 years ago COPY FROM WHEN condition 1824 Committed SQL Commands Not processed Surafel Temesgen (surafel) Tomas Vondra (fuzzycz), MyungKyu Lim (lmk) Tomas Vondra (fuzzycz) 2 7 years ago Make the planner treat empty jointrees as selecting from a new dummy RTE type 1827 Committed Performance Not processed Tom Lane (tgl) David Rowley (davidrowley), Mark Dilger (hornschnorter) Tom Lane (tgl) 2 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 Moved to different CF 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 Moved to different CF libpq 12 Not processed David Rowley (davidrowley), Surafel Temesgen (surafel) Fabien Coelho (calvin), Gerdan Santos (gerdan) Álvaro Herrera (alvherre) 3 7 years ago pg_stat_ssl additions 1833 Committed System Administration Not processed Peter Eisentraut (petere) Gerdan Santos (gerdan) Peter Eisentraut (petere) 2 7 years ago Use single-byte Boyer-Moore-Horspool search even with multibyte encodings. 1834 Committed Performance Not processed Heikki Linnakangas (heikki) John Naylor (john.naylor) Heikki Linnakangas (heikki) 2 7 years ago Add entry creation timestamp column to pg_stat_replication 1841 Committed Monitoring Not processed MyungKyu Lim (lmk) Surafel Temesgen (surafel) Michael Paquier (michael-kun) 2 7 years ago ATTACH/DETACH PARTITION CONCURRENTLY 1842 Moved to different CF 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 Moved to different CF Performance 12 Not processed David Rowley (davidrowley) Julien Rouhaud (rjuju), Antonin Houska (a.houska) Tom Lane (tgl) 3 7 years ago logical decoding Segmentation fault (predicate index causing crash) 1852 Committed Bugfix Not processed Álvaro Herrera (alvherre), Petr Jelínek (pjmodos) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 7 years ago improve pgbench doc about prepared statements 1853 Committed Docs Only Not processed Tatsuo Ishii (ishii) Fabien Coelho (calvin), Álvaro Herrera (alvarofherrera) Tatsuo Ishii (ishii) 2 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 Add options for COSTS and duration to auto_explain, and add tests 1855 Rejected Monitoring Not processed Daniel Gustafsson (d_gustafsson) 2 7 years ago Installation instructions update (pg_ctl) 1857 Committed Docs Only Not processed Andreas 'ads' Scherbaum (ads) Michael Banck (mbanck), Ryan Lambert (ryanlambert) Michael Paquier (michael-kun) 2 7 years ago pg_dumpall --exclude-database option 1860 Moved to different CF libpq 12 Not processed Andrew Dunstan (adunstan) Fabien Coelho (calvin) Andrew Dunstan (adunstan) 3 7 years ago Row filtering for logical replication 1862 Returned with feedback Not processed Euler Taveira (eulerto) Petr Jelínek (pjmodos), Hironobu Suzuki (suzuki_hironobu) 2 4 years ago Cleaning up orphaned files using undo logs 1863 Moved to different CF Not processed Thomas Munro (macdice) 5 4 years ago Avoid duplicate XIDs at recovery when building initial snapshot - take 2 1866 Returned with feedback Bugfix Not processed Michael Paquier (michael-kun) 2 7 years ago Connection slots reserved for replication 1867 Moved to different CF 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 Moved to different CF Performance Not processed Paul Ramsey (pramsey) Andrey Borodin (x4m), Darafei Praliaskouski (komzpa), Regina Obe (reginaobe) Stephen Frost (sfrost) 2 7 years ago Improvements to Postgres documentation "Getting started" tutorial for Google Code-in task 1869 Returned with feedback Docs Only Not processed Andreas 'ads' Scherbaum (ads) 1 7 years ago Update INSTALL file 1870 Moved to different CF Docs Only Not processed Andreas 'ads' Scherbaum (ads) Stephen Frost (sfrost) 2 7 years ago ON COMMIT actions and inheritance 1871 Committed Bugfix Not processed Amit Langote (amitlan) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago XML fixes 1872 Moved to different CF 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 Moved to different CF 12 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 7 years ago support VARIADIC arg for least/greatest functions 1874 Moved to different CF SQL Commands Not processed Pavel Stehule (okbobcz) Chapman Flack (chap) 2 7 years ago Convert MAX_SAOP_ARRAY_SIZE to new guc 1875 Withdrawn Performance Not processed James Coleman (jcole1989) Paul Ramsey (pramsey) 1 7 years ago Fix bug in multi-server ldapserver 1876 Committed Bugfix Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 7 years ago Foreign keys referencing partitioned tables 1877 Moved to different CF 12 Not processed Álvaro Herrera (alvherre) Jesper Pedersen (jpedersen) Álvaro Herrera (alvherre) 2 7 years ago More issues with pg_verify_checksums and checksum verification in base backups 1878 Committed Bugfix Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Prove IS NOT NULL inference for large arrays 1879 Moved to different CF Performance Not processed James Coleman (jcole1989) David Rowley (davidrowley), Pavel Stehule (okbobcz) Tom Lane (tgl) 2 7 years ago Fix BufFileSize() return type 1880 Committed Bugfix Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 7 years ago plpgsql unique statement id 1881 Committed Not processed Pavel Stehule (okbobcz) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Add client connection check during the execution of the query 1882 Moved to different CF Monitoring Not processed Sergey Cherkashin (cherkashins) Stas Kelvich (kelvich) 2 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 ALTER INDEX ... ALTER COLUMN not present in dump 1884 Committed Bugfix Not processed Michael Paquier (michael-kun) Adrien Nayrat (anayrat), Amul Sul (sulamul) Michael Paquier (michael-kun) 1 7 years ago Log PostgreSQL version number on startup 1885 Committed System Administration Not processed Christoph Berg (myon) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Pass COPT and PROFILE to CXXFLAGS 1886 Moved to different CF 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 Moved to different CF Performance Not processed David Rowley (davidrowley) John Naylor (john.naylor) Robert Haas (rhaas) 2 7 years ago Allow stopping wal senders to be invovled in SyncRepReleaseWaiters() also. 1888 Committed Bugfix Not processed Paul Guo (paulguo-pivotal) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Allow partitions to inherit their tablespace from their parent 1889 Committed Not processed David Rowley (davidrowley) Michael Paquier (michael-kun) Álvaro Herrera (alvherre) 1 7 years ago Allow UNLISTEN during recovery 1890 Committed SQL Commands Not processed Shay Rojansky (roji) Mi Tar (mitar) Tom Lane (tgl) 1 7 years ago Change pg_regress diffs to unified by default 1891 Committed Not processed Christoph Berg (myon) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago idle-in-transaction timeout error does not give a hint 1892 Moved to different CF Not processed Tatsuo Ishii (ishii) Takeshi Ideriha (ideriha) 2 7 years ago create and use subscription for nonsuperuser 1893 Moved to different CF 12 Not processed Evgeny Efimkin (efimkine) Andrey Borodin (x4m) 2 7 years ago Change "checkpoint starting" message to use "wal" 1894 Committed Monitoring Not processed Christoph Berg (myon) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Improve tab completion for CREATE TABLE 1895 Committed libpq Not processed Dagfinn Ilmari Mannsåker (ilmari) Michael Paquier (michael-kun) 1 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 Moved to different CF Performance Not processed David Rowley (davidrowley) 2 7 years ago Add sqlstate output mode to VERBOSITY 1898 Moved to different CF 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 Moved to different CF libpq 12 Not processed Álvaro Herrera (alvherre) Peter Eisentraut (petere) Álvaro Herrera (alvherre) 2 7 years ago Improve documentation about run-time pruning 1900 Committed Docs Only Not processed Amit Langote (amitlan) Álvaro Herrera (alvherre) 1 7 years ago Improve error about unsupported subscription target relations 1901 Committed Not processed Amit Langote (amitlan) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 7 years ago timeout parameters in libpq 1902 Moved to different CF Monitoring 12 Not processed Ryohei Nagaura (nyannyan) Fabien Coelho (calvin), Kirk Jamison (kirkjamison) Michael Paquier (michael-kun) 2 7 years ago minor fix in CancelVirtualTransaction 1903 Returned with feedback Refactoring Only Not processed Álvaro Herrera (alvherre) Peter Eisentraut (petere), Pavan Deolasee (pavan) 1 7 years ago don't create storage when unnecessary 1904 Committed Not processed Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 1 7 years ago rewrite ExecPartitionCheckEmitError 1905 Committed Not processed Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 1 7 years ago Add pg_partition_root to get top-most parent of a partition tree 1906 Moved to different CF 12 Not processed Michael Paquier (michael-kun) Amit Langote (amitlan) Michael Paquier (michael-kun) 2 7 years ago pg_partition_tree crashes for a non-defined relation 1907 Committed Bugfix Not processed Michael Paquier (michael-kun) Stephen Frost (sfrost), Amit Langote (amitlan) Michael Paquier (michael-kun) 1 7 years ago Allow anonymous rowtypes in function return column definition 1908 Committed SQL Commands Not processed Elvis Pranskevichus (elprans) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago ALTER TABLE synopsis : action keyword with two different usages 1909 Committed Docs Only Not processed Lætitia AVROT (arkhena) Michael Paquier (michael-kun) 1 7 years ago Statement-level rollback 1910 Moved to different CF 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 INSTALL file generation with Pandoc 1912 Committed Docs Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Remove deprecated exclusive backup mode 1913 Moved to different CF Not processed David Steele (dsteele) Magnus Hagander (mha) 9 5 years ago Fast path for empty relids in check_outerjoin_delay() 1914 Returned with feedback Refactoring Only Not processed Richard Guo (richardguo) Tom Lane (tgl) 1 7 years ago additional foreign key test coverage 1915 Committed Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Making WAL receiver startup rely on GUC context for primary_conninfo and primary_slot_name 1916 Moved to different CF Refactoring Only Not processed Michael Paquier (michael-kun) Sergei Kornilov (melkij), Donald Dong (ddong) 2 7 years ago tab-completion debug print 1917 Returned with feedback Not processed Kyotaro Horiguchi (horiguti) 1 7 years ago Change pgarch_readyXlog() to return .history files first 1918 Committed Not processed David Steele (dsteele) Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti) Michael Paquier (michael-kun) 1 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 Moved to different CF Performance 12 Not processed Andrew Gierth (rhodiumtoad) Donald Dong (ddong) Andrew Gierth (rhodiumtoad) 2 7 years ago REINDEX CONCURRENTLY 1921 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 use exec_stmt instead exec_stmt_block 1926 Committed Bugfix Not processed Pavel Stehule (okbobcz) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 7 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 Moved to different CF libpq 12 Not processed Hayato Kuroda (ha-kun) Michael Meskes (meskes) 2 7 years ago Tab completion for ALTER INDEX|TABLE ALTER COLUMN SET STATISTICS 1929 Committed libpq Not processed Tatsuro Yamada (tatsuro_yamada) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 7 years ago Make COPY TO STDOUT \g file or \g |command take the argument to \g into account 1930 Committed Bugfix Not processed Daniel Vérité (danielverite) Fabien Coelho (calvin) Tom Lane (tgl) 1 7 years ago Avoid treating core keywords as reserved in plpgsql 1931 Committed Not processed Tom Lane (tgl) Peter Eisentraut (petere) Tom Lane (tgl) 1 7 years ago Update generate_unaccent_rules.py to work with revised (r29+) Latin-ASCII transliteration file format 1932 Committed Bugfix Not processed Hugh Ranalli (hughr) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Python 2 and 3 compatibility for generate_unaccent_rules.py 1933 Committed Not processed Hugh Ranalli (hughr) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 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 Moved to different CF libpq 12 Not processed Ryo Matsumura (ryo) Michael Meskes (meskes) 2 7 years ago Avoid heap optimizations during COPY on foreign tables 1936 Committed Bugfix Not processed Michael Paquier (michael-kun), Amit Langote (amitlan), Luis M Carril (lmcarril) Etsuro Fujita (efujita) Michael Paquier (michael-kun) 1 7 years ago A few new options for vacuumdb 1937 Committed System Administration Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Switch to 64-bit Bitmapsets on 64-bit machines 1938 Committed Performance Not processed David Rowley (davidrowley) Tom Lane (tgl) 1 7 years ago Using POPCNT and other advanced bit manipulation instructions 1939 Moved to different CF Performance 12 Not processed David Rowley (davidrowley) Tom Lane (tgl) 2 7 years ago START/END line number for COPY FROM 1940 Rejected SQL Commands Not processed Surafel Temesgen (surafel) 1 7 years ago Reduce the footprint of ScanKeyword 1941 Committed Performance Not processed John Naylor (john.naylor) Hayato Kuroda (ha-kun) Tom Lane (tgl) 1 7 years ago Clean up some elog messages and comments for do_pg_stop_backup and do_pg_start_backup 1942 Committed Refactoring Only Not processed Michael Paquier (michael-kun) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 7 years ago pg_upgrade: Pass -j option down to vacuumdb 1943 Moved to different CF System Administration 12 Not processed Jesper Pedersen (jpedersen) Kirk Jamison (kirkjamison), Stefan Petrea (wsdookadr) 2 7 years ago Offline enabling/disabling of checksums 1944 Moved to different CF 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 Don't wake up to check trigger file if none is configured 1945 Withdrawn Not processed Jeff Janes (jjanes) Michael Paquier (michael-kun) 1 7 years ago Statement-level Triggers For Uniqueness Checks 1946 Withdrawn Performance Not processed Corey Huinker (coreyh) 1 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 Moved to different CF 13 Not processed Mi Tar (mitar) 2 7 years ago Truncate bug with tables which have temp table inherited 1949 Committed Bugfix Not processed Michael Paquier (michael-kun), Amit Langote (amitlan) Michael Paquier (michael-kun) 1 7 years ago postgres_fdw: Perform UPPERREL_ORDERED and UPPERREL_FINAL steps remotely 1950 Moved to different CF Performance 12 Not processed Etsuro Fujita (efujita) Antonin Houska (a.houska) Etsuro Fujita (efujita) 2 7 years ago Temporary materialized views 1951 Moved to different CF SQL Commands Not processed Mi Tar (mitar) Andreas Karlsson (kandreas) 2 7 years ago insensitive/non-deterministic collations 1952 Moved to different CF SQL Commands 12 Not processed Peter Eisentraut (petere) Peter Geoghegan (pgeoghegan), Daniel Vérité (danielverite) Peter Eisentraut (petere) 2 7 years ago Triggers on materialized views 1953 Withdrawn SQL Commands Not processed Mi Tar (mitar) 1 7 years ago Prepare Transaction support for ON COMMIT DROP temporary tables 1954 Returned with feedback SQL Commands Not processed Dimitri Fontaine (dim) Vik Fearing (xocolatl) 1 7 years ago recovery_target_timeline='latest' by default 1955 Committed Not processed Peter Eisentraut (petere) Michael Paquier (michael-kun), David Steele (dsteele) Peter Eisentraut (petere) 1 7 years ago Reorganize collation lookup time and place 1956 Returned with feedback Refactoring Only Not processed Peter Eisentraut (petere) 1 7 years ago Optimize constant MinMax expressions 1957 Committed Performance Not processed Vik Fearing (xocolatl) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago Removing --disable-strong-random from the code 1958 Committed Not processed Michael Paquier (michael-kun) Tom Lane (tgl) Michael Paquier (michael-kun) 1 7 years ago Use atexit() in initdb and pg_basebackup 1959 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 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 Detach postmaster from calling process group with setsid() 1962 Committed System Administration Not processed Heikki Linnakangas (heikki) Tom Lane (tgl) Heikki Linnakangas (heikki) 1 7 years ago Unified logging system for command-line programs 1963 Moved to different CF libpq Not processed Peter Eisentraut (petere) Donald Dong (ddong) Peter Eisentraut (petere) 2 7 years ago Check for ctags utility in make_ctags 1964 Committed Not processed Nikolay Shaplov (nataraj) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago SQL Inlining Behavior 1965 Returned with feedback Performance Not processed Adam Brightwell (abrightwell) Tom Lane (tgl) 1 7 years ago monitoring CREATE INDEX [CONCURRENTLY] 1966 Moved to different CF Monitoring 12 Not processed Álvaro Herrera (alvherre) Rahila Syed (rahila.syed), Pavan Deolasee (pavan) Álvaro Herrera (alvherre) 2 7 years ago