Commitfest 2019-03 (2019-03-01 – 2019-03-31)
Fix the optimization to skip WAL-logging on table created in same transaction
528
Moved to different CF
Bugfix
13
Not processed
Heikki Linnakangas (heikki), Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti)
Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti), Noah Misch (nmisch), satyanarayana Narlapuram (snarlap), Sameer Arora (sameera), Hüseyin Demir (huseyin.demir)
Noah Misch (nmisch)
19
6 years ago
Respect client-initiated CopyDone during logical streaming replication
621
Moved to different CF
Not processed
Dave Cramer (dcramer), Vladimir Gordiychuk (gordiychuk)
Craig Ringer (ringerc)
6
6 years ago
Protect syscache from bloating with negative cache entries
931
Moved to different CF
Performance
Not processed
Kyotaro Horiguchi (horiguti)
Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha)
23
5 years ago
Logical decoding of two-phase transactions
944
Moved to different CF
13
Not processed
Nikhil Sontakke (nikkhils)
Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos)
13
4 years ago
SERIALIZABLE with parallel query
1004
Committed
Performance
12
Not processed
Thomas Munro (macdice)
Masahiko Sawada (masahikosawada), Haribabu Kommi (haribabu), Kevin Grittner (kgrittn)
Thomas Munro (macdice)
10
7 years ago
Generic type subscripting
1062
Moved to different CF
14
Not processed
Dmitry Dolgov (erthalion)
Tom Lane (tgl), Pavel Stehule (okbobcz), Artur Zakirov (a.zakirov)
Alexander Korotkov (smagen)
19
5 years ago
multivariate MCV lists and histograms
1238
Committed
12
Not processed
Tomas Vondra (fuzzycz)
David Rowley (davidrowley), Dean Rasheed (deanr)
Tomas Vondra (fuzzycz)
9
6 years ago
Push aggregation down to base relations and joins
1247
Moved to different CF
Not processed
Antonin Houska (a.houska)
Tom Lane (tgl), Ashutosh Bapat (ashutoshbapat), Richard Guo (richardguo), Andy Fan (andyf)
19
5 years ago
Restricting maximum keep segments by repslots
1260
Moved to different CF
13
Not processed
Kyotaro Horiguchi (horiguti)
Masahiko Sawada (masahikosawada), Greg Stark (stark), Jehan-Guillaume de Rorthais (ioguix)
12
6 years ago
Pluggable storage API
1283
Committed
12
Not processed
Álvaro Herrera (alvherre), Andres Freund (andresfreund), Alexander Korotkov (smagen), Haribabu Kommi (haribabu)
Alexander Korotkov (smagen)
Andres Freund (andresfreund)
9
7 years ago
Custom compression methods
1294
Moved to different CF
Not processed
Ildus Kurbangaliev (ildus)
10
5 years ago
pgbench - another attempt at tap test for time-related options
1306
Moved to different CF
libpq
Not processed
Fabien Coelho (calvin)
14
5 years ago
BRIN bloom and multi-minmax indexes
1348
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
11
5 years ago
Removing [Merge]Append nodes which contain a single subpath
1353
Committed
Performance
Not processed
David Rowley (davidrowley)
Álvaro Herrera (alvherre), Tomas Vondra (fuzzycz)
Tom Lane (tgl)
8
7 years ago
verify ALTER TABLE SET NOT NULL by valid constraints
1389
Committed
Performance
Not processed
Sergei Kornilov (melkij)
David Rowley (davidrowley), Vitaly Burovoy (vitaly.burovoy), Ildar Musin (i.musin)
Robert Haas (rhaas)
7
7 years ago
generated columns
1443
Committed
SQL Commands
Not processed
Peter Eisentraut (petere)
Michael Paquier (michael-kun), Pavel Stehule (okbobcz)
Peter Eisentraut (petere)
5
6 years ago
SQL/JSON: jsonpath
1471
Committed
12
Not processed
Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg)
Tomas Vondra (fuzzycz)
Alexander Korotkov (smagen)
6
7 years ago
SQL/JSON: functions
1472
Moved to different CF
SQL Commands
Not processed
Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg)
Pavel Stehule (okbobcz), Andrew Dunstan (adunstan), Gerdan Santos (gerdan), Andrew Alsup (ahalsup)
13
4 years ago
SQL/JSON: JSON_TABLE
1473
Moved to different CF
SQL Commands
Not processed
Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg)
Pavel Stehule (okbobcz), Andrew Dunstan (adunstan)
12
4 years ago
Add enum relation option type
1489
Moved to different CF
13
Not processed
Nikolay Shaplov (nataraj)
Álvaro Herrera (alvherre)
8
6 years ago
pg_hba.conf : new auth option : clientcert=verify-full
1522
Committed
Security
Not processed
Julian Markwort (markwort)
Magnus Hagander (mha), Thomas Munro (macdice)
Magnus Hagander (mha)
6
7 years ago
postgres.exe doesn't output crash dump when it crashes before main()
1525
Moved to different CF
Bugfix
Not processed
Takayuki Tsunakawa (maumau)
Haribabu Kommi (haribabu)
9
6 years ago
get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead
1536
Moved to different CF
Refactoring Only
Not processed
Nikolay Shaplov (nataraj)
John Dent (denty)
8
6 years ago
Advanced partition matching for partition-wise join
1553
Moved to different CF
13
Not processed
Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat)
Etsuro Fujita (efujita), Amul Sul (sulamul), Ashutosh Bapat (ashutoshbapat), Mark Dilger (mark.dilger)
Etsuro Fujita (efujita)
11
6 years ago
Transactions involving multiple postgres foreign servers
1574
Moved to different CF
Not processed
Masahiko Sawada (masahikosawada), Ashutosh Bapat (ashutoshbapat)
Takayuki Tsunakawa (maumau), Ashutosh Bapat (ashutoshbapat), Chris Travers (einhverfr), Muhammad Usama (muhammad_usama), Masahiro Ikeda (masahiro.ikeda)
18
4 years ago
Reduce amount of WAL generated by CREATE INDEX for gist, gin and sp-gist
1578
Committed
Performance
Not processed
Anastasia Lubennikova (lubennikovaav), Andrei Lepikhov (lepikhov)
Heikki Linnakangas (heikki), Alexander Kuzmenkov (akuzmenkov)
Heikki Linnakangas (heikki)
6
7 years ago
Synchronous replay mode for avoiding stale reads on hot standbys
1589
Moved to different CF
13
Not processed
Thomas Munro (macdice)
7
7 years ago
chained transactions
1594
Committed
SQL Commands
Not processed
Peter Eisentraut (petere)
Fabien Coelho (calvin)
Peter Eisentraut (petere)
6
7 years ago
GiST VACUUM
1598
Committed
Performance
12
Not processed
Constantine Kuznetsov (chapaev28), Andrey Borodin (x4m)
Heikki Linnakangas (heikki)
Heikki Linnakangas (heikki)
5
7 years ago
declarative session variables, LET command
1608
Moved to different CF
DDL
10/10
+3003−37
Pavel Stehule (okbobcz)
Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), Jim Jones (jimus), newtglobal postgresql_contributors (newtpostgrescontributors)
40
5 days ago
Covering GiST indexes
1615
Committed
12
Not processed
Andrey Borodin (x4m)
Andreas Karlsson (kandreas)
Alexander Korotkov (smagen)
5
7 years ago
libpq compression
1635
Returned with feedback
Performance
Not processed
Konstantin Knizhnik (knizhnik)
Jeyson Linares (jeysonl)
5
4 years ago
GSSAPI encryption support
1647
Committed
Security
Not processed
Robbie Harwood (rharwood)
Nicolas Williams (cryptonector)
Stephen Frost (sfrost)
5
6 years ago
Undo logs
1649
Moved to different CF
13
Not processed
Dilip Kumar (dilip.kumar), Thomas Munro (macdice)
Amit Kapila (amitkapila)
8
6 years ago
Evaluate immutable functions during planning (in FROM clause)
1664
Moved to different CF
Performance
Not processed
Alexander Kuzmenkov (akuzmenkov), Aleksandr Parfenov (a.parfenov)
Antonin Houska (a.houska), Anastasia Lubennikova (lubennikovaav), Anthony Bykov (anthonyb)
Tom Lane (tgl)
7
6 years ago
Make installcheck-world in a clean environment
1672
Moved to different CF
Not processed
Alexander Lakhin (law)
6
6 years ago
New libpq option to prefer standby for connection
1677
Moved to different CF
libpq
Not processed
Haribabu Kommi (haribabu), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234)
Laurenz Albe (laurenz), Takayuki Tsunakawa (maumau), Peter Smith (smithpb)
Tom Lane (tgl)
15
5 years ago
Psql patch to show access methods info
1689
Moved to different CF
libpq
13
Not processed
Alik Khilazhev (alikhil), Sergey Cherkashin (cherkashins)
Kyotaro Horiguchi (horiguti), Nikita Glukhov (n.glukhov), vigneshwaran C (vignesh.postgres)
Alexander Korotkov (smagen)
10
6 years ago
Global shared meta cache
1695
Moved to different CF
Performance
13
Not processed
Takeshi Ideriha (ideriha)
7
6 years ago
Copy function for logical replication slots
1705
Committed
Not processed
Masahiko Sawada (masahikosawada)
Petr Jelínek (pjmodos)
Álvaro Herrera (alvherre)
5
7 years ago
Shared-memory based stats collector
1708
Moved to different CF
Monitoring
Not processed
Kyotaro Horiguchi (horiguti)
Tomas Vondra (fuzzycz), Antonin Houska (a.houska)
17
4 years ago
Remove self join on a unique column
1712
Moved to different CF
Performance
Not processed
Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov)
Alena Rybakina (a.rybakina)
Alexander Korotkov (smagen)
27
1 year ago
Track the next xid using 64 bits
1718
Committed
Refactoring Only
12
Not processed
Thomas Munro (macdice)
Andres Freund (andresfreund)
Thomas Munro (macdice)
4
7 years ago
Show size of partitioned table
1731
Committed
libpq
Not processed
Pavel Stehule (okbobcz)
Mathias Brossard (mathias)
Álvaro Herrera (alvherre)
4
7 years ago
Online verification of checksums
1733
Returned with feedback
System Administration
Not processed
Michael Banck (mbanck)
Fabien Coelho (calvin)
4
4 years ago
Inline Common Table Expressions
1734
Committed
Performance
12
Not processed
Andreas Karlsson (kandreas), Andrew Gierth (rhodiumtoad), David Fetter (dfetter)
Tom Lane (tgl)
Tom Lane (tgl)
4
7 years ago
pgbench - add pseudo-random permutation function
1736
Moved to different CF
libpq
Not processed
Fabien Coelho (calvin), Hironobu Suzuki (suzuki_hironobu)
Muhammad Usama (muhammad_usama)
Dean Rasheed (deanr)
14
5 years ago
Index Skip Scan
1741
Moved to different CF
16
Not processed
Dmitry Dolgov (erthalion), Thomas Munro (macdice), Jesper Pedersen (jpedersen)
Peter Geoghegan (pgeoghegan), Dilip Kumar (dilip.kumar), Thomas Munro (macdice), Chris Travers (einhverfr), James Coleman (jcole1989), Cristiano Duarte (cunha17), Andy Fan (andyf), Yuming Wang (yumwang), Jet Zhang (thinkj), Alexandre Felipe (bob.tpro)
19
4 years ago
conflict handling for COPY FROM
1745
Returned with feedback
SQL Commands
Not processed
Surafel Temesgen (surafel)
Karen Huddleston (khuddlefish), Andrew McElroy (andrew.mcelroy.punchh.com)
4
6 years ago
Autoprepare: implicitly replace literals with parameters and store generalized plan
1747
Moved to different CF
Performance
Not processed
Konstantin Knizhnik (knizhnik)
Ryo Yamaji (ryamaji), Ryohei Nagaura (nyannyan)
10
5 years ago
Tid range scan
1755
Moved to different CF
Performance
13
Not processed
Edmund Horner (ejrh)
David Rowley (davidrowley), Shawn Wang (shawnwang)
David Rowley (davidrowley)
7
5 years ago
FETCH FIRST clause PERCENT option
1759
Returned with feedback
SQL Commands
Not processed
Surafel Temesgen (surafel)
Tomas Vondra (fuzzycz), Vik Fearing (xocolatl), Gerdan Santos (gerdan)
4
4 years ago
ALTER TABLE on system catalogs
1764
Committed
SQL Commands
Not processed
Peter Eisentraut (petere)
Peter Eisentraut (petere)
4
7 years ago
Strengthen PGSharedMemoryCreate checks for still-attached processes
1767
Moved to different CF
Bugfix
Not processed
Noah Misch (nmisch)
Daniel Gustafsson (d_gustafsson), Alexandra Wang (l-wang)
Noah Misch (nmisch)
5
6 years ago
libpq host/hostaddr consistency
1769
Moved to different CF
libpq
Not processed
Fabien Coelho (calvin)
Artur Zakirov (a.zakirov)
Álvaro Herrera (alvherre)
6
6 years ago
Block level parallel vacuum
1774
Moved to different CF
Performance
Not processed
Masahiko Sawada (masahikosawada)
Dilip Kumar (dilip.kumar), Sergei Kornilov (melkij)
Amit Kapila (amitkapila)
8
6 years ago
Speed up planning with partitions
1778
Committed
Performance
12
Not processed
Amit Langote (amitlan)
David Rowley (davidrowley), Dilip Kumar (dilip.kumar), Jesper Pedersen (jpedersen), Yoshikazu Imai (yimai)
Tom Lane (tgl)
4
7 years ago
CLUSTER command progress monitor
1779
Committed
Monitoring
Not processed
Tatsuro Yamada (tatsuro_yamada)
Surafel Temesgen (surafel)
Robert Haas (rhaas)
4
7 years ago
Progress reporting for pg_verify_checksums
1786
Committed
System Administration
Not processed
Bernd Helmle (psoo), Michael Banck (mbanck)
Fabien Coelho (calvin)
Michael Paquier (michael-kun)
4
7 years ago
Make nbtree keys unique by appending heap TID, suffix truncation
1787
Committed
Performance
12
Not processed
Peter Geoghegan (pgeoghegan)
Heikki Linnakangas (heikki), Andrei Lepikhov (lepikhov)
Peter Geoghegan (pgeoghegan)
4
7 years ago
documenting signal handling with readme
1796
Moved to different CF
Docs Only
Not processed
Chris Travers (einhverfr)
Tom Lane (tgl)
5
6 years ago
SERIALIZABLE on standby servers
1799
Moved to different CF
13
Not processed
Thomas Munro (macdice)
Kevin Grittner (kgrittn)
4
7 years ago
amcheck verification for GiST
1800
Moved to different CF
13
Not processed
Andrey Borodin (x4m)
Peter Geoghegan (pgeoghegan)
Peter Geoghegan (pgeoghegan)
6
6 years ago
DNS SRV support for LDAP authentication
1803
Committed
12
Not processed
Thomas Munro (macdice)
Daniel Gustafsson (d_gustafsson)
Thomas Munro (macdice)
3
7 years ago
KNN for B-tree
1804
Moved to different CF
Performance
Not processed
Nikita Glukhov (n.glukhov)
Alexander Korotkov (smagen), Anastasia Lubennikova (lubennikovaav)
Alexander Korotkov (smagen)
8
1 year ago
New vacuum option to do only freezing
1817
Committed
Performance
12
Not processed
Masahiko Sawada (masahikosawada)
Nathan Bossart (bossartn), Darafei Praliaskouski (komzpa)
Andres Freund (andresfreund)
3
7 years ago
Allow AddForeignUpdateTargets to add extra target expressions other than columns
1819
Moved to different CF
Bugfix
Not processed
Etsuro Fujita (efujita), Kyotaro Horiguchi (horiguti)
Etsuro Fujita (efujita)
6
6 years ago
Avoid creation of the free space map for small tables
1821
Committed
12
Not processed
John Naylor (john.naylor)
Amit Kapila (amitkapila)
Amit Kapila (amitkapila)
3
7 years ago
Undo worker and transaction rollback
1828
Moved to different CF
13
Not processed
Amit Kapila (amitkapila), Dilip Kumar (dilip.kumar), mithun cy (mithun.cy), Rafia Sabih (rafia.sabih)
5
7 years ago
Refactoring the checkpointer's fsync request queue
1829
Committed
Refactoring Only
Not processed
Thomas Munro (macdice), Shawn Debnath (sd)
Kevin Grittner (kgrittn), Shawn Debnath (sd)
Thomas Munro (macdice)
3
7 years ago
pg_dump multi VALUES INSERT
1832
Committed
libpq
12
Not processed
David Rowley (davidrowley), Surafel Temesgen (surafel)
Fabien Coelho (calvin), Gerdan Santos (gerdan)
Álvaro Herrera (alvherre)
3
7 years ago
ATTACH/DETACH PARTITION CONCURRENTLY
1842
Committed
SQL Commands
Not processed
Álvaro Herrera (alvherre), Robert Haas (rhaas), David Rowley (davidrowley)
Robert Haas (rhaas)
3
7 years ago
FETCH FIRST clause WITH TIES option
1844
Moved to different CF
SQL Commands
Not processed
Surafel Temesgen (surafel)
Tomas Vondra (fuzzycz), Vik Fearing (xocolatl)
Álvaro Herrera (alvherre)
8
6 years ago
pg_rewind: options to use restore_command from recovery.conf or command line
1849
Moved to different CF
13
Not processed
Alexey Kondratov (ololobus)
Andrey Borodin (x4m)
Michael Paquier (michael-kun)
8
6 years ago
Ordered Partitioned Table Scans
1850
Committed
Performance
12
Not processed
David Rowley (davidrowley)
Julien Rouhaud (rjuju), Antonin Houska (a.houska)
Tom Lane (tgl)
3
7 years ago
libpq trace log
1854
Moved to different CF
libpq
13
Not processed
Aya Iwata (iwata.aya)
Jacob Champion (jchampion), Jim Doty (doty-pivotal), Ramanarayana M (ramnar)
5
5 years ago
pg_dumpall --exclude-database option
1860
Committed
libpq
12
Not processed
Andrew Dunstan (adunstan)
Fabien Coelho (calvin)
Andrew Dunstan (adunstan)
3
7 years ago
Connection slots reserved for replication
1867
Committed
Not processed
Alexander Kukushkin (cyberdem0n)
Kyotaro Horiguchi (horiguti), Petr Jelínek (pjmodos), Masahiko Sawada (masahikosawada), Oleksii Kliukin (alexk), Surafel Temesgen (surafel)
Michael Paquier (michael-kun)
3
7 years ago
Detoast Compressed Datum Slice
1868
Committed
Performance
Not processed
Paul Ramsey (pramsey)
Andrey Borodin (x4m), Darafei Praliaskouski (komzpa), Regina Obe (reginaobe)
Stephen Frost (sfrost)
2
7 years ago
Update INSTALL file
1870
Returned with feedback
Docs Only
Not processed
Andreas 'ads' Scherbaum (ads)
Stephen Frost (sfrost)
2
7 years ago
XML fixes
1872
Committed
Bugfix
12
Not processed
Pavel Stehule (okbobcz), Chapman Flack (chap)
Ryan Lambert (ryanlambert)
Álvaro Herrera (alvherre)
2
7 years ago
Adding a TAP test checking data consistency on standby with minRecoveryPoint
1873
Committed
12
Not processed
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
2
7 years ago
support VARIADIC arg for least/greatest functions
1874
Rejected
SQL Commands
Not processed
Pavel Stehule (okbobcz)
Chapman Flack (chap)
2
7 years ago
Foreign keys referencing partitioned tables
1877
Committed
12
Not processed
Álvaro Herrera (alvherre)
Jesper Pedersen (jpedersen)
Álvaro Herrera (alvherre)
2
7 years ago
Prove IS NOT NULL inference for large arrays
1879
Committed
Performance
Not processed
James Coleman (jcole1989)
David Rowley (davidrowley), Pavel Stehule (okbobcz)
Tom Lane (tgl)
2
7 years ago
Add Hook Functions for Disk Quota Extension
1883
Moved to different CF
Not processed
Haozhou Wang (hawang), Hubert Zhang (hubertz), Hao Wu (hwu)
Raymond Martin (ramarti)
8
5 years ago
Pass COPT and PROFILE to CXXFLAGS
1886
Committed
Not processed
Christoph Berg (myon)
Tom Lane (tgl), Andres Freund (andresfreund), Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
2
7 years ago
Delay locking partitions during INSERT and UPDATE
1887
Committed
Performance
Not processed
David Rowley (davidrowley)
John Naylor (john.naylor)
Robert Haas (rhaas)
2
7 years ago
idle-in-transaction timeout error does not give a hint
1892
Withdrawn
Not processed
Tatsuo Ishii (ishii)
Takeshi Ideriha (ideriha)
2
7 years ago
create and use subscription for nonsuperuser
1893
Returned with feedback
12
Not processed
Evgeny Efimkin (efimkine)
Andrey Borodin (x4m)
2
7 years ago
online change primary_conninfo
1896
Moved to different CF
13
Not processed
Sergei Kornilov (melkij)
Fujii Masao (masaofujii)
Álvaro Herrera (alvherre)
7
6 years ago
Delay locking partitions during query execution
1897
Withdrawn
Performance
Not processed
David Rowley (davidrowley)
2
7 years ago
Add sqlstate output mode to VERBOSITY
1898
Committed
libpq
12
Not processed
didier gautheron (didier.users.sourceforge.net)
Dagfinn Ilmari Mannsåker (ilmari)
Tom Lane (tgl)
2
7 years ago
psql display of foreign keys
1899
Committed
libpq
12
Not processed
Álvaro Herrera (alvherre)
Peter Eisentraut (petere)
Álvaro Herrera (alvherre)
2
7 years ago
timeout parameters in libpq
1902
Committed
Monitoring
12
Not processed
Ryohei Nagaura (nyannyan)
Fabien Coelho (calvin), Kirk Jamison (kirkjamison)
Michael Paquier (michael-kun)
2
7 years ago
Add pg_partition_root to get top-most parent of a partition tree
1906
Committed
12
Not processed
Michael Paquier (michael-kun)
Amit Langote (amitlan)
Michael Paquier (michael-kun)
2
7 years ago
Statement-level rollback
1910
Returned with feedback
Not processed
Álvaro Herrera (alvherre), Takayuki Tsunakawa (maumau)
2
7 years ago
anycompatible and anycompatiblearray polymorphic types
1911
Moved to different CF
Not processed
Pavel Stehule (okbobcz)
Tom Lane (tgl)
Tom Lane (tgl)
7
6 years ago
Remove deprecated exclusive backup mode
1913
Moved to different CF
Not processed
David Steele (dsteele)
Magnus Hagander (mha)
9
5 years ago
Making WAL receiver startup rely on GUC context for primary_conninfo and primary_slot_name
1916
Rejected
Refactoring Only
Not processed
Michael Paquier (michael-kun)
Sergei Kornilov (melkij), Donald Dong (ddong)
2
7 years ago
Add timeline to partial WAL segments
1919
Moved to different CF
Not processed
David Steele (dsteele)
9
5 years ago
Ryu floating point output
1920
Committed
Performance
12
Not processed
Andrew Gierth (rhodiumtoad)
Donald Dong (ddong)
Andrew Gierth (rhodiumtoad)
2
7 years ago
REINDEX CONCURRENTLY
1921
Committed
SQL Commands
12
Not processed
Peter Eisentraut (petere)
Michael Paquier (michael-kun), Sergei Kornilov (melkij)
Peter Eisentraut (petere)
2
7 years ago
EXPLAIN with information about modified GUC values
1922
Committed
Not processed
Tomas Vondra (fuzzycz)
Rafia Sabih (rafia.sabih), John Naylor (john.naylor)
Tomas Vondra (fuzzycz)
2
7 years ago
Log a sample of transactions
1923
Committed
Monitoring
12
Not processed
Adrien Nayrat (anayrat)
Hayato Kuroda (ha-kun)
Álvaro Herrera (alvherre)
2
7 years ago
Remove "combining diacriticals" in unaccent rules
1924
Committed
Bugfix
Not processed
Hugh Ranalli (hughr)
Thomas Munro (macdice)
Thomas Munro (macdice)
2
7 years ago
block level PRAGMA
1925
Moved to different CF
Not processed
Pavel Stehule (okbobcz)
3
6 years ago
logical streaming for large in-progress transactions
1927
Moved to different CF
Not processed
Amit Kapila (amitkapila), Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos), Dilip Kumar (dilip.kumar)
Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres)
Amit Kapila (amitkapila)
9
5 years ago
DECLARE STATEMENT syntax support in ECPG
1928
Committed
libpq
12
Not processed
Hayato Kuroda (ha-kun)
Michael Meskes (meskes)
2
7 years ago
Log bind parameter values on error
1934
Moved to different CF
Monitoring
13
Not processed
Alexey Bashtanov (bashtanov)
Álvaro Herrera (alvherre)
6
6 years ago
A new data type 'bytea' for ECPG host variable
1935
Committed
libpq
12
Not processed
Ryo Matsumura (ryo)
Michael Meskes (meskes)
2
7 years ago
Using POPCNT and other advanced bit manipulation instructions
1939
Committed
Performance
12
Not processed
David Rowley (davidrowley)
Tom Lane (tgl)
2
7 years ago
pg_upgrade: Pass -j option down to vacuumdb
1943
Returned with feedback
System Administration
12
Not processed
Jesper Pedersen (jpedersen)
Kirk Jamison (kirkjamison), Stefan Petrea (wsdookadr)
2
7 years ago
Offline enabling/disabling of checksums
1944
Committed
System Administration
Not processed
Michael Banck (mbanck)
Michael Paquier (michael-kun), Fabien Coelho (calvin), Sergei Kornilov (melkij)
Michael Paquier (michael-kun)
2
7 years ago
Implement NULL-related checks in object address functions to prevent cache lookup errors, take two
1947
Moved to different CF
Not processed
Michael Paquier (michael-kun)
Daniel Gustafsson (d_gustafsson)
Michael Paquier (michael-kun)
8
5 years ago
Triggers on Materialized Views
1948
Returned with feedback
13
Not processed
Mi Tar (mitar)
2
7 years ago
postgres_fdw: Perform UPPERREL_ORDERED and UPPERREL_FINAL steps remotely
1950
Committed
Performance
12
Not processed
Etsuro Fujita (efujita)
Antonin Houska (a.houska)
Etsuro Fujita (efujita)
2
7 years ago
Temporary materialized views
1951
Returned with feedback
SQL Commands
Not processed
Mi Tar (mitar)
Andreas Karlsson (kandreas)
2
7 years ago
insensitive/non-deterministic collations
1952
Committed
SQL Commands
12
Not processed
Peter Eisentraut (petere)
Peter Geoghegan (pgeoghegan), Daniel Vérité (danielverite)
Peter Eisentraut (petere)
2
7 years ago
Support huge_pages on AIX
1960
Moved to different CF
System Administration
13
Not processed
Thomas Munro (macdice)
Thomas Munro (macdice)
6
6 years ago
Synchronizing slots from primary to standby
1961
Moved to different CF
13
Not processed
Petr Jelínek (pjmodos)
Shaun Thomas (bonesmoses)
4
6 years ago
Unified logging system for command-line programs
1963
Committed
libpq
Not processed
Peter Eisentraut (petere)
Donald Dong (ddong)
Peter Eisentraut (petere)
2
7 years ago
monitoring CREATE INDEX [CONCURRENTLY]
1966
Committed
Monitoring
12
Not processed
Álvaro Herrera (alvherre)
Rahila Syed (rahila.syed), Pavan Deolasee (pavan)
Álvaro Herrera (alvherre)
2
7 years ago
Prevent PREPARE TRANSACTION for transactions involving the session's temporary namespace
1967
Committed
Bugfix
Not processed
Michael Paquier (michael-kun)
Masahiko Sawada (masahikosawada)
Michael Paquier (michael-kun)
1
7 years ago
Document client_min_messages vis. INFO message severity
1968
Committed
Docs Only
Not processed
Karl Pinc (kop)
Andrew Gierth (rhodiumtoad)
1
7 years ago
Prevent extension creation in temporary schemas
1969
Returned with feedback
Bugfix
Not processed
Michael Paquier (michael-kun)
Chris Travers (einhverfr), Hayato Kuroda (ha-kun)
1
7 years ago
Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (version 9.6 or earlier).
1970
Moved to different CF
System Administration
Not processed
daisuke higuchi (daisukehiguchi), Ramanarayana M (ramnar)
Takayuki Tsunakawa (maumau)
4
6 years ago
Include all columns in default names for foreign key constraints.
1971
Committed
Not processed
Paul Martinez (pauljulius)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
7 years ago
use strtof, not strtod, for float4in
1972
Committed
Not processed
Andrew Gierth (rhodiumtoad)
Andrew Gierth (rhodiumtoad)
1
7 years ago
Simplify set of flags used by MyXactFlags
1973
Committed
Not processed
Michael Paquier (michael-kun)
Álvaro Herrera (alvarofherrera)
Michael Paquier (michael-kun)
1
7 years ago
pg_stat_statements should notice FOR UPDATE clauses
1974
Moved to different CF
Monitoring
Not processed
Andrew Gierth (rhodiumtoad), Vik Fearing (xocolatl)
Greg Stark (stark), Takayuki Tsunakawa (maumau), Sergei Kornilov (melkij)
Andrew Gierth (rhodiumtoad)
2
6 years ago
Referential Integrity Checks with Statement Level Triggers
1975
Moved to different CF
Performance
13
Not processed
Corey Huinker (coreyh)
Antonin Houska (a.houska)
2
6 years ago
\describe: verbose commands in psql
1976
Moved to different CF
libpq
13
Not processed
Corey Huinker (coreyh)
Ibrar Ahmed (ibrar)
3
6 years ago
Ltree syntax improvement
1977
Moved to different CF
Not processed
Dmitry Belyavsky (beldmit)
Nikolay Shaplov (nataraj), Nikita Glukhov (n.glukhov), Aleksandr Sorokin (mustiks)
8
5 years ago
ArchiveEntry optional arguments
1978
Committed
Refactoring Only
Not processed
Dmitry Dolgov (erthalion)
Álvaro Herrera (alvherre)
1
7 years ago
First SVG graphic
1979
Committed
Docs Only
12
Not processed
Jürgen Purtz (jpurtzwiki)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
7 years ago
Log10 and hyperbolic functions for SQL:2016 compliance
1980
Committed
SQL Commands
12
Not processed
Lætitia AVROT (arkhena)
Tom Lane (tgl)
Tom Lane (tgl)
1
7 years ago
Skip table truncation at VACUUM
1981
Committed
12
Not processed
Takayuki Tsunakawa (maumau)
Julien Rouhaud (rjuju)
Fujii Masao (masaofujii)
1
7 years ago
Fix DROP FUNCTION IF NOT EXISTS with ambiguous function
1982
Committed
Bugfix
12
Not processed
David Rowley (davidrowley)
Pavel Stehule (okbobcz), Julien Rouhaud (rjuju)
Tom Lane (tgl)
1
7 years ago
Fix inadequate executor locking of indexes
1983
Committed
Bugfix
Not processed
David Rowley (davidrowley)
Julien Rouhaud (rjuju)
Tom Lane (tgl)
1
7 years ago
Fix performance issue in foreign-key-aware join estimation
1984
Moved to different CF
Bugfix
13
Not processed
David Rowley (davidrowley)
Tom Lane (tgl)
David Rowley (davidrowley)
2
6 years ago
Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;
1985
Committed
Bugfix
Not processed
Andreas Karlsson (kandreas)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
7 years ago
add_partial_path() may remove dominated path but still in use
1986
Committed
Bugfix
Not processed
Tom Lane (tgl)
1
7 years ago
Inconsistent error handling in the openssl init code
1987
Committed
Bugfix
Not processed
Daniel Gustafsson (d_gustafsson)
Michael Paquier (michael-kun)
Peter Eisentraut (petere)
1
7 years ago
Incorrect value of snapshot_type
1988
Committed
Bugfix
Not processed
Antonin Houska (a.houska)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
7 years ago
Fix pgbench tap tests when the path contains a perl special character
1989
Committed
Bugfix
stable
Not processed
Fabien Coelho (calvin)
Raúl Marín (algunenano)
Andrew Dunstan (adunstan)
1
7 years ago
SortSupport implementation on inet/cdir
1990
Withdrawn
Performance
Not processed
1
6 years ago
SortSupport implementation on inet/cdir
1991
Moved to different CF
Performance
13
Not processed
Brandur Leach (brandur)
Edmund Horner (ejrh)
Peter Geoghegan (pgeoghegan)
2
6 years ago
Improve wording of differences between constraint exclusion and partition pruning
1992
Committed
Docs Only
Not processed
David Rowley (davidrowley)
Chapman Flack (chap)
Michael Paquier (michael-kun)
1
7 years ago
Speed up transaction completion faster after many relations are accessed in a transaction
1993
Moved to different CF
Performance
13
Not processed
Takayuki Tsunakawa (maumau)
Takayuki Tsunakawa (maumau)
David Rowley (davidrowley)
5
2 years ago
xlogreader: do not read a file block twice
1994
Committed
Bugfix
Not processed
Artur Zakirov (a.zakirov)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
7 years ago
Replica with large recovery_min_apply_delay is not receiving changes from master after restart until this delay is expired
1995
Moved to different CF
Not processed
Konstantin Knizhnik (knizhnik)
Martín Marqués (mmarques)
7
5 years ago
Empty targetlist in a plan for certain inherited updates causes user-facing errors
1996
Committed
Bugfix
stable
Not processed
Amit Langote (amitlan)
Tom Lane (tgl)
Tom Lane (tgl)
1
7 years ago
Generated as identity field in a temporary table with on commit drop corrupts system catalogs
1997
Moved to different CF
Bugfix
stable
Not processed
Michael Paquier (michael-kun)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
2
6 years ago
ECPG: could not use some CREATE TABLE AS syntax
1998
Committed
Bugfix
Not processed
daisuke higuchi (daisukehiguchi)
Michael Meskes (meskes)
1
7 years ago
Planning counters in pg_stat_statements
1999
Moved to different CF
Monitoring
Not processed
Fujii Masao (masaofujii), Julien Rouhaud (rjuju), Thomas Munro (macdice), PAscal L (pascall)
Greg Stark (stark), Yoshikazu Imai (yimai), PAscal L (pascall)
Fujii Masao (masaofujii)
6
6 years ago
Fix optimization of foreign-key on update actions
2000
Committed
SQL Commands
Not processed
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
7 years ago
A separate table level option to control compression
2001
Returned with feedback
12
Not processed
Pavan Deolasee (pavan)
Masahiko Sawada (masahikosawada), Andrew Dunstan (adunstan), Shaun Thomas (bonesmoses), Vyacheslav Lenskyy (vyacheslavl)
Michael Paquier (michael-kun)
1
7 years ago
query logging of prepared statements
2002
Moved to different CF
Monitoring
12
Not processed
Justin Pryzby (justinpryzby)
Artur Zakirov (a.zakirov)
2
7 years ago
Fix Deadlock Issue in Single User Mode When IO Failure Occurs
2003
Moved to different CF
Bugfix
stable
Not processed
Chengchao Yu (allelujava)
Amit Kapila (amitkapila), Kyotaro Horiguchi (horiguti)
5
6 years ago
Prepared transaction releasing locks before deregistering its GID
2004
Committed
Bugfix
Not processed
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
7 years ago
clear PGAPPNAME for PostgresNode postmasters
2005
Committed
System Administration
Not processed
Peter Eisentraut (petere)
Noah Misch (nmisch)
Peter Eisentraut (petere)
1
7 years ago
pg_restore supports stdout in --file
2006
Committed
libpq
12
Not processed
Euler Taveira (eulerto)
Yoshikazu Imai (yimai), José Villanova (azlev)
Álvaro Herrera (alvherre)
1
7 years ago
Shared Ispell dictionaries
2007
Returned with feedback
13
Not processed
Artur Zakirov (a.zakirov)
Ildus Kurbangaliev (ildus)
1
7 years ago
Set fallback_application_name for a walreceiver to cluster_name
2008
Committed
12
Not processed
Peter Eisentraut (petere)
Euler Taveira (eulerto)
Peter Eisentraut (petere)
1
7 years ago
COPY FREEZE, PD_VISIBLE_ALL and VM status
2009
Moved to different CF
Bugfix
Not processed
Pavan Deolasee (pavan), Ibrar Ahmed (ibrar)
Darafei Praliaskouski (komzpa), Hamid Akhtar (hamidakhtar)
Tomas Vondra (fuzzycz)
6
5 years ago
psql: add schema size information to \dn+
2010
Withdrawn
libpq
12
Not processed
Gilles Darold (darold)
Julien Rouhaud (rjuju)
1
7 years ago
Optimization of some jsonb functions
2011
Moved to different CF
Performance
13
Not processed
Nikita Glukhov (n.glukhov)
Andrew Dunstan (adunstan)
Álvaro Herrera (alvherre)
3
6 years ago
Handle properly SCRAM channel binding with client and server mismatching OpenSSL versions
2012
Committed
Bugfix
stable
Not processed
Michael Paquier (michael-kun)
Peter Eisentraut (petere)
Michael Paquier (michael-kun)
1
7 years ago
Don't count parallel worker transactions as commits or rollbacks
2013
Moved to different CF
12
Not processed
Haribabu Kommi (haribabu)
Rahila Syed (rahila.syed), Kirk Jamison (kirkjamison)
Amit Kapila (amitkapila)
2
6 years ago
Track checksum failures in pg_stat_database
2014
Committed
Monitoring
Not processed
Magnus Hagander (mha)
Julien Rouhaud (rjuju)
Magnus Hagander (mha)
1
7 years ago
Align timestamps in pg_regress output
2015
Committed
Refactoring Only
Not processed
Christoph Berg (myon)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
7 years ago
Show temp table namespace xid in pg_stat_activity
2016
Returned with feedback
Monitoring
Not processed
Magnus Hagander (mha)
1
7 years ago
add reserved OID range for development
2017
Committed
12
Not processed
John Naylor (john.naylor)
Tom Lane (tgl)
Tom Lane (tgl)
1
7 years ago
pg_basebackup to adjust existing data directory permissions
2018
Moved to different CF
Not processed
Haribabu Kommi (haribabu)
Martín Marqués (mmarques)
4
6 years ago
Convert Lists into arrays
2019
Moved to different CF
Performance
13
Not processed
Tom Lane (tgl)
David Rowley (davidrowley), Jesper Pedersen (jpedersen)
Tom Lane (tgl)
2
6 years ago
Convert NOT IN to anti-joins when possible
2020
Moved to different CF
Performance
13
Not processed
David Rowley (davidrowley)
Antonin Houska (a.houska)
4
6 years ago
Increase default vacuum_cost_limit setting
2021
Committed
System Administration
12
Not processed
David Rowley (davidrowley)
Andrew Dunstan (adunstan)
1
7 years ago
Fix leak in "CREATE...AS"
2022
Committed
Bugfix
Not processed
Jeff Janes (jjanes)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
7 years ago
NOT IN to ANTI JOIN transformation
2023
Moved to different CF
Performance
13
Not processed
James Finnerty (jimfinnerty), Zheng Li (zhengli)
6
6 years ago
move current_logfiles to log_directory or change the permissions of the file to follow data directory
2024
Committed
Bugfix
Not processed
Haribabu Kommi (haribabu)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
7 years ago
SimpleLruTruncate() mutual exclusion (data loss from lack thereof)
2025
Moved to different CF
Bugfix
stable
Not processed
Noah Misch (nmisch)
5
6 years ago
Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss)
2026
Moved to different CF
Bugfix
stable
Not processed
Noah Misch (nmisch)
Andrey Borodin (x4m)
Noah Misch (nmisch)
10
5 years ago
Document the limitations of row-level security
2027
Returned with feedback
Docs Only
12
Not processed
Pierre Ducroquet (pinaraf)
Peter Eisentraut (petere)
1
7 years ago
Flexible partition pruning hook
2028
Moved to different CF
Performance
13
Not processed
Mike Palmiotto (mpalmiotto)
3
6 years ago
Problem with default partition pruning
2029
Moved to different CF
Bugfix
stable
Not processed
Yuzuko Hosoya (yuzu)
Thibaut MADELAINE (madtibo), Ibrar Ahmed (ibrar), Shawn Wang (shawnwang)
Álvaro Herrera (alvherre)
3
6 years ago
Oddity with parallel safety test for scan/join target in grouping_planner
2030
Committed
Bugfix
Not processed
Etsuro Fujita (efujita)
Tom Lane (tgl)
Etsuro Fujita (efujita)
1
7 years ago
Improve WAL on COW filesystems
2031
Committed
Performance
12
Not processed
Jerry Jelinek (jerryj)
Álvaro Herrera (alvherre)
Thomas Munro (macdice)
1
7 years ago
readdir is incorrectly implemented at Windows
2032
Committed
Bugfix
Not processed
Konstantin Knizhnik (knizhnik)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
7 years ago
extension patch to add OR REPLACE clause to CREATE TRIGGER
2033
Withdrawn
SQL Commands
Not processed
1
9 years ago
extension patch of CREATE OR REPLACE TRIGGER
2034
Moved to different CF
SQL Commands
13
Not processed
Takamichi Osumi (tatatappp)
Surafel Temesgen (surafel), Philippe BEAUDOIN (beaud76)
3
5 years ago
pgbench state change cleanup
2035
Committed
Refactoring Only
12
Not processed
Fabien Coelho (calvin)
Kirk Jamison (kirkjamison)
Álvaro Herrera (alvherre)
1
7 years ago
pgbench - improve zipfian documentation about performance
2036
Committed
Docs Only
stable
Not processed
Fabien Coelho (calvin)
Georgios Kokolatos (gkokolatos)
Tom Lane (tgl)
1
7 years ago
pgbench - enlarge max args
2037
Committed
libpq
stable
Not processed
Simon Riggs (simon), Dagfinn Ilmari Mannsåker (ilmari)
David Rowley (davidrowley), Fabien Coelho (calvin)
Andrew Dunstan (adunstan)
1
7 years ago
Row Level Security, leakproof-ness, and performance implications
2038
Rejected
Performance
12
Not processed
Joe Conway (jconway)
1
7 years ago
Switch current_schema() to PARALLEL UNSAFE
2039
Committed
Bugfix
Not processed
Michael Paquier (michael-kun)
Daniel Gustafsson (d_gustafsson)
Michael Paquier (michael-kun)
1
7 years ago
Optimization of index_deform_tuple
2040
Committed
Performance
Not processed
Konstantin Knizhnik (knizhnik)
Tom Lane (tgl)
Tom Lane (tgl)
1
7 years ago
Don't log empty incomplete startup packet
2041
Committed
Monitoring
12
Not processed
Tom Lane (tgl)
Andrew Dunstan (adunstan)
1
7 years ago
Add exclusive backup deprecation notes to documentation
2042
Committed
Docs Only
12
Not processed
David Steele (dsteele)
Martín Marqués (mmarques)
Robert Haas (rhaas)
1
7 years ago
Bloom index cost model
2043
Moved to different CF
Performance
13
Not processed
Jeff Janes (jjanes)
Julien Rouhaud (rjuju)
4
6 years ago
propagating replica identity to partitions
2044
Moved to different CF
Bugfix
13
Not processed
Álvaro Herrera (alvherre)
3
6 years ago
[WIP] Temporal query processing with range types - Temporal Normalization
2045
Moved to different CF
SQL Commands
13
Not processed
Peter Moser (pemoser), Anton Dignös (dignoes)
Ibrar Ahmed (ibrar)
5
6 years ago
Fix memleaks and error handling in jsonb_plpython
2046
Committed
Bugfix
stable
Not processed
Nikita Glukhov (n.glukhov)
Michael Paquier (michael-kun)
Tom Lane (tgl)
1
7 years ago
Tighten error control for OpenTransientFile/CloseTransientFile
2047
Committed
12
Not processed
Michael Paquier (michael-kun)
Georgios Kokolatos (gkokolatos)
Michael Paquier (michael-kun)
1
7 years ago
SQL:2011 application time
2048
Moved to different CF
SQL Commands
Not processed
Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar)
Peter Eisentraut (petere)
12
10 months ago
CLUSTER command progress monitor
2049
Committed
Monitoring
12
Not processed
Robert Haas (rhaas)
1
7 years ago
Fix unique join costings
2050
Moved to different CF
Bugfix
stable
Not processed
David Rowley (davidrowley)
Tom Lane (tgl)
9
5 years ago