Commitfest 2018-07 (2018-07-01 – 2018-07-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 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 Moved to different CF 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 Moved to different CF 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 Failure at replay for corrupted 2PC files + reduce window between end-of-recovery record and history file write 922 Committed Bugfix Not processed Heikki Linnakangas (heikki), Michael Paquier (michael-kun) Alexander Korotkov (smagen), Takayuki Tsunakawa (maumau) Michael Paquier (michael-kun) 7 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 new plpgsql extra_checks 962 Committed Not processed Pavel Stehule (okbobcz) Stephen Frost (sfrost), Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 6 7 years ago Fix a bug that can prevent standby from restarting 980 Committed Bugfix Not processed Kyotaro Horiguchi (horiguti) Michael Paquier (michael-kun) Heikki Linnakangas (heikki) 6 7 years ago add GUCs to control custom plan logic 990 Committed Not processed Pavel Stehule (okbobcz) Peter Eisentraut (petere) Peter Eisentraut (petere) 6 7 years ago Convert join OR clauses into UNION queries 1001 Moved to different CF 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 Replication status in logical replication 1113 Committed Bugfix Not processed Masahiko Sawada (masahikosawada) Simon Riggs (simon), Petr Jelínek (pjmodos), vaishnavi prabakaran (vaishnavip) Michael Paquier (michael-kun) 5 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 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 Another oddity in handling of WCO constraints in postgres_fdw 1311 Committed Bugfix Not processed Etsuro Fujita (efujita) Artur Zakirov (a.zakirov) Jeff Davis (jdavis) 4 7 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 Moved to different CF Performance Not processed David Rowley (davidrowley) Antonin Houska (a.houska) 5 7 years ago Tab completion for SELECT in psql 1376 Moved to different CF 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 Moved to different CF 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 Test partition-wise join with partitioned tables containing default partition 1426 Committed Not processed rajkumar raghuwanshi (rajkumar.raghuwanshi) Ashutosh Bapat (ashutoshbapat) Jeff Davis (jdavis) 3 7 years ago logical streaming for large in-progress transactions 1429 Moved to different CF 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 Changing WAL Header to reduce contention during ReserveXLogInsertLocation() 1455 Returned with feedback Not processed Simon Riggs (simon), Pavan Deolasee (pavan) 3 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 Parallel Aggregates for string_agg and array_agg 1468 Returned with feedback Performance Not processed David Rowley (davidrowley) Tomas Vondra (fuzzycz) 2 3 years ago pg_stat_statements with plans (v02) 1470 Moved to different CF 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 Moved to different CF libpq Not processed Curt Tilmes (ctilmes) Heikki Linnakangas (heikki) 3 7 years ago pg_rewind corrupts control file global/pg_control 1482 Committed Bugfix Not processed Michael Paquier (michael-kun) Dmitry Dolgov (erthalion) Michael Paquier (michael-kun) 2 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 Handling better supported channel binding types for SSL implementations 1491 Rejected Not processed Michael Paquier (michael-kun) Daniel Gustafsson (d_gustafsson) 2 7 years ago Add missing type conversion functions for PL/Python 1499 Moved to different CF 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 Moved to different CF libpq Not processed Daniel Vérité (danielverite) Fabien Coelho (calvin), Lætitia AVROT (arkhena) 3 7 years ago Freeing a character string returned by pgtypes library functions crashes on Windows 1502 Committed Bugfix Not processed Takayuki Tsunakawa (maumau) Kyotaro Horiguchi (horiguti), Thomas Munro (macdice) Thomas Munro (macdice) 2 7 years ago Reset temp schema on connection to prevent XID wraparound 1505 Moved to different CF 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 Moved to different CF Performance Not processed Michail Nikolaev (nkey) Heikki Linnakangas (heikki), Andrey Borodin (x4m) 3 7 years ago Cascaded standby cannot start after a shutdown 1516 Committed Bugfix Not processed Michael Paquier (michael-kun), Takayuki Tsunakawa (maumau) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 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 reorganize partitioning code 1520 Committed Refactoring Only Not processed Amit Langote (amitlan) Álvaro Herrera (alvherre) 2 8 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 Moved to different CF libpq Not processed Fabien Coelho (calvin) 3 5 years ago Speed up WAL file removal during recovery 1530 Moved to different CF 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 Remove DSM_IMPL_NONE 1572 Committed Not processed Kyotaro Horiguchi (horiguti) Peter Eisentraut (petere) 2 7 years 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 Moved to different CF 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 fix constraint exclusion failure for certain partition key types 1591 Committed Bugfix Not processed Amit Langote (amitlan) Álvaro Herrera (alvherre) 2 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 Make parallel CREATE INDEX worker pg_stat_activity entries display query string 1599 Committed Bugfix Not processed Peter Geoghegan (pgeoghegan) Robert Haas (rhaas) 1 8 years ago [WIP] Document update for Logical Replication security 1600 Committed Docs Only Not processed Noriyoshi Shinoda (shinoda) Peter Eisentraut (petere) 1 8 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 Fix corruption of backend REINDEX processing state (Parallel CREATE INDEX) 1603 Committed Bugfix Not processed Peter Geoghegan (pgeoghegan) Robert Haas (rhaas) 1 8 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 PostgreSQL 10: Segmentation fault when using GROUPING SETS with all unsortable columns 1606 Committed Bugfix Not processed Minh Huong Dang (bocap) Andrew Gierth (rhodiumtoad) Andrew Gierth (rhodiumtoad) 1 8 years ago Align error details, hints and contexts with style guide 1607 Committed Refactoring Only Not processed Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) 1 8 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 Simplify final sync in pg_rewind's target folder and add --no-sync 1609 Committed Not processed Michael Paquier (michael-kun) Heikki Linnakangas (heikki) Michael Paquier (michael-kun) 1 7 years ago fix pgbench doc 1610 Committed Docs Only Not processed Fabien Coelho (calvin) Edmund Horner (ejrh) Peter Eisentraut (petere) 1 8 years ago Fix COPY FROM handling of constraints on partitions 1611 Committed Bugfix Not processed Etsuro Fujita (efujita) Amit Langote (amitlan), Ashutosh Bapat (ashutoshbapat) Robert Haas (rhaas) 1 7 years ago Install errcodes.txt for the benefit of extension PLs 1612 Committed Not processed Thomas Munro (macdice) Andrew Gierth (rhodiumtoad) 1 8 years ago Fsync queue forgets requests on failure 1613 Rejected Bugfix Not processed Thomas Munro (macdice) 1 7 years ago power() function does not work correctly with NaN arguments in Windows environments. 1614 Committed Bugfix Not processed Minh Huong Dang (bocap) David Rowley (davidrowley) Tom Lane (tgl) 1 7 years 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 Speedup of relation deletes during recovery 1616 Committed Performance Not processed Fujii Masao (masaofujii) Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti), Thomas Munro (macdice), Takayuki Tsunakawa (maumau) Fujii Masao (masaofujii) 1 7 years ago Make PostmasterIsAlive() go faster with signals 1617 Committed Performance Not processed Thomas Munro (macdice) Heikki Linnakangas (heikki) Thomas Munro (macdice) 1 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 Moved to different CF 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 Moved to different CF System Administration Not processed Kyotaro Horiguchi (horiguti) Alexander Kuzmenkov (akuzmenkov) Alexander Korotkov (smagen) 2 7 years ago Allow auto_explain to log to NOTICE 1623 Committed Not processed Tom Dunstan (tomdcc) Daniel Gustafsson (d_gustafsson) Andrew Dunstan (adunstan) 1 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 Fix compiler warnings with --enable-dtrace 1627 Committed Refactoring Only Not processed Thomas Munro (macdice) Tom Lane (tgl) 1 7 years ago Use /etc/localtime to identify system timezone when possible 1628 Moved to different CF 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 Moved to different CF SQL Commands Not processed Simon Muller (samuller) Cynthia Shang (cshang) Andrew Dunstan (adunstan) 2 4 years ago Temporary WAL segments files not cleaned up after an instance crash 1630 Committed Bugfix Not processed Michael Paquier (michael-kun) Yugo Nagata (yugo.nagata) Michael Paquier (michael-kun) 1 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 MAP syntax for arrays 1632 Rejected SQL Commands Not processed Ildar Musin (i.musin) 1 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 postgres_fdw: Oddity in pushing down inherited UPDATE/DELETE joins to remote servers 1634 Committed Bugfix Not processed Etsuro Fujita (efujita) Amit Langote (amitlan) Robert Haas (rhaas) 1 7 years ago libpq compression 1635 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) Jeyson Linares (jeysonl) 5 4 years ago Use access() to check file existence in GetNewRelFileNode(). 1636 Committed Refactoring Only Not processed Paul Guo (paulguo) Michael Paquier (michael-kun) 1 7 years ago pg_ugprade test failure on data set with column with default value with type bit/varbit 1637 Moved to different CF Bugfix Not processed Paul Guo (paulguo) Davy Machado (davy.machado), John Naylor (john.naylor) Tom Lane (tgl) 2 7 years ago log_min_messages shows debug instead of debug2 1638 Committed System Administration Not processed Takeshi Ideriha (ideriha) Andrew Dunstan (adunstan) 1 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 Moved to different CF 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 Moved to different CF Bugfix Not processed Tom Lane (tgl) Michael Paquier (michael-kun) Tom Lane (tgl) 2 7 years ago Fix some error handling for read() and errno 1642 Committed Bugfix Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Test for trigger accessing a system column 1643 Committed Not processed Ashutosh Bapat (ashutoshbapat) Heikki Linnakangas (heikki) 1 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 Moved to different CF libpq Not processed Marina Polyakova (whipping.top1991) Fabien Coelho (calvin), Kevin Grittner (kgrittn) 2 4 years ago Subplan result cache 1646 Moved to different CF 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 Fix slot's xmin advancement and subxact's lost snapshots in decoding 1650 Committed Bugfix Not processed Arseny Sher (sher-ars) Antonin Houska (a.houska) Álvaro Herrera (alvherre) 1 7 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 Bitmapset optimization in postgres_fdw 1652 Committed Performance Not processed Daniel Gustafsson (d_gustafsson) Nathan Bossart (bossartn) Michael Paquier (michael-kun) 1 7 years ago Order windows to avoid Sort node between WindowAgg where sort result can be reused 1653 Moved to different CF Performance Not processed Daniel Gustafsson (d_gustafsson) Masahiko Sawada (masahikosawada), Alexander Kuzmenkov (akuzmenkov) Andrew Gierth (rhodiumtoad) 2 7 years ago Provide toast tables for all system tables except those that the toast mechanism itself depends on (pg_class, pg_attribute, and pg_index) 1654 Committed Not processed Joe Conway (jconway) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 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 Desirability of psql \if expressions? 1656 Rejected libpq Not processed Fabien Coelho (calvin) Pavel Stehule (okbobcz) 1 7 years ago Make deparsing of column defaults faster 1657 Moved to different CF Performance Not processed Jeff Janes (jjanes) Peter Eisentraut (petere) 2 7 years ago Improve recovery performance of dropping database having many tablespaces 1658 Moved to different CF Performance Not processed Fujii Masao (masaofujii) Michael Paquier (michael-kun) 2 6 years ago Locking B-tree leafs immediately in exclusive mode 1659 Committed Performance Not processed Alexander Korotkov (smagen) Yoshikazu Imai (yimai) Alexander Korotkov (smagen) 1 7 years ago Concurrency bug in UPDATE of partition-key 1660 Committed Bugfix Not processed Amit Khandekar (amitdkhan) Amit Kapila (amitkapila), Dilip Kumar (dilip.kumar) Amit Kapila (amitkapila) 1 7 years ago Update psql tab completion for multiple commits 1661 Moved to different CF 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 Consider avoiding terms "partition" and "partitioned" in docs for inheritence-based partitioning 1663 Committed Docs Only Not processed Justin Pryzby (justinpryzby) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 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 --on-conflict-do-nothing option to pg_dump 1665 Committed libpq Not processed Surafel Temesgen (surafel) Takeshi Ideriha (ideriha) Thomas Munro (macdice) 1 7 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 Allow build.pl just to construct project files without running a build 1668 Rejected Not processed Andrew Dunstan (adunstan) 1 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 Moved to different CF Not processed 2 7 years ago location reporting in TAP test failures 1674 Committed Not processed Peter Eisentraut (petere) Heikki Linnakangas (heikki) Peter Eisentraut (petere) 1 7 years ago Run-time partition pruning for MergeAppend 1675 Committed Performance Not processed David Rowley (davidrowley) Heikki Linnakangas (heikki) 1 7 years ago Adding tests for inheritance trees with temporary tables 1676 Committed Not processed Michael Paquier (michael-kun) Ashutosh Bapat (ashutoshbapat) Michael Paquier (michael-kun) 1 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 Logical replication docs indicating cross platform support 1678 Committed Docs Only Not processed Haribabu Kommi (haribabu) Bruce Momjian (bmomjian) 1 7 years ago Excessive CPU usage in StandbyReleaseLocks() 1679 Committed Bugfix Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 7 years ago PANIC during crash recovery of a recently promoted standby 1680 Committed Bugfix Not processed Kyotaro Horiguchi (horiguti), Pavan Deolasee (pavan) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Suggested updates to pg_verify_checksums from review 1681 Committed System Administration Not processed Daniel Gustafsson (d_gustafsson) Magnus Hagander (mha) 1 7 years ago SLRU data page checksums 1682 Moved to different CF 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 Moved to different CF Monitoring Not processed Don Seiler (dtseiler) Gilles Darold (darold) Stephen Frost (sfrost) 2 7 years ago Push down aggregates below joins. 1685 Moved to different CF Performance Not processed Heikki Linnakangas (heikki) 2 7 years ago Multi-inserts for partitioned tables in COPY 1686 Committed Performance Not processed David Rowley (davidrowley) Melanie Plageman (melanieplageman), Karen Huddleston (khuddlefish) Peter Eisentraut (petere) 1 7 years ago Incorrect comments in commit_ts.c 1687 Committed Comments Only Not processed bret shao (bret) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 7 years ago Build frontend executables (particularly pg_test_fsync) using pgwin32_open on Windows 1688 Moved to different CF 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 Generating partitioning tuple conversion maps faster 1692 Committed Performance Not processed David Rowley (davidrowley) Alexander Kuzmenkov (akuzmenkov) Heikki Linnakangas (heikki) 1 7 years ago Log query parameters for terminated execute 1693 Rejected Monitoring Not processed Sergei Kornilov (melkij) Ibrar Ahmed (ibrar) 1 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 Issue with Logical replication workers and sub-transactions 1696 Committed Bugfix Not processed Amit Khandekar (amitdkhan) Robert Haas (rhaas) 1 7 years ago Update snowball stemmers 1697 Moved to different CF Not processed Artur Zakirov (a.zakirov) Tom Lane (tgl) Tom Lane (tgl) 2 7 years ago Nepali Snowball dictionary 1698 Moved to different CF 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 Moved to different CF Performance Not processed Jerry Jelinek (jerryj) Peter Eisentraut (petere) 2 7 years ago ssl_library parameter 1701 Committed Security Not processed Peter Eisentraut (petere) Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) 1 7 years ago libpq example doesn't work 1702 Committed Docs Only Not processed Takeshi Ideriha (ideriha) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 7 years ago Remove .backup related code from pg_standby 1703 Committed Refactoring Only Not processed Yugo Nagata (yugo.nagata) Peter Eisentraut (petere) 1 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 CREATE TABLE .. LIKE .. EXCLUDING documentation 1709 Committed Docs Only Not processed Yugo Nagata (yugo.nagata) Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) 1 7 years ago Row filtering for logical replication 1710 Moved to different CF Not processed Euler Taveira (eulerto) Hironobu Suzuki (suzuki_hironobu) 2 4 years ago