| declarative session variables, LET command |
1608 |
Needs review |
DDL
|
|
10/10
|
+3003−37
|
Pavel Stehule (okbobcz) |
Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), Jim Jones (jimus), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
41 |
4 weeks ago |
| pgbench - adding pl/pgsql versions of tests |
4105 |
Needs review |
Testing
|
19 |
10/10
|
+247−14
|
Hannu Krosing (hannukrosing) |
Fabien Coelho (calvin), Yugo Nagata (yugo.nagata), Robert Treat (xzilla) |
|
10 |
3 months ago |
| Add XMLCanonicalize function |
4237 |
Ready for Committer |
SQL Commands
|
19 |
10/10
|
+509−0
|
Jim Jones (jimus) |
Pavel Stehule (okbobcz), Oliver Ford (ojford), Yogesh Sharma (sharmay), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
16 |
1 month ago |
| Logging parallel worker draught |
4291 |
Waiting on Author |
Monitoring
|
19 |
0/10
|
+37−0
|
Benoit Lobréau (benoitl) |
Sami Imseih (simseih), Yogesh Sharma (sharmay) |
|
14 |
2 weeks ago |
| Incremental View Maintenance (IVM), take 2 |
4337 |
Waiting on Author |
SQL Commands
|
|
Needs rebase!
|
|
Yugo Nagata (yugo.nagata) |
Alexandre Felipe (afelipe) |
|
16 |
2 months ago |
| Index Prefetching |
4351 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Jerry Zhang (xingtanzjr) |
|
15 |
3 weeks ago |
| add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl |
4390 |
Needs review |
Security
|
|
Needs rebase!
|
|
Cary Huang (cary) |
Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) |
|
12 |
10 months ago |
| Implement row pattern recognition feature |
4460 |
Needs review |
SQL Commands
|
19 |
10/10
|
+46915−45
|
Tatsuo Ishii (ishii), Henson Choi (assam258.gmail.com) |
Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033), Henson Choi (assam258.gmail.com) |
|
15 |
7 hours ago |
| Make COPY format extendable: Extract COPY TO format implementations |
4681 |
Needs review |
SQL Commands
|
|
Needs rebase!
|
|
Kouhei Sutou (kou) |
Masahiko Sawada (masahikosawada), Zhao Junwang (zhjwpku), Yong Li (yoli) |
|
11 |
1 month ago |
| COPY (on_error table) saving error info to a table |
4817 |
Needs review |
|
|
3/10
|
+849−11
|
Jian He (stayreal) |
Nishant Sharma (nishant-at-edb) |
|
10 |
1 week ago |
| Avoid orphaned objects dependencies, take 3 |
4942 |
Needs review |
DDL
|
18 |
10/10
|
+642−8
|
Bertrand Drouvot (bertranddrouvot.pg) |
Yogesh Sharma (sharmay) |
|
11 |
5 days ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Needs review |
Performance
DDL
|
19 |
3/10
|
+3060−484
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
10 |
2 weeks ago |
| relfilenode statistics |
5007 |
Needs review |
Monitoring
|
18 |
Needs rebase!
|
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
11 |
1 month ago |
| Vacuum statistics |
5012 |
Ready for Committer |
Monitoring
|
19 |
10/10
|
+4667−10
|
Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) |
Ilia Evdokimov (ilidock95) |
|
11 |
5 days ago |
| Extension security improvement: Add support for extensions with an owned schema |
5018 |
Needs review |
Security
Extensions
|
|
Needs rebase!
|
|
Jelte Fennema-Nio (jeltef) |
Sadeq Dousti (msdousti), Artem Gavrilov (artem.gavrilov) |
|
11 |
1 month ago |
| Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state |
5029 |
Needs review |
Bugfix
Logical Replication
|
|
10/10
|
+110−6
|
ChangAo Chen (chenchangao) |
harinath kanchu (harinath001), Lilian Ontowhee (ontowhee), haiyang li (ocean-li) |
|
10 |
5 months ago |
| Incorrect error message for cancellation triggered by statement_timeout & flaky test |
5070 |
Ready for Committer |
Bugfix
Flakyfix
|
stable |
10/10
|
+33−15
|
Jelte Fennema-Nio (jeltef) |
Yogesh Sharma (sharmay), Akshat Jaimini (akshatj) |
|
11 |
3 months ago |
| Add OR REPLACE option to CREATE MATERIALIZED VIEW |
5099 |
Needs review |
SQL Commands
|
|
9/10
|
+694−98
|
Erik Wienhold (ewie) |
Paul Jungwirth (pjungwir), newtglobal postgresql_contributors (newtpostgrescontributors), Soumya S Murali (soumyamurali) |
|
9 |
yesterday |
| Add XMLCast (SQL/XML X025) |
5110 |
Needs review |
SQL Commands
|
19 |
10/10
|
+2746−26
|
Jim Jones (jimus) |
Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
11 |
1 month ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
10/10
|
+1427−744
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
9 |
2 weeks ago |
| DirtySnapshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication |
5151 |
Needs review |
Bugfix
Logical Replication
Help - Stuck Rebasing
|
stable |
10/10
|
+613−48
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Luan Silva (luansilva) |
|
9 |
3 weeks ago |
| Refactor SLRU to always use long file names |
5250 |
Ready for Committer |
Refactoring Only
|
|
10/10
|
+95−84
|
Aleksander Alekseev (a.alekseev) |
|
|
9 |
3 weeks ago |
| libpq: Fix processing of SSL records >8kB on async API |
5251 |
Needs review |
Bugfix
Backport
libpq
|
stable |
10/10
|
+208−11
|
Jacob Champion (jchampion), Lars Kanis (larsk) |
Jacob Champion (jchampion) |
|
8 |
1 month ago |
| Add GUC log_parameter_max_length to limit logged SQL statements |
5272 |
Ready for Committer |
GUC
Good First Review
|
19 |
10/10
|
+263−38
|
Kirill Gavrilov (diphantxm) |
Fujii Masao (masaofujii), Jim Jones (jimus) |
Fujii Masao (masaofujii) |
6 |
2 days ago |
| Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) |
5279 |
Needs review |
SQL Commands
|
19 |
10/10
|
+1559−59
|
Jim Jones (jimus) |
newtglobal postgresql_contributors (newtpostgrescontributors) |
|
9 |
1 month ago |
| System views for versions reporting |
5318 |
Ready for Committer |
Monitoring
|
stable |
Needs rebase!
|
|
Dmitry Dolgov (erthalion) |
Laurenz Albe (laurenz) |
|
9 |
5 months ago |
| Logging plan of the currently running query |
5330 |
Needs review |
Monitoring
|
18 |
Needs rebase!
|
|
Atsushi Torikoshi (atsushitorikoshi) |
Hironobu Suzuki (suzuki_hironobu), Sadeq Dousti (msdousti) |
|
9 |
1 month ago |
| Fix bug with accessing to temporary tables of other sessions |
5379 |
Ready for Committer |
Bugfix
Backport
|
18 |
Needs rebase!
|
|
Daniil Davydov (dddaniil) |
Tom Lane (tgl), Rafia Sabih (rafia.sabih), Jim Jones (jimus), Soumya S Murali (soumyamurali) |
|
8 |
3 hours ago |
| Add Option to Check All Addresses For Matching target_session_attr |
5396 |
Needs review |
libpq
|
18 |
10/10
|
+334−10
|
Andrew Jackson (andrewjackson) |
Andrey Borodin (x4m) |
|
7 |
1 month ago |
| Add XMLDocument (SQL/XML X030) |
5431 |
Ready for Committer |
SQL Commands
|
19 |
10/10
|
+258−1
|
Jim Jones (jimus) |
Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
8 |
1 month ago |
| using index to speedup add not null constraints to a table |
5444 |
Needs review |
|
|
Needs rebase!
|
|
Jian He (stayreal) |
Tanzeel Khan (tanzeelk) |
|
7 |
3 weeks ago |
| Clarify FileTag-based unlinking |
5454 |
Ready for Committer |
Refactoring Only
|
|
10/10
|
+10−7
|
Matthias van de Meent (mmeent) |
Surya Poondla (spoondla) |
|
5 |
1 month ago |
| Add XMLNamespaces option to XMLElement |
5456 |
Ready for Committer |
SQL Commands
|
19 |
10/10
|
+1242−41
|
Pavel Stehule (okbobcz), Jim Jones (jimus) |
Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
8 |
1 month ago |
| Function scan FDW pushdown |
5470 |
Needs review |
Performance
|
18 |
10/10
|
+1348−104
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
Ashutosh Bapat (ashutoshbapat) |
|
3 |
1 month ago |
| SQL/JSON json_table PLAN clause |
5478 |
Needs review |
|
18 |
Needs rebase!
|
|
Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrew Dunstan (adunstan), Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Anton Melnikov (antonmel), Nikita Malakhov (nmalakh) |
Amit Langote (amitlan), Vladlen Popolitov (vladlenpopolitov) |
|
6 |
1 year ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Needs review |
Performance
|
19 |
9/10
|
+1508−58
|
Alena Rybakina (a.rybakina) |
Ilia Evdokimov (ilidock95) |
|
7 |
1 month ago |
| add function argument name to substring and substr |
5524 |
Waiting on Author |
|
|
Needs rebase!
|
|
Jian He (stayreal) |
David Johnston (polobo) |
|
6 |
1 month ago |
| Add storage I/O tracking to EXPLAIN BUFFERS |
5526 |
Needs review |
Monitoring
|
|
Needs rebase!
|
|
Atsushi Torikoshi (atsushitorikoshi) |
Jelte Fennema-Nio (jeltef) |
|
7 |
1 month ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Greg Burd (gregburd) |
Nathan Bossart (bossartn) |
|
6 |
1 month ago |
| Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup |
5570 |
Needs review |
Multithreading
AIO
|
|
Needs rebase!
|
|
Jelte Fennema-Nio (jeltef) |
|
|
7 |
1 month ago |
| Warn, and disallow, clear text passwords via SQL |
5597 |
Needs review |
|
|
Needs rebase!
|
|
Greg Sabino Mullane (greg) |
Guillaume Lelarge (gleu) |
|
4 |
3 months ago |
| Beautify read stream "per buffer data" APIs |
5617 |
Needs review |
Refactoring Only
|
|
10/10
|
+116−44
|
Thomas Munro (macdice) |
Nazir Bilal Yavuz (nbyavuz) |
|
5 |
1 month ago |
| support create index on virtual generated column. |
5667 |
Waiting on Author |
|
|
Needs rebase!
|
|
Jian He (stayreal) |
Soumya S Murali (soumyamurali) |
|
6 |
1 month ago |
| Produce LLVM bitcode files on meson builds |
5671 |
Needs review |
Performance
|
19 |
10/10
|
+928−58
|
Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) |
|
|
5 |
3 weeks ago |
| Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION |
5681 |
Waiting on Author |
Bugfix
|
|
10/10
|
+132−19
|
Yugo Nagata (yugo.nagata) |
Jim Jones (jimus), Daniil Davydov (dddaniil) |
|
6 |
7 months ago |
| amcheck support for BRIN indexes |
5715 |
Needs review |
Monitoring
|
|
10/10
|
+2150−9
|
Arseniy Mukhin (amukhin) |
Tomas Vondra (fuzzycz) |
|
4 |
1 week ago |
| virtual generated column as partition key |
5720 |
Waiting on Author |
|
19 |
3/10
|
+665−65
|
Jian He (stayreal) |
Rustam ALLAKOV (rustam.allakov), Haibo Yan (billyean) |
|
6 |
1 month ago |
| ALTER DOMAIN ADD NOT NULL NOT VALID |
5768 |
Needs review |
|
19 |
10/10
|
+219−29
|
Jian He (stayreal) |
|
|
6 |
2 months ago |
| Extend skipping FK checks on replicas to include ADD FK and TRUNCATE |
5774 |
Needs review |
Performance
Help - Stuck Rebasing
Logical Replication
|
19 |
10/10
|
+96−3
|
Hannu Krosing (hannukrosing) |
|
|
5 |
3 months ago |
| Improve the performance of Unicode Normalization Forms. |
5802 |
Ready for Committer |
Performance
|
|
10/10
|
+7706−12726
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov) |
|
6 |
1 month ago |
| pgindent: improve formatting of multiline comments |
5831 |
Ready for Committer |
Good First Review
Devtools
|
19 |
10/10
|
+36−0
|
Aleksander Alekseev (a.alekseev) |
Payal Singh (payal) |
|
6 |
1 month ago |
| problems with toast.* reloptions |
5839 |
Needs review |
Bugfix
|
stable |
3/10
|
+177−304
|
Nathan Bossart (bossartn) |
Yogesh Sharma (sharmay) |
|
6 |
yesterday |
| Carefully exposing information without authentication |
5845 |
Needs review |
Monitoring
|
19 |
Needs rebase!
|
|
Greg Sabino Mullane (greg) |
|
|
4 |
1 month ago |
| Allow ON CONFLICT DO SELECT/UPDATE to return EXCLUDED values |
5854 |
Needs review |
SQL Commands
|
19 |
Needs rebase!
|
|
Dean Rasheed (deanr) |
Viktor Holmberg (rutchkiwi) |
|
6 |
2 months ago |
| docs: Include protocol version changes made without a version bump or extension |
5863 |
Ready for Committer |
Docs Only
|
|
10/10
|
+22−104
|
Jelte Fennema-Nio (jeltef) |
|
|
6 |
2 months ago |
| Support for basic ALTER TABLE progress reporting. |
5873 |
Needs review |
Monitoring
|
|
Needs rebase!
|
|
Jiří Kavalík (jkavalik) |
Jian He (stayreal) |
|
5 |
9 months ago |
| Report bytes and transactions actually sent downtream |
5877 |
Needs review |
Monitoring
Logical Replication
|
|
0/10
|
+434−166
|
Ashutosh Bapat (ashutoshbapat) |
|
|
6 |
1 month ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Needs review |
Performance
System Administration
|
stable |
10/10
|
+498−89
|
Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) |
Dilip Kumar (dilip.kumar) |
|
4 |
2 days ago |
| no table rewrite when set column type to constrained domain |
5907 |
Waiting on Author |
|
19 |
10/10
|
+167−10
|
Jian He (stayreal) |
Yogesh Sharma (sharmay), Viktor Holmberg (rutchkiwi), Aditya Gollamudi (adigoll) |
|
5 |
1 month ago |
| CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions |
5941 |
Needs review |
SQL Commands
|
19 |
Needs rebase!
|
|
Jian He (stayreal) |
Corey Huinker (coreyh) |
|
5 |
4 weeks ago |
| Adding per backend commit and rollback counters |
5947 |
Waiting on Author |
Monitoring
|
19 |
Needs rebase!
|
|
Bertrand Drouvot (bertranddrouvot.pg) |
Miłosz Bieniek (moozzi), Kuba Knysiak (xsni12) |
|
5 |
1 month ago |
| implement CAST(expr AS type FORMAT 'template') |
5957 |
Waiting on Author |
|
19 |
Needs rebase!
|
|
Jian He (stayreal) |
Corey Huinker (coreyh), Surya Poondla (spoondla) |
|
5 |
1 month ago |
| Per backend relation statistics tracking |
5958 |
Needs review |
Monitoring
|
19 |
Needs rebase!
|
|
Bertrand Drouvot (bertranddrouvot.pg) |
Yogesh Sharma (sharmay) |
|
5 |
8 months ago |
| disallow alter individual column if partition key contains wholerow reference |
5988 |
Waiting on Author |
Bugfix
Backport
|
18 |
10/10
|
+39−0
|
Jian He (stayreal) |
Sergey Dudoladov (sdudoladov), Matt Dailis (mattdailis) |
|
5 |
6 months ago |
| pgbench: extend variable usage in scripts |
6012 |
Waiting on Author |
libpq
|
19 |
Needs rebase!
|
|
Yugo Nagata (yugo.nagata) |
lakshmi g (lakshmi) |
|
5 |
3 months ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Needs review |
Performance
|
19 |
0/1
|
+0−0
|
Lukas Fittl (lfittl) |
Zsolt Parragi (zsolt.parragi) |
|
5 |
3 weeks ago |
| Improve read_local_xlog_page_guts by replacing polling with latch-based waiting |
6024 |
Needs review |
Performance
Logical Replication
|
19 |
10/10
|
+40−11
|
Xuneng Zhou (dylanzhou) |
|
|
4 |
3 months ago |
| Fix race condition in SSI when reading PredXact->SxactGlobalXmin |
6037 |
Ready for Committer |
Bugfix
Backport
My First Patch
|
stable |
Needs rebase!
|
|
Josh Curtis (joshcurtis) |
Mihail Nikalayeu (mihailnikalayeu) |
|
4 |
1 month ago |
| RFC: adding pytest as a supported test framework |
6045 |
Needs review |
Testing
Help - User Testing
Modernization
Devtools
|
|
10/10
|
+3020−249
|
Jacob Champion (jchampion), Jelte Fennema-Nio (jeltef) |
|
|
4 |
1 month ago |
| let ALTER TABLE DROP COLUMN drop whole-row referenced object |
6055 |
Needs review |
Bugfix
Backport
|
stable |
Needs rebase!
|
|
Jian He (stayreal) |
lakshmi g (lakshmi) |
|
4 |
3 days ago |
| Improving the names generated for indexes on expressions |
6059 |
Needs review |
|
|
3/10
|
+265−159
|
Tom Lane (tgl) |
|
|
4 |
6 months ago |
| CREATE TABLE LIKE INCLUDING TRIGGERS |
6087 |
Ready for Committer |
SQL Commands
|
19 |
10/10
|
+556−23
|
Jian He (stayreal) |
Andrey Borodin (x4m), Zsolt Parragi (zsolt.parragi) |
|
4 |
1 month ago |
| create table like including storage parameter |
6088 |
Needs review |
SQL Commands
|
19 |
10/10
|
+218−9
|
Jian He (stayreal) |
lakshmi g (lakshmi) |
|
4 |
5 days ago |
| Little refactoring of portalcmds.c |
6113 |
Needs review |
Refactoring Only
Good First Review
|
|
10/10
|
+16−24
|
Aleksander Alekseev (a.alekseev) |
|
|
4 |
6 months ago |
| Preserve index stats during ALTER TABLE ... TYPE ... |
6118 |
Needs review |
Bugfix
|
19 |
2/10
|
+576−4
|
Bertrand Drouvot (bertranddrouvot.pg) |
Yogesh Sharma (sharmay) |
|
4 |
6 months ago |
| Migrate pg_commit_ts directory to the new node during an upgrade |
6119 |
Needs review |
|
19 |
10/10
|
+353−3
|
Sergey Levin (lsv) |
Hayato Kuroda (ha-kun), Maxim Orlov (m.orlov) |
|
4 |
3 weeks ago |
| avoid call ATPostAlterTypeCleanup twice |
6121 |
Needs review |
Bugfix
Backport
|
stable |
9/10
|
+88−0
|
Jian He (stayreal) |
|
|
4 |
6 months ago |
| Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement |
6131 |
Ready for Committer |
Good First Review
My First Patch
|
19 |
10/10
|
+312−0
|
Phil Alger (paalger) |
Josef Šimánek (retro), Jim Jones (jimus), Soumya S Murali (soumyamurali) |
|
4 |
5 months ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Needs review |
Performance
|
|
10/10
|
+417−9
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada) |
|
4 |
3 weeks ago |
| Optimization of the is_normalized() function. |
6152 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Alexander Borisov (lexborisov) |
|
|
4 |
3 weeks ago |
| Add GoAway protocol message for graceful but fast server shutdown/switchover |
6156 |
Needs review |
libpq
|
|
10/10
|
+553−21
|
Jelte Fennema-Nio (jeltef) |
|
|
4 |
1 month ago |
| Improve docs syntax checking and enable it in the meson build |
6161 |
Needs review |
CI
Testing
|
|
10/10
|
+141−16
|
Nazir Bilal Yavuz (nbyavuz) |
|
|
3 |
1 month ago |
| ci: Skip minfree file in the cores_backtrace.sh |
6162 |
Needs review |
CI
Testing
|
|
10/10
|
+1−1
|
Christoph Berg (myon), Nazir Bilal Yavuz (nbyavuz) |
|
|
2 |
3 weeks ago |
| Batching in executor, part 1: add batch variant of table AM scan API |
6176 |
Needs review |
Help - Benchmarks
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
|
|
3 |
3 weeks ago |
| Report oldest xmin source when autovacuum cannot remove tuples |
6188 |
Waiting on Author |
Monitoring
|
19 |
Needs rebase!
|
|
Shinya Kato (shinyakato) |
Fujii Masao (masaofujii), Sami Imseih (simseih) |
|
4 |
1 month ago |
| ago(interval) → timestamptz |
6202 |
Needs review |
SQL Commands
|
19 |
10/10
|
+25−0
|
Florents Tselai (florentst) |
|
|
3 |
5 months ago |
| Add pg_get_subscription_ddl() function |
6208 |
Ready for Committer |
My First Patch
|
19 |
9/10
|
+458−0
|
Vaibhav Dalvi (vaibhavdalvi) |
|
|
3 |
5 months ago |
| pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement |
6212 |
Needs review |
Good First Review
|
19 |
Needs rebase!
|
|
Florin Irion (irionr), Tim Waizenegger (tim.waizenegger.edb) |
Haritabh Gupta (haritabhgupta), Kuba Knysiak (xsni12) |
|
3 |
1 month ago |
| Reduce unnecessary locking of pruned partitions when reusing cached plans |
6216 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
|
|
2 |
4 weeks ago |
| pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized |
6219 |
Waiting on Author |
Performance
libpq
|
stable |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) |
|
3 |
1 month ago |
| Give Plugins control at the end of CHECKPOINT to store their state |
6224 |
Needs review |
Extensions
|
19 |
10/10
|
+215−0
|
Andrei Lepikhov (lepikhov), Asif Rehman (asifrana) |
|
|
3 |
1 week ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Needs review |
postgres_fdw
Performance
|
19 |
10/10
|
+627−51
|
Rafia Sabih (rafia.sabih) |
|
|
2 |
2 weeks ago |
| parallel pgbench -i |
6242 |
Needs review |
Performance
|
|
10/10
|
+134−4
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
3 |
2 weeks ago |
| Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) |
6245 |
Ready for Committer |
Performance
My First Patch
Refactoring Only
|
19 |
10/10
|
+978−150
|
Boris Mironov (bmironov) |
Fujii Masao (masaofujii), Egor Madyshev (emadyshev) |
|
3 |
1 month ago |
| Use ROLERECURSE_PRIVS in is_admin_of_role() |
6251 |
Needs review |
Good First Review
|
|
10/10
|
+27−2
|
ChangAo Chen (chenchangao) |
Nathan Bossart (bossartn) |
|
3 |
4 days ago |
| doc: Clarify ANALYZE VERBOSE output |
6259 |
Needs review |
Docs Only
|
stable |
10/10
|
+2−3
|
Shinya Kato (shinyakato) |
Maciek Sakrejda (msakrejda), Surya Poondla (spoondla) |
|
3 |
2 weeks ago |
| extend JSON_TABLE top level path expression |
6260 |
Needs review |
|
19 |
10/10
|
+238−105
|
Jian He (stayreal) |
|
|
3 |
5 months ago |
| split tablecmds.c |
6269 |
Waiting on Author |
Refactoring Only
|
19 |
Needs rebase!
|
|
Nathan Bossart (bossartn) |
|
|
3 |
3 months ago |
| skip check constraints verification for unaffected columns during UPDATE |
6270 |
Needs review |
|
19 |
3/10
|
+259−17
|
Jian He (stayreal) |
Florin Irion (irionr) |
|
3 |
1 month ago |
| Add a greedy join search algorithm to handle large join problems |
6274 |
Waiting on Author |
Performance
|
|
3/10
|
+1922−4
|
Chengpeng Yan (chengpeng.yan) |
lakshmi g (lakshmi) |
|
3 |
2 months ago |
| refactor ExecInitPartitionInfo |
6280 |
Needs review |
Refactoring Only
|
stable |
10/10
|
+14−26
|
Jian He (stayreal) |
|
|
3 |
1 month ago |
| Add sampling statistics to autoanalyze log output |
6288 |
Needs review |
Monitoring
|
|
10/10
|
+116−42
|
Tatsuya Kawata (croissant) |
Fujii Masao (masaofujii) |
|
3 |
2 months ago |
| Proposal to allow setting cursor options on Portals |
6292 |
Needs review |
libpq
|
|
9/10
|
+1212−11
|
Dave Cramer (dcramer) |
Jelte Fennema-Nio (jeltef) |
|
2 |
3 weeks ago |
| Add pg_current_vxact_id() function to expose virtual transaction IDs |
6298 |
Needs review |
Good First Review
Monitoring
PGConf.dev
|
19 |
9/10
|
+109−4
|
Pavlo Golub (pasha_golub) |
Henson Choi (assam258.gmail.com) |
|
3 |
2 months ago |
| Safer and easier to use hash table initialization macro |
6301 |
Waiting on Author |
Refactoring Only
|
|
Needs rebase!
|
|
Bertrand Drouvot (bdrouvot), Jelte Fennema-Nio (jeltef) |
|
|
3 |
1 month ago |
| refactor handling optional argument in system functions |
6303 |
Ready for Committer |
Refactoring Only
|
19 |
10/10
|
+25−168
|
Mark Wong (markwkm) |
Andreas Karlsson (kandreas) |
|
3 |
3 weeks ago |
| Incorrect historic snapshot may be serialized to disk during fast-forwarding |
6304 |
Needs review |
Bugfix
|
|
9/10
|
+11−7
|
ChangAo Chen (chenchangao), haiyang li (ocean-li) |
|
|
3 |
3 months ago |
| Add support for partial incremental materialized view refresh using REFRESH ... WHERE |
6305 |
Needs review |
My First Patch
SQL Commands
|
19 |
10/10
|
+1468−70
|
Adam Brusselback (tostino) |
Dharin Shah (dharins0) |
|
3 |
3 weeks ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Needs review |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
3 |
4 months ago |
| SQL-level pg_datum_image_equal |
6309 |
Needs review |
|
|
Needs rebase!
|
|
Matthias van de Meent (mmeent) |
|
|
2 |
1 month ago |
| Don't use the deprecated and insecure PQcancel in our frontend tools anymore |
6314 |
Ready for Committer |
psql
Security
|
|
Needs rebase!
|
|
Jelte Fennema-Nio (jeltef) |
|
|
3 |
3 weeks ago |
| json_table function PLAN clause |
6332 |
Needs review |
Help - User Testing
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Nikita Malakhov (nmalakh) |
|
|
2 |
4 months ago |
| File locks for data directory lockfile in the context of Linux namespaces |
6335 |
Needs review |
|
stable |
10/10
|
+111−18
|
Dmitry Dolgov (erthalion) |
|
|
3 |
3 months ago |
| Add --extra-dependencies and immediate data dumping for pg_dump/pg_upgrade |
6340 |
Needs review |
|
19 |
10/10
|
+220−6
|
Jeevan Chalke (jeevan.chalke) |
|
|
3 |
1 month ago |
| Cleaning up PREPARE query strings? |
6341 |
Needs review |
SQL Commands
|
|
10/10
|
+135−23
|
Julien Rouhaud (rjuju) |
Sami Imseih (simseih) |
|
3 |
1 month ago |
| Fix several Datum conversion inconsistencies (was: Remove Int8GetDatum, DatumGetUInt8 and UInt8GetDatum funcitons) |
6354 |
Needs review |
Refactoring Only
Good First Review
|
19 |
10/10
|
+47−47
|
Aleksander Alekseev (a.alekseev), Kirill Reshke (reshke) |
Michael Paquier (michael-kun) |
Peter Eisentraut (petere) |
3 |
3 days ago |
| Hash-based MCV matching for large IN-lists |
6356 |
Ready for Committer |
Performance
|
stable |
10/10
|
+542−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
3 |
3 weeks ago |
| Support for EXTRA_REGRESS_OPTS and TEMP_CONFIG for meson tests |
6361 |
Waiting on Author |
Testing
|
|
10/10
|
+9−0
|
Andreas Karlsson (kandreas) |
|
|
3 |
1 month ago |
| Add a berief general comment on BTScanInsertData's nextkey and backward |
6363 |
Needs review |
Comments Only
|
|
10/10
|
+18−15
|
Yugo Nagata (yugo.nagata) |
|
|
3 |
1 month ago |
| QoL improvements for pgindent and combining pgindent, pgperltidy, pgperlcritic and pgperlsyncheck into one tool |
6366 |
Needs review |
Devtools
|
|
10/10
|
+1051−516
|
Jelte Fennema-Nio (jeltef) |
|
|
3 |
1 month ago |
| Create unique GiST index |
6368 |
Waiting on Author |
Bugfix
SQL Commands
|
19 |
0/10
|
+447−17
|
Paul Jungwirth (pjungwir) |
warda bibi (warda), Prafulla Ranadive (pprandive) |
|
3 |
1 month ago |
| docs: clarify ALTER TABLE behavior on partitioned tables |
6379 |
Ready for Committer |
Docs Only
DDL
|
19 |
9/10
|
+227−90
|
Chao Li (chaol) |
David Johnston (polobo), Zsolt Parragi (zsolt.parragi) |
|
2 |
1 month ago |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
19 |
10/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
2 |
1 month ago |
| Add ldapservice connection parameter |
6390 |
Ready for Committer |
libpq
|
|
10/10
|
+340−7
|
Andrew Jackson (andrewjackson) |
|
|
2 |
3 weeks ago |
| Use CASEFOLD() internally rather than LOWER() |
6391 |
Needs review |
|
19 |
10/10
|
+55−30
|
Jeff Davis (jdavis) |
Mark Dilger (mark.dilger) |
|
2 |
1 month ago |
| ALTER TABLE: notice when actions do not recurse to partitions |
6392 |
Ready for Committer |
DDL
|
19 |
Needs rebase!
|
|
Chao Li (chaol) |
Jim Jones (jimus) |
|
2 |
1 month ago |
| Refactor *_abbrev_convert() functions |
6393 |
Needs review |
Refactoring Only
Good First Review
|
19 |
10/10
|
+33−54
|
Aleksander Alekseev (a.alekseev) |
Aditya Gollamudi (adigoll) |
John Naylor (john.naylor) |
2 |
2 weeks ago |
| extended statistic (examine_variable) ignored CollateExpr |
6397 |
Needs review |
Bugfix
|
stable |
4/10
|
+138−5
|
Jian He (stayreal) |
|
|
2 |
3 months ago |
| Fix gistkillitems & add regression test to microvacuum |
6399 |
Ready for Committer |
Bugfix
|
|
10/10
|
+5−5
|
Kirill Reshke (reshke) |
Soumya S Murali (soumyamurali) |
|
2 |
1 month ago |
| Add pg_get_publication_ddl function |
6400 |
Needs review |
DDL
|
19 |
Needs rebase!
|
|
Jonathan Gonzalez V. (sxd) |
Hüseyin Demir (demir) |
|
2 |
2 months ago |
| Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY |
6401 |
Needs review |
Performance
DDL
|
19 |
10/10
|
+1347−152
|
Mihail Nikalayeu (mihailnikalayeu) |
|
|
2 |
2 weeks ago |
| nbtree: reduce code redundancy by using _bt_getmeta() in _bt_gettrueroot() |
6402 |
Needs review |
Refactoring Only
|
19 |
10/10
|
+1−21
|
Chao Li (chaol) |
|
|
2 |
3 months ago |
| Add cascade synchronous replication |
6404 |
Needs review |
Missing Docs
Testing
Physical Replication
|
|
Needs rebase!
|
|
Григорий Новиков (grishanovik) |
|
|
2 |
4 months ago |
| JumbleQuery may treat different GROUP BY expr as the same |
6411 |
Needs review |
|
stable |
10/10
|
+49−3
|
Jian He (stayreal) |
Keisuke Kuroda (keisuke.kuroda.3862) |
|
2 |
1 month ago |
| Reduce build times of pg_trgm GIN indexes |
6418 |
Needs review |
Performance
|
19 |
10/10
|
+225−209
|
David Geier (geidav) |
Heikki Linnakangas (heikki) |
Heikki Linnakangas (heikki) |
2 |
1 week ago |
| ANALYZE: hash-accelerate MCV tracking for equality-only types |
6422 |
Needs review |
Performance
|
|
9/10
|
+214−24
|
Chengpeng Yan (chengpeng.yan) |
Ilia Evdokimov (ilidock95), Tatsuya Kawata (croissant) |
|
2 |
2 weeks ago |
| Avoid recalculating pgprocno in ProcArrayAdd() |
6426 |
Ready for Committer |
Good First Review
Refactoring Only
|
stable |
10/10
|
+1−1
|
Shinya Kato (shinyakato) |
Chao Li (chaol) |
|
2 |
2 months ago |
| BUG #19369: Not documented that io_uring on kernel versions between 5.1 and below 5.6 does not work |
6428 |
Needs review |
Bugfix
AIO
|
19 |
10/10
|
+122−3
|
Surya Poondla (spoondla) |
|
|
2 |
3 months ago |
| Add SQL/JSON ON MISMATCH clause to JSON_VALUE, JSON_QUERY, JSON_TABLE |
6429 |
Needs review |
SQL Commands
|
19 |
9/10
|
+747−52
|
Florents Tselai (florentst) |
|
|
2 |
3 months ago |
| ci: Add MTEST_SUITES for optional test tailoring |
6430 |
Needs review |
CI
Devtools
|
|
10/10
|
+8−7
|
Jacob Champion (jchampion), Jelte Fennema-Nio (jeltef) |
|
|
2 |
3 months ago |
| Add `tsmatch` JSONPath operator for granular Full Text Search |
6436 |
Needs review |
SQL Commands
|
19 |
10/10
|
+597−4
|
Florents Tselai (florentst) |
Chao Li (chaol) |
|
2 |
4 weeks ago |
| LLVMJIT: introduce force-inlined functions |
6437 |
Needs review |
Performance
|
19 |
10/10
|
+103−4
|
Pierre Ducroquet (pinaraf) |
|
|
2 |
1 month ago |
| ATPrepCmd: cleanup unreachable AT_AddIndexConstraint handling |
6439 |
Needs review |
Refactoring Only
|
19 |
10/10
|
+18−14
|
Chao Li (chaol) |
|
|
2 |
3 months ago |
| tablecmds: fix bug where index rebuild loses replica identity on partitions |
6440 |
Needs review |
Bugfix
DDL
PGConf.dev
|
stable |
10/10
|
+227−29
|
Chao Li (chaol) |
|
|
2 |
2 weeks ago |
| tablecmds: fix Deadlock caused by Attach Partition |
6442 |
Needs review |
Bugfix
DDL
|
19 |
10/10
|
+54−0
|
Chao Li (chaol) |
|
|
2 |
3 months ago |
| BUG #19382: Server crash at __nss_database_lookup |
6449 |
Needs review |
Bugfix
Security
|
17 |
10/10
|
+511−1
|
Surya Poondla (spoondla) |
|
|
2 |
1 week ago |
| Fix the race condition for updating slot minimum LSN |
6451 |
Ready for Committer |
Bugfix
|
|
10/10
|
+32−1
|
Zhijie Hou (houzj) |
Surya Poondla (spoondla) |
|
2 |
2 weeks ago |
| Use correct collation in pg_trgm |
6454 |
Ready for Committer |
Bugfix
|
19 |
Needs rebase!
|
|
David Geier (geidav) |
Zsolt Parragi (zsolt.parragi) |
|
2 |
1 month ago |
| Show expression of virtual columns in error messages |
6460 |
Needs review |
|
|
10/10
|
+208−43
|
Matheus Alcantara (matheus.alcantara) |
|
|
2 |
1 month ago |
| Unfortunate pushing down of expressions below sort |
6467 |
Waiting on Author |
Performance
|
|
10/10
|
+318−56
|
Chengpeng Yan (chengpeng.yan) |
|
|
2 |
3 weeks ago |
| Add +/- operators for xid8 type |
6478 |
Needs review |
|
19 |
10/10
|
+180−25
|
Shinya Kato (shinyakato) |
|
|
2 |
2 months ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
2 |
2 weeks ago |
| Add table COMMENTS in CREATE TABLE LIKE |
6482 |
Needs review |
DDL
Good First Review
|
19 |
10/10
|
+116−11
|
Jim Jones (jimus) |
Carlos Alves (ccsalves) |
|
2 |
1 month ago |
| Pipelined Recovery |
6487 |
Needs review |
Performance
|
19 |
10/10
|
+1988−40
|
Imran Zaheer (imranzaheer) |
|
|
2 |
1 week ago |
| Change the default wal_blocksize to 4KB |
6490 |
Needs review |
Performance
|
|
10/10
|
+12−12
|
Andy Pogrebnoi (birdofdada) |
|
|
2 |
1 month ago |
| Provide support for trailing commas |
6492 |
Waiting on Author |
|
|
Needs rebase!
|
|
Greg Sabino Mullane (greg) |
|
|
2 |
1 month ago |
| add assertion for palloc in signal handlers |
6498 |
Waiting on Author |
|
19 |
Needs rebase!
|
|
Nathan Bossart (bossartn) |
|
|
2 |
2 months ago |
| DOCS - Add introductory paragraph to Getting Started chapter |
6506 |
Needs review |
Docs Only
|
stable |
10/10
|
+6−0
|
Dragos Andriciuc (andriciucdragos) |
|
|
2 |
1 week ago |
| Improve pgindent's formatting named fields in struct literals and varidic functions |
6508 |
Ready for Committer |
Devtools
|
|
Needs rebase!
|
|
Andreas Karlsson (kandreas) |
|
|
2 |
2 weeks ago |
| Support automatic sequence replication |
6514 |
Needs review |
Logical Replication
|
|
Needs rebase!
|
|
Ajin Cherian (ajinc) |
Dilip Kumar (dilip.kumar), Hayato Kuroda (ha-kun) |
|
2 |
2 weeks ago |
| Optional skipping of unchanged relations during ANALYZE? |
6516 |
Waiting on Author |
psql
Performance
SQL Commands
|
19 |
Needs rebase!
|
|
Vasu M (vasu01) |
Ilia Evdokimov (ilidock95) |
|
2 |
1 month ago |
| [PATCH] Add RetrieveInstrumentation hook for CustomScan providers so that Parallel CustomScan providers can currently aggregate worker instrumentation before DSM unlinking |
6524 |
Needs review |
Extensions
|
stable |
10/10
|
+16−0
|
Siddharth Kothari (sidkot.google.com) |
|
|
2 |
3 weeks ago |
| amcheck: add index-all-keys-match verification for B-Tree |
6526 |
Needs review |
System Administration
Good First Review
Devtools
|
|
3/10
|
+747−46
|
Andrey Borodin (x4m) |
|
|
2 |
5 days ago |
| amcheck: fix bug of missing corruption in allequalimage validation |
6534 |
Ready for Committer |
Bugfix
|
19 |
10/10
|
+9−7
|
Chao Li (chaol) |
Xuneng Zhou (dylanzhou) |
|
2 |
2 weeks ago |
| synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
6543 |
Needs review |
Performance
Logical Replication
|
|
3/10
|
+979−134
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
2 |
2 weeks ago |
| Decorrelate nested tuple hash tables |
6553 |
Needs review |
Performance
|
19 |
9/10
|
+13−7
|
Ants Aasma (ants) |
|
|
2 |
2 months ago |
| pg_buffercache: Add per-relation summary stats |
6555 |
Needs review |
Monitoring
|
|
Needs rebase!
|
|
Lukas Fittl (lfittl) |
Paul Jungwirth (pjungwir) |
Heikki Linnakangas (heikki) |
2 |
3 weeks ago |
| Simplify ExecWithoutOverlapsNotEmpty by removing unused parameter |
6556 |
Ready for Committer |
Good First Review
|
|
Needs rebase!
|
|
Man Zeng (zengman) |
shihao zhong (zhong950419) |
|
1 |
1 month ago |
| POC: PLpgSQL FOREACH IN JSON ARRAY |
6557 |
Needs review |
PL/pgSQL
|
|
10/10
|
+1016−97
|
Pavel Stehule (okbobcz) |
Tom Lane (tgl), Jim Jones (jimus) |
|
1 |
1 month ago |
| Pgbench: remove synchronous prepare |
6558 |
Ready for Committer |
|
|
10/10
|
+104−5
|
Dmitrii Bondar (difesu) |
lakshmi g (lakshmi) |
|
1 |
3 days ago |
| psql tab completion for user functions and if explicitly required also "pg_" |
6563 |
Needs review |
psql
|
19 |
2/10
|
+49−1
|
Florin Irion (irionr) |
|
|
1 |
2 months ago |
| Reject ADD CONSTRAINT NOT NULL if name mismatches existing domain not-null constraint |
6564 |
Needs review |
Bugfix
|
stable |
10/10
|
+40−2
|
Jian He (stayreal) |
|
|
1 |
2 months ago |
| guc: make dereference style consistent in check_backtrace_functions |
6566 |
Needs review |
Bugfix
|
|
10/10
|
+16−16
|
zhang hu (zhanghu) |
|
|
1 |
1 month ago |
| doc: Improve wal_level and effective_wal_level GUC around logical replication |
6567 |
Waiting on Author |
Docs Only
|
stable |
10/10
|
+27−31
|
David Johnston (polobo) |
Andreas Karlsson (kandreas) |
|
1 |
3 weeks ago |
| Assert failure in ReorderBufferReturnTXN during logical decoding due to leaked specinsert change |
6569 |
Ready for Committer |
Bugfix
|
stable |
10/10
|
+54−11
|
Vishal Prasanna (vishalprasanna) |
Hayato Kuroda (ha-kun) |
|
1 |
1 month ago |
| Compress prune/freeze records with Delta Frame of Reference algorithm |
6574 |
Needs review |
Performance
|
|
10/10
|
+5238−60
|
Evgeny Voropaev (evoro) |
|
|
1 |
1 week ago |
| Fix the wrong behavior of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6579 |
Needs review |
Bugfix
|
19 |
Needs rebase!
|
|
Rafia Sabih (rafia.sabih), Surya Poondla (spoondla) |
|
|
1 |
1 month ago |
| Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6580 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Surya Poondla (spoondla) |
|
|
1 |
1 month ago |
| ECPG: inconsistent behavior with the document in “GET/SET DESCRIPTOR.” |
6584 |
Ready for Committer |
Bugfix
My First Patch
|
|
10/10
|
+4−12
|
Masashi Kamura (kam) |
lakshmi g (lakshmi) |
|
1 |
6 days ago |
| Fix JSON_SERIALIZE() coercion placeholder type for jsonb input |
6587 |
Needs review |
Bugfix
|
|
9/10
|
+80−3
|
Matt Blewitt (mble-ps) |
Zsolt Parragi (zsolt.parragi) |
|
1 |
1 month ago |
| Speed up COPY TO text/CSV parsing using SIMD |
6588 |
Needs review |
Performance
|
19 |
9/10
|
+262−18
|
Ayoub Kazar (kaz) |
Nathan Bossart (bossartn) |
Nathan Bossart (bossartn) |
1 |
1 month ago |
| MERGE PARTITIONS and DEPENDS ON EXTENSION. |
6589 |
Needs review |
Bugfix
|
|
0/1
|
+0−0
|
Matheus Alcantara (matheus.alcantara) |
|
|
1 |
1 week ago |
| SQL/JSON json_table() function PLAN clause |
6590 |
Needs review |
Help - Stuck Rebasing
SQL Commands
|
|
Needs rebase!
|
|
Nikita Malakhov (nmalakh) |
|
|
1 |
1 month ago |
| A stack allocation API |
6591 |
Needs review |
Refactoring Only
Performance
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
1 month ago |
| tupdesc: simplify assert in equalTupleDescs() |
6594 |
Ready for Committer |
Refactoring Only
|
19 |
10/10
|
+1−2
|
Chao Li (chaol) |
Surya Poondla (spoondla) |
|
1 |
3 days ago |
| elog: clarify usage and style of error reporting functions |
6595 |
Needs review |
Comments Only
|
19 |
10/10
|
+21−0
|
Chao Li (chaol) |
|
|
1 |
1 month ago |
| Validate user-supplied c_args in meson builds |
6596 |
Needs review |
Devtools
|
19 |
10/10
|
+9−0
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
1 |
2 weeks ago |
| Replace __builtin_types_compatible_p with _Generic |
6597 |
Needs review |
Modernization
Refactoring Only
|
|
10/10
|
+62−77
|
Thomas Munro (macdice), Jelte Fennema-Nio (jeltef) |
|
|
1 |
1 month ago |
| Add ssl_(supported|shared)_groups to sslinfo |
6598 |
Needs review |
|
|
Needs rebase!
|
|
Dmitry Dolgov (erthalion) |
|
|
1 |
1 month ago |
| pg_dump: fix NOT NULL constraint name comparison using makeObjectName |
6601 |
Needs review |
Bugfix
|
19 |
10/10
|
+258−127
|
JoongHyuk Shin (shin) |
|
|
1 |
1 month ago |
| rewriteGraphTable: Fix missing RTEs in FROM clause by setting inFromCl=true |
6602 |
Waiting on Author |
Bugfix
|
19 |
10/10
|
+3−3
|
Man Zeng (zengman) |
|
Peter Eisentraut (petere) |
1 |
1 month ago |
| Avoid use of TopMemoryContext for resource owner cleanup in portals |
6603 |
Needs review |
Refactoring Only
|
|
10/10
|
+106−23
|
Lukas Fittl (lfittl) |
|
|
1 |
1 month ago |
| Add pg_stat_vfdcache view for VFD cache statistics |
6604 |
Needs review |
Monitoring
|
19 |
Needs rebase!
|
|
Ayoub Kazar (kaz) |
David Geier (geidav) |
|
1 |
yesterday |
| Two issues leading to discrepancies in FSM data on the standby server |
6605 |
Needs review |
Bugfix
|
19 |
10/10
|
+11−1
|
Alexey Makhmutov (lerm) |
|
|
1 |
19 hours ago |
| log_checkpoints: count WAL segment creations from all processes |
6606 |
Needs review |
Monitoring
|
|
10/10
|
+137−4
|
Xuneng Zhou (dylanzhou) |
|
|
1 |
1 month ago |
| New pg_stat_tablespace view for tablespace level metrics |
6607 |
Needs review |
Monitoring
|
|
0/10
|
+759−14
|
shihao zhong (zhong950419) |
|
|
1 |
1 month ago |
| bugfix - fix broken output in expanded aligned format, when data are too short |
6608 |
Needs review |
Bugfix
|
|
10/10
|
+41−3
|
Pavel Stehule (okbobcz) |
|
|
1 |
1 month ago |
| ORDER BY ALL |
6610 |
Needs review |
SQL Commands
|
|
3/10
|
+1348−6
|
Rushabh Lathia (rlathia) |
|
|
1 |
1 month ago |
| This adds a new GUC parameter that automatically rolls back prepared transactions that have remained unresolved beyond the configured timeout. The cleanup is performed by the checkpointer process. |
6611 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Nikhil Chawla (nchawla) |
|
|
1 |
1 month ago |
| heapam_tuple_complete_speculative : remove unnecessary tuple fetch |
6613 |
Ready for Committer |
Refactoring Only
|
stable |
10/10
|
+1−7
|
Chao Li (chaol) |
|
|
1 |
1 month ago |
| Add http connection service file functionality |
6614 |
Needs review |
libpq
|
19 |
4/10
|
+1117−2
|
Andrew Jackson (andrewjackson) |
|
|
1 |
3 weeks ago |
| Make \d tablename fast again, regression introduced by 85b7efa1cdd |
6615 |
Needs review |
Bugfix
Performance
|
18 |
10/10
|
+31−1
|
Jelte Fennema-Nio (jeltef) |
|
|
1 |
1 month ago |
| VACUUM FULL, CLUSTER, and REPACK block on other sessions' temp tables |
6616 |
Needs review |
Bugfix
Backport
|
stable |
10/10
|
+95−1
|
Jim Jones (jimus) |
|
|
1 |
yesterday |
| Fix a file descriptor leak when using io_method=io_uring |
6617 |
Needs review |
Bugfix
AIO
My First Patch
|
stable |
10/10
|
+42−0
|
Lucas DRAESCHER (draescherl) |
|
|
1 |
2 weeks ago |
| Improving psql autocompletion for SET LOCAL / SET SESSION |
6618 |
Needs review |
psql
My First Patch
|
|
10/10
|
+7−0
|
Álvaro Rodríguez (arodrgr) |
|
|
1 |
1 month ago |
| pg_stat_xact_user_tables stat not currect during the transaction |
6619 |
Needs review |
Bugfix
|
|
9/10
|
+332−10
|
Xuneng Zhou (dylanzhou) |
Gabriel Batista (gabo) |
|
1 |
1 month ago |
| PoC - psql - emphases line with table name in verbose output |
6620 |
Needs review |
psql
|
|
10/10
|
+16−1
|
Pavel Stehule (okbobcz) |
|
|
1 |
1 week ago |
| Bug: wrong relname in RemoveSubscriptionRel() error detail |
6621 |
Needs review |
Bugfix
|
stable |
10/10
|
+1−1
|
Chao Li (chaol) |
|
|
1 |
1 month ago |
| Get rid of redundant StringInfo accumulation |
6622 |
Needs review |
Performance
|
19 |
10/10
|
+15−5
|
Daniil Davydov (dddaniil) |
|
|
1 |
1 month ago |
| pg_stat_statements: add last_execution_start column |
6624 |
Needs review |
Monitoring
PGConf.dev
|
19 |
9/10
|
+354−11
|
Pavlo Golub (pasha_golub) |
|
|
1 |
2 weeks ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Needs review |
Performance
|
|
10/10
|
+422−9
|
Richard Guo (richardguo) |
|
|
1 |
1 month ago |
| jsonb subscripting vs SQL/JSON array accessor semantics (SQL:2023) |
6631 |
Needs review |
|
|
10/10
|
+758−87
|
Alexandra Wang (l-wang) |
|
|
1 |
1 month ago |
| Add tests for src/backend/nodes/extensible.c |
6632 |
Needs review |
Testing
|
|
10/10
|
+575−0
|
Aleksander Alekseev (a.alekseev) |
|
|
1 |
1 month ago |
| Add condition variable support to WaitEventSetWait() |
6633 |
Needs review |
Refactoring Only
PGConf.dev
|
19 |
10/10
|
+197−48
|
Chao Li (chaol) |
|
|
1 |
1 week ago |
| Skip prefetch for block references that follow a FPW or WILL_INIT of the same block |
6634 |
Needs review |
Performance
Physical Replication
|
19 |
Needs rebase!
|
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
1 |
1 month ago |
| Add support for INSERT ... SET syntax |
6635 |
Needs review |
SQL Commands
|
|
10/10
|
+814−4
|
Suraj Kharage (surajk) |
|
|
1 |
3 weeks ago |
| Add ParameterDescription message to libpq frontend long message types |
6636 |
Needs review |
Bugfix
libpq
My First Patch
|
stable |
9/10
|
+2−1
|
Ning Sun (sunng) |
|
|
1 |
1 month ago |
| Silence compiler warnings -Wmaybe-uninitialized |
6638 |
Needs review |
Refactoring Only
|
stable |
10/10
|
+3−3
|
Imran Zaheer (imranzaheer) |
|
|
1 |
4 weeks ago |
| Track skipped vacuum and analyze in pg_stat_all_tables |
6639 |
Needs review |
Monitoring
|
|
10/10
|
+601−56
|
Yugo Nagata (yugo.nagata) |
|
|
1 |
6 days ago |
| Warn when creating or enabling a subscription with max_logical_replication_workers = 0 |
6642 |
Needs review |
Logical Replication
|
|
10/10
|
+14−0
|
Yugo Nagata (yugo.nagata) |
|
|
1 |
2 weeks ago |
| Extract numeric filed in JSONB more effectively |
6644 |
Needs review |
Performance
|
|
7/10
|
+3155−10
|
Andy Fan (andyf), Haibo Yan (billyean) |
|
|
1 |
5 days ago |
| meson: Adjust test timeout for Valgrind builds |
6646 |
Needs review |
Devtools
|
19 |
10/10
|
+21−4
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
1 |
3 weeks ago |
| Remove commented-out code in 026_overwrite_contrecord.pl |
6647 |
Needs review |
Comments Only
|
|
10/10
|
+0−0
|
Imran Zaheer (imranzaheer) |
|
|
1 |
3 weeks ago |
| Docs: Create table description for constraints markup fix and label tweaks |
6648 |
Needs review |
Bugfix
Docs Only
|
|
10/10
|
+8−8
|
David Johnston (polobo) |
Dapeng Wang (w345731923) |
|
1 |
3 weeks ago |
| Docs: Distinguish table and index storage parameters in CREATE TABLE |
6649 |
Needs review |
Docs Only
|
|
9/10
|
+21−12
|
David Johnston (polobo) |
Andreas Karlsson (kandreas) |
|
1 |
4 weeks ago |
| Optimize numeric comparison and aggregation via packed-datum extraction |
6651 |
Needs review |
Performance
|
|
10/10
|
+246−28
|
Chenhui Mo (littleganyu) |
|
|
1 |
4 weeks ago |
| Resizable shared memory structures |
6652 |
Needs review |
System Administration
|
|
Needs rebase!
|
|
Ashutosh Bapat (ashutoshbapat) |
|
|
1 |
1 week ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6653 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Alexandre Felipe (afelipe) |
|
|
1 |
2 weeks ago |
| Return DSA area for hash table from GetNamedDSHash() |
6655 |
Needs review |
|
19 |
10/10
|
+12−0
|
Sami Imseih (simseih) |
|
|
1 |
3 weeks ago |
| Minor cleanup of Meson files given that we require 0.57 |
6656 |
Needs review |
Refactoring Only
|
|
Needs rebase!
|
|
Andreas Karlsson (kandreas) |
|
|
1 |
1 week ago |
| Environment variable to disable diffs file output |
6657 |
Needs review |
Testing
Devtools
|
|
10/10
|
+7−0
|
Ilya Cherdakov (i.cherdakov) |
|
|
1 |
3 weeks ago |
| Upload only the failed tests' logs to the Postgres CI (Cirrus CI) |
6658 |
Needs review |
CI
|
|
10/10
|
+86−0
|
Nazir Bilal Yavuz (nbyavuz) |
|
|
1 |
3 weeks ago |
| bump minimum supported version of psql and pg_{dump,dumpall,upgrade} to v10 |
6659 |
Needs review |
|
|
10/10
|
+618−1774
|
Nathan Bossart (bossartn) |
|
|
1 |
yesterday |
| s/pg_attribute_always_inline/pg_always_inline/ |
6661 |
Needs review |
Refactoring Only
|
|
Needs rebase!
|
|
Andres Freund (andresfreund) |
|
|
1 |
3 weeks ago |
| Allow a condition string in an injection point |
6663 |
Needs review |
|
|
10/10
|
+123−22
|
Sami Imseih (simseih) |
|
|
1 |
3 weeks ago |
| Support EXCEPT for ALL SEQUENCES publications |
6664 |
Needs review |
Logical Replication
|
|
3/10
|
+702−270
|
Shlok Kyal (shlokkyal) |
|
|
1 |
2 weeks ago |
| pg_waldump: read modern tar formats with libarchive |
6665 |
Needs review |
Modernization
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
3 weeks ago |
| change SOFT_ERROR_OCCURRED to a static inline function |
6666 |
Needs review |
Refactoring Only
|
|
10/10
|
+14−6
|
Nathan Bossart (bossartn) |
|
|
1 |
1 month ago |
| DISTINCT in plain aggregate window functions |
6667 |
Needs review |
SQL Commands
|
|
10/10
|
+1168−3
|
Haibo Yan (billyean) |
|
|
1 |
3 days ago |
| Implement missing join selectivity estimation for range types |
6668 |
Needs review |
|
|
10/10
|
+987−657
|
Mahmoud SAKR (mahmsakr), Diogo Repas (diogo.repas), Maxime Schoemans (mschoema), Zhicheng Luo (zcsysu.163.com), Haibo Yan (billyean) |
|
|
1 |
1 week ago |
| Use stack allocated StringInfoDatas, where possible (round 2) |
6670 |
Needs review |
Refactoring Only
|
19 |
0/1
|
+0−0
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
1 |
2 weeks ago |
| Avoid calling SetMatViewPopulatedState if possible |
6671 |
Needs review |
Good First Review
|
|
10/10
|
+2−1
|
ChangAo Chen (chenchangao) |
|
|
1 |
3 weeks ago |
| Don't call ereport(ERROR) from recovery target GUC assign hooks |
6672 |
Needs review |
Bugfix
|
19 |
8/10
|
+111−55
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii) |
Fujii Masao (masaofujii) |
1 |
2 days ago |
| More jsonpath methods: translate, split, join |
6673 |
Needs review |
SQL Commands
|
19 |
10/10
|
+658−7
|
Florents Tselai (florentst) |
|
|
1 |
2 weeks ago |
| Adding a stored generated column without long-lived locks |
6674 |
Needs review |
DDL
PGConf.dev
My First Patch
|
|
10/10
|
+882−1
|
Alberto Piai (albe) |
|
|
2 |
1 week ago |
| Add bms_offset_members() function for bitshifting Bitmapsets |
6675 |
Needs review |
Refactoring Only
|
|
10/10
|
+374−52
|
David Rowley (davidrowley) |
|
|
1 |
1 week ago |
| ISBN range table |
6676 |
Needs review |
Modernization
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
2 weeks ago |
| WAIT FOR LSN bug fixes |
6678 |
Needs review |
Bugfix
|
19 |
10/10
|
+507−61
|
Xuneng Zhou (dylanzhou) |
|
|
1 |
2 days ago |
| Take a long time to reach consistent after pg_rewind |
6679 |
Needs review |
Bugfix
|
|
10/10
|
+24−1
|
ChangAo Chen (chenchangao) |
Surya Poondla (spoondla) |
|
1 |
2 weeks ago |
| Return value of XLogInsertRecord() for XLOG_SWITCH record is inconsistent with other records |
6680 |
Needs review |
Good First Review
|
|
8/10
|
+9−2
|
ChangAo Chen (chenchangao) |
Surya Poondla (spoondla) |
|
1 |
1 week ago |
| docs: Include database collation check on SQL from alter_collation.sgml |
6681 |
Needs review |
Docs Only
|
|
10/10
|
+20−6
|
Matheus Alcantara (matheus.alcantara) |
|
|
1 |
2 weeks ago |
| Todo item: Include the symbolic SQLSTATE name in verbose error reports |
6685 |
Needs review |
System Administration
|
|
Needs rebase!
|
|
Josh Kupershmidt (schmiddy) |
|
|
1 |
1 month ago |
| pg_dump: eliminate tmpfile double-write in tar format output |
6686 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Josh Kupershmidt (schmiddy) |
|
|
1 |
2 weeks ago |
| Adding event mask validation for ModifyWaitEvent |
6687 |
Needs review |
Bugfix
|
|
Needs rebase!
|
|
Josh Kupershmidt (schmiddy) |
|
|
1 |
3 weeks ago |
| Extensible sync handler registration |
6689 |
Needs review |
Extensions
|
19 |
10/10
|
+798−41
|
Greg Lamberson (glamberson) |
|
|
1 |
1 week ago |
| Prevent repeated deadlock-check signals in standby buffer pin waits |
6690 |
Needs review |
Performance
|
19 |
10/10
|
+12−9
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii) |
Fujii Masao (masaofujii) |
1 |
6 days ago |
| repack: clarify final phase of concurrent mode in file header comment |
6692 |
Needs review |
Comments Only
DDL
|
19 |
10/10
|
+4−3
|
Chao Li (chaol) |
|
|
1 |
2 weeks ago |
| Extend MXactCache lifetime from per-transaction to per-session |
6693 |
Needs review |
Performance
|
19 |
10/10
|
+47−20
|
JoongHyuk Shin (shin) |
|
|
1 |
1 week ago |
| Fix duplicate errmsg in ALTER TABLE SPLIT PARTITION |
6694 |
Needs review |
Bugfix
|
19 |
10/10
|
+157−171
|
Ayush Tiwari (aytiwari) |
|
|
1 |
4 days ago |
| Fix column name escaping in postgres_fdw stats import |
6695 |
Ready for Committer |
Bugfix
Security
|
19 |
10/10
|
+29−4
|
Ayush Tiwari (aytiwari) |
|
|
1 |
1 week ago |
| Proposal: Conflict log history table for Logical Replication |
6696 |
Needs review |
Logical Replication
|
stable |
10/10
|
+1828−162
|
Dilip Kumar (dilip.kumar) |
|
|
1 |
yesterday |
| Remove dead code in ExecForPortionOfLeftovers() |
6697 |
Needs review |
Good First Review
Performance
|
19 |
10/10
|
+0−14
|
Aleksander Alekseev (a.alekseev) |
|
|
1 |
1 week ago |
| Fix null pointer dereference in PG19 |
6698 |
Needs review |
Bugfix
|
19 |
10/10
|
+49−16
|
Aleksander Alekseev (a.alekseev) |
|
|
1 |
1 week ago |
| Allow SJE to recognize GiST-backed temporal primary keys |
6699 |
Needs review |
Bugfix
|
|
10/10
|
+61−1
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
1 |
1 week ago |
| Apply ENCODING option for COPY TO FORMAT JSON |
6700 |
Needs review |
Bugfix
|
19 |
10/10
|
+52−1
|
Ayush Tiwari (aytiwari) |
|
|
1 |
3 days ago |
| Fix FOR PORTION OF recomputing GENERATED STORED columns that depend on the range column |
6701 |
Needs review |
Bugfix
|
19 |
Needs rebase!
|
|
Paul Jungwirth (pjungwir), SATYANARAYANA NARLAPURAM (satyanarayanan), jian he (universality) |
|
|
1 |
1 week ago |
| Fix temporal leftover INSERT triggers sharing a tuple |
6702 |
Needs review |
Bugfix
|
19 |
10/10
|
+87−0
|
Sergei Patiakin (spatiakin) |
Paul Jungwirth (pjungwir) |
|
1 |
3 days ago |
| Fix FOR PORTION OF with DO INSTEAD/DO ALSO rules |
6703 |
Needs review |
Bugfix
|
19 |
10/10
|
+0−0
|
jian he (universality) |
Paul Jungwirth (pjungwir) |
|
1 |
6 days ago |
| Skip FOR PORTION OF leftovers after INSTEAD OF trigger |
6704 |
Needs review |
Bugfix
|
19 |
10/10
|
+49−16
|
jian he (universality) |
Paul Jungwirth (pjungwir) |
|
1 |
1 week ago |
| Logical Replication - revisit `is_table_publication` function implementation |
6705 |
Needs review |
Refactoring Only
Performance
|
stable |
10/10
|
+28−27
|
Peter Smith (smithpb2250) |
|
|
1 |
3 weeks ago |
| DOCS: Describe some missing parameters on CREATE/ALTER PUBLICATION pages |
6706 |
Needs review |
Docs Only
|
stable |
10/10
|
+68−24
|
Peter Smith (smithpb2250) |
|
|
1 |
3 weeks ago |
| Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server |
6707 |
Needs review |
Bugfix
DDL
|
19 |
10/10
|
+116−13
|
Chao Li (chaol) |
|
|
1 |
2 days ago |
| Cleanup: Replace sscanf with strtol/strtoul in snapmgr |
6709 |
Ready for Committer |
Refactoring Only
Performance
|
|
10/10
|
+35−10
|
Amul Sul (sulamul) |
Andreas Karlsson (kandreas) |
|
1 |
2 days ago |
| GetPublicationsStr i18n for quotes |
6710 |
Needs review |
Bugfix
Logical Replication
|
19 |
Needs rebase!
|
|
Peter Smith (smithpb2250) |
|
|
1 |
5 days ago |
| meson/testwrap: support EXTRA_REGRESS_OPTS environment variable |
6711 |
Needs review |
Devtools
|
|
10/10
|
+3−0
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
1 |
2 days ago |
| [Patch]Incorrect usage of PageGetFreeSpace instead of PageGetHeapFreeSpace in heap_xlog_visible |
6712 |
Needs review |
Bugfix
|
14 |
Needs rebase!
|
|
Alexey Makhmutov (lerm) |
|
|
1 |
1 week ago |
| pgbench: make verbose error messages thread-safe |
6713 |
Needs review |
Bugfix
|
|
9/10
|
+11−12
|
Fujii Masao (masaofujii) |
|
|
1 |
1 week ago |
| pgcrypto: Respect builtin_crypto_enabled for PGP ciphers |
6714 |
Needs review |
Security
|
|
10/10
|
+250−14
|
Shishir Sharma (shishir2001) |
|
|
1 |
1 week ago |
| Fix race condition in pg_get_publication_tables with concurrent DROP TABLE |
6715 |
Needs review |
Bugfix
|
|
9/10
|
+104−7
|
Bharath Rupireddy (bharathrupireddy) |
|
|
1 |
2 days ago |
| Fix cascading standby reconnect failure after archive fallback |
6716 |
Needs review |
Bugfix
|
stable |
10/10
|
+252−7
|
Marco Nenciarini (mnencia) |
|
|
1 |
2 days ago |
| Improve HASH overflow page reuse by preferring recently freed pages to enhance locality. |
6718 |
Needs review |
Performance
|
|
Needs rebase!
|
|
lakshmi g (lakshmi) |
|
|
1 |
5 days ago |
| Support for DNS SRV records (whole cluster as 1 dns record) |
6719 |
Needs review |
libpq
PGConf.dev
|
|
9/10
|
+863−6
|
Andrey Borodin (x4m) |
|
|
1 |
1 week ago |
| Remove inner joins based on foreign keys |
6720 |
Needs review |
|
|
10/10
|
+1607−46
|
Richard Guo (richardguo) |
|
|
1 |
2 days ago |
| Propagate stadistinct through GROUP BY/DISTINCT in subqueries and CTEs |
6721 |
Needs review |
Performance
|
|
10/10
|
+221−14
|
Richard Guo (richardguo) |
|
|
1 |
2 weeks ago |
| Consider collation when proving uniqueness |
6722 |
Needs review |
Bugfix
|
stable |
10/10
|
+537−59
|
Richard Guo (richardguo) |
|
|
1 |
1 week ago |
| Make transformAExprIn() return a flattened bool expression directly |
6723 |
Needs review |
Good First Review
|
|
10/10
|
+20−16
|
ChangAo Chen (chenchangao) |
|
|
1 |
3 days ago |
| Add join MCV statistics for selectivity estimation |
6724 |
Needs review |
DDL
PGConf.dev
Performance
|
|
Needs rebase!
|
|
Alexandra Wang (alexandrawang) |
|
|
1 |
3 days ago |
| Fix overflow and underflow in regr_r2() |
6725 |
Needs review |
Bugfix
|
19 |
10/10
|
+112−29
|
Chengpeng Yan (chengpeng.yan) |
|
|
1 |
6 days ago |
| Refactor code around GUC default_toast_compression |
6727 |
Needs review |
Refactoring Only
|
|
9/10
|
+151−82
|
Michael Paquier (michael-kun) |
|
|
1 |
yesterday |