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