Commitfest 2021-09 (2021-09-01 – 2021-09-30)
Make async slave to wait for lsn to be replayed
772
Returned with feedback
Not processed
Ivan Kartyshov (fenimorkin)
Thomas Munro (macdice), Dmitry Ivanov (funbringer), Anna Akenteva (a.akenteva), Alexandra Pervushina (a.pervushina)
14
5 years ago
Protect syscache from bloating with negative cache entries
931
Returned with feedback
Performance
Not processed
Kyotaro Horiguchi (horiguti)
Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha)
23
5 years ago
Transactions involving multiple postgres foreign servers
1574
Returned with feedback
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
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
2 days 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
Shared-memory based stats collector
1708
Returned with feedback
Monitoring
Not processed
Kyotaro Horiguchi (horiguti)
Tomas Vondra (fuzzycz), Antonin Houska (a.houska)
17
3 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
11 months 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
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
psql - add SHOW_ALL_RESULTS option
2096
Moved to different CF
libpq
Not processed
Fabien Coelho (calvin)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
13
3 years ago
Remove page-read callback from XLogReaderState
2113
Moved to different CF
Refactoring Only
Not processed
Kyotaro Horiguchi (horiguti)
Heikki Linnakangas (heikki), Antonin Houska (a.houska), Takashi Menjo (tmenjo)
Thomas Munro (macdice)
13
4 years ago
Incremental Materialized View Maintenance
2138
Moved to different CF
SQL Commands
16
Not processed
Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai)
Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua)
17
3 years ago
standby recovery fails when re-replaying due to missing directory which was removed in previous replay.
2161
Moved to different CF
Bugfix
stable
Not processed
Kyotaro Horiguchi (horiguti), Paul Guo (paulguo)
Michael Paquier (michael-kun)
Álvaro Herrera (alvherre)
16
3 years ago
FETCH FIRST clause PERCENT option
2176
Returned with feedback
SQL Commands
Not processed
Surafel Temesgen (surafel)
12
4 years ago
pg_upgrade fails with non-standard ACL
2215
Moved to different CF
Bugfix
Not processed
Anastasia Lubennikova (lubennikovaav), Artur Zakirov (a.zakirov)
Grigory Smolkin (g.smolkin.postgrespro.ru)
Noah Misch (nmisch)
12
4 years ago
Implement INSERT SET syntax
2218
Moved to different CF
SQL Commands
Not processed
Gareth Palmer (gareth)
Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj)
15
3 years ago
A hook for path-removal decision on add_path
2234
Returned with feedback
Not processed
KaiGai Kohei (kaigai)
11
3 years ago
Fix partitionwise join with partially-redundant join clauses
2266
Moved to different CF
Not processed
Richard Guo (richardguo)
Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat)
Richard Guo (richardguo)
16
1 year ago
WITH SYSTEM VERSIONING Temporal Tables
2316
Moved to different CF
SQL Commands
Not processed
Surafel Temesgen (surafel)
Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre)
11
4 years ago
Global temporary table
2349
Moved to different CF
16
Not processed
Wenjing Zeng (wenjing.zwj)
Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw)
13
3 years ago
Split StdRdOptions into HeapOptions and ToastOptions
2370
Moved to different CF
Refactoring Only
Not processed
Nikolay Shaplov (nataraj)
10
4 years ago
UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR
2376
Returned with feedback
Not processed
John Dent (denty)
Daniel Vérité (danielverite)
9
4 years ago
Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...)
2377
Moved to different CF
System Administration
Not processed
Justin Pryzby (justinpryzby)
Fabien Coelho (calvin)
21
2 years ago
Using multicolumn statistics for more precise join selectivity estimatation
2386
Returned with feedback
Performance
Not processed
Konstantin Knizhnik (knizhnik)
Yugo Nagata (yugo.nagata)
9
4 years ago
GUC to disable cancellation of awaiting for synchronous replication
2402
Returned with feedback
Not processed
Andrey Borodin (x4m)
Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev)
9
4 years ago
Erase the distinctClause if the result is unique by definition
2433
Moved to different CF
Performance
Not processed
Andy Fan (andyf)
David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Zhijie Hou (houzj)
11
4 years ago
jsonpath syntax extensions
2482
Moved to different CF
15
Not processed
Nikita Glukhov (n.glukhov)
12
4 years ago
Make message at end-of-recovery less scary
2490
Moved to different CF
Not processed
Kyotaro Horiguchi (horiguti)
Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov)
20
2 years ago
Corruption during WAL replay
2518
Moved to different CF
Bugfix
stable
Not processed
Teja Mupparti (tejam)
Robert Haas (rhaas), Daniel Shelepanov (dshelepanov)
Robert Haas (rhaas)
10
4 years ago
archive status ".ready" files may be created too early
2520
Committed
Bugfix
stable
Not processed
Nathan Bossart (bossartn)
Álvaro Herrera (alvherre)
Álvaro Herrera (alvherre)
7
4 years ago
INSERT SELECT: BulkInsertState and table_multi_insert
2553
Moved to different CF
Performance
15
Not processed
Justin Pryzby (justinpryzby)
8
4 years ago
pg_dump - read data for some options from external file
2573
Moved to different CF
libpq
Not processed
Pavel Stehule (okbobcz)
Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v)
Daniel Gustafsson (d_gustafsson)
18
2 years ago
Fast COPY FROM command for the foreign tables
2601
Moved to different CF
Performance
Not processed
Andrei Lepikhov (lepikhov)
Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby)
Etsuro Fujita (efujita)
13
3 years ago
ALTER SYSTEM READ { ONLY | WRITE }
2602
Moved to different CF
Not processed
Amul Sul (sulamul)
9
4 years ago
DROP relation IF EXISTS Docs and Tests - Bug Fix
2603
Withdrawn
Bugfix
Not processed
David Johnston (polobo)
Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com)
7
4 years ago
Add table expansion hook
2614
Returned with feedback
Not processed
Erik Nordström (enordstr)
Euler Taveira (eulerto), Aleksander Alekseev (aalekseev)
7
4 years ago
More scalable multixacts buffers and locking
2627
Moved to different CF
Performance
Not processed
Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness)
Álvaro Herrera (alvherre)
20
1 year ago
enhancing plpgsql API for debugging and tracing
2684
Moved to different CF
Not processed
Pavel Stehule (okbobcz)
Aleksander Alekseev (aalekseev)
Tom Lane (tgl)
9
4 years ago
Fix collation handling in postgres_fdw
2685
Returned with feedback
Bugfix
Not processed
Tom Lane (tgl)
Etsuro Fujita (efujita)
6
4 years ago
Automatic HASH and LIST partition creation
2694
Moved to different CF
SQL Commands
Not processed
Anastasia Lubennikova (lubennikovaav)
Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov)
7
4 years ago
Optimizing NULL check on pkey column
2699
Returned with feedback
Performance
Not processed
Surafel Temesgen (surafel)
Ashutosh Bapat (ashutoshbapat)
6
4 years ago
Background writer and checkpointer in crash recovery
2706
Committed
Not processed
Thomas Munro (macdice)
Aleksander Alekseev (aalekseev)
Thomas Munro (macdice)
6
4 years ago
Fix behavior of geo_ops when NaN is involved
2710
Moved to different CF
Not processed
Kyotaro Horiguchi (horiguti)
Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos)
10
4 years ago
fix spinlock contention in LogwrtResult
2716
Moved to different CF
Performance
Not processed
Álvaro Herrera (alvherre)
11
1 year ago
Fix checksum verification in base backups for zero page headers
2719
Returned with feedback
Bugfix
Not processed
Michael Banck (mbanck)
Anastasia Lubennikova (lubennikovaav), David Steele (dsteele)
6
4 years ago
Add extra statistics to explain for Nested Loop
2765
Moved to different CF
Monitoring
Not processed
Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova)
Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby)
10
3 years ago
parallel distinct union and aggregate support patch
2769
Moved to different CF
Performance
Not processed
bucoo hsiao (bucoo)
6
4 years ago
libpq compression
2773
Moved to different CF
libpq
15
Not processed
Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt)
Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag)
6
4 years ago
Further note require activity aspect of automatic checkpoint and archiving
2774
Moved to different CF
Docs Only
Not processed
David Johnston (polobo)
6
4 years ago
Allow COPY "text" to output a header and add header matching mode to COPY FROM
2780
Moved to different CF
SQL Commands
Not processed
Rémi Lapeyre (remilapeyre)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
8
4 years ago
Replace polyphase merge with a simple k-way balanced merge
2781
Moved to different CF
Performance
Not processed
Heikki Linnakangas (heikki)
John Naylor (john.naylor)
Heikki Linnakangas (heikki)
6
4 years ago
CLUSTER on partitioned table
2800
Moved to different CF
SQL Commands
15
Not processed
Justin Pryzby (justinpryzby)
Matthias van de Meent (mmeent)
Álvaro Herrera (alvherre)
8
4 years ago
CREATE INDEX CONCURRENTLY on partitioned table
2815
Moved to different CF
SQL Commands
Not processed
Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov)
Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops)
15
9 months ago
Reduce the number of special cases to build contrib modules on windows
2817
Committed
Not processed
David Rowley (davidrowley)
David Rowley (davidrowley)
5
4 years ago
Functions for sorting GiST build of gist_btree types
2824
Moved to different CF
Not processed
Andrey Borodin (x4m)
Heikki Linnakangas (heikki), Emre Hasegeli (hasegeli)
Heikki Linnakangas (heikki)
7
4 years ago
Make Append Cost aware of some run time partition prune case
2829
Moved to different CF
Performance
Not processed
Andy Fan (andyf)
5
4 years ago
Extended statistics / estimate Var op Var clauses
2831
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
Dean Rasheed (deanr), Mark Dilger (mark.dilger)
9
3 years ago
ResourceOwner refactoring
2834
Returned with feedback
Refactoring Only
Not processed
Heikki Linnakangas (heikki)
Aleksander Alekseev (a.alekseev)
4
2 years ago
pg_stat_statements and "IN" conditions
2837
Moved to different CF
Monitoring
6/7
+945−23
Dmitry Dolgov (erthalion)
Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih)
Álvaro Herrera (alvherre)
22
1 year ago
brin: avoid errors processing work item following concurrent reindex
2838
Moved to different CF
Bugfix
stable
Not processed
Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby)
Gurjeet Singh (gurjeet)
5
4 years ago
possibility to rename root namespace in plpgsql
2839
Moved to different CF
Not processed
Pavel Stehule (okbobcz)
Julien Rouhaud (rjuju)
7
4 years ago
Consider parallel for LATERAL subqueries having LIMIT/OFFSET
2851
Moved to different CF
Performance
Not processed
James Coleman (jcole1989)
Greg Nancarrow (gregn1234)
11
3 years ago
Xact event callback at command start
2860
Rejected
Not processed
Gilles Darold (darold)
Julien Rouhaud (rjuju)
4
4 years ago
move pg_upgrade test.sh kludges to a SQL script
2861
Moved to different CF
Not processed
Justin Pryzby (justinpryzby)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
6
4 years ago
Function to log backtrace of postgres processes
2863
Moved to different CF
Not processed
vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy)
Christoph Berg (myon), Maciek Sakrejda (msakrejda)
17
2 years ago
Fix pg_rewind race condition just after promotion
2864
Moved to different CF
System Administration
Not processed
Heikki Linnakangas (heikki)
Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev)
Heikki Linnakangas (heikki)
12
3 years ago
create table like: ACCESS METHOD
2865
Returned with feedback
SQL Commands
15
Not processed
Justin Pryzby (justinpryzby)
Simon Riggs (simon)
4
4 years ago
Mitigate pg_rewind race condition, if config file is enlarged concurrently.
2869
Moved to different CF
System Administration
Not processed
Heikki Linnakangas (heikki)
Daniel Gustafsson (d_gustafsson), Cary Huang (cary)
Daniel Gustafsson (d_gustafsson)
7
4 years ago
New Table Access Methods for Multi and Single Inserts
2871
Moved to different CF
Not processed
Bharath Rupireddy (bharathrupireddy)
9
1 year ago
Fix firing of RI triggers during cross-partition updates of partitioned tables
2877
Moved to different CF
Bugfix
Not processed
Amit Langote (amitlan)
Masahiko Sawada (masahikosawada)
Álvaro Herrera (alvherre)
7
4 years ago
Faster pglz compression
2897
Moved to different CF
Performance
Not processed
Andrey Borodin (x4m), Владимир Лесков (tinsane)
Mark Dilger (mark.dilger)
Tomas Vondra (fuzzycz)
12
3 years ago
On client login event trigger
2900
Moved to different CF
17
Not processed
Konstantin Knizhnik (knizhnik), Greg Nancarrow (gregn1234), Mikhail Gribkov (youzhick)
Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234)
Alexander Korotkov (smagen)
15
2 years ago
SQL/JSON: functions
2901
Moved to different CF
15
Not processed
Nikita Glukhov (n.glukhov)
Andrew Dunstan (adunstan)
7
3 years ago
SQL/JSON: JSON_TABLE
2902
Moved to different CF
15
Not processed
Nikita Glukhov (n.glukhov)
Andrew Dunstan (adunstan)
7
3 years ago
Parallel Hash Full Join
2903
Moved to different CF
Performance
16
Not processed
Melanie Plageman (melanieplageman)
Thomas Munro (macdice)
Thomas Munro (macdice)
12
2 years ago
Row filtering for logical replication
2906
Moved to different CF
15
Not processed
Euler Taveira (eulerto), Peter Smith (smithpb), Ajin Cherian (ajinc), Zhijie Hou (houzj)
Dilip Kumar (dilip.kumar), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Zhijie Hou (houzj), Rahila Syed (rahila)
Amit Kapila (amitkapila)
7
4 years ago
PoC Refactor AM analyse API
2907
Returned with feedback
Refactoring Only
Not processed
Denis Smirnov (darthunix)
Heikki Linnakangas (heikki)
4
4 years ago
wal_sessioninfo
2910
Returned with feedback
Not processed
Simon Riggs (simon)
Cleysson Lima (cleyssonlima)
4
4 years ago
Dynamic result sets from procedures
2911
Moved to different CF
SQL Commands
Not processed
Peter Eisentraut (petere)
12
3 years ago
logical decoding of two-phase transactions
2914
Committed
15
Not processed
Stas Kelvich (kelvich), Nikhil Sontakke (nikkhils), Ajin Cherian (ajinc), Peter Smith (smithpb2250)
Amit Kapila (amitkapila), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234)
Amit Kapila (amitkapila)
4
4 years ago
New default role allowing to change per-role settings
2918
Moved to different CF
System Administration
Not processed
Michael Banck (mbanck)
Stephen Frost (sfrost), Shinya Kato (kato-shinya)
8
4 years ago
MERGE SQL command
2920
Returned with feedback
SQL Commands
15
Not processed
Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan)
4
4 years ago
Partial foreign key updates in referential integrity triggers
2932
Moved to different CF
SQL Commands
15
Not processed
Paul Martinez (pauljulius)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
5
4 years ago
WIP: Track relation size in shared memory
2933
Returned with feedback
Performance
Not processed
Thomas Munro (macdice)
3
4 years ago
Reduce the time required for a database recovery from archive.
2935
Returned with feedback
Not processed
Anna Akenteva (a.akenteva), Dmitry Shulga (d.shulga), Ivan Taranov (i.taranov)
3
5 years ago
NOT VALID for Unique Indexes
2937
Returned with feedback
SQL Commands
Not processed
Simon Riggs (simon)
3
4 years ago
increase size of pg_commit_ts buffers
2942
Moved to different CF
Performance
Not processed
Álvaro Herrera (alvherre)
Noah Misch (nmisch)
Álvaro Herrera (alvherre)
4
4 years ago
Full support for index LP_DEAD hint bits on standby
2947
Moved to different CF
Performance
Not processed
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
Antonin Houska (a.houska)
6
4 years ago
Simplify some RI checks to reduce SPI overhead
2948
Moved to different CF
Performance
Not processed
Amit Langote (amitlan)
Tom Lane (tgl), Corey Huinker (coreyh)
Álvaro Herrera (alvherre)
6
3 years ago
Extend comments on signal handling and cross-reference comments on signal handling functions
2951
Returned with feedback
Comments Only
Not processed
Craig Ringer (ringerc)
Mark Dilger (mark.dilger)
3
4 years ago
Introduce ProcessInterrupts_hook for C extensions
2952
Returned with feedback
Not processed
Craig Ringer (ringerc)
3
4 years ago
Extend docs on how to write correct postgres-dialect C including extensions and bgworkers
2953
Moved to different CF
Docs Only
Not processed
Craig Ringer (ringerc)
Laurenz Albe (laurenz)
4
4 years ago
Identify missing publications from publisher while create/alter subscription.
2957
Moved to different CF
Not processed
vigneshwaran C (vignesh.postgres)
Dilip Kumar (dilip.kumar), Euler Taveira (eulerto), Ashutosh Sharma (ashu_coek), Japin Li (japin), Bharath Rupireddy (bharathrupireddy)
Amit Kapila (amitkapila)
6
4 years ago
Adaptive query optimization: create extented statistics using auto_explain extension
2958
Moved to different CF
Performance
Not processed
Konstantin Knizhnik (knizhnik)
4
4 years ago
Improve join selectivity estimation using extended statistics
2959
Returned with feedback
Performance
Not processed
Konstantin Knizhnik (knizhnik)
3
4 years ago
Infrastructure changes to make the code less sensitive to transaction id bit width
2960
Returned with feedback
Refactoring Only
Not processed
James Finnerty (jimfinnerty)
3
4 years ago
Fix DROP TABLESPACE on Windows with ProcSignalBarrier?
2962
Moved to different CF
Bugfix
Not processed
Thomas Munro (macdice)
Daniel Gustafsson (d_gustafsson)
Thomas Munro (macdice)
6
4 years ago
Foreign Key Arrays
2966
Returned with feedback
SQL Commands
Not processed
Mark Rofail (markmoheb)
Joel Jacobson (joeljacobson), Justin Pryzby (justinpryzby)
3
4 years ago
Minimal logical decoding on standbys (take 6)
2968
Moved to different CF
Not processed
Amit Khandekar (amitdkhan)
Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot)
5
2 years ago
Set default transactions to read-only at servers start in pg_upgrade
2970
Moved to different CF
Bugfix
Not processed
Denis Laxalde (dlax)
Julien Rouhaud (rjuju)
4
4 years ago
Support tab completion for upper character inputs in psql
2979
Moved to different CF
libpq
Not processed
Haiying Tang (tanghy)
Tom Lane (tgl), Peter Eisentraut (petere)
Tom Lane (tgl)
5
4 years ago
partial heap only tuples
2981
Moved to different CF
Performance
15
Not processed
Nathan Bossart (bossartn)
4
4 years ago
Autovacuum dynamic cost_limit, cost_delay
2983
Returned with feedback
Bugfix
Not processed
Scott Mead (meads-amazon)
Masahiko Sawada (masahikosawada)
3
4 years ago
Allow setting parallel_workers on partitioned tables
2987
Returned with feedback
Performance
Not processed
Seamus Abshere (seamusabshere)
Amit Langote (amitlan), Laurenz Albe (laurenz), Zhijie Hou (houzj)
3
4 years ago
speed up pg_rewind by using copy_file_range() and skipping some fsync
2990
Returned with feedback
Performance
Not processed
Paul Guo (paulguo-vmware)
Michael Paquier (michael-kun)
3
4 years ago
Allow batched insert during cross-partition updates
2992
Moved to different CF
Not processed
Amit Langote (amitlan)
Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Zhijie Hou (houzj)
Etsuro Fujita (efujita)
10
3 years ago
Track wal_level drop for backup management
2994
Returned with feedback
Monitoring
Not processed
Takamichi Osumi (tatatappp)
3
4 years ago
Speed up verifying UTF-8
2996
Moved to different CF
Performance
Not processed
John Naylor (john.naylor)
Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan)
John Naylor (john.naylor)
5
4 years ago
Catalog version access
2999
Moved to different CF
System Administration
Not processed
Vik Fearing (xocolatl), Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
5
4 years ago
Refactor ECPGconnect() and allow IPv6 connection
3005
Returned with feedback
libpq
Not processed
Hayato Kuroda (ha-kun)
3
4 years ago
public schema default ACL
3017
Committed
Security
Not processed
Noah Misch (nmisch)
Peter Eisentraut (petere)
Noah Misch (nmisch)
3
4 years ago
Hooks and API to allow loadable wire protocol extensions
3018
Returned with feedback
Not processed
Jan Wieck (wieck)
3
5 years ago
Speeding up GIST index builds using popcount
3023
Returned with feedback
Performance
Not processed
Amit Khandekar (amitdkhan)
John Naylor (john.naylor)
3
4 years ago
postgres_fdw: suppress explicit casts in text:text comparisons
3025
Moved to different CF
Not processed
Dian Fay (dmfay)
Tom Lane (tgl), Georgios Kokolatos (gkokolatos)
Tom Lane (tgl)
4
4 years ago
Add --create-only option to pg_dump/pg_dumpall
3026
Returned with feedback
System Administration
Not processed
Michael Banck (mbanck)
Cary Huang (cary), Nitin Jadhav (nitinjadhav11)
3
4 years ago
Add regexp_positions(string text, pattern text, flags text) → setof record (starts integer[], lengths integer[])
3027
Moved to different CF
Not processed
Joel Jacobson (joeljacobson)
Tom Lane (tgl)
3
4 years ago
Rework the sslfiles Makefile target
3029
Moved to different CF
Refactoring Only
Not processed
Jacob Champion (jchampion)
Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson)
Daniel Gustafsson (d_gustafsson)
3
4 years ago
Make relfile tombstone files conditional on WAL level
3030
Moved to different CF
Performance
Not processed
Thomas Munro (macdice)
3
3 years ago
PROXY protocol support
3032
Moved to different CF
Not processed
Magnus Hagander (mha)
Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj)
7
3 years ago
Add system views pg_permissions and pg_ownerships
3033
Moved to different CF
Monitoring
Not processed
Joel Jacobson (joeljacobson)
5
1 year ago
Using COPY FREEZE in pgbench
3034
Committed
libpq
15
Not processed
Tatsuo Ishii (ishii)
Fabien Coelho (calvin)
Tatsuo Ishii (ishii)
2
4 years ago
Removing unused trailing linepointers from heap pages
3035
Moved to different CF
Bugfix
Not processed
Matthias van de Meent (mmeent)
3
3 years ago
Add some tests for pg_stat_statements compatibility verification
3036
Moved to different CF
Not processed
Erica Zhang (zerica)
Julien Rouhaud (rjuju)
Michael Paquier (michael-kun)
3
4 years ago
Release SPI plans for referential integrity with DISCARD
3037
Returned with feedback
SQL Commands
Not processed
Yuzuko Hosoya (yuzu)
2
4 years ago
More sort-related specialisation
3038
Moved to different CF
Performance
Not processed
Thomas Munro (macdice)
John Naylor (john.naylor)
John Naylor (john.naylor)
5
4 years ago
Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation
3040
Moved to different CF
Not processed
Bharath Rupireddy (bharathrupireddy)
Daniel Gustafsson (d_gustafsson), vigneshwaran C (vignesh.postgres)
Daniel Gustafsson (d_gustafsson)
3
4 years ago
Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns
3041
Moved to different CF
Bugfix
Not processed
Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1)
Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi)
Amit Kapila (amitkapila)
7
3 years ago
Add common functions regexp_like, regexp_count, regexp_instr, regexp_substr and regexp_replace
3042
Committed
Not processed
Gilles Darold (darold)
Tom Lane (tgl)
Tom Lane (tgl)
2
4 years ago
Built-in connection pooler
3043
Returned with feedback
Performance
Not processed
Konstantin Knizhnik (knizhnik)
Antonin Houska (a.houska)
2
4 years ago
rename column if exists
3045
Moved to different CF
SQL Commands
Not processed
David Oksman (oks)
Yagiz Nizipli (yagiznizipli)
4
4 years ago
Allow multiple recursive self-references
3046
Moved to different CF
Not processed
Denis Hirn (brainy)
Peter Eisentraut (petere)
6
3 years ago
pg_stat_statements: Track statement entry timestamp
3048
Moved to different CF
Monitoring
17
Not processed
Andrei Zubkov (zubkov)
Alena Rybakina (a.rybakina)
Alexander Korotkov (smagen)
13
2 years ago
Extended statistics in EXPLAIN
3050
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
Tatsuro Yamada (tatsuro_yamada)
6
4 years ago
pg_dump new feature: exporting functions only
3051
Moved to different CF
libpq
15
Not processed
Lætitia AVROT (arkhena)
ahsan hadi (ahsan.hadi), Ryan Lambert (ryanlambert)
5
3 years ago
Merging statistics from children instead of re-sampling everything
3052
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
5
4 years ago
Add missing function abs (interval)
3054
Moved to different CF
Not processed
Isaac Morland (ijmorlan)
Tom Lane (tgl)
3
4 years ago
estimating joins using extended statistics
3055
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
Andy Fan (andyf)
4
4 years ago
Eliminating "Permission denied" errors on stat() (on Windows)
3058
Moved to different CF
Bugfix
Not processed
Alexander Lakhin (law)
4
4 years ago
fix ICU explorer link in locale documentation
3059
Moved to different CF
Docs Only
Not processed
Anton Voloshin (a.voloshin)
Laurenz Albe (laurenz)
Bruce Momjian (bmomjian)
3
4 years ago
use AV work items infrastructure for GIN pending list's cleanup
3060
Returned with feedback
15
Not processed
Jaime Casanova (jcasanov)
Masahiko Sawada (masahikosawada)
2
4 years ago
tablesync early exit
3062
Moved to different CF
15
Not processed
Peter Smith (smithpb2250)
6
4 years ago
Remove 64K hard limit on rangetable size
3063
Committed
Not processed
Tom Lane (tgl)
Aleksander Alekseev (a.alekseev)
Tom Lane (tgl)
2
4 years ago
Add option --drop-cascade for pg_dump/restore
3065
Moved to different CF
libpq
Not processed
Wu Haotian (whtsky)
Greg Sabino Mullane (greg)
3
4 years ago
add explicit partial union-all and improve parallel subquery costing
3070
Moved to different CF
Performance
Not processed
Luc Vlaming (luc.vlaming)
Ronan Dunklau (rdunklau)
3
4 years ago
Lazy JIT IR code generation to increase JIT speed with partitions
3071
Moved to different CF
Performance
Not processed
David Geier (geidav), Luc Vlaming (luc.vlaming)
Dmitry Dolgov (erthalion)
9
3 years ago
Add callback table access method to reset filenode when dropping relation
3073
Moved to different CF
Not processed
Mats Kindahl (matski)
Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov)
7
3 years ago
Convert contrib SQL functions to new style
3074
Returned with feedback
Security
Not processed
Tom Lane (tgl)
2
1 year ago
Improve sepgsql logging so it follows the behaviour of selinux's logging.
3076
Moved to different CF
Security
Not processed
Dave Page (dpage)
Jacob Champion (jchampion)
Tom Lane (tgl)
4
4 years ago
Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation
3078
Moved to different CF
Performance
15
Not processed
Matthias van de Meent (mmeent)
4
4 years ago
generate fractional cheapest paths in generate_orderedappend_paths
3080
Moved to different CF
Bugfix
Not processed
Tomas Vondra (fuzzycz)
Arne Roland (harks)
Tomas Vondra (fuzzycz)
4
4 years ago
badly calculated width of emoji in psql
3087
Committed
Bugfix
Not processed
Jacob Champion (jchampion)
Pavel Stehule (okbobcz)
John Naylor (john.naylor)
2
4 years ago
Reduce lock level for ALTER TABLE ... ADD CHECK
3088
Moved to different CF
System Administration
15
Not processed
Simon Riggs (simon)
Greg Sabino Mullane (greg)
3
4 years ago
A test for replay of regression tests
3090
Moved to different CF
Not processed
Thomas Munro (macdice)
Anastasia Lubennikova (lubennikovaav)
Thomas Munro (macdice)
4
4 years ago
Use simplehash.h instead of dynahash in SMgr
3092
Moved to different CF
Performance
Not processed
David Rowley (davidrowley)
Yura Sokolov (funny_falcon)
3
4 years ago
avoid logical replication empty transactions
3093
Moved to different CF
15
Not processed
Euler Taveira (eulerto), Ajin Cherian (ajinc)
vigneshwaran C (vignesh.postgres), Peter Smith (smithpb), Greg Nancarrow (gregn1234)
Amit Kapila (amitkapila)
5
4 years ago
Addition of authenticated ID to pg_stat_activity
3095
Returned with feedback
15
Not processed
Michael Paquier (michael-kun)
Aleksander Alekseev (aalekseev)
2
4 years ago
Extend portability of client_connection_check_interval
3098
Moved to different CF
Refactoring Only
Not processed
Thomas Munro (macdice)
Maksim Milyutin (maksm90)
Thomas Munro (macdice)
5
4 years ago
Asymmetric partition-wise JOIN
3099
Moved to different CF
15
Not processed
KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov)
Alexander Pyhalov (a.pyhalov)
7
4 years ago
Extensible parsing
3100
Moved to different CF
15
Not processed
Julien Rouhaud (rjuju)
4
4 years ago
Toast compression method options
3102
Moved to different CF
Performance
Not processed
Dilip Kumar (dilip.kumar)
3
4 years ago
pg_upgrade: copy the source oldestXid
3105
Committed
Bugfix
stable
Not processed
Bertrand Drouvot (bdrouvot)
Bruce Momjian (bmomjian)
2
4 years ago
Avoid orphaned dependencies
3106
Moved to different CF
16
Not processed
Bertrand Drouvot (bdrouvot)
Ronan Dunklau (rdunklau)
6
4 years ago
Extending amcheck to check toast size and compression
3107
Moved to different CF
Not processed
Mark Dilger (mark.dilger)
Greg Stark (stark), Aleksander Alekseev (aalekseev)
Michael Paquier (michael-kun)
3
4 years ago
psql: exclude valid constraints in tab-complete for ALTER TABLE .. VALIDATE CONSTRAINT
3113
Moved to different CF
Bugfix
Not processed
David Fetter (dfetter)
Aleksander Alekseev (aalekseev)
Tom Lane (tgl)
4
4 years ago
Rewriting the test of pg_upgrade as a TAP test - take three
3120
Moved to different CF
Not processed
Michael Paquier (michael-kun)
3
4 years ago
Support of time zone patterns - of, tzh and tzm
3121
Moved to different CF
Bugfix
Not processed
Nitin Jadhav (nitinjadhav11)
David Zhang (david.z)
Robert Haas (rhaas)
5
4 years ago
Diagnostic comment in LogicalIncreaseXminForSlot
3124
Committed
Not processed
Ashutosh Bapat (ashutoshbapat)
Masahiko Sawada (masahikosawada)
Amit Kapila (amitkapila)
2
4 years ago
Improve documentation for pg_upgrade, standbys and rsync
3125
Moved to different CF
Docs Only
15
Not processed
Laurenz Albe (laurenz)
David Fetter (dfetter)
5
3 years ago
Clarify how triggers relate to transactions
3126
Committed
Docs Only
15
Not processed
Laurenz Albe (laurenz)
Simon Riggs (simon)
Tom Lane (tgl)
2
4 years ago
Document the 1GB memory limit for VACUUM
3127
Committed
Docs Only
15
Not processed
David Rowley (davidrowley), Laurenz Albe (laurenz)
Greg Sabino Mullane (greg)
David Rowley (davidrowley)
2
4 years ago
TAP test for contrib/sslinfo
3128
Moved to different CF
Not processed
Daniel Gustafsson (d_gustafsson)
Tom Lane (tgl)
Daniel Gustafsson (d_gustafsson)
3
4 years ago
Parallel scan with SubTransGetTopmostTransaction assert coredump
3129
Committed
Bugfix
Not processed
Robert Haas (rhaas), Greg Nancarrow (gregn1234), Maxim Orlov (m.orlov), Pavel Borisov (pborisov)
Pavel Borisov (pborisov)
Robert Haas (rhaas)
2
4 years ago
Change internal PRNG (from rand48 to something better, with a cleaner interface)
3131
Moved to different CF
15
Not processed
Fabien Coelho (calvin)
Aleksander Alekseev (aalekseev)
Tom Lane (tgl)
3
4 years ago
Bug in query rewriter - hasModifyingCTE not getting set
3134
Returned with feedback
Bugfix
15
Not processed
Takayuki Tsunakawa (maumau)
Tom Lane (tgl)
2
4 years ago
Support for NSS as a libpq TLS backend
3138
Moved to different CF
Security
Not processed
Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion)
Joshua Brindle (joshuab)
5
4 years ago
Replicates changes for all tables in schema
3139
Moved to different CF
15
Not processed
vigneshwaran C (vignesh.postgres)
Greg Nancarrow (gregn1234), Haiying Tang (tanghy), Mark Dilger (mark.dilger), Zhijie Hou (houzj), Rahila Syed (rahila)
Amit Kapila (amitkapila)
3
4 years ago
psql - refactor echo code
3140
Moved to different CF
Refactoring Only
Not processed
Fabien Coelho (calvin)
Pavel Stehule (okbobcz), Peter Eisentraut (petere)
10
3 years ago
Reducing memory consumption for pending inval messages
3141
Committed
Performance
Not processed
Tom Lane (tgl)
Nathan Bossart (bossartn)
Tom Lane (tgl)
2
4 years ago
Logging plan of the currently running query
3142
Moved to different CF
Monitoring
16
Not processed
atsushi torikoshi (atorik)
Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina)
9
2 weeks ago
Parallel INSERT SELECT take 2
3143
Moved to different CF
Performance
Not processed
Greg Nancarrow (gregn1234), Zhijie Hou (houzj)
6
3 years ago
postgres_fdw: Handle boolean comparison predicates
3144
Returned with feedback
Not processed
Emre Hasegeli (hasegeli)
Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat), Cary Huang (cary)
2
4 years ago
Incorrect snapshots while promoting hot standby node when 2PC is used
3145
Moved to different CF
Bugfix
stable
Not processed
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
3
4 years ago
A micro-optimisation for ProcSendSignal()
3146
Moved to different CF
Refactoring Only
Not processed
Thomas Munro (macdice)
Soumyadeep Chakraborty (soumyadeepc)
Thomas Munro (macdice)
4
4 years ago
Allow queries in WHEN expression of FOR EACH STATEMENT triggers
3148
Withdrawn
SQL Commands
Not processed
Joe Wildish (joewildish)
2
4 years ago
logical decoding and replication of sequences
3155
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
Peter Eisentraut (petere)
Tomas Vondra (fuzzycz)
5
3 years ago
btree_gist: Support bool
3157
Moved to different CF
Not processed
Emre Hasegeli (hasegeli)
Tomas Vondra (fuzzycz)
3
4 years ago
pre-allocating WAL files
3158
Moved to different CF
Performance
16
Not processed
Nathan Bossart (bossartn)
Maxim Orlov (m.orlov), Pavel Borisov (pborisov)
6
3 years ago
Range Merge Join
3160
Moved to different CF
15
Not processed
Thomas Mannhart (thomasmannhart97)
4
4 years ago
add pg_ctl option that returns amount of shmem required
3161
Committed
System Administration
Not processed
Nathan Bossart (bossartn)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
2
3 years ago
Update Toast data failure in logical replication
3162
Moved to different CF
Bugfix
Not processed
Dilip Kumar (dilip.kumar)
Euler Taveira (eulerto), Haiying Tang (tanghy)
Amit Kapila (amitkapila)
5
4 years ago
Use tuple-level SIREAD locks for index-only scans
3163
Moved to different CF
Not processed
Thomas Munro (macdice)
3
4 years ago
Add proper planner support for ORDER BY / DISTINCT aggregates
3164
Moved to different CF
Performance
Not processed
David Rowley (davidrowley)
Ronan Dunklau (rdunklau), Richard Guo (richardguo)
David Rowley (davidrowley)
7
3 years ago
Fix around conn_duration in pgbench
3166
Committed
Bugfix
14
Not processed
Yugo Nagata (yugo.nagata)
Asif Rehman (asifrana)
Fujii Masao (masaofujii)
2
4 years ago
Avoid stuck of pgbench due to skipped transactions
3168
Committed
Bugfix
stable
Not processed
Yugo Nagata (yugo.nagata)
Greg Sabino Mullane (greg)
Fujii Masao (masaofujii)
2
4 years ago
procarray.c: two refactorings
3169
Committed
Refactoring Only
Not processed
Ranier Vilela (raniervilela)
Aleksander Alekseev (aalekseev)
Fujii Masao (masaofujii)
2
4 years ago
Consistent use of SSL/TLS in docs
3172
Moved to different CF
Docs Only
Not processed
Daniel Gustafsson (d_gustafsson)
Robert Haas (rhaas), Lætitia AVROT (arkhena)
Daniel Gustafsson (d_gustafsson)
5
4 years ago
Split xlog.c
3173
Moved to different CF
Refactoring Only
Not processed
Heikki Linnakangas (heikki)
3
4 years ago
Fix documentation for COPY protocol flow
3175
Moved to different CF
Docs Only
Not processed
Jeff Davis (jdavis)
3
4 years ago
unnesting multirange data types
3178
Returned with feedback
14
Not processed
Alexander Korotkov (smagen)
Justin Pryzby (justinpryzby), Jonathan Katz (jkatz05)
Alexander Korotkov (smagen)
2
4 years ago
Extended protocol COPY FROM STDIN fix
3180
Moved to different CF
Bugfix
Not processed
Jeff Davis (jdavis)
3
4 years ago
Map WAL segment files on PMEM as WAL buffers
3181
Moved to different CF
Performance
Not processed
Takashi Menjo (tmenjo)
6
4 years ago
automatically generating node support functions
3182
Moved to different CF
Refactoring Only
Not processed
Peter Eisentraut (petere)
Tom Lane (tgl)
Peter Eisentraut (petere)
6
3 years ago
Detectable crashes and unlogged table resets
3183
Moved to different CF
Not processed
Jeff Davis (jdavis)
5
4 years ago
pg_stats and range statistics
3184
Moved to different CF
17
Not processed
Egor Rogov (egorius)
Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc)
Alexander Korotkov (smagen)
13
2 years ago
Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands
3188
Returned with feedback
Not processed
Yuzuko Hosoya (yuzu)
2
4 years ago
Using indexUnchanged with nbtree
3191
Returned with feedback
Performance
15
Not processed
Simon Riggs (simon)
2
4 years ago
Fully WAL logged CREATE DATABASE - No Checkpoints
3192
Moved to different CF
Not processed
Dilip Kumar (dilip.kumar)
Ashutosh Sharma (ashu_coek)
Robert Haas (rhaas)
5
4 years ago
Fix pkg-config file for static linking
3193
Committed
Bugfix
Not processed
Filip Gospodinov (fil)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
2
4 years ago
pgbench - allow retries on some errors
3194
Returned with feedback
libpq
15
Not processed
Yugo Nagata (yugo.nagata), Marina Polyakova (whipping.top1991)
Fabien Coelho (calvin)
2
4 years ago
DELETE CASCADE
3195
Moved to different CF
SQL Commands
15
Not processed
David Christensen (davidchristensen)
4
4 years ago
Emit namespace in post-copy output
3200
Committed
libpq
Not processed
Mike Fiedler (miketheman)
Daniel Gustafsson (d_gustafsson), Corey Huinker (coreyh)
Daniel Gustafsson (d_gustafsson)
2
4 years ago
Expose get_query_def()
3204
Moved to different CF
Not processed
Julien Rouhaud (rjuju)
Pavel Stehule (okbobcz), Gilles Darold (darold)
Tom Lane (tgl)
5
4 years ago
Skipping logical replication transactions on subscriber side
3205
Moved to different CF
Not processed
Masahiko Sawada (masahikosawada)
vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Mark Dilger (mark.dilger), Zhijie Hou (houzj)
Amit Kapila (amitkapila)
5
3 years ago
Write visibility map during CLUSTER/VACUUM FULL
3206
Moved to different CF
Performance
Not processed
Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva)
Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva)
6
3 years ago
improvements in Unicode tables generation code
3208
Moved to different CF
Refactoring Only
Not processed
Peter Eisentraut (petere)
Peter Eisentraut (petere)
3
4 years ago
PoC: improving join estimates using sampling
3211
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
5
4 years ago
Allow providing restore_command as a command line option to pg_rewind
3213
Moved to different CF
Not processed
Alexey Kondratov (ololobus)
Andrey Borodin (x4m)
5
3 years ago
Fix numeric power for negative bases and other corner cases
3214
Moved to different CF
Bugfix
Not processed
Dean Rasheed (deanr)
Yugo Nagata (yugo.nagata)
Dean Rasheed (deanr)
3
4 years ago
Extensible storage manager API - smgr hooks
3216
Moved to different CF
Refactoring Only
Not processed
Anastasia Lubennikova (lubennikovaav)
5
4 years ago
Don't block HOT update by BRIN index
3218
Moved to different CF
Performance
Not processed
Josef Šimánek (retro)
Tomas Vondra (fuzzycz)
Tomas Vondra (fuzzycz)
3
4 years ago
Fix pgbench's exit status and log messages for connection failures
3219
Moved to different CF
Bugfix
stable
Not processed
Fabien Coelho (calvin), Yugo Nagata (yugo.nagata)
Fujii Masao (masaofujii)
3
4 years ago
Speed up LockReleaseAll
3220
Moved to different CF
Performance
Not processed
David Rowley (davidrowley)
3
2 years ago
PITR enhance getRecordTimestamp()
3222
Moved to different CF
Not processed
Simon Riggs (simon)
8
4 years ago
Delegating superuser tasks to new security roles
3223
Moved to different CF
Security
15
Not processed
Mark Dilger (mark.dilger)
Andrew Dunstan (adunstan), Nathan Bossart (bossartn)
3
4 years ago
Fix ExecRTCheckPerms() inefficiency with many prunable partitions
3224
Moved to different CF
Performance
16
Not processed
Amit Langote (amitlan)
Álvaro Herrera (alvherre), Tom Lane (tgl)
Álvaro Herrera (alvherre)
8
2 years ago
pgbench: add multiconnect support
3227
Moved to different CF
16
Not processed
David Christensen (davidchristensen)
Jelte Fennema-Nio (jeltef)
9
3 years ago
Cleaning up orphaned files using undo logs
3228
Moved to different CF
Not processed
Antonin Houska (a.houska)
Dmitry Dolgov (erthalion)
4
4 years ago
Remove redundant initializations
3229
Returned with feedback
Refactoring Only
Not processed
Peter Eisentraut (petere)
Noah Misch (nmisch)
2
4 years ago
Column filtering in logical replication
3230
Moved to different CF
15
Not processed
Álvaro Herrera (alvherre), Rahila Syed (rahila.syed), Tomas Vondra (fuzzycz)
Álvaro Herrera (alvherre), Peter Eisentraut (petere), vigneshwaran C (vignesh.postgres)
Tomas Vondra (fuzzycz)
5
4 years ago
Teach pg_receivewal to use lz4 compression
3231
Moved to different CF
15
Not processed
Georgios Kokolatos (gkokolatos)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
3
4 years ago
Automatic notification of top transaction IDs
3232
Moved to different CF
Not processed
Gurjeet Singh (gurjeet)
Cary Huang (cary)
3
4 years ago
ECPG bug fix: allow using connection-associated prepared_name
3233
Committed
Bugfix
Not processed
Hayato Kuroda (ha-kun)
Michael Meskes (meskes)
2
4 years ago
Window function run conditions
3234
Moved to different CF
Performance
Not processed
David Rowley (davidrowley)
David Rowley (davidrowley)
5
3 years ago
Using each rel as both outer and inner for anti-joins
3235
Moved to different CF
Performance
Not processed
Richard Guo (richardguo)
Ronan Dunklau (rdunklau)
Tom Lane (tgl)
9
2 years ago
Fix uninitialized variable access (freepages)
3236
Moved to different CF
Bugfix
15
Not processed
Ranier Vilela (raniervilela)
Greg Nancarrow (gregn1234), David Zhang (david.z)
4
4 years ago
Use optimized single-datum tuplesort in ExecSort
3237
Committed
Performance
15
Not processed
Ronan Dunklau (rdunklau)
James Coleman (jcole1989), Ranier Vilela (raniervilela)
David Rowley (davidrowley)
1
4 years ago
Slightly improve initdb --sync-only option's help message
3238
Committed
System Administration
Not processed
Gurjeet Singh (gurjeet)
Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn)
Daniel Gustafsson (d_gustafsson)
1
4 years ago
Warn if initdb's --sync-only option is mixed with other options
3239
Returned with feedback
System Administration
Not processed
Gurjeet Singh (gurjeet)
Daniel Gustafsson (d_gustafsson)
1
4 years ago
when the blocksize is 32k, the function page_header of pageinspect returns negative numbers.
3240
Committed
Bugfix
Not processed
Zongliang Quan (quanzl)
Michael Paquier (michael-kun)
1
4 years ago
[bug] Logical Decoding of relation rewrite with toast does not reset toast_hash
3241
Committed
Bugfix
stable
Not processed
Bertrand Drouvot (bdrouvot)
David Zhang (david.z)
Amit Kapila (amitkapila)
1
4 years ago
test pgbench time-related features
3242
Moved to different CF
libpq
15
Not processed
Fabien Coelho (calvin)
2
4 years ago
Add statistics refresh materialized view
3243
Returned with feedback
Monitoring
Not processed
Yuki Seino (seinoyu)
Fujii Masao (masaofujii)
1
4 years ago
parse_subscription_options - some suggested improvements
3244
Moved to different CF
15
Not processed
Peter Smith (smithpb2250)
Nathan Bossart (bossartn)
Michael Paquier (michael-kun)
3
4 years ago
Postgres picks suboptimal index after building extended statistics
3245
Moved to different CF
Performance
14
Not processed
Andrei Lepikhov (lepikhov)
7
3 years ago
Parallelize correlated subqueries that execute within each worker
3246
Moved to different CF
Performance
Not processed
James Coleman (jcole1989)
Akshat Jaimini (akshatj)
15
1 year ago
Small documentation improvement for ALTER SUBSCRIPTION
3247
Committed
Docs Only
Not processed
Masahiko Sawada (masahikosawada)
Peter Eisentraut (petere)
Daniel Gustafsson (d_gustafsson)
1
4 years ago
CREATE SUBSCRIPTION option list order
3248
Committed
Docs Only
15
Not processed
Peter Smith (smithpb2250)
Euler Taveira (eulerto)
Amit Kapila (amitkapila)
1
4 years ago
psql tab auto-complete for CREATE PUBLICATION
3249
Committed
15
Not processed
Peter Smith (smithpb2250)
vigneshwaran C (vignesh.postgres)
Fujii Masao (masaofujii)
1
4 years ago
Fix handling of outer GroupingFunc within subqueries
3250
Moved to different CF
Bugfix
Not processed
Richard Guo (richardguo)
Tom Lane (tgl), Platon Pronko (rogach)
Tom Lane (tgl)
4
4 years ago
Document pg_encoding_to_char() and pg_char_to_encoding()
3251
Moved to different CF
Docs Only
15
Not processed
Ian Barwick (barwick)
Fujii Masao (masaofujii)
Fujii Masao (masaofujii)
2
4 years ago
Tab completion for CREATE SCHEMA AUTHORIZATION
3252
Moved to different CF
libpq
Not processed
Dagfinn Ilmari Mannsåker (ilmari)
Suraj Khamkar (suraj.khamkar)
2
2 years ago
Use lfoo_node(...) instead of castNode(..., lfoo(...))
3253
Committed
Refactoring Only
Not processed
Dagfinn Ilmari Mannsåker (ilmari)
Peter Eisentraut (petere)
1
4 years ago
Remove repeated PQfnumber() in pg_dump
3254
Committed
Performance
Not processed
Zhijie Hou (houzj)
Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn)
Daniel Gustafsson (d_gustafsson)
1
4 years ago
Use WaitLatch for {pre, post}_auth_delay instead of pg_usleep
3255
Rejected
Refactoring Only
Not processed
Bharath Rupireddy (bharathrupireddy)
Nathan Bossart (bossartn)
1
4 years ago
functions to compute size of schemas/AMs (and maybe \dn++ and \dA++)
3256
Moved to different CF
libpq
Not processed
Justin Pryzby (justinpryzby)
David Christensen (davidchristensen)
16
1 year ago
Dissallow sending SI messages when excuting ROLLBACK PREPARED command
3257
Committed
Not processed
huailing liu (haylee)
Michael Paquier (michael-kun)
1
4 years ago
proposal of adding 2 new diag items related to parsing the dynamic sql statement
3258
Moved to different CF
Not processed
Dinesh Chemuduru (dineshc)
Pavel Stehule (okbobcz)
2
3 years ago
corruption of WAL page header is never reported
3259
Moved to different CF
Bugfix
stable
Not processed
Yugo Nagata (yugo.nagata)
Fujii Masao (masaofujii)
Fujii Masao (masaofujii)
2
4 years ago
pgbench: using prepared BEGIN statement in a pipeline could cause an error
3260
Moved to different CF
Bugfix
15
Not processed
Yugo Nagata (yugo.nagata)
Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege)
Álvaro Herrera (alvherre)
9
3 years ago
Log the activity of startup process
3261
Moved to different CF
Monitoring
15
Not processed
Nitin Jadhav (nitinjadhav)
Justin Pryzby (justinpryzby), Bharath Rupireddy (bharathrupireddy)
Robert Haas (rhaas)
2
3 years ago
schema change not getting invalidated, both renamed table and new table data were getting replicated
3262
Moved to different CF
Not processed
vigneshwaran C (vignesh.postgres)
Tom Lane (tgl)
Tom Lane (tgl)
8
3 years ago
Added documentation for cascade and restrict option of drop statistics
3263
Committed
Docs Only
Not processed
vigneshwaran C (vignesh.postgres)
Michael Paquier (michael-kun)
1
4 years ago
Fix postgres_fdw's ORDER BY pushdown handling
3264
Moved to different CF
Bugfix
Not processed
Ronan Dunklau (rdunklau)
Tom Lane (tgl), David Zhang (david.z)
Tom Lane (tgl)
4
4 years ago
Kerberos delegation support in libpq and postgres_fdw
3265
Moved to different CF
Security
Not processed
Peifeng Qiu (pqiu)
2
2 years ago
Stored Procedure Triggered by Logical Replication is Unable to use Notification Events
3266
Committed
Bugfix
15
Not processed
Artur Zakirov (a.zakirov)
Tom Lane (tgl)
Tom Lane (tgl)
1
4 years ago
improve tab-completion behavior when parse text in single quote
3267
Moved to different CF
libpq
Not processed
Haiying Tang (tanghy)
2
4 years ago
Add tab-complete for full name backslash commands
3268
Committed
libpq
Not processed
Haiying Tang (tanghy)
Dagfinn Ilmari Mannsåker (ilmari)
Tom Lane (tgl)
1
4 years ago
New READ_REPLICATION_SLOT command & usage in pg_receivewal
3269
Returned with feedback
Not processed
Ronan Dunklau (rdunklau)
Michael Paquier (michael-kun), Bharath Rupireddy (bharathrupireddy)
1
4 years ago
Cache tuple routing info during bulk loads into partitioned tables
3270
Moved to different CF
Performance
Not processed
David Rowley (davidrowley), Amit Langote (amitlan), Zhijie Hou (houzj)
Álvaro Herrera (alvherre), David Rowley (davidrowley)
David Rowley (davidrowley)
6
3 years ago
KnownAssignedXidsGetAndSetXmin performance
3271
Moved to different CF
Performance
Not processed
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
Kirill Reshke (reshke), Andrey Borodin (x4mmm)
6
3 years ago
Add system view tracking shared buffer actions
3272
Moved to different CF
Monitoring
16
Not processed
Melanie Plageman (melanieplageman)
Justin Pryzby (justinpryzby)
Andres Freund (andresfreund)
9
3 years ago
wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION
3273
Committed
Bugfix
Not processed
Zhijie Hou (houzj)
Amit Kapila (amitkapila)
1
4 years ago
Gather partial paths for subproblem's topmost scan/join rel
3274
Moved to different CF
Not processed
Richard Guo (richardguo)
Antonin Houska (a.houska)
Tom Lane (tgl)
5
3 years ago
Skip useless paren-captures in regexps
3275
Committed
Performance
Not processed
Tom Lane (tgl)
Mark Dilger (hornschnorter)
Tom Lane (tgl)
1
4 years ago
disallow external access to MaxBackends
3276
Moved to different CF
Not processed
Nathan Bossart (bossartn)
Greg Sabino Mullane (greg)
Michael Paquier (michael-kun)
4
3 years ago
Allow escape sequence in application_name
3277
Moved to different CF
libpq
Not processed
Hayato Kuroda (ha-kun)
Fujii Masao (masaofujii)
Fujii Masao (masaofujii)
3
4 years ago
perlcritic: prohibit map and grep in void conext
3278
Committed
Not processed
Dagfinn Ilmari Mannsåker (ilmari)
Daniel Gustafsson (d_gustafsson)
Daniel Gustafsson (d_gustafsson)
1
4 years ago
Tab completion for EXECUTE after EXPLAIN
3279
Committed
libpq
Not processed
Dagfinn Ilmari Mannsåker (ilmari)
Michael Paquier (michael-kun)
1
4 years ago
Tab completion for ALTER TABLE … ADD …
3280
Committed
libpq
Not processed
Dagfinn Ilmari Mannsåker (ilmari)
Michael Paquier (michael-kun)
1
4 years ago
use regular expressions to simplify less_greater and not_equals
3281
Rejected
Refactoring Only
Not processed
Fan Xiaojian (funnyxj.qq.com), Shihao Sun (sunshihao.ssh.alibaba-inc.com)
Tom Lane (tgl)
1
4 years ago
Support reset of Shared objects statistics
3282
Committed
Bugfix
Not processed
B Sadhu Prasad Patro (sadhuprasad)
Mahendra Singh Thalor (mahithalor)
Fujii Masao (masaofujii)
1
4 years ago
Failed Assertion in ReorderBufferChangeMemoryUpdate()
3283
Committed
Bugfix
stable
Not processed
Bertrand Drouvot (bdrouvot)
Amit Kapila (amitkapila)
1
4 years ago
Native spinlock support on RISC-V
3284
Committed
Performance
Not processed
Marek Szuba (mkszuba)
Tom Lane (tgl)
1
4 years ago
glossary definitions for auxiliary processes
3285
Committed
Docs Only
15
Not processed
Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby)
Álvaro Herrera (alvherre)
1
4 years ago
Error out if SKIP LOCKED and WITH TIES are both specified
3286
Moved to different CF
Bugfix
stable
Not processed
David Christensen (davidchristensen)
Álvaro Herrera (alvherre)
2
4 years ago
Remove obsolete macro CHECKFLOATVAL in contrib/btree_gist
3287
Committed
Refactoring Only
Not processed
Haiying Tang (tanghy)
Michael Paquier (michael-kun)
1
4 years ago
pg_dump handling of ALTER DEFAULT PRIVILEGES IN SCHEMA
3288
Moved to different CF
Bugfix
stable
Not processed
Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn)
Muhammad Usama (muhammad_usama)
Tom Lane (tgl)
2
4 years ago
Push down time-related SQLValue functions to foreign server
3289
Moved to different CF
Performance
15
Not processed
Alexander Pyhalov (a.pyhalov)
5
4 years ago
Allow special values in GUC configurations
3290
Moved to different CF
16
Not processed
David Christensen (davidchristensen)
Cary Huang (cary)
4
4 years ago
Add PGDLLIMPORT to all direct or indirect GUC variables
3291
Moved to different CF
15
Not processed
Robert Haas (rhaas), Julien Rouhaud (rjuju)
Robert Haas (rhaas)
4
3 years ago
Non-decimal integer literals
3292
Moved to different CF
SQL Commands
Not processed
Peter Eisentraut (petere)
John Naylor (john.naylor)
Peter Eisentraut (petere)
6
3 years ago
Tags in errordata
3293
Moved to different CF
15
Not processed
Ronan Dunklau (rdunklau)
Greg Stark (stark), Justin Pryzby (justinpryzby)
4
3 years ago
Separate out FileSet from SharedFileSet
3294
Committed
Refactoring Only
Not processed
Dilip Kumar (dilip.kumar)
Masahiko Sawada (masahikosawada)
Amit Kapila (amitkapila)
1
4 years ago
psql: add xheader_width option to handle very long record lines
3295
Moved to different CF
libpq
Not processed
Platon Pronko (rogach)
Andrew Dunstan (adunstan)
Andrew Dunstan (adunstan)
5
3 years ago
Preserving db/ts/relfilenode OIDs across pg_upgrade
3296
Moved to different CF
Not processed
Antonin Houska (a.houska), Shruthi Gowda (shruthi)
Robert Haas (rhaas), Rushabh Lathia (rlathia)
Robert Haas (rhaas)
4
3 years ago
mitigate O(n^2) behavior of WAL archiver process
3297
Moved to different CF
Performance
15
Not processed
Nathan Bossart (bossartn), Dipesh Pandit (dpandit)
Nathan Bossart (bossartn)
Robert Haas (rhaas)
2
4 years ago
Showing I/O timings spent reading/writing temp buffers in EXPLAIN
3298
Moved to different CF
15
Not processed
Masahiko Sawada (masahikosawada)
Julien Rouhaud (rjuju), Melanie Plageman (melanieplageman), Georgios Kokolatos (gkokolatos)
Michael Paquier (michael-kun)
4
3 years ago
Do not start bgworker processes during binary upgrade
3299
Moved to different CF
Bugfix
Not processed
Denis Laxalde (dlax)
Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju)
4
4 years ago
AIX: Symbols are missing in libpq.a
3300
Committed
14
Not processed
Tony Reix (trex58)
Noah Misch (nmisch)
Noah Misch (nmisch)
1
4 years ago
Fix ATTACH/DETACH PARTITION to invalidate partitions of table being attached/detached
3301
Moved to different CF
Bugfix
stable
Not processed
Álvaro Herrera (alvherre), Amit Langote (amitlan)
Maxim Orlov (m.orlov), Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov)
Álvaro Herrera (alvherre)
2
4 years ago
Trap SIGCHLD in pg_basebackup to exit early on stream child failure
3302
Moved to different CF
Monitoring
Not processed
Daniel Gustafsson (d_gustafsson)
Magnus Hagander (mha), Bharath Rupireddy (bharathrupireddy)
Daniel Gustafsson (d_gustafsson)
4
4 years ago
\dP and \dX use ::regclass without "pg_catalog."
3303
Committed
Bugfix
12
Not processed
Justin Pryzby (justinpryzby)
Álvaro Herrera (alvherre)
1
4 years ago
Optimize parallel tuple queue
3304
Moved to different CF
Performance
Not processed
Dilip Kumar (dilip.kumar)
Robert Haas (rhaas)
2
4 years ago
Fix erroneous parallel execution when modifying CTE is present in rewritten query
3305
Committed
Bugfix
15
Not processed
Greg Nancarrow (gregn1234)
Tom Lane (tgl)
Tom Lane (tgl)
1
4 years ago
Remove Value node struct
3306
Committed
Refactoring Only
Not processed
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
4 years ago
UNIQUE null treatment option
3307
Moved to different CF
SQL Commands
Not processed
Peter Eisentraut (petere)
Vik Fearing (xocolatl), Maxim Orlov (m.orlov), Pavel Borisov (pborisov)
Peter Eisentraut (petere)
4
4 years ago
Some RELKIND macro refactoring
3308
Moved to different CF
Refactoring Only
Not processed
Peter Eisentraut (petere)
Michael Paquier (michael-kun)
Peter Eisentraut (petere)
3
4 years ago
Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?
3309
Committed
Bugfix
Not processed
Aleksander Alekseev (aalekseev)
Tom Lane (tgl)
Tom Lane (tgl)
1
4 years ago
add guc: hugepages_active
3310
Moved to different CF
System Administration
Not processed
Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda)
Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby)
Michael Paquier (michael-kun)
7
2 years ago
Invalidations were missing in case of for all tables publication
3311
Committed
Not processed
Amit Kapila (amitkapila)
1
4 years ago
Add JSON logging via jsonlog log_destination
3312
Moved to different CF
System Administration
15
Not processed
Michael Paquier (michael-kun), Sehrope Sarkuni (sehrope)
Michael Paquier (michael-kun)
3
4 years ago
psql: \dl+ to list large objects privileges
3313
Moved to different CF
libpq
Not processed
Pavel Luzanov (pluzanov)
Daniel Gustafsson (d_gustafsson), Georgios Kokolatos (gkokolatos)
Tom Lane (tgl)
3
4 years ago
Support pg_ident mapping for LDAP
3314
Moved to different CF
Not processed
Jacob Champion (jchampion)
Magnus Hagander (mha)
5
4 years ago
improve pg_receivewal code
3315
Committed
Refactoring Only
Not processed
Bharath Rupireddy (bharathrupireddy)
Ronan Dunklau (rdunklau)
Michael Paquier (michael-kun)
1
4 years ago
Asynchronous and "direct" IO support for PostgreSQL
3316
Moved to different CF
Performance
Not processed
Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice)
6
3 years ago
pg_receivewal: remove extra conn = NULL; in StreamLog
3317
Committed
Refactoring Only
Not processed
Bharath Rupireddy (bharathrupireddy)
Daniel Gustafsson (d_gustafsson)
Daniel Gustafsson (d_gustafsson)
1
4 years ago
Check for STATUS_DELETE_PENDING on Windows
3326
Moved to different CF
Bugfix
Not processed
Thomas Munro (macdice)
Thomas Munro (macdice)
3
4 years ago