Commitfest 2018-11 (2018-11-01 – 2018-11-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 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 Moved to different CF 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 Moved to different CF Not processed Pavel Stehule (okbobcz) Kyotaro Horiguchi (horiguti) 8 7 years ago Add and report the new "session_read_only" GUC pseudo-variable. 1090 Moved to different CF Not processed Elvis Pranskevichus (elprans) Melanie Plageman (melanieplageman) 3 7 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 6 years ago Full merge join on comparison clause 1141 Rejected Performance Not processed Alexander Kuzmenkov (akuzmenkov) Jeff Davis (jdavis), Ashutosh Bapat (ashutoshbapat) 7 7 years ago Fix LWLock degradation on NUMA 1166 Returned with feedback Performance Not processed Yura Sokolov (funny_falcon) Jesper Pedersen (jpedersen), kalyan s (kalyan) 7 7 years ago Implement NULL-related checks in object address functions to prevent cache lookup errors 1204 Returned with feedback Not processed Michael Paquier (michael-kun) 7 5 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 Moved to different CF 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 Lazy hash table for snapshot's "xid in progress" 1288 Returned with feedback Performance Not processed Yura Sokolov (funny_falcon) Tomas Vondra (fuzzycz) 6 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 Pipelining/batch mode support for libpq 1317 Returned with feedback Performance Not processed Craig Ringer (ringerc), vaishnavi prabakaran (vaishnavip) Andres Freund (andresfreund), Daniel Vérité (danielverite) 6 5 years ago Add ALWAYS DEFERRED option for CONSTRAINTs and CONSTRAINT TRIGGERs 1319 Moved to different CF 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 Add SKIP LOCKED option to VACUUM and ANALYZE 1399 Committed SQL Commands Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun), Masahiko Sawada (masahikosawada) Michael Paquier (michael-kun) 5 7 years ago Flexible configuration for full-text search 1421 Moved to different CF 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 Moved to different CF SQL Commands Not processed Pavan Deolasee (pavan) 6 7 years ago Sample values for pg_stat_statements 1460 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 Moved to different CF Security Not processed Daniel Gustafsson (d_gustafsson) Heikki Linnakangas (heikki) 5 7 years ago lc_messages parameter doesn't work on Windows 1518 Returned with feedback Bugfix Not processed Aleksandr Parfenov (a.parfenov) Noah Misch (nmisch) 4 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 Moved to different CF 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 file cloning in pg_upgrade 1537 Committed Performance Not processed Peter Eisentraut (petere) Michael Paquier (michael-kun) Peter Eisentraut (petere) 4 7 years ago hash joins with bloom filters 1540 Returned with feedback Performance Not processed Tomas Vondra (fuzzycz) Thomas Munro (macdice) 4 7 years ago ICU as default collation provider 1543 Moved to different CF Not processed Marina Polyakova (whipping.top1991) Peter Geoghegan (pgeoghegan), Daniel Vérité (danielverite), Andrey Borodin (x4m) 5 7 years ago Nested ConvertRowtypeExpr optimization 1552 Committed Performance Not processed Ashutosh Bapat (ashutoshbapat) Andrew Gierth (rhodiumtoad) Andrew Gierth (rhodiumtoad) 4 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 ConvertRowtypeExpr reference errors from partition-wise join 1554 Committed Bugfix Not processed Ashutosh Bapat (ashutoshbapat) Etsuro Fujita (efujita) Etsuro Fujita (efujita) 4 8 months ago Changing the autovacuum launcher scheduling; oldest table first algorithm 1573 Moved to different CF 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 Moved to different CF Performance Not processed Yura Sokolov (funny_falcon) Masahiko Sawada (masahikosawada), Ashutosh Bapat (ashutoshbapat) 4 7 years ago Implement ASSERTIONs per the SQL standard. 1604 Moved to different CF Not processed Joe Wildish (joewildish) 4 7 years ago Allow granting of permission to REFRESH MATERIALIZED VIEW, CLUSTER, and REINDEX 1605 Returned with feedback SQL Commands Not processed Isaac Morland (ijmorlan) 3 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) 41 1 week 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 Easy way to handle postmaster death + related bug fixes and improvements 1618 Committed Refactoring Only Not processed Thomas Munro (macdice) Kyotaro Horiguchi (horiguti) Thomas Munro (macdice) 3 7 years ago de-deduplicate code in DML execution hooks in postgres_fdw 1619 Moved to different CF Refactoring Only Not processed Ashutosh Bapat (ashutoshbapat) Etsuro Fujita (efujita) Etsuro Fujita (efujita) 4 7 years ago generalized expression syntax for partition bounds 1620 Moved to different CF 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 Moved to different CF Not processed Aleksandr Parfenov (a.parfenov) Dmitry Ivanov (funbringer) 4 7 years ago Accounting of zero-filled buffers in EXPLAIN (BUFFERS) 1625 Committed Bugfix Not processed Thomas Munro (macdice) Haribabu Kommi (haribabu) Thomas Munro (macdice) 3 7 years ago Replace conversion_create.sql with normal data entries 1626 Moved to different CF 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 Moved to different CF libpq Not processed Ildar Musin (i.musin) Surafel Temesgen (surafel) 4 7 years ago Make description of heap records more talkative for flags 1633 Committed libpq Not processed Michael Paquier (michael-kun) Nathan Bossart (bossartn) Michael Paquier (michael-kun) 3 7 years ago libpq compression 1635 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) Jeyson Linares (jeysonl) 5 4 years ago PANIC on fsync failure 1639 Committed Bugfix Not processed Craig Ringer (ringerc) Thomas Munro (macdice) Thomas Munro (macdice) 3 7 years ago Add --include-table-data-where option to pg_dump, to export only a subset of table data 1644 Moved to different CF 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 Moved to different CF 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 Check constraint documentation about cross table constraint 1655 Committed Docs Only Not processed Lætitia AVROT (arkhena), Patrick Francelle (pfrancelle) Fabien Coelho (calvin), Vik Fearing (xocolatl) Álvaro Herrera (alvherre) 3 7 years ago Global snapshots 1662 Moved to different CF 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 Moved to different CF Performance Not processed Masahiko Sawada (masahikosawada) 4 7 years ago cursors with prepared statements 1667 Returned with feedback SQL Commands Not processed Peter Eisentraut (petere) Heikki Linnakangas (heikki) 3 7 years ago Add function to release an allocated SQLDA 1669 Returned with feedback libpq Not processed sho kato (kato-sho) Gerdan Santos (gerdan) 3 7 years ago Support optional message in backend cancellation/termination 1670 Moved to different CF System Administration Not processed Daniel Gustafsson (d_gustafsson) Pavel Stehule (okbobcz) 4 7 years ago Default values in partition tables don't work as expected and allow NOT NULL violation 1671 Committed Bugfix Not processed Amit Langote (amitlan) Ashutosh Bapat (ashutoshbapat) Álvaro Herrera (alvherre) 3 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 Moved to different CF 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 Reduce partition tuple routing overheads 1690 Committed Performance Not processed David Rowley (davidrowley) Amit Langote (amitlan), Jesper Pedersen (jpedersen) Álvaro Herrera (alvherre) 3 7 years ago Sample rate logging 1691 Committed Monitoring Not processed Adrien Nayrat (anayrat) Vik Fearing (xocolatl) Álvaro Herrera (alvherre) 3 7 years ago Partition tree inspection functions 1694 Committed Not processed Amit Langote (amitlan) Michael Paquier (michael-kun), Jesper Pedersen (jpedersen) Michael Paquier (michael-kun) 3 7 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 Moved to different CF 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 Moved to different CF Performance Not processed Fedor Sigaev (sigaev) 4 7 years ago pg_stat_statements_reset() update to reset specific statement statistics 1707 Moved to different CF 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 Proposal for changes to recovery.conf API 1711 Committed Not processed Simon Riggs (simon), Sergei Kornilov (melkij) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 7 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 pread() and pwrite() 1722 Committed Refactoring Only Not processed Oskari Saarenmaa (os), Thomas Munro (macdice) Thomas Munro (macdice), Jesper Pedersen (jpedersen) Thomas Munro (macdice) 2 7 years ago Allow to rename index in concurrent mode 1726 Committed SQL Commands Not processed Peter Eisentraut (petere), Andrew Klychkov (andreiklychkov) Andrew Klychkov (andreiklychkov) Peter Eisentraut (petere) 2 7 years ago Allow to warn or error on ... = NULL expressions 1728 Returned with feedback Not processed David Fetter (dfetter) Fabien Coelho (calvin) 2 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 Moved to different CF 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 pgbench - set non zero exit code on all errors 1751 Committed libpq Not processed Peter Eisentraut (petere) Fabien Coelho (calvin) Peter Eisentraut (petere) 2 7 years ago pgbench - doCustom cleanup 1754 Committed Refactoring Only Not processed Fabien Coelho (calvin) Kirk Jamison (kirkjamison) Álvaro Herrera (alvherre) 2 7 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 unused/redundant foreign key code 1757 Committed Refactoring Only Not processed Peter Eisentraut (petere) Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) 2 7 years ago Revise executor's handling of range table relations 1758 Committed Performance Not processed Amit Langote (amitlan) David Rowley (davidrowley), Jesper Pedersen (jpedersen) Tom Lane (tgl) 2 7 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 snprintf.c performance improvements 1763 Committed Performance Not processed Tom Lane (tgl) Tom Lane (tgl) 2 7 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 Moved to different CF 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 Calculate total_table_pages after set_base_rel_sizes() 1768 Committed Bugfix Not processed David Rowley (davidrowley) Edmund Horner (ejrh) Tom Lane (tgl) 2 7 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 Improve the accuracy of floating point statistical aggregates 1775 Committed Not processed Dean Rasheed (deanr) Madeleine Thompson (madeleine) Dean Rasheed (deanr) 2 7 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 Refactor textToQualifiedNameList() 1781 Rejected Refactoring Only Not processed Yugo Nagata (yugo.nagata) 2 7 years ago Allow has_table_previlege to return false when user has no previlege on namespace 1783 Moved to different CF 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 Moved to different CF Refactoring Only Not processed Michael Paquier (michael-kun) Nikolay Shaplov (nataraj) Michael Paquier (michael-kun) 2 7 years ago A fix for signal-handling and dynamic shared memory resizing on linux that can cause endless loop 1790 Committed Bugfix Not processed Chris Travers (einhverfr) Thomas Munro (macdice) 1 7 years ago Small performance tweak to run-time partition pruning 1791 Committed Performance Not processed David Rowley (davidrowley) Yoshikazu Imai (yimai) Tom Lane (tgl) 1 7 years ago In one case, XLogReadRecord returns a pointer to the shared memory buffer 1792 Committed Bugfix Not processed Andrei Lepikhov (lepikhov) Kyotaro Horiguchi (horiguti) Michael Paquier (michael-kun) 1 7 years ago pg_ls_tmpdir() 1793 Committed Monitoring Not processed Nathan Bossart (bossartn) Laurenz Albe (laurenz) Michael Paquier (michael-kun) 1 7 years ago Fix segment_bins corruption in in dsa.c 1794 Committed Bugfix Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 7 years ago Change wal_sender from PGC_SIGHUP to PGC_BACKEND 1795 Committed Not processed Takayuki Tsunakawa (maumau) Michael Paquier (michael-kun) 1 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 Function to promote standby servers 1797 Committed Not processed Laurenz Albe (laurenz) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Variadic macros for tab-complete.c 1798 Committed Refactoring Only Not processed Andres Freund (andresfreund), Thomas Munro (macdice) Tom Lane (tgl) 1 7 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 [patch]overallocate memory for curly braces in array_out 1801 Committed Bugfix Not processed Keiichi Hirobe (keiichihirobe) Tom Lane (tgl) 1 7 years ago Retail IndexTuple Deletion 1802 Moved to different CF 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 Improve semijoin selectivity estimates by clamping them to not more than innerjoin equivalent 1805 Committed Bugfix Not processed Tom Lane (tgl) Melanie Plageman (melanieplageman) Tom Lane (tgl) 1 7 years ago Remove dsm_resize() 1806 Committed Refactoring Only Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 7 years ago Implement predicate propagation for non-equivalence clauses. 1807 Moved to different CF Not processed Richard Guo (richardguo) Alexander Kuzmenkov (akuzmenkov) 2 7 years ago kqueue 1808 Returned with feedback Performance Not processed Thomas Munro (macdice) 1 7 years ago 64-bit hash function for hstore and citext data type 1809 Committed Not processed Amul Sul (sulamul) Hironobu Suzuki (suzuki_hironobu) Tom Lane (tgl) 1 7 years ago Clean .ready and .done files for missing WAL segments at recovery 1810 Moved to different CF Bugfix Not processed Michael Paquier (michael-kun) Nathan Bossart (bossartn), Ibrar Ahmed (ibrar) Michael Paquier (michael-kun) 2 7 years ago Fix incorrect hi_options in COPY to partitioned table 1811 Committed Bugfix Not processed David Rowley (davidrowley) Steve Singer (ssinger), tingting hui (timz) Álvaro Herrera (alvherre) 1 7 years ago Some incorrect comments and out-dated README from run-time pruning 1812 Committed Comments Only Not processed David Rowley (davidrowley) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Function for listing archive_status directory: pg_ls_archive_status() 1813 Committed Monitoring Not processed Christoph Moench-Tegeder (chrmoenchtegeder) Aya Iwata (iwata.aya) Michael Paquier (michael-kun) 1 7 years ago Sync ECPG scanner with core 1814 Committed Refactoring Only Not processed John Naylor (john.naylor) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago settings to control SSL/TLS protocol version 1815 Committed Security Not processed Peter Eisentraut (petere) Steve Singer (ssinger) Peter Eisentraut (petere) 1 7 years ago Relax transactional restrictions on ALTER ENUM ... ADD TYPE (redux) 1816 Committed Not processed Tom Lane (tgl), Andrew Dunstan (adunstan), Thomas Munro (macdice) Thomas Munro (macdice) 1 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 TAP tests for pg_verify_checksums 1818 Committed Not processed Magnus Hagander (mha), Michael Paquier (michael-kun), Michael Banck (mbanck) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 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 Moved to different CF 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 Moved to different CF System Administration Not processed Daniel Gustafsson (d_gustafsson) Hironobu Suzuki (suzuki_hironobu) Tom Lane (tgl) 2 7 years ago Restore CurrentUserId only if 'prevUser' is valid when abort transaction 1823 Committed Bugfix Not processed Michael Paquier (michael-kun), Richard Guo (richardguo) Tom Lane (tgl) Michael Paquier (michael-kun) 1 7 years ago COPY FROM WHEN condition 1824 Moved to different CF SQL Commands Not processed Surafel Temesgen (surafel) Tomas Vondra (fuzzycz), MyungKyu Lim (lmk) Tomas Vondra (fuzzycz) 2 7 years ago Small run-time pruning doc fix 1825 Committed Docs Only Not processed David Rowley (davidrowley) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Change simple_heap_insert() to a macro 1826 Rejected Refactoring Only Not processed Andrew Klychkov (andreiklychkov) 1 7 years ago Make the planner treat empty jointrees as selecting from a new dummy RTE type 1827 Moved to different CF 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 heap_insert() and heap_update() optimization 1830 Rejected Performance Not processed Andrew Klychkov (andreiklychkov) 1 7 years ago Pull up sublink of type 'NOT NOT (expr)' 1831 Rejected Not processed Richard Guo (richardguo) Tom Lane (tgl) 1 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 Moved to different CF 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 Moved to different CF Performance Not processed Heikki Linnakangas (heikki) John Naylor (john.naylor) Heikki Linnakangas (heikki) 2 7 years ago Bug with AFTER trigger and heap_expand_tuple 1835 Committed Bugfix Not processed Amit Langote (amitlan) Andrew Dunstan (adunstan) 1 7 years ago Add CheckTableNotInUse guard on parent table for create table partition of / inherits 1836 Committed Bugfix Not processed Amit Langote (amitlan) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Tab complete EXECUTE FUNCTION for CREATE (EVENT) TRIGGER 1837 Committed libpq Not processed Dagfinn Ilmari Mannsåker (ilmari) Tom Lane (tgl) Michael Paquier (michael-kun) 1 7 years ago SIGPIPE handling in COPY TO/FROM PROGRAM 1838 Committed Bugfix Not processed Tom Lane (tgl) Etsuro Fujita (efujita) Tom Lane (tgl) 1 7 years ago notice processors for isolationtester 1839 Committed libpq Not processed Álvaro Herrera (alvherre) Haribabu Kommi (haribabu) Álvaro Herrera (alvherre) 1 7 years ago A small tweak to some comments for PartitionKeyData 1840 Committed Comments Only Not processed David Rowley (davidrowley) Peter Eisentraut (petere) 1 7 years ago Add entry creation timestamp column to pg_stat_replication 1841 Moved to different CF 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 timeout parameters in libpq 1843 Returned with feedback Monitoring Not processed Ryohei Nagaura (nyannyan) Fabien Coelho (calvin) 1 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_waldump output on CREATE DATABASE 1845 Committed Not processed Jean-Christophe Arnu (jc.arnu) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Fix psql \conninfo & \connect when both host & hostaddr are used 1846 Committed Bugfix Not processed Fabien Coelho (calvin) Pavel Stehule (okbobcz), Artur Zakirov (a.zakirov) Álvaro Herrera (alvherre) 1 7 years ago Change pg_attribute textual link to an actual link 1847 Committed Docs Only Not processed Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) Michael Paquier (michael-kun) 1 7 years ago Conflicting option checking in pg_restore 1848 Committed libpq Not processed Daniel Gustafsson (d_gustafsson) Michael Paquier (michael-kun), Fabien Coelho (calvin) Michael Paquier (michael-kun) 1 7 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 date_trunc() in a specific time zone 1851 Committed Not processed Vik Fearing (xocolatl) Tom Lane (tgl) Tom Lane (tgl) 1 7 years ago logical decoding Segmentation fault (predicate index causing crash) 1852 Moved to different CF 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 Moved to different CF 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 Moved to different CF Monitoring Not processed Daniel Gustafsson (d_gustafsson) 2 7 years ago Document PostgreSQL Limitations 1856 Committed Docs Only Not processed David Rowley (davidrowley) John Naylor (john.naylor) Peter Eisentraut (petere) 1 7 years ago Installation instructions update (pg_ctl) 1857 Moved to different CF Docs Only Not processed Andreas 'ads' Scherbaum (ads) Michael Banck (mbanck), Ryan Lambert (ryanlambert) Michael Paquier (michael-kun) 2 7 years ago Fix cancellation of significant digits on ECPG 1858 Committed Bugfix Not processed daisuke higuchi (daisukehiguchi) Tom Lane (tgl) Tom Lane (tgl) 1 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 csv output format for psql 1861 Committed libpq Not processed Daniel Vérité (danielverite) Fabien Coelho (calvin), David Fetter (dfetter) Tom Lane (tgl) 1 7 years ago Row filtering for logical replication 1862 Moved to different CF 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 Factor out PartitionBoundInfo creation code 1864 Committed Refactoring Only Not processed Amit Langote (amitlan) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Getting ERROR: could not open file with partition table and ON COMMIT 1865 Committed Bugfix Not processed Amit Langote (amitlan) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Avoid duplicate XIDs at recovery when building initial snapshot - take 2 1866 Moved to different CF 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