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

Fix the optimization to skip WAL-logging on table created in same transaction 528 Moved to different CF Bugfix 13 Not processed Heikki Linnakangas (heikki), Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti) Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti), Noah Misch (nmisch), satyanarayana Narlapuram (snarlap), Sameer Arora (sameera), Hüseyin Demir (huseyin.demir) Noah Misch (nmisch) 19 6 years ago 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 Correct space parsing in to_timestamp() 713 Committed Not processed Artur Zakirov (a.zakirov) Dmitry Dolgov (erthalion), Amul Sul (sulamul), Paulo Junior (paulocsd) Alexander Korotkov (smagen) 10 7 years ago Vacuum: allow usage of more than 1GB of work mem 844 Returned with feedback Performance Not processed Heikki Linnakangas (heikki), Claudio Freire (klaussfreire) Heikki Linnakangas (heikki), Masahiko Sawada (masahikosawada), Anastasia Lubennikova (lubennikovaav), Aleksander Alekseev (a.alekseev), Alexey Chernyshov (alexey-chernyshov) 9 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 Convert join OR clauses into UNION queries 1001 Returned with feedback Performance Not processed Tom Lane (tgl) Peter Geoghegan (pgeoghegan), Jim Nasby (decibel), Noah Misch (nmisch) 7 7 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 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 Improve compactify_tuples and PageRepairFragmentation 1138 Returned with feedback Performance Not processed Yura Sokolov (funny_falcon) Claudio Freire (klaussfreire) 6 7 years ago Full merge join on comparison clause 1141 Moved to different CF Performance Not processed Alexander Kuzmenkov (akuzmenkov) Jeff Davis (jdavis), Ashutosh Bapat (ashutoshbapat) 7 7 years ago Improve geometric types 1160 Committed Not processed Emre Hasegeli (hasegeli) Kyotaro Horiguchi (horiguti), Tomas Vondra (fuzzycz), Aleksander Alekseev (a.alekseev) Tomas Vondra (fuzzycz) 6 7 years ago Fix LWLock degradation on NUMA 1166 Moved to different CF 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 Moved to different CF 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 Foreign Key Arrays 1252 Returned with feedback SQL Commands Not processed Mark Rofail (markmoheb) Andreas Karlsson (kandreas), Sergey Myasoedov (smyasoedov) Álvaro Herrera (alvherre) 6 4 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 Exclude partition constaint checking in query execution plan for partitioned table queries 1264 Returned with feedback Performance Not processed Konstantin Knizhnik (knizhnik) David Rowley (davidrowley), Thomas Munro (macdice) 6 7 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 Moved to different CF 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 Better estimate for filter cost 1296 Returned with feedback Performance Not processed Yuto Hayamizu (hayamiz), Ryoji Kawamichi (kawamichi) Thomas Munro (macdice), Ashutosh Bapat (ashutoshbapat) 5 7 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 Moved to different CF 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 Remove LEFT JOINs in more cases 1364 Returned with feedback Performance Not processed David Rowley (davidrowley) Antonin Houska (a.houska) 5 7 years ago Tab completion for SELECT in psql 1376 Returned with feedback libpq Not processed Edmund Horner (ejrh) Vik Fearing (xocolatl), Johnes Castro (johnes), Ruurd Pels (ruurd) 4 7 years ago pgbench - option to build using ppoll() for larger connection counts 1388 Committed libpq Not processed doug rady (drady) Robert Haas (rhaas), Fabien Coelho (calvin) Tom Lane (tgl) 4 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 Moved to different CF 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 logical streaming for large in-progress transactions 1429 Returned with feedback Not processed Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos) Masahiko Sawada (masahikosawada), Peter Eisentraut (petere) 4 5 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 pg_stat_statements with plans (v02) 1470 Returned with feedback Monitoring Not processed Marius Timmer (mtimm_01), Julian Markwort (markwort) Artur Zakirov (a.zakirov) 3 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 Find additional connection service files in pg_service.conf.d directory 1480 Returned with feedback libpq Not processed Curt Tilmes (ctilmes) Heikki Linnakangas (heikki) 3 7 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 Add missing type conversion functions for PL/Python 1499 Returned with feedback Not processed Haozhou Wang (hawang) Heikki Linnakangas (heikki), Nikita Glukhov (n.glukhov), Anthony Bykov (anthonyb) 3 7 years ago csv output format for psql 1500 Returned with feedback libpq Not processed Daniel Vérité (danielverite) Fabien Coelho (calvin), Lætitia AVROT (arkhena) 3 7 years ago Reset temp schema on connection to prevent XID wraparound 1505 Committed Bugfix Not processed Takayuki Tsunakawa (maumau) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 7 years ago OFFSET optimisation for IndexScan using visibility map 1513 Returned with feedback Performance Not processed Michail Nikolaev (nkey) Heikki Linnakangas (heikki), Andrey Borodin (x4m) 3 7 years ago lc_messages parameter doesn't work on Windows 1518 Moved to different CF 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 pgbench - test whether a variable exists 1528 Returned with feedback libpq Not processed Fabien Coelho (calvin) 3 5 years ago Speed up WAL file removal during recovery 1530 Returned with feedback Performance Not processed Takayuki Tsunakawa (maumau) Fujii Masao (masaofujii) 3 7 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 Moved to different CF Performance Not processed Peter Eisentraut (petere) Michael Paquier (michael-kun) Peter Eisentraut (petere) 4 7 years ago hash joins with bloom filters 1540 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 kNN for SP-GiST 1587 Committed Not processed Nikita Glukhov (n.glukhov) Andrey Borodin (x4m) Alexander Korotkov (smagen) 3 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 Moved to different CF 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 Moved to different CF 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 ALTER TABLE - check for column existence before starting operations 1621 Returned with feedback SQL Commands Not processed Pierre Ducroquet (pinaraf) Artur Zakirov (a.zakirov) 2 7 years ago A way to request the rotation of server logs 1622 Committed System Administration Not processed Kyotaro Horiguchi (horiguti) Alexander Kuzmenkov (akuzmenkov) Alexander Korotkov (smagen) 2 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 Moved to different CF 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 Use /etc/localtime to identify system timezone when possible 1628 Committed Not processed Tom Lane (tgl) Michael Paquier (michael-kun) Tom Lane (tgl) 2 7 years ago Allow COPY's 'text' format to output a header 1629 Returned with feedback SQL Commands Not processed Simon Muller (samuller) Cynthia Shang (cshang) Andrew Dunstan (adunstan) 2 4 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 Moved to different CF 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 pg_ugprade test failure on data set with column with default value with type bit/varbit 1637 Committed Bugfix Not processed Paul Guo (paulguo) Davy Machado (davy.machado), John Naylor (john.naylor) Tom Lane (tgl) 2 7 years ago PANIC on fsync failure 1639 Moved to different CF Bugfix Not processed Craig Ringer (ringerc) Thomas Munro (macdice) Thomas Munro (macdice) 3 7 years ago generate bootstrap entries for array types 1640 Committed Refactoring Only Not processed John Naylor (john.naylor) Dagfinn Ilmari Mannsåker (ilmari) Tom Lane (tgl) 2 7 years ago Try to produce compiler warnings for incorrect usage of printf("%m") 1641 Committed Bugfix Not processed Tom Lane (tgl) Michael Paquier (michael-kun) Tom Lane (tgl) 2 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 WIP: Pgbench Errors and serialization/deadlock retries 1645 Returned with feedback libpq Not processed Marina Polyakova (whipping.top1991) Fabien Coelho (calvin), Kevin Grittner (kgrittn) 2 4 years ago Subplan result cache 1646 Returned with feedback Performance Not processed Heikki Linnakangas (heikki) David Rowley (davidrowley) 2 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 Order windows to avoid Sort node between WindowAgg where sort result can be reused 1653 Committed Performance Not processed Daniel Gustafsson (d_gustafsson) Masahiko Sawada (masahikosawada), Alexander Kuzmenkov (akuzmenkov) Andrew Gierth (rhodiumtoad) 2 7 years ago Check constraint documentation about cross table constraint 1655 Moved to different CF Docs Only Not processed Lætitia AVROT (arkhena), Patrick Francelle (pfrancelle) Fabien Coelho (calvin), Vik Fearing (xocolatl) Álvaro Herrera (alvherre) 3 7 years ago Make deparsing of column defaults faster 1657 Returned with feedback Performance Not processed Jeff Janes (jjanes) Peter Eisentraut (petere) 2 7 years ago Improve recovery performance of dropping database having many tablespaces 1658 Returned with feedback Performance Not processed Fujii Masao (masaofujii) Michael Paquier (michael-kun) 2 6 years ago Update psql tab completion for multiple commits 1661 Committed libpq Not processed Justin Pryzby (justinpryzby) Álvaro Herrera (alvherre), Artur Zakirov (a.zakirov), Edmund Horner (ejrh) Tom Lane (tgl) 2 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 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) Heikki Linnakangas (heikki) 3 7 years ago Add function to release an allocated SQLDA 1669 Moved to different CF 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 Moved to different CF 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 Client Connection redirection support for PostgreSQL 1673 Returned with feedback Not processed 2 7 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 SLRU data page checksums 1682 Returned with feedback Not processed 2 7 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 Add application_name to "connection authorized" log messages 1684 Committed Monitoring Not processed Don Seiler (dtseiler) Gilles Darold (darold) Stephen Frost (sfrost) 2 7 years ago Push down aggregates below joins. 1685 Returned with feedback Performance Not processed Heikki Linnakangas (heikki) 2 7 years ago Build frontend executables (particularly pg_test_fsync) using pgwin32_open on Windows 1688 Committed Bugfix Not processed Laurenz Albe (laurenz) Michael Paquier (michael-kun), Noah Misch (nmisch) Michael Paquier (michael-kun) 2 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 Moved to different CF Performance Not processed David Rowley (davidrowley) Amit Langote (amitlan), Jesper Pedersen (jpedersen) Álvaro Herrera (alvherre) 3 7 years ago Sample rate logging 1691 Moved to different CF Monitoring Not processed Adrien Nayrat (anayrat) Vik Fearing (xocolatl) Álvaro Herrera (alvherre) 3 7 years ago Partition tree inspection functions 1694 Moved to different CF 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 Update snowball stemmers 1697 Committed Not processed Artur Zakirov (a.zakirov) Tom Lane (tgl) Tom Lane (tgl) 2 7 years ago Nepali Snowball dictionary 1698 Committed Not processed Artur Zakirov (a.zakirov), Oleg Bartunov (oleg) Tom Lane (tgl) Tom Lane (tgl) 2 7 years ago option to disable WAL recycling 1700 Returned with feedback Performance Not processed Jerry Jelinek (jerryj) Peter Eisentraut (petere) 2 7 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 Row filtering for logical replication 1710 Returned with feedback Not processed Euler Taveira (eulerto) Hironobu Suzuki (suzuki_hironobu) 2 4 years ago Proposal for changes to recovery.conf API 1711 Moved to different CF 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 Fix for Bug #15259 (invalid empty array returned by intarray "&" operator) 1713 Committed Bugfix Not processed Alexey Kryuchkov (a-kr) Tom Lane (tgl) 1 7 years ago Call AcceptInvalidationMessages() after authenticating 1714 Committed Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 7 years ago setproctitle_fast() 1715 Committed Performance Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 7 years ago Allow contrib and pgxs modules to install .h files 1716 Committed Not processed Andrew Gierth (rhodiumtoad) Andrew Gierth (rhodiumtoad) 1 7 years ago Incorrect error handling for two-phase state files resulting in data loss 1717 Committed Bugfix Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years 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 Retrieve memory size allocated by libpq 1719 Committed libpq Not processed Lars Kanis (larskanis) Pavel Stehule (okbobcz) Tom Lane (tgl) 1 7 years ago Costing bug in hash join logic for unique joins 1720 Committed Bugfix Not processed David Rowley (davidrowley) Tom Lane (tgl) 1 7 years ago Allow to specify a index name as ANALYZE parameter 1721 Returned with feedback SQL Commands Not processed Yugo Nagata (yugo.nagata) John Naylor (john.naylor) 1 7 years ago pread() and pwrite() 1722 Moved to different CF Refactoring Only Not processed Oskari Saarenmaa (os), Thomas Munro (macdice) Thomas Munro (macdice), Jesper Pedersen (jpedersen) Thomas Munro (macdice) 2 7 years ago pgbench - overflow detection 1723 Committed libpq Not processed Fabien Coelho (calvin) Ibrar Ahmed (ibrar) Andres Freund (andresfreund) 1 7 years ago Add IGNORE NULLS and FROM LAST options 1724 Returned with feedback SQL Commands Not processed Oliver Ford (ojford) Krasiyan Andreev (krasiyan) Andrew Gierth (rhodiumtoad) 1 6 months ago Upper limit arguments of pg_logical_slot_xxx_changes functions accept invalid values 1725 Returned with feedback Refactoring Only Not processed Masahiko Sawada (masahikosawada) Brian Faherty (scrummyin) 1 7 years ago Allow to rename index in concurrent mode 1726 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere), Andrew Klychkov (andreiklychkov) Andrew Klychkov (andreiklychkov) Peter Eisentraut (petere) 2 7 years ago BUG #15288: Logical Replication failed when inserting record which has CHECK constraint 1727 Committed Not processed Álvaro Herrera (alvherre) 1 7 years ago Allow to warn or error on ... = NULL expressions 1728 Moved to different CF Not processed David Fetter (dfetter) Fabien Coelho (calvin) 2 7 years ago pgbench - remove duplicate hash function declarations 1729 Committed Bugfix Not processed Fabien Coelho (calvin) Robert Haas (rhaas) Robert Haas (rhaas) 1 7 years ago Fix calculations on WAL recycling 1730 Rejected Bugfix Not processed Kyotaro Horiguchi (horiguti) 1 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 VACUUM, TRUNCATE, REINDEX -- Canceling authentication due to timeout aka Denial of Service Attack 1732 Committed Bugfix Not processed Michael Paquier (michael-kun) Kyotaro Horiguchi (horiguti), Nathan Bossart (bossartn) Michael Paquier (michael-kun) 1 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 - fix #args check on hash() 1735 Committed Bugfix Not processed Fabien Coelho (calvin) Michael Paquier (michael-kun) 1 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 pg_default_acl doc fix about 'n' case 1737 Committed Docs Only Not processed Fabien Coelho (calvin) Álvaro Herrera (alvherre) 1 7 years ago Adding a note to protocol.sgml regarding CopyData 1738 Returned with feedback Docs Only Not processed Tatsuo Ishii (ishii), Bradley DeJong (bd) Fabien Coelho (calvin) 1 7 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 add RECURSIVE to bookindex 1740 Committed Docs Only Not processed Daniel Vérité (danielverite) Fabien Coelho (calvin) Álvaro Herrera (alvherre) 1 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 doc - add documentation for aclitem functions 1742 Committed Docs Only Not processed Fabien Coelho (calvin) Joe Conway (jconway) Joe Conway (jconway) 1 7 years ago pg_dumpall --exclude-database option 1743 Returned with feedback libpq Not processed Andrew Dunstan (adunstan) Fabien Coelho (calvin) 1 7 years ago pgbench - document compatibility with older server versions 1744 Rejected Docs Only Not processed Fabien Coelho (calvin) Peter Eisentraut (petere) 1 7 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 REINDEX and shared catalogs 1746 Committed Bugfix Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 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 Add regress test for pg_read_all_stats role 1748 Committed System Administration Not processed Alexandra Ryzhevich (aryzhevich) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago libpq should not look up all host addresses at once 1749 Committed libpq Not processed Tom Lane (tgl) Fabien Coelho (calvin) Tom Lane (tgl) 1 7 years ago libpq connection timeout mismanagement 1750 Committed libpq Not processed Tom Lane (tgl) Fabien Coelho (calvin) Tom Lane (tgl) 1 7 years ago pgbench - set non zero exit code on all errors 1751 Moved to different CF libpq Not processed Peter Eisentraut (petere) Fabien Coelho (calvin) Peter Eisentraut (petere) 2 7 years ago libpq should append error messages, not overwrite 1752 Returned with feedback libpq Not processed Tom Lane (tgl) Fabien Coelho (calvin) 1 7 years ago Indicate anti-wraparound autovacuum in log_autovacuum_min_duration 1753 Committed Monitoring Not processed Sergei Kornilov (melkij) Masahiko Sawada (masahikosawada) Michael Paquier (michael-kun) 1 7 years ago pgbench - doCustom cleanup 1754 Moved to different CF 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 Fix quadratic performance of regexp match/split functions 1756 Committed Performance Not processed Andrew Gierth (rhodiumtoad) Andrew Gierth (rhodiumtoad) 1 7 years ago unused/redundant foreign key code 1757 Moved to different CF 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 Moved to different CF 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 Add a semicolon to query related to search_path 1760 Committed Refactoring Only Not processed Tatsuro Yamada (tatsuro_yamada) Peter Eisentraut (petere) 1 7 years ago Proposal to add work_mem option to postgres_fdw module 1761 Committed Not processed Noriyoshi Shinoda (shinoda) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago libpq stricter integer parsing 1762 Committed libpq Not processed Fabien Coelho (calvin) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 7 years ago snprintf.c performance improvements 1763 Moved to different CF 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 Fix for REFRESH MATERIALIZED VIEW ownership error message 1766 Rejected Bugfix Not processed Jonathan Katz (jkatz05) 1 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 Moved to different CF 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 Fix help option of contrib/oid2name and contrib/vacuumlo 1770 Committed Refactoring Only Not processed Tatsuro Yamada (tatsuro_yamada) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Make executor's Range Table an array instead of a List 1771 Returned with feedback Performance Not processed David Rowley (davidrowley) 1 7 years ago Create a new session for postmaster in pg_ctl 1772 Returned with feedback Bugfix Not processed Paul Guo (paulguo-pivotal) Tom Lane (tgl), Michael Paquier (michael-kun) 1 7 years ago Hint to set owner for tablespace directory 1773 Committed Not processed Maksim Milyutin (maksm90) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 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 Moved to different CF Not processed Dean Rasheed (deanr) Madeleine Thompson (madeleine) Dean Rasheed (deanr) 2 7 years ago smarter parallel dump/restore scheduling 1776 Committed Performance Not processed Tom Lane (tgl) Peter Eisentraut (petere) Tom Lane (tgl) 1 7 years ago "could not reattach to shared memory" on buildfarm member dory (design review sought) 1777 Rejected Bugfix Not processed Noah Misch (nmisch) 1 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 simplify index tuple descriptor initialization 1780 Committed Refactoring Only Not processed Peter Eisentraut (petere) Artur Zakirov (a.zakirov) Peter Eisentraut (petere) 1 7 years ago Refactor textToQualifiedNameList() 1781 Moved to different CF Refactoring Only Not processed Yugo Nagata (yugo.nagata) 2 7 years ago Allow pg_verify_checksums to specify a database to scan 1782 Returned with feedback System Administration Not processed Yugo Nagata (yugo.nagata) Fabien Coelho (calvin) 1 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 Refactor dlopen() support 1784 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Tab completion for ALTER DATABASE … SET TABLESPACE 1785 Committed libpq Not processed Dagfinn Ilmari Mannsåker (ilmari) Artur Zakirov (a.zakirov) Tom Lane (tgl) 1 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 automatic restore point 1788 Rejected Not processed Naoki Yotsunaga (yotsunaga) 1 7 years ago