Commitfest 2024-03 (2024-03-01 – 2024-04-08)
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
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
More scalable multixacts buffers and locking
2627
Committed
Performance
Not processed
Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness)
Álvaro Herrera (alvherre)
20
1 year 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
Function to log backtrace of postgres processes
2863
Returned with feedback
Not processed
vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy)
Christoph Berg (myon), Maciek Sakrejda (msakrejda)
17
2 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
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
Extend postgres_fdw_get_connections() to print the user_name
3388
Moved to different CF
Monitoring
Not processed
Hayato Kuroda (ha-kun)
Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Shinya Kato (shinyakato), Yuta Katsuragi (katsuragiy)
Fujii Masao (masaofujii)
15
1 year ago
Add pg_stat_session
3405
Moved to different CF
Monitoring
Needs rebase!
Rafia Sabih (rafia.sabih), Sergey Dudoladov (sdudoladov)
Bertrand Drouvot (bdrouvot), Atsushi Torikoshi (atsushitorikoshi), Andrei Zubkov (zubkov), Sadeq Dousti (msdousti)
19
11 months ago
In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal)
3461
Moved to different CF
Performance
Not processed
Kyotaro Horiguchi (horiguti)
Heikki Linnakangas (heikki), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom)
16
1 year ago
AcquireExecutorLocks() and run-time pruning
3478
Moved to different CF
Performance
Needs rebase!
Amit Langote (amitlan)
Tom Lane (tgl)
Amit Langote (amitlan)
17
4 months ago
warn if GUC set to an invalid shared library
3482
Moved to different CF
System Administration
Not processed
Justin Pryzby (justinpryzby)
Christoph Berg (myon), cary huang (caryh), Maciek Sakrejda (msakrejda), Cary Huang (cary)
14
1 year ago
Speed up releasing of locks
3501
Moved to different CF
Performance
Not processed
Andres Freund (andresfreund), David Rowley (davidrowley)
Heikki Linnakangas (heikki)
13
2 years ago
Add non-blocking version of PQcancel
3511
Committed
libpq
17
Not processed
Jelte Fennema-Nio (jeltef)
Denis Laxalde (dlax)
Álvaro Herrera (alvherre)
11
1 year ago
Support logical replication of DDL commands
3595
Withdrawn
Not processed
Zheng Li (zhengli), vigneshwaran C (vignesh.postgres), Ajin Cherian (ajinc), Zhijie Hou (houzj), Runqi Tian (runqitian)
Amit Kapila (amitkapila), Peter Smith (smithpb2250)
10
2 years ago
Add SPLIT PARTITION/MERGE PARTITIONS commands
3659
Moved to different CF
SQL Commands
19
10/10
+8227−46
Dmitry Koval (d.koval)
stephane tachoires (sttachoires)
Alexander Korotkov (smagen)
17
2 months ago
Switching XLog source from archive to streaming when primary available
3663
Moved to different CF
Not processed
Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan)
Nathan Bossart (bossartn)
13
1 year ago
nbtree performance improvements through specialization on key shape
3672
Moved to different CF
Performance
Not processed
Matthias van de Meent (mmeent)
14
1 year ago
Add sortsupport for range types and btree_gist
3686
Moved to different CF
Performance
Not processed
Christoph Heiss (christoph.heiss)
Tomas Vondra (fuzzycz), Bernd Helmle (psoo)
12
1 year ago
Improve dead tuple storage for lazy vacuum
3687
Committed
Performance
Not processed
Masahiko Sawada (masahikosawada), John Naylor (john.naylor)
Masahiko Sawada (masahikosawada)
10
1 year ago
Reducing planning time when tables have many partitions
3701
Moved to different CF
Performance
7/7
+446−120
Yuya Watari (watari)
Tom Lane (tgl), Thom Brown (thom), Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), newtglobal postgresql_contributors (newtpostgrescontributors)
David Rowley (davidrowley)
15
11 months ago
ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables
3705
Moved to different CF
Performance
Not processed
Justin Pryzby (justinpryzby)
Bertrand Drouvot (bertranddrouvot.pg)
13
1 year ago
CI and test improvements
3709
Moved to different CF
Testing
Not processed
Justin Pryzby (justinpryzby)
14
1 year ago
ALTER TABLE SET ACCESS METHOD on partitioned tables
3727
Committed
Not processed
Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc)
Álvaro Herrera (alvherre)
Álvaro Herrera (alvherre)
10
2 years ago
Amcheck verification of GiST and GIN
3733
Moved to different CF
Monitoring
6/7
+1508−215
Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko)
José Villanova (azlev), Mark Dilger (mark.dilger)
Tomas Vondra (fuzzycz)
15
1 year ago
BCP 47 locale names for Windows
3772
Moved to different CF
Not processed
Thomas Munro (macdice)
8
1 year ago
Patch to implement missing join selectivity estimation for range types
3821
Moved to different CF
Not processed
Mahmoud SAKR (mahmsakr), Diogo Repas (diogo.repas), Maxime Schoemans (mschoema), Zhicheng Luo (zcsysu.163.com)
Damir Belyalov (xhevx), Alena Rybakina (a.rybakina)
10
2 years ago
logical decoding and replication of sequences, take 2
3823
Moved to different CF
Not processed
Tomas Vondra (fuzzycz)
Dilip Kumar (dilip.kumar), Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat)
10
2 years ago
Add the ability to limit the amount of memory that can be allocated to backends.
3867
Moved to different CF
Not processed
Reid Thompson (jreidthompsoncd), John Morris (coyotebush)
11
2 years ago
pg_rewind WAL deletion pitfall
3874
Moved to different CF
Bugfix
Not processed
Alexander Kukushkin (cyberdem0n), Polina Bungina (hughcapet)
Kyotaro Horiguchi (horiguti), Atsushi Torikoshi (atsushitorikoshi), moro dream (morod)
Álvaro Herrera (alvherre)
12
1 year ago
Multi-version ICU
3956
Moved to different CF
Not processed
Thomas Munro (macdice)
10
2 years ago
Post-special Page Storage TDE support (aka Reserved Page Size)
3986
Moved to different CF
Not processed
David Christensen (davidchristensen)
12
1 year ago
SetLatches()
3998
Moved to different CF
Refactoring Only
Not processed
Thomas Munro (macdice)
12
1 year ago
Transaction timeout
4040
Committed
Not processed
Andrey Borodin (x4mmm)
Nathan Bossart (bossartn), Nik Samokhvalov (nikolay), yuhang qiu (qyh), Tung Nguyen (tngngn)
Alexander Korotkov (smagen)
7
2 years ago
Improve WALRead() to suck data directly from WAL buffers when possible
4060
Committed
Not processed
Bharath Rupireddy (bharathrupireddy)
Nathan Bossart (bossartn)
Jeff Davis (jdavis)
7
1 year ago
Check lateral references within PHVs for memoize cache keys
4067
Moved to different CF
Performance
Not processed
Richard Guo (richardguo)
Paul Jungwirth (pjungwir)
Richard Guo (richardguo)
8
1 year ago
MERGE INTO updatable_view
4076
Committed
SQL Commands
Not processed
Dean Rasheed (deanr)
Vik Fearing (xocolatl)
Dean Rasheed (deanr)
7
2 years ago
recovery modules
4082
Moved to different CF
System Administration
18
Not processed
Nathan Bossart (bossartn)
8
1 year ago
MERGE ... WHEN NOT MATCHED BY SOURCE
4092
Committed
SQL Commands
Not processed
Dean Rasheed (deanr)
Vik Fearing (xocolatl)
Dean Rasheed (deanr)
7
2 years ago
Lock updated tuples in tuple_update() and tuple_delete()
4099
Moved to different CF
Refactoring Only
Not processed
Alexander Korotkov (smagen)
Andres Freund (andresfreund), Chris Travers (einhverfr), vigneshwaran C (vignesh.postgres), Pavel Borisov (pborisov)
Alexander Korotkov (smagen)
9
2 years ago
MERGE ... RETURNING
4168
Committed
SQL Commands
Not processed
Dean Rasheed (deanr)
Jeff Davis (jdavis), Gurjeet Singh (gurjeet)
Dean Rasheed (deanr)
6
2 years ago
archive modules loose ends
4192
Committed
Not processed
Nathan Bossart (bossartn)
Yong Li (yoli)
Nathan Bossart (bossartn)
6
2 years ago
Evaluate arguments of correlated SubPlans in the referencing ExprState
4209
Moved to different CF
Performance
Not processed
Andres Freund (andresfreund)
Tom Lane (tgl), Alena Rybakina (alenka)
Andres Freund (andresfreund)
7
1 year ago
Make async slave to wait for lsn to be replayed
4221
Moved to different CF
18
Not processed
Ivan Kartyshov (fenimorkin)
Bharath Rupireddy (bharathrupireddy)
Alexander Korotkov (smagen)
8
1 year ago
Use libpq single row mode for FETCH_COUNT when a cursor cannot be used
4233
Committed
libpq
Not processed
Daniel Vérité (danielverite)
Tom Lane (tgl), Laurenz Albe (laurenz)
Tom Lane (tgl)
6
1 year ago
Add XMLCanonicalize function
4237
Moved to different CF
SQL Commands
19
10/10
+509−0
Jim Jones (jimus)
Pavel Stehule (okbobcz), Oliver Ford (ojford), newtglobal postgresql_contributors (newtpostgrescontributors)
15
3 days ago
Add some checks to avoid stack overflow
4239
Committed
Bugfix
17
Not processed
Heikki Linnakangas (heikki), Egor Chindyaskin (egorchin21)
Robert Haas (rhaas), Tom Lane (tgl), Andres Freund (andresfreund), Alexander Korotkov (smagen)
Alexander Korotkov (smagen)
5
2 years ago
Cross-database SERIALIZABLE safe snapshots
4240
Moved to different CF
Performance
Not processed
Thomas Munro (macdice)
Heikki Linnakangas (heikki)
9
2 years ago
Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE
4248
Moved to different CF
Not processed
David Geier (geidav)
Heikki Linnakangas (heikki), Masahiro Ikeda (masahiro.ikeda)
David Rowley (davidrowley)
6
1 year ago
bytea PL/Perl transform
4252
Moved to different CF
Not processed
Ivan Panchenko (wao)
Pavel Stehule (okbobcz)
7
2 years ago
pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value
4267
Committed
Not processed
Yugo Nagata (yugo.nagata)
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
5
2 years ago
A new strategy for pull-up correlated ANY_SUBLINK
4268
Committed
Performance
17
Not processed
Andy Fan (andyf)
Alena Rybakina (a.rybakina)
Alexander Korotkov (smagen)
5
2 years ago
Permute underscore separated components of columns before fuzzy matching
4282
Moved to different CF
Not processed
Arne Roland (harks)
Mikhail Gribkov (youzhick)
7
2 years ago
Support Right Semi Join
4284
Moved to different CF
Performance
Not processed
Richard Guo (richardguo)
wenhui qiu (wenhuiqiu), Wen Yi (wenyi)
Richard Guo (richardguo)
6
1 year ago
Revise get_cheapest_parallel_safe_total_inner
4285
Moved to different CF
Refactoring Only
10/10
+11−4
Richard Guo (richardguo)
wenhui qiu (wenhuiqiu)
11
1 year ago
Add instrumentation showing if Heap2/PRUNE records came from VACUUM or from opportunistic pruning
4288
Committed
Monitoring
Not processed
Peter Geoghegan (pgeoghegan)
Melanie Plageman (melanieplageman)
Heikki Linnakangas (heikki)
5
2 years ago
Logging parallel worker draught
4291
Moved to different CF
Monitoring
19
10/10
+95−0
Benoit Lobréau (benoitl)
Sami Imseih (simseih)
13
2 months ago
Skip hidden files in serverside utilities
4301
Committed
Not processed
Daniel Gustafsson (d_gustafsson)
Tobias Bussmann (t.bussmann)
Daniel Gustafsson (d_gustafsson)
5
2 years ago
SQL:2011 application time
4308
Moved to different CF
SQL Commands
Needs rebase!
Paul Jungwirth (pjungwir)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
10
10 months ago
Unlinking Parallel Hash Join inner batch files sooner
4314
Moved to different CF
Needs rebase!
Thomas Munro (macdice)
Ben Mejia (benmejia)
11
2 months ago
Avoid unnecessary PlaceHolderVars for simple Vars
4319
Moved to different CF
Performance
Not processed
Richard Guo (richardguo)
James Coleman (jcole1989)
Richard Guo (richardguo)
9
1 year ago
Detect test suite sideeffects in pg_regress
4321
Withdrawn
Testing
Not processed
Daniel Gustafsson (d_gustafsson)
5
2 years ago
Refactor pipe_read_line as a more generic interface for reading arbitrary strings off a pipe
4323
Committed
Refactoring Only
Not processed
Daniel Gustafsson (d_gustafsson)
Heikki Linnakangas (heikki)
Daniel Gustafsson (d_gustafsson)
5
2 years ago
XLog size reductions: smaller XLogRecordBlockHeader
4324
Moved to different CF
Performance
Not processed
Matthias van de Meent (mmeent)
Wen Yi (wenyi)
7
2 years ago
Use atomic ops for unlogged LSN
4330
Committed
Refactoring Only
17
Not processed
John Morris (coyotebush)
Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy)
Nathan Bossart (bossartn)
5
2 years ago
Doc limitations update proposal: include out-of-line OID usage per TOAST-ed columns
4332
Moved to different CF
Docs Only
stable
Not processed
Jakub Wartak (jakub.wartak.tomtom)
John Naylor (john.naylor)
John Naylor (john.naylor)
7
1 year ago
Incremental View Maintenance (IVM), take 2
4337
Moved to different CF
SQL Commands
Needs rebase!
Yugo Nagata (yugo.nagata)
Alexandre Felipe (afelipe)
16
1 month ago
pg_upgrade, pg_combinebackup --copy-file-range
4338
Moved to different CF
Performance
Not processed
Tomas Vondra (fuzzycz), Thomas Munro (macdice), Jakub Wartak (jakub.wartak.tomtom)
Tomas Vondra (fuzzycz), Jakub Wartak (jakub.wartak.tomtom)
Tomas Vondra (fuzzycz)
4
1 year ago
Logging plan of the currently running query
4345
Moved to different CF
Monitoring
Not processed
Atsushi Torikoshi (atsushitorikoshi)
Andrei Lepikhov (lepikhov), James Coleman (jcole1989)
7
2 weeks ago
Index Prefetching
4351
Moved to different CF
Performance
6/10
+5138−2325
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz)
14
16 hours ago
Index-only filters without IOS
4352
Moved to different CF
Performance
Not processed
Tomas Vondra (fuzzycz)
Jeff Davis (jdavis), James Coleman (jcole1989)
6
2 years ago
Add last_commit_lsn to pg_stat_database
4355
Moved to different CF
Monitoring
Not processed
James Coleman (jcole1989)
Wen Yi (wenyi)
9
1 year ago
abidiff tests
4358
Withdrawn
Testing
Not processed
Peter Eisentraut (petere)
Christoph Berg (myon)
5
2 years ago
Built-in collation provider for "C" and "C.UTF-8"
4365
Committed
17
Not processed
Jeff Davis (jdavis)
Peter Eisentraut (petere), Daniel Vérité (danielverite)
Jeff Davis (jdavis)
5
2 years ago
ltree hash functions
4375
Committed
Not processed
Tommy Pavlicek (tommyp)
Tom Lane (tgl)
5
2 years ago
Refactor fork+exec code
4376
Committed
Refactoring Only
Not processed
Heikki Linnakangas (heikki)
Heikki Linnakangas (heikki)
5
1 year ago
Remaining sql/json patches
4377
Committed
SQL Commands
Not processed
Amit Langote (amitlan), Nikita Glukhov (n.glukhov)
Amit Langote (amitlan)
5
1 year ago
Parent/child context relation in pg_get_backend_memory_contexts()
4379
Moved to different CF
Monitoring
Not processed
Melih Mutlu (melihmutlu)
Atsushi Torikoshi (atsushitorikoshi)
David Rowley (davidrowley)
6
1 year ago
Opportunistically pruning page before insert
4384
Moved to different CF
Performance
Not processed
James Coleman (jcole1989)
Melanie Plageman (melanieplageman)
7
2 years ago
XLog size reductions: Reduced XLog record header size
4386
Moved to different CF
Performance
Not processed
Matthias van de Meent (mmeent)
6
1 year ago
UUID v7
4388
Moved to different CF
17
Not processed
Andrey Borodin (x4m)
Masahiko Sawada (masahikosawada), Aleksander Alekseev (a.alekseev), Chris Travers (einhverfr), Nik Samokhvalov (nikolay), Przemysław Sztoch (psztoch), Kirk Wolak (kirkw)
Masahiko Sawada (masahikosawada)
9
1 year ago
add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl
4390
Moved to different CF
Security
Needs rebase!
Cary Huang (cary)
Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion)
12
9 months ago
pgbench: allow to cancel queries during benchmark
4399
Moved to different CF
libpq
Not processed
Yugo Nagata (yugo.nagata)
Fabien Coelho (calvin)
7
2 years ago
Add bump memory context type and use it for tuplesorts
4406
Committed
Performance
Not processed
David Rowley (davidrowley)
Nathan Bossart (bossartn), Matthias van de Meent (mmeent)
David Rowley (davidrowley)
5
1 year ago
Client authentication via OAuth 2.0
4412
Moved to different CF
Security
7/7
+0−0
Jacob Champion (jchampion)
Peter Eisentraut (petere), Daniel Gustafsson (d_gustafsson), Antonin Houska (a.houska)
Daniel Gustafsson (d_gustafsson)
10
7 months ago
vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases
4417
Committed
libpq
17
Not processed
Nathan Bossart (bossartn)
Dean Rasheed (deanr)
Nathan Bossart (bossartn)
5
2 years ago
Use ReadRecentBuffer() for btree root page
4419
Moved to different CF
Performance
Not processed
Thomas Munro (macdice)
7
2 years ago
Synchronizing slots from primary to standby
4423
Committed
17
Not processed
Bertrand Drouvot (bertranddrouvot.pg)
Dilip Kumar (dilip.kumar)
Amit Kapila (amitkapila)
5
1 year ago
Revises for the check of parameterized partial paths
4425
Moved to different CF
Refactoring Only
Not processed
Richard Guo (richardguo)
Richard Guo (richardguo)
6
1 year ago
Extension Enhancement: Buffer Invalidation in pg_buffercache
4426
Committed
Not processed
Palak Chaturvedi (palak)
Cédric Villemain (c2main)
Thomas Munro (macdice)
5
1 year ago
Custom storage managers (SMGR), redux
4428
Moved to different CF
Not processed
Matthias van de Meent (mmeent), Tristan Partin (tristan957)
Kirill Reshke (reshke), Krishnakumar Ravi (kkpgdev)
7
2 months ago
pg_stat_logmsg
4431
Moved to different CF
Not processed
Joe Conway (jconway)
7
1 year ago
Forcing new tuples of updates off the page
4440
Withdrawn
Not processed
Matthias van de Meent (mmeent)
Laurenz Albe (laurenz)
4
2 years ago
Replace a large number of OR clauses with ANY expression
4450
Moved to different CF
Performance
17
Not processed
Andrei Lepikhov (lepikhov), Alena Rybakina (alenka)
Nikolay Shaplov (nataraj), Ranier Vilela (raniervilela)
Alexander Korotkov (smagen)
7
1 year ago
Flush disk write caches by default on macOS and Windows
4453
Moved to different CF
Not processed
Thomas Munro (macdice)
Nathan Bossart (bossartn)
6
1 year ago
Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans
4455
Committed
Performance
Not processed
Peter Geoghegan (pgeoghegan)
Matthias van de Meent (mmeent)
Peter Geoghegan (pgeoghegan)
4
1 year ago
pg_tracing
4456
Moved to different CF
Not processed
Anthonin Bonnefoy (bonnefoa)
Nikita Malakhov (nmalakh)
5
2 years ago
Retiring is_pushed_down
4458
Moved to different CF
Refactoring Only
Needs rebase!
Richard Guo (richardguo)
Tom Lane (tgl)
10
1 year ago
Implement row pattern recognition feature
4460
Moved to different CF
SQL Commands
19
Needs rebase!
Tatsuo Ishii (ishii), Henson Choi (assam258.gmail.com)
Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033), Henson Choi (assam258.gmail.com)
14
9 hours ago
Allow SIGINT to cancel psql database reconnections
4474
Committed
Bugfix
Not processed
Tristan Partin (tristan957)
Robert Haas (rhaas)
4
2 years ago
Extract numeric field in JSONB more effectively
4476
Moved to different CF
Performance
Not processed
Andy Fan (andyf)
Chapman Flack (chap)
8
2 days ago
Postpone reparameterization of paths until when creating plans
4477
Committed
Bugfix
Not processed
Richard Guo (richardguo)
Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina)
Tom Lane (tgl)
4
2 years ago
Add pg_wait_for_lockers() function
4480
Moved to different CF
Not processed
Will Mortensen (will-extrahop)
5
1 year ago
Simplify create_merge_append_path a bit for clarity
4496
Moved to different CF
Refactoring Only
Not processed
Richard Guo (richardguo)
Paul Jungwirth (pjungwir)
Richard Guo (richardguo)
5
1 year ago
logicalrep_worker_launch - counting/checking the type limits
4499
Withdrawn
Not processed
Peter Smith (smithpb2250)
4
2 years ago
Memory consumed by child SpecialJoinInfo in partitionwise join planning
4500
Committed
Performance
Not processed
Ashutosh Bapat (ashutoshbapat)
Amit Langote (amitlan)
Amit Langote (amitlan)
4
2 years ago
Support run-time partition pruning for hash join
4512
Moved to different CF
17
Not processed
Richard Guo (richardguo)
6
1 year ago
Support prepared statement invalidation when result or argument types change
4518
Moved to different CF
Not processed
Jelte Fennema-Nio (jeltef)
Euler Taveira (eulerto)
5
1 year ago
CI speed improvements for FreeBSD
4520
Committed
Testing
Not processed
Thomas Munro (macdice)
Maxim Orlov (m.orlov)
Thomas Munro (macdice)
4
2 years ago
CREATE SUBSCRIPTION ... SERVER
4529
Moved to different CF
DDL
Needs rebase!
Jeff Davis (jdavis)
Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy)
Jeff Davis (jdavis)
12
1 week ago
Change tuple table slot for Unique node to "virtual"
4531
Withdrawn
Performance
Not processed
Denis Smirnov (darthunix)
Heikki Linnakangas (heikki)
4
2 years ago
Streaming I/O, vectored I/O
4532
Committed
Performance
Not processed
Thomas Munro (macdice)
Heikki Linnakangas (heikki), Melanie Plageman (melanieplageman), Nazir Bilal Yavuz (nbyavuz)
Thomas Munro (macdice)
4
1 year ago
Add pg_get_owned_sequence function
4535
Moved to different CF
Not processed
Dagfinn Ilmari Mannsåker (ilmari)
Nathan Bossart (bossartn)
5
2 years ago
Statistics Import and Export
4538
Moved to different CF
Performance
7/7
+267−64
Corey Huinker (coreyh)
Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy)
Jeff Davis (jdavis)
9
10 months ago
Reduce size of postgres.bki
4544
Moved to different CF
Not processed
Matthias van de Meent (mmeent)
4
1 year ago
Should consider materializing the cheapest inner path in consider_parallel_nestloop()
4549
Moved to different CF
Performance
Not processed
Tender Wang (tndrwang)
Robert Haas (rhaas), Richard Guo (richardguo), Yuki Fujii (fujiiyuki)
Richard Guo (richardguo)
4
1 year ago
Reuse child_relids in try_partitionwise_join
4553
Moved to different CF
Performance
Not processed
Ashutosh Bapat (ashutoshbapat)
Richard Guo (richardguo)
Richard Guo (richardguo)
4
1 year ago
Separate memory contexts for relcache and catcache
4554
Moved to different CF
Monitoring
Not processed
Melih Mutlu (melihmutlu)
Atsushi Torikoshi (atsushitorikoshi)
6
1 year ago
Build the docs if there are changes in docs and don't run other tasks if the changes are only in docs
4555
Moved to different CF
Testing
Not processed
Nazir Bilal Yavuz (nbyavuz)
4
1 year ago
pg_rewind with cascade standby doesn't work well
4559
Moved to different CF
Not processed
Masaki Kuwamura (mackyson)
Ilya Gladyshev (qoops)
5
1 year ago
Reducing memory consumed by RestrictInfo list translations in partitionwise join planning
4564
Moved to different CF
Performance
7/7
+389−77
Ashutosh Bapat (ashutoshbapat)
Amit Langote (amitlan)
8
1 year ago
Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set
4566
Committed
17
Not processed
Nathan Bossart (bossartn), Tung Nguyen (tngngn)
Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
3
2 years ago
Add pg_basetype() function to obtain a DOMAIN base type
4568
Committed
Not processed
Steve Chávez (steve-chavez)
Tom Lane (tgl)
Tom Lane (tgl)
3
2 years ago
SET ROLE documentation improvement
4572
Moved to different CF
Docs Only
17
Not processed
Nathan Bossart (bossartn), Yurii Rashkovskii (yrashk)
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
4
1 year ago
pg_ctl start may return 0 even if the postmaster has been already started on Windows
4573
Moved to different CF
Bugfix
Windows
10/10
+369−153
Kyotaro Horiguchi (horiguti)
Hayato Kuroda (ha-kun), Yasir Shah (yasir.hussain.shah.gmail.com)
12
2 months ago
Relation bulk write facility
4575
Committed
Refactoring Only
Not processed
Heikki Linnakangas (heikki)
Heikki Linnakangas (heikki)
3
2 years ago
Various small unrelated doc patches: plpgsql, schemas, permissions, oidvector
4581
Moved to different CF
Docs Only
Not processed
Karl Pinc (kop)
Robert Treat (xzilla)
5
2 years ago
Mark expressions nullable by grouping sets
4583
Moved to different CF
Bugfix
Not processed
Richard Guo (richardguo)
Tom Lane (tgl)
Richard Guo (richardguo)
5
1 year ago
Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE
4587
Committed
libpq
17
Not processed
vigneshwaran C (vignesh.postgres)
Suraj Khamkar (suraj.khamkar), Shubham Khanna (skhanna)
Masahiko Sawada (masahikosawada)
3
1 year ago
HOT - correct claim about indexes not referencing old line pointers
4597
Committed
Docs Only
Not processed
James Coleman (jcole1989)
Peter Geoghegan (pgeoghegan), Robert Haas (rhaas), David Johnston (polobo)
Robert Haas (rhaas)
3
2 years ago
Document that triggers can break foreign key constraints
4599
Moved to different CF
Docs Only
Not processed
Laurenz Albe (laurenz)
Aleksander Alekseev (a.alekseev), David Johnston (polobo), shihao zhong (zhong950419)
Tom Lane (tgl)
4
1 year ago
Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block
4606
Moved to different CF
17
Not processed
Zongliang Quan (quanzl)
jian he (universality)
4
1 year ago
Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING
4617
Moved to different CF
Not processed
Marko Tiikkaja (johto)
5
1 year ago
Force the old transactions logs cleanup even if checkpoint is skipped
4619
Moved to different CF
Not processed
Daniil Zakhlystov (daniil.zakhlystov)
4
2 years ago
CRC32C Parallel Computation Optimization on ARM
4620
Moved to different CF
Performance
Needs rebase!
xiang gao (xiang.gao)
Nathan Bossart (bossartn), John Naylor (john.naylor)
8
1 year ago
Index Insert Prefetching
4622
Moved to different CF
Performance
Not processed
Tomas Vondra (fuzzycz)
4
2 years ago
SLRU optimizations
4626
Committed
Performance
Not processed
Dilip Kumar (dilip.kumar), Andrey Borodin (x4m)
Álvaro Herrera (alvherre)
3
2 years ago
Special-case executor expression steps for common combinations
4627
Moved to different CF
Performance
7/7
+194−39
Andres Freund (andresfreund), Daniel Gustafsson (d_gustafsson)
Andreas Karlsson (kandreas)
Daniel Gustafsson (d_gustafsson)
8
1 year ago
nbtree: implement dynamic prefix truncation
4635
Moved to different CF
Performance
Not processed
Matthias van de Meent (mmeent)
7
1 year ago
speed up a logical replication setup (pg_createsubscriber)
4637
Committed
17
Not processed
Euler Taveira (eulerto)
Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat), Hayato Kuroda (ha-kun)
Peter Eisentraut (petere)
3
2 years ago
nbtree: downlink right separator/HIKEY optimization
4638
Moved to different CF
Performance
Not processed
Matthias van de Meent (mmeent)
7
2 years ago
Add EXCLUDE COLLATE in CREATE/ALTER TABLE document
4639
Committed
Docs Only
17
Not processed
shihao zhong (zhong950419)
Daniel Vérité (danielverite), Shubham Khanna (skhanna)
Tom Lane (tgl)
3
1 year ago
Properly pathify the UNION planner
4642
Committed
Performance
Not processed
David Rowley (davidrowley)
Richard Guo (richardguo)
David Rowley (davidrowley)
3
2 years ago
Make it possible to add custom options to EXPLAIN
4643
Moved to different CF
Monitoring
Not processed
Konstantin Knizhnik (knizhnik)
Pavel Stehule (okbobcz)
5
1 year ago
make pg_ctl more friendly
4645
Moved to different CF
Not processed
Zhao Junwang (zhjwpku), TianXiang Li (krisdiano)
Laurenz Albe (laurenz), Nathan Bossart (bossartn), Nazir Bilal Yavuz (nbyavuz)
Tom Lane (tgl)
3
1 year ago
Mark search_path as GUC_REPORT
4646
Moved to different CF
Not processed
Alexander Kukushkin (cyberdem0n), Jelte Fennema-Nio (jeltef)
Tomas Vondra (fuzzycz)
4
1 year ago
autovectorize page checksum code included elsewhere
4649
Moved to different CF
Performance
18
Not processed
Nathan Bossart (bossartn)
3
2 years ago
Support for named parsed statement in psql
4650
Moved to different CF
libpq
Not processed
Anthonin Bonnefoy (bonnefoa)
Jelte Fennema-Nio (jeltef)
Michael Paquier (michael-kun)
4
1 year ago
locked reads for atomics
4654
Committed
17
Not processed
Nathan Bossart (bossartn)
Yong Li (yoli)
Nathan Bossart (bossartn)
2
2 years ago
Add minimal C example and SQL registration example for custom table access methods.
4655
Moved to different CF
Docs Only
Not processed
Phil Eaton (eatonphil)
Robert Haas (rhaas)
Michael Paquier (michael-kun)
4
1 year ago
Add detail regarding resource consumption wrt max_connections
4658
Moved to different CF
Docs Only
Not processed
Roberto Mello (rmello)
Robert Treat (xzilla)
Robert Haas (rhaas)
3
1 year ago
pgbench log file headers
4660
Returned with feedback
libpq
17
Not processed
Adam Hendel (adamhendel)
2
2 years ago
GUC hashtable optimizations
4663
Committed
Performance
17
Not processed
Jeff Davis (jdavis), John Naylor (john.naylor)
John Naylor (john.naylor)
2
1 year ago
Propagate pathkeys from CTEs up to the outer query
4667
Committed
Performance
Not processed
Richard Guo (richardguo)
Tom Lane (tgl)
Tom Lane (tgl)
2
2 years ago
common signal handler protection
4669
Committed
17
Not processed
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
2
2 years ago
add AVX2 support to simd.h
4675
Committed
Performance
17
Not processed
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
2
2 years ago
Sequence Access Methods, round two
4677
Moved to different CF
Needs rebase!
Michael Paquier (michael-kun)
12
2 months ago
Catalog domain not-null constraints
4678
Committed
SQL Commands
Not processed
Peter Eisentraut (petere)
Aleksander Alekseev (a.alekseev)
Peter Eisentraut (petere)
2
1 year ago
Extend pgbench partitioning to pgbench_history
4679
Moved to different CF
libpq
Not processed
Gabriele Bartolini (gbartolini)
Abhijit Menon-Sen (ams)
3
1 year ago
LockAcquireExtended improvement
4680
Committed
Bugfix
17
Not processed
Jingxian Li (jingxian)
Robert Haas (rhaas)
2
2 years ago
Make COPY format extendable: Extract COPY TO format implementations
4681
Moved to different CF
SQL Commands
Needs rebase!
Kouhei Sutou (kou)
Masahiko Sawada (masahikosawada), Zhao Junwang (zhjwpku), Yong Li (yoli)
11
1 week ago
Thread-safe gai_strerror() for Windows
4682
Committed
Bugfix
Not processed
Thomas Munro (macdice)
Thomas Munro (macdice)
2
2 years ago
Fix comment about cross-checking the varnullingrels
4683
Moved to different CF
Comments Only
Not processed
Richard Guo (richardguo)
Matt Skelley (mattwasere)
Richard Guo (richardguo)
3
1 year ago
Reducing serialized size of Nodes from nodeToString output
4685
Returned with feedback
Not processed
Matthias van de Meent (mmeent)
Peter Eisentraut (petere)
2
2 years ago
New [relation] options engine
4688
Moved to different CF
Refactoring Only
Needs rebase!
Nikolay Shaplov (nataraj)
10
2 months ago
Teach predtest about IS [NOT] <boolean> proofs
4690
Moved to different CF
Performance
10/10
+1882−129
James Coleman (jcole1989)
Tom Lane (tgl)
8
1 year ago
automating RangeTblEntry node support
4697
Committed
Refactoring Only
Not processed
Peter Eisentraut (petere)
Paul Jungwirth (pjungwir)
Peter Eisentraut (petere)
2
2 years ago
Improve eviction algorithm in ReorderBuffer
4699
Committed
Not processed
Masahiko Sawada (masahikosawada)
Jeff Davis (jdavis)
Masahiko Sawada (masahikosawada)
2
1 year ago
Make attstattarget nullable
4700
Committed
Refactoring Only
Not processed
Peter Eisentraut (petere)
Álvaro Herrera (alvherre)
Peter Eisentraut (petere)
2
2 years ago
64-bit XIDs
4703
Moved to different CF
Performance
18
Not processed
Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Aleksander Alekseev (a.alekseev), Konstantin Knizhnik (knizhnik), Nikita Glukhov (n.glukhov), Yura Sokolov (funny_falcon), Maxim Orlov (m.orlov), Pavel Borisov (pborisov)
Chris Travers (einhverfr), wenhui qiu (wenhuiqiu)
4
1 year ago
Add SQL syntax check
4704
Moved to different CF
Not processed
Josef Šimánek (retro)
3
1 year ago
Quick Start Guide to PL/pgSQL and PL/Python Documentation
4705
Withdrawn
Docs Only
17
Not processed
Ishaan Adarsh (requi3m)
2
2 years ago
psql JSON output format
4707
Moved to different CF
Not processed
Christoph Berg (myon)
Laurenz Albe (laurenz)
3
1 year ago
Making the initial and maximum DSA segment sizes configurable
4708
Committed
Not processed
Masahiko Sawada (masahikosawada)
Masahiko Sawada (masahikosawada)
2
2 years ago
Add the page header to each SLRU page.
4709
Moved to different CF
Not processed
Rishu Bagga (rishubagga), Yong Li (yoli)
Thomas Munro (macdice), Shawn Debnath (sd)
6
1 year ago
Fix COPY FROM...CSV importing \. on a line by itself
4710
Moved to different CF
Bugfix
Not processed
Daniel Vérité (danielverite)
Tom Lane (tgl)
Tom Lane (tgl)
4
1 year ago
Adjust tuples estimate for appendrel
4711
Moved to different CF
Performance
Not processed
Richard Guo (richardguo)
4
2 years ago
Improve pg_dump/pg_restore/pg_upgrade handling of large objects
4713
Committed
Performance
Not processed
Tom Lane (tgl)
Nathan Bossart (bossartn)
Tom Lane (tgl)
2
2 years ago
Flushing large data immediately in pqcomm
4714
Committed
Not processed
Melih Mutlu (melihmutlu)
Heikki Linnakangas (heikki)
David Rowley (davidrowley)
2
1 year ago
Union Replacement of OR logic
4715
Moved to different CF
16
Not processed
3
1 year ago
COPY TO json
4716
Moved to different CF
SQL Commands
10/10
+620−65
Joe Conway (jconway)
Masahiko Sawada (masahikosawada), Richard Yen (richyen)
Andrew Dunstan (adunstan)
10
2 weeks ago
Avoid computing ORDER BY junk columns unnecessarily
4717
Returned with feedback
Performance
Not processed
Heikki Linnakangas (heikki)
2
2 years ago
Set log_lock_waits=on by default
4718
Moved to different CF
GUC
Monitoring
19
10/10
+4−4
Laurenz Albe (laurenz)
Michael Banck (mbanck)
Peter Eisentraut (petere)
9
6 months ago
"unexpected duplicate for tablespace" problem in logical replication
4720
Moved to different CF
Bugfix
stable
10/10
+58−20
Shenhao Wang (wangshenhao)
Masahiko Sawada (masahikosawada)
Michael Paquier (michael-kun)
8
6 months ago
Proposal to include --exclude-extension Flag in pg_dump
4721
Committed
Not processed
Ayush Vatsa (developerayuva)
Dean Rasheed (deanr)
Dean Rasheed (deanr)
2
2 years ago
Functions to return random numbers in a given range
4722
Committed
Not processed
Dean Rasheed (deanr)
Andreas Karlsson (kandreas)
Dean Rasheed (deanr)
2
2 years ago
RETURNING OLD/NEW values
4723
Moved to different CF
SQL Commands
18
Not processed
Dean Rasheed (deanr)
Dean Rasheed (deanr)
6
1 year ago
An improvement on parallel DISTINCT
4724
Committed
Performance
Not processed
Richard Guo (richardguo)
David Rowley (davidrowley)
2
2 years ago
WIP Incremental Json Parser
4725
Committed
Not processed
Andrew Dunstan (adunstan)
Jacob Champion (jchampion)
Andrew Dunstan (adunstan)
2
1 year ago
Exponential backoff for auth_delay
4727
Returned with feedback
System Administration
Not processed
Michael Banck (mbanck)
Abhijit Menon-Sen (ams), Nathan Bossart (bossartn)
2
1 year ago
Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s)
4728
Moved to different CF
Bugfix
17
Not processed
Amul Sul (sulamul)
Dean Rasheed (deanr), Aleksander Alekseev (a.alekseev)
Álvaro Herrera (alvherre)
3
1 year ago
Tidy fill hstv array (src/backend/access/heap/pruneheap.c)
4734
Returned with feedback
17
Not processed
Ranier Vilela (raniervilela)
2
2 years ago
Support a wildcard in backtrace_functions
4735
Moved to different CF
GUC
Help - Bikeshedding
Needs rebase!
Jelte Fennema-Nio (jeltef)
Daniel Gustafsson (d_gustafsson), Bharath Rupireddy (bharathrupireddy)
Daniel Gustafsson (d_gustafsson)
13
1 year ago
Add new protocol message to change GUCs to be able to change protocol extension parameters
4736
Moved to different CF
18
Needs rebase!
Jelte Fennema-Nio (jeltef)
Robert Haas (rhaas)
7
1 year ago
psql: Rethinking of \du command
4738
Moved to different CF
libpq
10/10
+72−126
Pavel Luzanov (p.luzanov@postgrespro.ru)
David Johnston (polobo), Wen Yi (wenyi)
8
9 months ago
Not to invalidate CatalogSnapshot for local invalidation messages
4739
Rejected
Performance
Not processed
Xiaoran Wang (fanfuxiaoran)
2
2 years ago
Add Index-level REINDEX with multiple jobs
4740
Committed
17
Not processed
Maxim Orlov (m.orlov), Svetlana Derevyanko (getsusun)
Alexander Korotkov (smagen)
2
2 years ago
Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid
4741
Moved to different CF
Not processed
Maxim Orlov (m.orlov)
3
2 years ago
Direct SSL connections
4742
Committed
Not processed
Greg Stark (stark)
Heikki Linnakangas (heikki), Jacob Champion (jchampion)
Heikki Linnakangas (heikki)
2
1 year ago
add function argument names to regex* functions.
4743
Moved to different CF
Not processed
jian he (universality)
Dian Fay (dmfay)
Tom Lane (tgl)
3
1 year ago
change regexp_substr first argument make tests more easier to understand
4744
Moved to different CF
Testing
stable
Not processed
jian he (universality)
4
1 year ago
Simplify documentation related to Windows builds
4745
Moved to different CF
Docs Only
17
Not processed
Michael Paquier (michael-kun)
3
1 year ago
Libpq Compression
4746
Moved to different CF
libpq
Not processed
Jacob Burroughs (maths22)
3
1 year ago
Network failure may prevent promotion
4748
Moved to different CF
Bugfix
7/7
+52−202
Kyotaro Horiguchi (horiguti)
Heikki Linnakangas (heikki)
7
1 year ago
Not to invalidate CatalogSnapshot for local invalidation messages
4750
Moved to different CF
Not processed
Xiaoran Wang (fanfuxiaoran)
jian he (universality)
4
2 years ago
Remove useless GROUP BY columns considering unique index
4751
Moved to different CF
Not processed
Mingli Zhang (zml)
jian he (universality)
4
1 year ago
False positive in bt_index_check in case of short 4B varlena datum
4752
Committed
Bugfix
17
Not processed
Mikhail Zhilin (mizhka-at-pgpro)
Andrey Borodin (x4m)
Alexander Korotkov (smagen)
2
2 years ago
Avoid deadlock and concurrency during orphan temp table removal
4753
Committed
Bugfix
17
Not processed
Mikhail Zhilin (mizhka-at-pgpro)
Akshat Jaimini (akshatj)
Tom Lane (tgl)
2
2 years ago
Add LSN <-> time conversion facility
4754
Moved to different CF
Not processed
Melanie Plageman (melanieplageman)
Daniel Gustafsson (d_gustafsson), Andrey Borodin (x4m)
5
1 year ago
Confine vacuum skip logic to lazy_scan_skip
4755
Committed
Refactoring Only
17
Not processed
Melanie Plageman (melanieplageman)
Heikki Linnakangas (heikki)
Heikki Linnakangas (heikki)
2
5 months ago
Make vacuum opportunistic freezing adaptive
4756
Withdrawn
Performance
Not processed
Melanie Plageman (melanieplageman)
2
2 years ago
shared detoast datum
4759
Moved to different CF
Performance
Not processed
Andy Fan (andy2)
6
1 year ago
verify predefined LWLocks have entries in wait_event_names.txt
4760
Committed
Testing
17
Not processed
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
2 years ago
date_trunc function in interval version
4761
Moved to different CF
Not processed
Przemysław Sztoch (psztoch)
5
1 year ago
Update docs for default value of fdw_tuple_cost
4762
Committed
Docs Only
17
Not processed
Umair Shahid (umairshahid)
Chris Travers (einhverfr)
John Naylor (john.naylor)
1
2 years ago
Change prefetch and read strategies to use range in pg_prewarm
4763
Moved to different CF
Refactoring Only
Not processed
Cédric Villemain (c2main)
Nazir Bilal Yavuz (nbyavuz)
5
1 year ago
Adding comments to help understand psql hidden queries
4764
Moved to different CF
libpq
9/10
+217−100
David Christensen (davidchristensen), Greg Sabino Mullane (greg)
Tom Lane (tgl)
Tom Lane (tgl)
8
1 week ago
cleanup patches for incremental backup
4765
Committed
Bugfix
17
Not processed
Robert Haas (rhaas)
Robert Haas (rhaas)
1
2 years ago
data loss bug in initial sync of logical replication
4766
Moved to different CF
Bugfix
Needs rebase!
Tomas Vondra (fuzzycz)
Nitin Motiani (nitinmotiani), work nsandeepkumar (nsandeepk)
Amit Kapila (amitkapila)
7
11 months ago
Fix txid_status() returning wrong status for some xids
4767
Committed
Bugfix
Not processed
Karina Litskevich (karinalitskevich)
Alexander Korotkov (smagen)
1
2 years ago
A infrastructure to detect misuse of spin lock easier
4768
Moved to different CF
Not processed
Andy Fan (andy2)
3
2 years ago
System username in pg_stat_activity
4769
Moved to different CF
Monitoring
Not processed
Magnus Hagander (mha)
3
2 years ago
Introduce XID age and inactive timeout based replication slot invalidation
4770
Moved to different CF
Needs rebase!
Bharath Rupireddy (bharathrupireddy), Nisha Moond (nishamoond)
Nathan Bossart (bossartn), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal)
Amit Kapila (amitkapila)
6
1 year ago
reorganize "Shared Memory and LWLocks" section of docs
4771
Committed
Docs Only
17
Not processed
Nathan Bossart (bossartn)
Bharath Rupireddy (bharathrupireddy)
Nathan Bossart (bossartn)
1
2 years ago
Added support of XML_PARSE_HUGE flag for XML documents
4772
Rejected
17
Not processed
Dmitry Koval (d.koval)
1
2 years ago
Fix race condition in InvalidatePossiblyObsoleteSlot()
4773
Committed
Bugfix
16
Not processed
Bertrand Drouvot (bertranddrouvot.pg)
Michael Paquier (michael-kun)
1
2 years ago
Postgres and --config-file option
4774
Moved to different CF
Not processed
Aleksander Alekseev (a.alekseev), David Johnston (polobo)
Peter Eisentraut (petere), Nathan Bossart (bossartn), Álvaro Herrera (alvarofherrera)
Michael Paquier (michael-kun)
2
1 year ago
Explicitly show dependent types as extension members
4775
Committed
Bugfix
17
Not processed
Tom Lane (tgl), David Geier (geidav)
Tom Lane (tgl)
1
2 years ago
Allow subtransactions in parallel workers
4776
Committed
Bugfix
Not processed
Tom Lane (tgl)
Robert Haas (rhaas)
Tom Lane (tgl)
1
2 years ago
Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM
4777
Moved to different CF
Not processed
Bharath Rupireddy (bharathrupireddy)
Jeff Davis (jdavis)
5
1 year ago
Fix bugs not to discard statistics when changing stats_fetch_consistency
4778
Committed
Bugfix
stable
Not processed
Shinya Kato (shinyakato)
Michael Paquier (michael-kun)
1
2 years ago
Adding linux cachestat in file Readv and Prefetch
4779
Rejected
Not processed
Cédric Villemain (c2main)
1
2 years ago
Fix two catalog tuple update/delete visibility issues
4780
Committed
Bugfix
Not processed
Tender Wang (tndrwang)
Michael Paquier (michael-kun)
1
2 years ago
GUC-ify WALSender's MAX_SEND_SIZE constant
4781
Moved to different CF
Not processed
Majid Garoosi (magaroo)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
2
1 year ago
Improving EXPLAIN's display of SubPlan nodes
4782
Committed
17
Not processed
Tom Lane (tgl)
Dean Rasheed (deanr), Aleksander Alekseev (aalekseev)
Tom Lane (tgl)
1
2 years ago
cleanup patches for dshash
4783
Committed
17
Not processed
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
2 years ago
Helpful hint for unnecessary table-qualified target column in UPDATE
4784
Committed
Not processed
James Coleman (jcole1989)
Tom Lane (tgl)
Tom Lane (tgl)
1
2 years ago
fix DSM registry coverity complaint
4785
Committed
Bugfix
17
Not processed
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
2 years ago
fix core dump in autoprewarm
4786
Committed
Bugfix
17
Not processed
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
2 years ago
Reordering DISTINCT keys to match input path's pathkeys
4787
Moved to different CF
Performance
Not processed
Richard Guo (richardguo)
Richard Guo (richardguo)
4
1 year ago
psql: Allow editing query results with \gedit
4788
Moved to different CF
libpq
Not processed
Christoph Berg (myon)
2
1 year ago
int4->bool test coverage
4789
Committed
Testing
Not processed
Christoph Berg (myon)
Michael Paquier (michael-kun)
1
2 years ago
Remove IndividualLWLockNames
4790
Committed
Not processed
Álvaro Herrera (alvherre)
Álvaro Herrera (alvherre)
1
2 years ago
meson: Specify -Wformat as a common warning flag for extensions
4791
Moved to different CF
Not processed
Kouhei Sutou (kou)
Tristan Partin (tristan957)
Peter Eisentraut (petere)
2
1 year ago
Split index and table statistics into different types of stats
4792
Moved to different CF
Refactoring Only
Not processed
Bertrand Drouvot (bertranddrouvot.pg)
3
2 years ago
Combine prune and freeze records emitted by vacuum
4793
Committed
Performance
Not processed
Melanie Plageman (melanieplageman)
Heikki Linnakangas (heikki)
Heikki Linnakangas (heikki)
1
2 years ago
Remove potentially redundant smgropen() calls
4794
Committed
Refactoring Only
Not processed
Japin Li (japin)
Heikki Linnakangas (heikki)
1
2 years ago
make dist using git archive
4795
Committed
Not processed
Peter Eisentraut (petere)
Tristan Partin (tristan957)
Peter Eisentraut (petere)
1
2 years ago
A failure in t/038_save_logical_slots_shutdown.pl
4796
Committed
Testing
Not processed
Bharath Rupireddy (bharathrupireddy)
Amit Kapila (amitkapila)
1
2 years ago
add COPY option REJECT_LIMIT
4797
Moved to different CF
SQL Commands
Not processed
Atsushi Torikoshi (atsushitorikoshi)
Fujii Masao (masaofujii), Kirill Reshke (reshke)
Fujii Masao (masaofujii)
4
1 year ago
Add new error_action COPY ON_ERROR "log"
4798
Committed
SQL Commands
17
Not processed
Bharath Rupireddy (bharathrupireddy), Atsushi Torikoshi (atsushitorikoshi)
Masahiko Sawada (masahikosawada)
Masahiko Sawada (masahikosawada)
1
2 years ago
Request for votes: Should we remove -Wdeclaration-after-statement?
4799
Rejected
Not processed
Jelte Fennema-Nio (jeltef)
1
2 years ago
PG DOCS - protocol specifying boolean parameters without values.
4800
Committed
Docs Only
17
Not processed
Peter Smith (smithpb2250)
Tom Lane (tgl)
1
1 year ago
Apply the "LIMIT 1" optimization to partial DISTINCT
4801
Committed
Performance
Not processed
Richard Guo (richardguo)
David Rowley (davidrowley)
1
2 years ago
Improve cost estimates for MergeAppend plan with filters
4802
Committed
Performance
Not processed
Alexander Kuzmenkov (akuzmenkov)
Aleksander Alekseev (a.alekseev)
David Rowley (davidrowley)
1
2 years ago
Documentation: warn about two_phase when altering a subscription
4803
Committed
Docs Only
17
Not processed
Bertrand Drouvot (bertranddrouvot.pg)
Amit Kapila (amitkapila)
1
2 years ago
Remove WIN32 conditional compilation from win32common.c
4804
Committed
Not processed
Tristan Partin (tristan957)
Heikki Linnakangas (heikki)
1
2 years ago
Possibility to disable `ALTER SYSTEM`
4805
Committed
System Administration
17
Not processed
Gabriele Bartolini (gbartolini), Jelte Fennema-Nio (jeltef)
Robert Haas (rhaas)
1
2 years ago
Report the correct SQLSTATE for ENOMEM in file access
4806
Committed
Not processed
Alexander Kuzmenkov (akuzmenkov)
Tom Lane (tgl)
1
2 years ago
Add to_regtypemod() SQL function
4807
Committed
17
Not processed
Erik Wienhold (ewie), David Wheeler (theory)
Pavel Stehule (okbobcz), Jim Jones (jimus)
Tom Lane (tgl)
1
2 years ago
Note error condition in to_regtype docs
4808
Withdrawn
Docs Only
17
Not processed
David Johnston (polobo), David Wheeler (theory)
1
2 years ago
Encoding protection for pgcrypto
4809
Moved to different CF
Security
Not processed
shihao zhong (zhong950419)
3
2 years ago
COPY ON_ERROR 'NULL'
4810
Moved to different CF
10/10
+251−43
jian he (universality)
Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), Jim Jones (jimus)
Peter Eisentraut (petere)
9
2 weeks ago
Avoiding concurrent calls to bindtextdomain()
4811
Committed
Bugfix
stable
Not processed
Tom Lane (tgl)
Tom Lane (tgl)
1
2 years ago
Remove Start* macros from postmaster.c to ease understanding of code
4812
Committed
Not processed
Reid Thompson (jreidthompsoncd)
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
2 years ago
table inheritance versus column compression and storage settings
4813
Returned with feedback
Not processed
Ashutosh Bapat (ashutoshbapat)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
2 years ago
psql meta-command conninfo+
4814
Moved to different CF
libpq
7/7
+162−33
Maiquel Grassi (maiquel), Hunaid Sohail (hunaid)
Álvaro Herrera (alvherre), Nathan Bossart (bossartn), Sami Imseih (simseih), Jim Jones (jimus), Erik Wienhold (ewie)
Álvaro Herrera (alvherre)
6
1 year ago
ensure qsort() comparison functions are transitive
4815
Committed
17
Not processed
Mats Kindahl (matski)
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
2 years ago
Race condition in FetchTableStates() breaks synchronization of subscription tables
4816
Moved to different CF
Not processed
vigneshwaran C (vignesh.postgres)
Alexander Lakhin (law)
Amit Kapila (amitkapila)
2
1 year ago
on_error table, saving error info to a table
4817
Moved to different CF
Needs rebase!
jian he (hellothere)
Nishant Sharma (nishant-at-edb)
9
4 months ago
Fix buffer tracking on parallel vacuum
4818
Moved to different CF
Bugfix
Not processed
Anthonin Bonnefoy (bonnefoa)
Masahiko Sawada (masahikosawada), Alena Rybakina (alenka)
Masahiko Sawada (masahikosawada)
2
1 year ago
Separate equalRowTypes() from equalTupleDescs()
4819
Committed
Refactoring Only
Not processed
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
2 years ago
allow pg_current_logfile() execution under pg_monitor role
4820
Committed
17
Not processed
Pavlo Golub (pasha_golub)
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
2 years ago
ALTER TYPE OWNER fails to recurse to multirange
4821
Committed
Bugfix
17
Not processed
Tom Lane (tgl)
Tom Lane (tgl)
1
2 years ago
Fix incorrect PG_GETARG in pgcrypto
4822
Committed
Security
stable
Not processed
shihao zhong (zhong950419)
Michael Paquier (michael-kun)
1
2 years ago
Add test module for verifying backtrace functionality
4823
Moved to different CF
Testing
Not processed
Bharath Rupireddy (bharathrupireddy)
3
1 year ago
Do away with zero-padding assumption before WALRead()
4824
Committed
Not processed
Bharath Rupireddy (bharathrupireddy)
Jeff Davis (jdavis)
1
2 years ago
Optimize planner memory consumption for huge arrays
4825
Moved to different CF
Performance
17
Not processed
Andrei Lepikhov (lepikhov)
Alena Rybakina (a.rybakina)
3
2 years ago
Document efficient self-joins / UPDATE LIMIT techniques
4826
Committed
Docs Only
17
Not processed
Corey Huinker (coreyh)
Laurenz Albe (laurenz)
Tom Lane (tgl)
1
1 year ago
Fix overflow hazard in interval rounding
4827
Committed
Bugfix
Not processed
Joseph Koshakow (jkoshakow)
Tom Lane (tgl)
1
2 years ago
Rename constants in preparation of variableness
4828
Moved to different CF
Refactoring Only
18
Not processed
David Christensen (davidchristensen)
3
1 year ago
Add trim_trailing_whitespace to editorconfig file
4829
Moved to different CF
Not processed
Jelte Fennema-Nio (jeltef)
Peter Eisentraut (petere)
Peter Eisentraut (petere)
5
1 year ago
Put genbki.pl output into src/include/catalog/ directly
4830
Committed
Refactoring Only
Not processed
Peter Eisentraut (petere)
Andreas Karlsson (kandreas)
Peter Eisentraut (petere)
1
2 years ago
Combine headerscheck and cpluspluscheck scripts
4831
Committed
Refactoring Only
Not processed
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
2 years ago
Remove adminpack contrib extension
4832
Committed
17
Not processed
Daniel Gustafsson (d_gustafsson)
Tom Lane (tgl), Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy)
Daniel Gustafsson (d_gustafsson)
1
2 years ago
[Code Cleanup] : Small code cleanup in twophase.sql
4833
Committed
Testing
Not processed
Nishant Sharma (nishant-at-edb)
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
2 years ago
Avoid mixing custom and OpenSSL BIO functions
4834
Withdrawn
Security
Not processed
1
1 year ago
Avoid mixing custom and OpenSSL BIO functions
4835
Moved to different CF
Security
Not processed
David Benjamin (dbenjamin)
Daniel Gustafsson (d_gustafsson)
Daniel Gustafsson (d_gustafsson)
4
1 year ago
un-revert MAINTAIN privilege and pg_maintain predefined role
4836
Committed
17
Not processed
Nathan Bossart (bossartn)
Nathan Bossart (bossartn)
1
1 year ago
JIT compilation per plan node
4837
Moved to different CF
Performance
Not processed
David Rowley (davidrowley), Melih Mutlu (melihmutlu)
3
1 year ago
Injection points: some tools to wait and wake
4838
Committed
Testing
17
Not processed
Michael Paquier (michael-kun)
Michael Paquier (michael-kun)
1
2 years ago
The Prepare statement with the skewed parameter uses the custom plan
4839
Moved to different CF
Performance
Not processed
Zongliang Quan (quanzl)
3
2 years ago
Avoid switching between system-user and system-username in the doc
4840
Committed
Docs Only
17
Not processed
Bertrand Drouvot (bertranddrouvot.pg)
Michael Paquier (michael-kun)
1
2 years ago
Have pg_basebackup write "dbname" in "primary_conninfo"?
4841
Committed
17
Not processed
Ian Barwick (barwick)
Amit Kapila (amitkapila)
1
2 years ago
Add missing error codes to PANIC/FATAL error reports in xlog.c and relcache.c
4842
Committed
Monitoring
Not processed
Nazir Bilal Yavuz (nbyavuz)
Daniel Gustafsson (d_gustafsson)
Daniel Gustafsson (d_gustafsson)
1
2 years ago
Use streaming read API in ANALYZE
4843
Committed
Performance
Not processed
Nazir Bilal Yavuz (nbyavuz)
Thomas Munro (macdice)
1
1 year ago
Change the bool member of the Query structure to bits
4844
Withdrawn
Refactoring Only
Not processed
Zongliang Quan (quanzl)
1
2 years ago
confirmed flush lsn seems to be move backward in certain error cases
4845
Moved to different CF
Not processed
vigneshwaran C (vignesh.postgres)
Amit Kapila (amitkapila)
2
1 year ago
LogwrtResult contended spinlock
4846
Committed
Not processed
Álvaro Herrera (alvarofherrera), Bharath Rupireddy (bharathrupireddy)
Jeff Davis (jdavis), Bharath Rupireddy (bharathrupireddy)
Álvaro Herrera (alvherre)
1
1 year ago
Improve readability by using designated initializers when possible
4847
Committed
Refactoring Only
17
Not processed
Jelte Fennema-Nio (jeltef)
Michael Paquier (michael-kun)
1
2 years ago
Documentation to upgrade logical replication cluster
4848
Moved to different CF
Not processed
vigneshwaran C (vignesh.postgres)
Hayato Kuroda (ha-kun), Bharath Rupireddy (bharathrupireddy), Peter Smith (smithpb2250)
Amit Kapila (amitkapila)
3
1 year ago
Implementing OCSP Stapling for Server certificate status verification
4849
Moved to different CF
Security
Not processed
David Zhang (david.z)
Jacob Champion (jchampion)
3
1 year ago
Can we include capturing logs of pgdata/pg_upgrade_output.d/*/log in buildfarm
4850
Rejected
Testing
Not processed
vigneshwaran C (vignesh.postgres)
1
2 years ago
perlcritic error handling checks
4851
Committed
Not processed
Peter Eisentraut (petere)
Peter Eisentraut (petere)
1
2 years ago
EXPLAIN (SERIALIZE) option for measuring overheads incurred during serialization
4852
Committed
Monitoring
Not processed
Matthias van de Meent (mmeent)
Tom Lane (tgl)
Tom Lane (tgl)
1
2 years ago
Better error messages for %TYPE and %ROWTYPE in plpgsql
4853
Committed
Not processed
Tom Lane (tgl)
Tom Lane (tgl)
1
2 years ago
Documentation patch to the HOT updates page to add references to summary (BRIN) indexes not blocking HOT updates
4854
Committed
Docs Only
16
Not processed
Elizabeth Garrett Christensen (elizabeth.christensen)
Stephen Frost (sfrost)
Jeff Davis (jdavis)
1
2 years ago
pg_visibility's pg_check_visible() yields false positive when working in parallel with autovacuum
4855
Committed
Bugfix
17
Not processed
Alexander Korotkov (smagen), Daniel Shelepanov (dshelepanov)
Alexander Korotkov (smagen)
1
2 years ago
session username in default psql prompt
4856
Withdrawn
libpq
Not processed
Kori Lane (koril)
1
2 years ago
Partial aggregates push down
4857
Moved to different CF
Performance
Not processed
Yuki Fujii (fujiiyuki)
3
1 year ago
Add basic tests for the low-level backup method
4858
Committed
Testing
17
Not processed
David Steele (dsteele)
Michael Paquier (michael-kun)
1
2 years ago
Add checkpoint/redo LSNs to recovery errors
4859
Committed
System Administration
17
Not processed
David Steele (dsteele)
Michael Paquier (michael-kun)
1
2 years ago
create index failed. PARALLEL UNSAFE function does not prevent parallel index build
4860
Rejected
Bugfix
Not processed
Tender Wang (tndrwang)
1
2 years ago
Potential issue in ecpg-informix decimal converting functions
4861
Committed
Refactoring Only
17
Not processed
Aidar Imamov (gipergeek)
Daniel Gustafsson (d_gustafsson)
Daniel Gustafsson (d_gustafsson)
1
2 years ago
Refactor SASL exchange in preparation for OAuth Bearer
4862
Committed
Refactoring Only
Not processed
Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion)
Daniel Gustafsson (d_gustafsson)
1
2 years ago
Reducing connection overhead in pg_upgrade compat check phase
4863
Committed
Performance
Not processed
Daniel Gustafsson (d_gustafsson)
Peter Eisentraut (petere), Nathan Bossart (bossartn)
Daniel Gustafsson (d_gustafsson)
1
2 years ago
initdb's -c option behaves wrong way
4864
Committed
Bugfix
17
Not processed
Tom Lane (tgl)
Kyotaro Horiguchi (horiguti), Daniel Gustafsson (d_gustafsson)
Tom Lane (tgl)
1
2 years ago
type cache cleanup improvements
4865
Moved to different CF
Performance
18
Not processed
Fedor Sigaev (sigaev)
Roman Zharkov (r.zharkov)
Alexander Korotkov (smagen)
3
1 year ago
Table AM Interface Enhancements
4866
Moved to different CF
Not processed
Alexander Korotkov (smagen)
Alexander Korotkov (smagen)
3
1 year ago
Allow altering two_phase parameter of subscriptions
4867
Moved to different CF
18
Not processed
Hayato Kuroda (ha-kun), Ajin Cherian (ajinc)
Peter Smith (smithpb)
Amit Kapila (amitkapila)
2
1 year ago
Checkpoint extension hook
4868
Moved to different CF
Not processed
Jeff Davis (jdavis)
Heikki Linnakangas (heikki)
2
1 year ago
Avoid stack frame setup in GenerationAlloc() and SlabAlloc() by
4869
Committed
Performance
Not processed
David Rowley (davidrowley)
David Rowley (davidrowley)
1
2 years ago
Make query cancellation keys longer
4870
Moved to different CF
Security
7/7
+786−161
Heikki Linnakangas (heikki), Jelte Fennema-Nio (jeltef)
Heikki Linnakangas (heikki)
4
1 year ago
KNN-btree
4871
Moved to different CF
Needs rebase!
Nikita Glukhov (n.glukhov), Anton Melnikov (antonmel)
8
1 year ago
Return ssize_t, not int, in fd.c I/O functions
4872
Committed
Refactoring Only
Not processed
Thomas Munro (macdice)
Peter Eisentraut (petere)
Thomas Munro (macdice)
1
2 years ago
unaccent: understand ancient Greek "oxia" and other codepoints merged by Unicode
4873
Moved to different CF
Bugfix
Not processed
Thomas Munro (macdice)
Thomas Munro (macdice)
2
1 year ago
BitmapHeapScan table AM violation removal (and use streaming read API)
4874
Moved to different CF
Refactoring Only
7/7
+826−911
Melanie Plageman (melanieplageman)
Heikki Linnakangas (heikki), Andres Freund (andresfreund), Tomas Vondra (fuzzycz)
Melanie Plageman (melanieplageman)
6
11 months ago
Streaming read sequential and TID range scan
4875
Committed
Refactoring Only
17
Not processed
Melanie Plageman (melanieplageman)
David Rowley (davidrowley)
Thomas Munro (macdice)
1
1 year ago
CREATE DATABASE ... STRICT_UNICODE
4876
Moved to different CF
Not processed
Jeff Davis (jdavis)
5
1 year ago
Propagate sanity checks of ProcessUtility() to standard_ProcessUtility()?
4877
Moved to different CF
Not processed
Michael Paquier (michael-kun)
2
1 year ago
Missing LWLock protection in pgstat_reset_replslot()
4878
Committed
Bugfix
stable
Not processed
Bertrand Drouvot (bertranddrouvot.pg)
Michael Paquier (michael-kun)
1
2 years ago