| Add XMLCanonicalize function |
4237 |
Ready for Committer |
SQL Commands
|
20 |
10/10
|
+310−0
|
Jim Jones (jimus) |
Pavel Stehule (okbobcz), Oliver Ford (ojford), Yogesh Sharma (sharmay), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
17 |
1 month ago |
| Vacuum statistics |
5012 |
Needs review |
Monitoring
|
19 |
1/2
|
+3914−13
|
Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) |
Ilia Evdokimov (ilidock95), Khoa Nguyen (kdnguyen9) |
|
12 |
5 days ago |
| Add XMLCast (SQL/XML X025) |
5110 |
Needs review |
SQL Commands
|
20 |
10/10
|
+1547−26
|
Jim Jones (jimus) |
Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
12 |
1 month ago |
| SendProcSignal(), SetLatch() → SendInterrupt() |
5118 |
Needs review |
Refactoring Only
|
|
Needs rebase!
|
|
Heikki Linnakangas (heikki), Thomas Munro (macdice) |
|
|
6 |
1 month ago |
| Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) |
5279 |
Needs review |
SQL Commands
|
20 |
9/10
|
+776−55
|
Jim Jones (jimus) |
newtglobal postgresql_contributors (newtpostgrescontributors) |
|
10 |
1 month ago |
| Add XMLDocument (SQL/XML X030) |
5431 |
Ready for Committer |
SQL Commands
|
20 |
10/10
|
+153−1
|
Jim Jones (jimus) |
Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
9 |
1 month ago |
| Add XMLNamespaces option to XMLElement |
5456 |
Ready for Committer |
SQL Commands
|
20 |
10/10
|
+787−39
|
Pavel Stehule (okbobcz), Jim Jones (jimus) |
Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
9 |
1 month ago |
| Fix Protocol documentation |
5783 |
Needs review |
Docs Only
|
18 |
9/10
|
+22−104
|
Dave Cramer (dcramer) |
|
|
2 |
3 weeks ago |
| Adding basic NUMA awareness |
6049 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Tomas Vondra (fuzzycz) |
Jakub Wartak (jakub.wartak.tomtom) |
|
2 |
3 weeks ago |
| explain plans for foreign scans |
6285 |
Needs review |
|
19 |
10/10
|
+1178−12
|
Dinesh Salve (dinesh-salve) |
Sami Imseih (simseih) |
|
3 |
17 hours ago |
| Add table COMMENTS in CREATE TABLE LIKE |
6482 |
Needs review |
DDL
Good First Review
|
20 |
10/10
|
+116−11
|
Jim Jones (jimus) |
Carlos Alves (ccsalves), Zizhuan Liu (liuzizhuan) |
|
3 |
4 days ago |
| Track skipped vacuum and analyze in pg_stat_all_tables |
6639 |
Needs review |
Monitoring
|
|
10/10
|
+767−36
|
Yugo Nagata (yugo.nagata) |
Shinya Kato (shinyakato), Sami Imseih (simseih), Zsolt Parragi (zsolt.parragi) |
|
2 |
9 hours ago |
| Fix Segfault caused by reentrancy in ri_triggers.c |
6825 |
Needs review |
Bugfix
|
|
10/10
|
+240−1
|
Lucas Jeffrey (lucasjeffrey.acs) |
|
|
2 |
2 weeks ago |
| Separate catalog_xmin from xmin in walsender hot standby feedback |
6861 |
Needs review |
Physical Replication
|
20 |
10/10
|
+49−19
|
Rui Zhao (zhaorui) |
|
|
2 |
1 month ago |
| Add malloc attribute to memory allocation functions |
6967 |
Needs review |
Modernization
|
20 |
9/10
|
+48−36
|
Tristan Partin (tristan957) |
solai v (solaiv) |
|
1 |
2 weeks ago |
| Tepid: extend the heap-only tuple (HOT) update optimization model such that only those indexes directly impacted by the update need be updated |
6968 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Nathan Bossart (bossartn), Greg Burd (gregburd) |
|
|
1 |
19 hours ago |
| add list of major features to the v19 release notes |
6969 |
Ready for Committer |
Docs Only
|
19 |
Needs rebase!
|
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
1 |
7 hours ago |
| Re-read subscription state after lock in AlterSubscription |
6972 |
Needs review |
Bugfix
|
stable |
Needs rebase!
|
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
1 |
3 weeks ago |
| replacing join_collapse_limit with a join hardness estimate |
6973 |
Needs review |
Performance
|
|
1/2
|
+1403−3
|
Tomas Vondra (fuzzycz) |
|
|
1 |
3 weeks ago |
| json/jsonb cleanup + FmgrInfo caching |
6975 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Robert Haas (rhaas) |
|
|
1 |
2 weeks ago |
| pg_plan_advice: add NO_ scan and join method tags |
6976 |
Needs review |
System Administration
|
20 |
10/10
|
+1127−23
|
Florin Irion (irionr) |
solai v (solaiv) |
|
1 |
13 hours ago |
| remove VersionedQuery support from psql tab completion |
6977 |
Needs review |
Refactoring Only
|
20 |
10/10
|
+45−105
|
Nathan Bossart (bossartn) |
|
|
1 |
3 weeks ago |
| [PATCH v2] Avoid internal error for invalid interval typmods |
6978 |
Ready for Committer |
|
|
10/10
|
+22−1
|
feng wu (wufengwind) |
solai v (solaiv) |
|
1 |
3 weeks ago |
| Lazy LEFT NestLoop JOIN: gate rescanning of the inner side by outer-side-only join clauses |
6981 |
Needs review |
Performance
|
20 |
9/10
|
+469−252
|
Andrei Lepikhov (lepikhov), Mikhail Zhilin (mizhka-at-pgpro), Peter Petrov (pspetrov) |
|
|
1 |
15 hours ago |
| Proposal: INSERT ... BY NAME |
6982 |
Needs review |
SQL Commands
|
20 |
10/10
|
+503−0
|
Ayush Tiwari (aytiwari) |
Jim Jones (jimus), solai v (solaiv) |
|
1 |
6 days ago |
| pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement |
6983 |
Needs review |
System Administration
|
20 |
10/10
|
+574−11
|
Florin Irion (irionr) |
solai v (solaiv) |
|
1 |
2 weeks ago |
| [PATCH v1 0/7] Wait event timing and tracing instrumentation |
6984 |
Needs review |
Performance
Monitoring
|
|
9/10
|
+5594−9
|
Dmitry Fomin (dmitryf) |
|
|
1 |
6 days ago |
| Fix races conditions in DropRole() and GrantRole() |
6985 |
Ready for Committer |
Bugfix
|
stable |
10/10
|
+373−65
|
Bertrand Drouvot (bertranddrouvot.pg) |
Surya Poondla (spoondla) |
|
1 |
1 week ago |
| Remove unused include from analyze.c |
6987 |
Needs review |
Refactoring Only
Good First Review
|
20 |
Needs rebase!
|
|
Dongpo Liu (0xpoe) |
|
|
1 |
5 days ago |
| pg_threads.h take II |
6988 |
Needs review |
Multithreading
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
3 weeks ago |
| Possible replace of strncpy on xactdesc.c |
6989 |
Needs review |
Refactoring Only
|
|
10/10
|
+1−1
|
Mario Gonzalez (gonzalemario) |
solai v (solaiv) |
|
1 |
2 weeks ago |
| Rename EXISTS-to-ANY converted subplan to exists_to_any |
6990 |
Needs review |
|
19 |
10/10
|
+30−30
|
Yugo Nagata (yugo.nagata) |
solai v (solaiv) |
Fujii Masao (masaofujii) |
1 |
4 days ago |
| Add per-backend AIO statistics |
6991 |
Needs review |
Monitoring
|
20 |
10/10
|
+319−1
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
1 |
2 weeks ago |
| Don't count logical decoding cleanup aborts in pg_stat_database.xact_rollback |
6992 |
Needs review |
Bugfix
|
|
10/10
|
+221−18
|
Nik Samokhvalov (nikolay) |
jihyun bahn (ichibahn) |
|
1 |
2 weeks ago |
| lazy_scan_heap: avoid vacuum block, already vacuumed (src/backend/access/heap/vacuumlazy.c) |
6993 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Ranier Vilela (raniervilela) |
|
|
1 |
3 weeks ago |
| clean up AdjustUpgrade.pm after pg_upgrade minimum version bump |
6995 |
Ready for Committer |
Refactoring Only
|
20 |
10/10
|
+5−202
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
1 |
2 weeks ago |
| Batched clock sweep to reduce cross-socket atomic contention |
7000 |
Needs review |
Performance
|
20 |
9/10
|
+597−1649
|
Jim Mlodgenski (jimmy76), Greg Burd (gregburd) |
|
|
1 |
3 days ago |
| convert various variables to atomics |
7001 |
Needs review |
|
20 |
10/10
|
+123−213
|
Nathan Bossart (bossartn) |
|
|
1 |
4 days ago |
| Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation |
7002 |
Needs review |
Bugfix
|
19 |
8/10
|
+246−15
|
Srinath Reddy (srinath-reddy-sadipiralla) |
|
|
1 |
yesterday |
| Improve get_json_table_plan() test coverage |
7003 |
Needs review |
Testing
|
20 |
10/10
|
+40−0
|
Aleksander Alekseev (a.alekseev) |
solai v (solaiv) |
|
1 |
yesterday |
| pg_xmin_horizon system view |
7004 |
Needs review |
Monitoring
|
20 |
10/10
|
+1227−19
|
Scott Ray (scottray) |
solai v (solaiv) |
|
1 |
1 week ago |
| Add configure-time choice of either port/atomics.h or <stdatomic.h> for atomic operations |
7005 |
Needs review |
Refactoring Only
Modernization
|
20 |
10/10
|
+3630−2376
|
Thomas Munro (macdice), Greg Burd (gregburd) |
|
|
1 |
2 weeks ago |
| Add bypass IO to pg_stat_io |
7006 |
Needs review |
Monitoring
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
1 |
3 weeks ago |
| Grab bag of OpenSSL fixups |
7007 |
Needs review |
Security
|
20 |
10/10
|
+49−31
|
Daniel Gustafsson (d_gustafsson) |
|
|
1 |
10 hours ago |
| Separation of OpenSSL and LibreSSL |
7008 |
Needs review |
Security
|
20 |
1/2
|
+4105−201
|
Daniel Gustafsson (d_gustafsson) |
|
|
1 |
2 weeks ago |
| PSQL - improve tab completion for pub/sub options |
7009 |
Needs review |
Bugfix
Good First Review
psql
Logical Replication
|
|
10/10
|
+123−20
|
Peter Smith (smithpb2250) |
|
|
1 |
16 hours ago |
| pg_hosts: Add pg_hosts_file_rules() |
7011 |
Needs review |
SQL Commands
|
|
10/10
|
+380−8
|
Zsolt Parragi (zsolt.parragi) |
solai v (solaiv) |
|
1 |
1 week ago |
| pg_dump: ALTER INDEX SET STATISTICS missing for index-backed constraints |
7012 |
Needs review |
Bugfix
|
|
10/10
|
+61−0
|
Zsolt Parragi (zsolt.parragi) |
|
|
1 |
2 weeks ago |
| Use Boyer-Moore-Horspool for simple LIKE contains patterns |
7013 |
Needs review |
Performance
|
20 |
10/10
|
+721−2
|
Atsushi Ogawa (atsushio) |
|
|
1 |
1 week ago |
| Avoid crash on malformed CREATE_REPLICATION_SLOT reply |
7014 |
Needs review |
Bugfix
|
|
10/10
|
+13−0
|
Kenny Chen (kennychen) |
|
|
1 |
1 week ago |
| Fix LSN of logical decoding message |
7016 |
Needs review |
Bugfix
|
18 |
10/10
|
+3−3
|
Atsushi Torikoshi (atsushitorikoshi) |
solai v (solaiv) |
|
1 |
1 week ago |
| Soft DROP TABLE, recoverable drops for PostgreSQL |
7017 |
Needs review |
Extensions
DDL
|
20 |
10/10
|
+10306−0
|
Surya Poondla (spoondla) |
|
|
1 |
21 hours ago |
| GRAPH_TABLE: aggregates/window/set-returning functions in COLUMNS crash the backend |
7018 |
Needs review |
Bugfix
|
20 |
10/10
|
+30−0
|
Ewan Young (kdbase.hack.gmail.com) |
|
|
1 |
1 month ago |
| Do not flush BufFile for regular temp files on close |
7020 |
Needs review |
Performance
|
stable |
9/10
|
+3−2
|
Sergey Solovev (ashblade) |
|
|
1 |
1 week ago |
| Proposal: JSON5 support in the JSON parsers |
7021 |
Needs review |
System Administration
|
|
9/10
|
+2342−103
|
Zsolt Parragi (zsolt.parragi) |
Tristan Partin (tristan957) |
|
1 |
2 weeks ago |
| Add pg_get_event_trigger_ddl() function |
7022 |
Ready for Committer |
DDL
|
20 |
10/10
|
+376−2
|
Ian Barwick (barwick) |
Jim Jones (jimus), Zsolt Parragi (zsolt.parragi), solai v (solaiv) |
|
1 |
5 days ago |
| A new C function `get_partition_root`. |
7023 |
Needs review |
Refactoring Only
Good First Review
|
|
10/10
|
+33−16
|
Peter Smith (smithpb2250) |
solai v (solaiv) |
|
1 |
17 hours ago |
| pg_upgrade: add --initdb option to create the new cluster automatically |
7025 |
Needs review |
|
20 |
10/10
|
+488−17
|
Bohyun Lee (leebohyun) |
|
|
1 |
1 week ago |
| PITR: Shut down instead of promoting when recovery cannot pause |
7026 |
Needs review |
Bugfix
|
|
Needs rebase!
|
|
Jan Nidzwetzki (jnidzwetzki) |
|
|
1 |
1 month ago |
| psql: schema-qualify catalog references in a tab-completion query |
7027 |
Ready for Committer |
Bugfix
|
|
10/10
|
+2−2
|
Vismay Tiwari (vismay.t.gmail.com) |
sundong kim (mok03127.naver.com) |
|
1 |
1 week ago |
| amcheck: Allow interrupting the child-level rightlink walk |
7028 |
Needs review |
Bugfix
|
|
10/10
|
+2−0
|
sundong kim (mok03127.naver.com) |
|
|
1 |
1 week ago |
| Document "getdatabaseencoding()" |
7029 |
Ready for Committer |
Docs Only
|
|
10/10
|
+17−0
|
Ian Barwick (barwick) |
Surya Poondla (spoondla) |
|
1 |
yesterday |
| Caching a partition index's parent OID in the relcache? |
7030 |
Needs review |
Performance
|
20 |
10/10
|
+229−6
|
Ayush Tiwari (aytiwari) |
|
|
1 |
1 week ago |
| Restore vacuum_delay_point() in GIN posting-tree leaf vacuum |
7031 |
Needs review |
Bugfix
|
|
10/10
|
+7−0
|
sundong kim (mok03127.naver.com) |
solai v (solaiv) |
|
1 |
yesterday |
| Modernize our parsing of XML data in CONTENT mode |
7032 |
Needs review |
Modernization
|
|
10/10
|
+66−67
|
Tom Lane (tgl) |
|
|
1 |
1 week ago |
| Adds summaries of all planner nodes to docs |
7033 |
Needs review |
Docs Only
|
|
10/10
|
+2260−4
|
Brian Brennglass (brianb0) |
|
|
1 |
yesterday |
| Rewrite undirected edge patterns in GRAPH_TABLE using UNION ALL |
7034 |
Needs review |
Performance
|
20 |
10/10
|
+307−26
|
Ayoub Kazar (kaz) |
|
|
1 |
yesterday |
| read stream: Backward I/O combining |
7035 |
Needs review |
Performance
|
|
10/10
|
+951−123
|
Nazir Bilal Yavuz (nbyavuz) |
|
|
1 |
4 days ago |
| pg_plan_advice: fix empty FOREIGN_JOIN sublist validation |
7036 |
Needs review |
Bugfix
|
19 |
10/10
|
+5−1
|
Chao Li (chaol) |
|
|
1 |
1 week ago |
| injection_points: canceled or terminated waiters leak their wait slots |
7037 |
Needs review |
Bugfix
|
|
Needs rebase!
|
|
Zsolt Parragi (zsolt.parragi) |
|
|
1 |
5 days ago |
| Add vacuum_delay_point() to GiST empty-page deletion pass |
7038 |
Needs review |
Bugfix
|
|
10/10
|
+3−0
|
sundong kim (mok03127.naver.com) |
solai v (solaiv) |
|
1 |
yesterday |
| REPACK (CONCURRENTLY) doesn't handle invalid indexes |
7039 |
Needs review |
Bugfix
|
19 |
10/10
|
+75−6
|
Zsolt Parragi (zsolt.parragi) |
|
|
1 |
13 hours ago |
| REPACK (CONCURRENTLY) doesn't handle invalid indexes |
7040 |
Needs review |
Bugfix
|
19 |
10/10
|
+75−6
|
Zsolt Parragi (zsolt.parragi) |
|
|
1 |
13 hours ago |
| Race between datachecksum enablement and create table with the file_copy strategy |
7041 |
Needs review |
Bugfix
|
19 |
10/10
|
+96−0
|
Zsolt Parragi (zsolt.parragi) |
|
|
1 |
yesterday |
| Logical Replication - revisit `is_table_publication` function implementation |
7042 |
Needs review |
Refactoring Only
Logical Replication
|
19 |
10/10
|
+28−27
|
Peter Smith (smithpb2250) |
|
|
1 |
6 days ago |
| Make the logical replication conflict messages more like each other |
7043 |
Needs review |
Logical Replication
|
19 |
Not processed
|
|
Peter Smith (smithpb2250) |
|
|
1 |
6 days ago |
| doc: Add PROPERTY GRAPH to the access privilege tables |
7044 |
Needs review |
Docs Only
|
19 |
10/10
|
+7−0
|
Shinya Kato (shinyakato) |
|
|
1 |
6 days ago |
| Tracking per-RelOptInfo uniqueness during planning |
7045 |
Needs review |
Performance
|
20 |
10/10
|
+2235−122
|
Richard Guo (richardguo) |
|
|
1 |
yesterday |
| Add support for label conjunction (&) in SQL/PGQ |
7047 |
Needs review |
SQL Commands
|
20 |
2/10
|
+265−84
|
Ayoub Kazar (kaz) |
|
|
1 |
6 days ago |
| Fix error handling in getCopyDataMessage and pqFunctionCall3 |
7048 |
Needs review |
Bugfix
|
stable |
10/10
|
+14−0
|
Anthonin Bonnefoy (bonnefoa) |
|
|
1 |
5 days ago |
| vacuum: stop using stream ring after failsafe |
7049 |
Needs review |
Bugfix
|
|
10/10
|
+28−2
|
Jingtang Zhang (mrdrivingduck) |
|
|
1 |
6 days ago |
| DELETE FOR PORTION OF bypasses view WITH CHECK OPTION for leftover rows |
7050 |
Needs review |
Bugfix
|
19 |
10/10
|
+81−1
|
Zsolt Parragi (zsolt.parragi) |
solai v (solaiv) |
|
1 |
6 days ago |
| Should CUSTER (ANALYZE) work? |
7051 |
Needs review |
Bugfix
|
19 |
10/10
|
+13−0
|
Zsolt Parragi (zsolt.parragi) |
|
|
1 |
1 week ago |
| Add a pg_wal_preallocate() SQL function to eagerly create future WAL segments |
7052 |
Needs review |
Help - Benchmarks
Performance
|
20 |
10/10
|
+309−0
|
Ayush Tiwari (aytiwari) |
|
|
1 |
17 hours ago |
| DOCS - Fix spacing hack in synopses replaceable tag. |
7054 |
Needs review |
Bugfix
Docs Only
|
|
10/10
|
+34−24
|
Peter Smith (smithpb2250) |
|
|
1 |
5 days ago |
| Collect ALTER PUBLICATION commands for event triggers |
7055 |
Needs review |
Bugfix
DDL
|
|
10/10
|
+110−18
|
Fujii Masao (masaofujii) |
Ian Barwick (barwick) |
|
1 |
4 days ago |
| Fix quotation logic for unreserved keywords in window specifications |
7056 |
Needs review |
Bugfix
|
|
10/10
|
+48−1
|
Kwangwon Seo (kwangwonseo) |
Henson Choi (assam258.gmail.com) |
|
1 |
4 days ago |
| doc: clarify AS requirement when VALUES used in a FROM clause |
7057 |
Needs review |
Docs Only
|
stable |
10/10
|
+6−7
|
Ian Barwick (barwick) |
|
|
1 |
4 days ago |
| fix autovacuum database sorting |
7058 |
Ready for Committer |
Bugfix
|
stable |
10/10
|
+7−4
|
Rustam Khamidullin (rustamkhamidullin) |
Nathan Bossart (bossartn) |
Nathan Bossart (bossartn) |
1 |
4 days ago |
| Perform join removal by editing the query's jointree |
7059 |
Needs review |
Bugfix
|
|
10/10
|
+922−1673
|
Tom Lane (tgl) |
|
|
1 |
10 hours ago |
| Speed up repeat() for larger counts |
7060 |
Needs review |
Performance
|
20 |
10/10
|
+26−2
|
Chenhui Mo (littleganyu) |
|
|
1 |
21 hours ago |
| psql: filter system functions before visibility checks |
7061 |
Needs review |
Bugfix
Performance
|
20 |
10/10
|
+34−4
|
xiaoyu liu (raindrop) |
|
|
1 |
4 days ago |
| pg_upgrade fails when FK constraint with same name exists on partitioned table and its partition |
7062 |
Needs review |
Bugfix
|
|
10/10
|
+106−0
|
Arseny Kositsin (arseny114) |
|
|
1 |
5 days ago |
| SAOP nullability analysis below NOT/BooleanTest |
7063 |
Needs review |
Bugfix
|
stable |
10/10
|
+44−2
|
Ayush Tiwari (aytiwari) |
|
|
1 |
6 hours ago |
| Restrict partial unique index estimates to base quals |
7064 |
Needs review |
Bugfix
|
20 |
10/10
|
+185−18
|
Chengpeng Yan (chengpeng.yan) |
|
|
1 |
2 days ago |
| Missing list_free in publicationcmds.c:OpenTableList |
7065 |
Needs review |
Bugfix
Good First Review
Logical Replication
|
|
10/10
|
+1−0
|
Peter Smith (smithpb2250) |
|
|
1 |
18 hours ago |
| PSQL schema "describe" \dn is not escaping quotes |
7066 |
Needs review |
Bugfix
psql
Logical Replication
|
|
10/10
|
+9−4
|
Peter Smith (smithpb2250) |
|
|
1 |
10 hours ago |
| Possible wrong result from inlining a STRICT SQL function |
7067 |
Needs review |
Bugfix
|
stable |
10/10
|
+51−0
|
Ayush Tiwari (aytiwari) |
|
|
1 |
3 hours ago |