| pgbench - adding pl/pgsql versions of tests |
4105 |
Needs review |
Testing
|
19 |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
Fabien Coelho (calvin), Yugo Nagata (yugo.nagata), Robert Treat (xzilla) |
|
11 |
8 months ago |
| Add XMLCanonicalize function |
4237 |
Ready for Committer |
SQL Commands
|
20 |
10/10
|
+350−0
|
Jim Jones (jimus) |
Pavel Stehule (okbobcz), Oliver Ford (ojford), Yogesh Sharma (sharmay), newtglobal postgresql_contributors (newtpostgrescontributors) |
|
18 |
5 days ago |
| COPY (on_error table) saving error info to a table |
4817 |
Needs review |
|
|
1/2
|
+1037−50
|
Jian He (stayreal) |
Nishant Sharma (nishant-at-edb), Zsolt Parragi (zsolt.parragi), Solaimurugan V (solaimurugan) |
|
12 |
2 months ago |
| using index to speedup add not null constraints to a table |
5444 |
Needs review |
|
|
Needs rebase!
|
|
Jian He (stayreal) |
Tanzeel Khan (tanzeelk) |
|
9 |
2 months ago |
| CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions |
5941 |
Needs review |
SQL Commands
|
19 |
10/10
|
+3202−210
|
Jian He (stayreal) |
Corey Huinker (coreyh), Henson Choi (assam258.gmail.com) |
|
7 |
5 days ago |
| NOT NULL NOT ENFORCED |
6029 |
Needs review |
DDL
|
19 |
Needs rebase!
|
|
Jian He (stayreal) |
Haritabh Gupta (haritabhgupta) |
Álvaro Herrera (alvherre) |
5 |
1 week ago |
| Fix replica identity mismatch for partitioned tables with publish_via_partition_root |
6047 |
Needs review |
Bugfix
Logical Replication
|
stable |
Needs rebase!
|
|
Mikhail Kharitonov (mkharitonov) |
Henson Choi (assam258.gmail.com), jihyun bahn (ichibahn) |
|
5 |
1 month ago |
| CREATE TABLE LIKE INCLUDING TRIGGERS |
6087 |
Ready for Committer |
SQL Commands
|
19 |
10/10
|
+649−18
|
Jian He (stayreal) |
Andrey Borodin (x4m), Henson Choi (assam258.gmail.com), Zsolt Parragi (zsolt.parragi), lakshmi g (lakshmi) |
|
6 |
2 weeks ago |
| create table like including storage parameter |
6088 |
Needs review |
SQL Commands
|
19 |
Needs rebase!
|
|
Jian He (stayreal) |
lakshmi g (lakshmi) |
|
6 |
4 months ago |
| avoid call ATPostAlterTypeCleanup twice |
6121 |
Needs review |
Bugfix
Backport
|
stable |
10/10
|
+152−2
|
Jian He (stayreal) |
Bryan Green (lispyone) |
|
6 |
6 days ago |
| COPY FROM with RLS |
6178 |
Needs review |
SQL Commands
|
19 |
Needs rebase!
|
|
Jian He (stayreal) |
Bryan Green (lispyone), solai v (solaiv) |
|
6 |
1 week ago |
| parallel pgbench -i |
6242 |
Needs review |
Performance
|
|
10/10
|
+269−27
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
4 |
4 months ago |
| skip check constraints verification for unaffected columns during UPDATE |
6270 |
Needs review |
|
19 |
10/10
|
+170−17
|
Jian He (stayreal) |
Florin Irion (irionr), solai v (solaiv) |
|
5 |
1 week ago |
| Proposal to allow setting cursor options on Portals |
6292 |
Needs review |
libpq
|
|
Needs rebase!
|
|
Dave Cramer (dcramer) |
Jelte Fennema-Nio (jeltef) |
|
3 |
6 days ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Needs review |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
4 |
4 months ago |
| Reduce build times of pg_trgm GIN indexes |
6418 |
Waiting on Author |
Performance
|
20 |
10/10
|
+239−242
|
David Geier (geidav) |
Heikki Linnakangas (heikki), Japin Li (japin), Matthias van de Meent (mmeent) |
Heikki Linnakangas (heikki) |
3 |
6 days ago |
| Use correct collation in pg_trgm |
6454 |
Ready for Committer |
Bugfix
|
19 |
10/10
|
+170−67
|
David Geier (geidav) |
Zsolt Parragi (zsolt.parragi), solai v (solaiv) |
|
3 |
4 hours ago |
| Speed up COPY TO text/CSV parsing using SIMD |
6588 |
Needs review |
Performance
|
19 |
10/10
|
+16−3
|
Ayoub Kazar (kaz) |
Sahil Verma (sahilverma) |
|
2 |
1 week ago |
| Prevent repeated deadlock-check signals in standby buffer pin waits |
6690 |
Waiting on Author |
Performance
|
20 |
Needs rebase!
|
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii), Henson Choi (assam258.gmail.com), Ilmar Yunusov (tanswis42.gmail.com) |
Fujii Masao (masaofujii) |
3 |
3 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) |
|
|
3 |
3 months ago |
| PROXY protocol support |
6916 |
Needs review |
System Administration
Monitoring
GUC
My First Patch
|
20 |
10/10
|
+2131−16
|
Julien Riou (riouj) |
|
|
2 |
3 months ago |
| Continuous re-validation of session credentials |
6921 |
Needs review |
Security
|
20 |
7/10
|
+1847−17
|
ajitpostgres awekar (ajit.awekar) |
|
|
2 |
3 days ago |
| Reduce reorder buffer spill from O(N²) to O(N) during vacuum storms |
6933 |
Waiting on Author |
Performance
Logical Replication
|
20 |
10/10
|
+764−61
|
Rui Zhao (zhaorui) |
shihao zhong (zhong950419) |
|
3 |
2 weeks ago |
| ERROR: failed to find conversion function from unknown to text |
7094 |
Waiting on Author |
Bugfix
|
stable |
9/10
|
+22−0
|
Jian He (stayreal) |
Manu Reyes Bravo (manu15) |
|
2 |
5 hours ago |
| ALTER COLUMN SET EXPRESSION on partitions not work in case of dependencies |
7117 |
Needs review |
Bugfix
|
stable |
Needs rebase!
|
|
Jian He (stayreal) |
|
|
2 |
3 weeks ago |
| SQL/PGQ: Support multi-pattern path matching in GRAPH_TABLE |
7172 |
Waiting on Author |
SQL Commands
|
20 |
Needs rebase!
|
|
Henson Choi (assam258.gmail.com) |
|
|
2 |
1 week ago |
| handling transitions in timestamptz_trunc_* |
7243 |
Ready for Committer |
Bugfix
|
|
10/10
|
+36−1
|
Alexandre Felipe (afelipe) |
solai v (solaiv), Pierre Forstmann (pifor) |
|
1 |
2 weeks ago |
| Price hashed aggregation for hash tables that exceed CPU cache capacity |
7244 |
Needs review |
Bugfix
Performance
|
20 |
10/10
|
+87−0
|
William Bernbaum (wjb-fwx) |
|
|
1 |
2 weeks ago |
| pg_dump: Don't emit OVERRIDING SYSTEM VALUE for dropped identity columns |
7246 |
Needs review |
Bugfix
|
20 |
10/10
|
+77−1
|
William Bernbaum (wjb-fwx) |
solai v (solaiv) |
Fujii Masao (masaofujii) |
1 |
1 week ago |
| 035_standby_logical_decoding might fail due to FATAL message lost inside libpq |
7247 |
Ready for Committer |
Flakyfix
|
|
9/10
|
+12−6
|
Hayato Kuroda (ha-kun) |
Bertrand Drouvot (bertranddrouvot.pg) |
|
1 |
2 weeks ago |
| Fix a typo in EnableLogicalDecoding() |
7248 |
Ready for Committer |
Comments Only
Good First Review
|
|
10/10
|
+4−4
|
Chao Li (chaol) |
shihao zhong (zhong950419), Surya Poondla (spoondla), solai v (solaiv) |
|
1 |
1 week ago |
| Remove redundant path_null checks in setPathObject/Array |
7249 |
Ready for Committer |
Refactoring Only
|
|
9/10
|
+2−2
|
Ilya Gladyshev (ilya.gladysev) |
solai v (solaiv), Pierre Forstmann (pifor) |
|
1 |
2 weeks ago |
| glist: _Generic wrapper for selective dlist/dclist usage |
7250 |
Needs review |
|
|
10/10
|
+117−0
|
Matthias van de Meent (mmeent) |
|
|
1 |
2 weeks ago |
| Honor WAL insertion clamp in XLogBackgroundFlush |
7252 |
Needs review |
Bugfix
|
20 |
10/10
|
+170−3
|
Paul Kim (mok03127.naver.com) |
Bharath Rupireddy (bharathrupireddy) |
|
1 |
4 days ago |
| [PATCH v1 0/1] Avoid carrying self lock-only xmax to updated tuple |
7253 |
Needs review |
Bugfix
Performance
|
20 |
9/10
|
+57−6
|
Chee Wooson (chee.wooson) |
|
|
1 |
2 weeks ago |
| Allow bare library names for non-superuser LOAD |
7254 |
Needs review |
SQL Commands
|
|
10/10
|
+19−15
|
ChangAo Chen (chenchangao) |
Jim Jones (jimus), solai v (solaiv) |
|
1 |
1 week ago |
| Fix races in Windows pthread emulation |
7255 |
Needs review |
Bugfix
|
|
9/10
|
+13−15
|
Harrison Booth (hbooth) |
Nazir Bilal Yavuz (nbyavuz) |
|
1 |
2 weeks ago |
| Avoid checksumming extra files in the datadir |
7256 |
Waiting on Author |
|
20 |
10/10
|
+121−168
|
Jacob Champion (jchampion) |
|
|
1 |
5 days ago |
| Fix use-after-free after failed pg_checksum_init |
7257 |
Needs review |
Bugfix
|
20 |
9/10
|
+224−29
|
Yuriy Grigoryev (ju.grigorev) |
|
|
1 |
3 weeks ago |
| Native planner and executor for SQL/PGQ |
7258 |
Needs review |
SQL Commands
GUC
My First Patch
|
20 |
Needs rebase!
|
|
Henri Gasc (henri.gasc) |
Henson Choi (assam258.gmail.com) |
|
1 |
3 days ago |
| Stabilize recovery conflict stats checks in 031_recovery_conflict.pl |
7259 |
Needs review |
Flakyfix
|
stable |
10/10
|
+13−6
|
Ayush Tiwari (aytiwari) |
|
|
1 |
4 days ago |
| libpq: Add PQpassfileLookup() |
7261 |
Needs review |
Good First Review
My First Patch
|
20 |
10/10
|
+438−14
|
Diego - (galponcio) |
Denis Smirnov (darthunix), Yuriy Grigoryev (ju.grigorev) |
|
1 |
2 days ago |
| Teach pg_upgrade to deal with invalid databases |
7262 |
Needs review |
|
20 |
10/10
|
+112−19
|
Bharath Rupireddy (bharathrupireddy) |
|
|
1 |
1 week ago |
| add missed tests for gist index |
7264 |
Needs review |
Missing Tests
Good First Review
Testing
|
stable |
10/10
|
+192−0
|
shihao zhong (zhong950419) |
|
|
1 |
2 weeks ago |
| logical decoding: skip unnecessary snapshot distribution. |
7265 |
Waiting on Author |
Performance
|
|
10/10
|
+72−14
|
boyu yang (mobilephone724) |
shihao zhong (zhong950419) |
|
1 |
1 week ago |
| pg_surgery: check the page header and line pointers |
7266 |
Ready for Committer |
Bugfix
|
stable |
10/10
|
+165−0
|
shihao zhong (zhong950419) |
Andrey Borodin (x4m) |
|
1 |
1 week ago |
| Direct TOAST v2, faster, smaller and no migration needed |
7267 |
Needs review |
Help - User Testing
Help - Bikeshedding
Help - Benchmarks
Performance
Testing
GUC
|
20 |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
|
|
1 |
2 weeks ago |
| postgres_fdw: push down FETCH FIRST .. WITH TIES when server version allows |
7269 |
Needs review |
postgres_fdw
Performance
|
20 |
10/10
|
+404−18
|
Sagar Shedge (sdshedge) |
|
|
1 |
1 week ago |
| pg_createsubscriber does not check output_plugin_libraries |
7271 |
Needs review |
Bugfix
Backport
|
|
9/10
|
+135−1
|
Hayato Kuroda (ha-kun) |
|
|
1 |
4 days ago |
| Add recovery boundary WAL record for database and tablespace commands |
7272 |
Needs review |
Bugfix
Physical Replication
|
20 |
10/10
|
+232−15
|
JoongHyuk Shin (shin) |
|
|
1 |
2 weeks ago |
| Add a permission check to pg_stat_get_backend_subxact() |
7273 |
Needs review |
Bugfix
Good First Review
|
20 |
10/10
|
+156−10
|
shihao zhong (zhong950419) |
Jim Jones (jimus) |
|
1 |
1 week ago |
| Report changes discarded for relations not in the subscription |
7274 |
Needs review |
Logical Replication
|
20 |
10/10
|
+212−5
|
Hüseyin Demir (demir) |
|
|
1 |
1 week ago |
| Prevent object capture in CREATE/ALTER EXTENSION scripts |
7276 |
Needs review |
Extensions
|
|
10/10
|
+1044−49
|
Jan Nidzwetzki (jnidzwetzki) |
Osama Abdul Qader (oabdul-qader) |
|
1 |
6 days ago |
| Report userid to PgBackendStatus for standalone backends |
7277 |
Needs review |
Good First Review
|
|
10/10
|
+5−1
|
ChangAo Chen (chenchangao) |
|
|
1 |
1 week ago |
| Use maintenance_io_concurrency for parallel index builds |
7280 |
Needs review |
Bugfix
Performance
|
stable |
10/10
|
+24−11
|
Jingtang Zhang (mrdrivingduck) |
|
|
1 |
1 week ago |
| Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses |
7281 |
Needs review |
Performance
|
stable |
10/10
|
+18−2
|
Ilia Evdokimov (ilidock95) |
|
|
1 |
1 week ago |
| Allow subquery pull-up past inlineable CTEs |
7283 |
Needs review |
Performance
My First Patch
|
20 |
10/10
|
+244−45
|
Andrey Kazarinov (kazar) |
Xinlei Zhang (clemenza) |
|
1 |
1 week ago |
| {heap,minimal}_expand_tuple() are unused |
7284 |
Needs review |
Refactoring Only
|
|
10/10
|
+4−287
|
Aleksander Alekseev (a.alekseev) |
Kyle Snavely (ksnavely) |
|
1 |
5 days ago |
| Use PG 14's hashed ScalarArrayOpExpr path for a non-Const array the planner can prove is fixed for one execution (col = ANY($1), IN ($1,...,$N), $1::int[], string_to_array($1,','), a stable function), not only for a Const array. |
7285 |
Needs review |
Performance
|
20 |
10/10
|
+658−176
|
Linden Lance (bestxmg) |
|
|
1 |
1 week ago |
| JIT inlining SIGSEGV in MemoryBuffer::getFile with LLVM 17 / GCC 13 |
7289 |
Needs review |
Bugfix
|
|
10/10
|
+30−11
|
Yuriy Grigoryev (ju.grigorev) |
|
|
1 |
1 month ago |
| BUG #19599: RestoreBlockImage: the decode cross-checks never bound hole_offset + hole_length against BLCKSZ |
7290 |
Needs review |
Bugfix
|
|
10/10
|
+23−3
|
Yuriy Grigoryev (ju.grigorev) |
|
|
1 |
2 weeks ago |
| DSA_ALLOC_NO_OOM vs dsm_create ERROR leaving a half-initialized pgstats hash entry |
7291 |
Needs review |
Bugfix
|
|
10/10
|
+90−61
|
Yuriy Grigoryev (ju.grigorev) |
|
|
1 |
4 days ago |
| [PATCH v1] Reject zero resource kinds in test_resowner_many() |
7292 |
Needs review |
Bugfix
|
|
10/10
|
+13−2
|
Yuriy Grigoryev (ju.grigorev) |
|
|
1 |
1 week ago |
| Logical Implication |
7293 |
Needs review |
SQL Commands
|
20 |
10/10
|
+343−42
|
Vik Fearing (xocolatl) |
solai v (solaiv) |
|
1 |
4 days ago |
| [BUG] Fix EXCLUDED virtual generated columns using tableoid |
7295 |
Needs review |
Bugfix
|
stable |
10/10
|
+32−0
|
Ayush Tiwari (aytiwari) |
|
|
1 |
1 week ago |
| BUG #19684: Assertion in tuplesort_begin_heap() falsified by parallel plan with sort |
7296 |
Needs review |
Bugfix
|
stable |
10/10
|
+40−1
|
Ayush Tiwari (aytiwari) |
|
|
1 |
1 week ago |
| Use pg_parse_lsn function in START_REPLICATION flow |
7297 |
Needs review |
Bugfix
|
20 |
10/10
|
+2−5
|
Ayush Tiwari (aytiwari) |
|
|
1 |
1 week ago |
| Report pruning statistics in pg_stat_all_tables |
7298 |
Needs review |
Good First Review
Monitoring
|
|
10/10
|
+303−4
|
shihao zhong (zhong950419) |
|
|
1 |
6 days ago |
| Avoid emitting core dumps when not needed |
7299 |
Needs review |
Devtools
GUC
|
20 |
10/10
|
+498−2
|
Ayush Tiwari (aytiwari) |
|
|
1 |
2 days ago |
| meson: pass OpenSSL/ICU include dirs to extensions |
7300 |
Needs review |
|
|
8/10
|
+48−3
|
Aidar Imamov (gipergeek) |
|
|
1 |
1 week ago |
| Combine qual-based and NOT NULL proofs when reducing outer joins |
7301 |
Ready for Committer |
Performance
|
|
10/10
|
+132−9
|
Zhenglong Li (smartkeyerror.gmail.com) |
Ziming Zhang (torenzhang) |
|
1 |
17 hours ago |
| Optimize MCV stats for sortable types and utilize sorted-order properties |
7302 |
Needs review |
Performance
|
|
2/10
|
+748−94
|
Zizhuan Liu (liuzizhuan) |
|
|
1 |
6 hours ago |
| FIX: BUG #19687: ALTER SEQUENCE missing lock |
7303 |
Needs review |
Bugfix
|
|
10/10
|
+7−1
|
Alexandre Felipe (afelipe) |
|
|
1 |
6 days ago |
| Discard aborted updaters when expanding a multixact |
7304 |
Needs review |
Bugfix
|
20 |
10/10
|
+107−1
|
Chee Wooson (chee.wooson) |
|
|
1 |
4 days ago |
| Add get_actual_variable_range index page read limit (complements existing VISITED_PAGES_LIMIT) |
7305 |
Needs review |
Performance
|
|
10/10
|
+36−2
|
Peter Geoghegan (pgeoghegan) |
Rui Zhao (zhaorui) |
|
1 |
5 days ago |
| Remove unused PageIsPredicateLocked() |
7306 |
Ready for Committer |
Refactoring Only
|
|
10/10
|
+0−43
|
Aleksander Alekseev (a.alekseev) |
Pierre Forstmann (pifor) |
|
1 |
yesterday |
| ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...) |
7307 |
Needs review |
SQL Commands
|
|
9/10
|
+1077−148
|
Hannu Krosing (hannukrosing) |
|
|
1 |
2 days ago |
| Optimize truncation logic to reduce AccessExclusive lock impact |
7308 |
Needs review |
Performance
Good First Review
|
20 |
10/10
|
+42−8
|
shihao zhong (zhong950419), Stepan Neretin (snpgg) |
|
|
1 |
4 days ago |
| Doc: clarify pg_locks descriptions of classid/objid/objsubid |
7309 |
Needs review |
Docs Only
|
|
10/10
|
+24−11
|
|
|
Fujii Masao (masaofujii) |
1 |
1 month ago |
| Improve hash aggregate spilling by writing only the needed columns |
7310 |
Needs review |
Performance
|
|
10/10
|
+95−32
|
Mario Karuza (mkaruza) |
|
|
1 |
4 days ago |
| tuplesort_putdatum() does not account for tuple memory |
7311 |
Needs review |
Good First Review
My First Patch
|
|
10/10
|
+11−1
|
Mario Karuza (mkaruza) |
|
|
1 |
1 week ago |
| BUG #19686: Rolling back SET TABLESPACE |
7312 |
Needs review |
Bugfix
|
|
10/10
|
+618−11
|
Alexandre Felipe (afelipe) |
|
|
1 |
4 days ago |
| Row contention in regress/parallel_schedule, adding multi-line test groups |
7313 |
Needs review |
Devtools
|
|
10/10
|
+346−36
|
Alexandre Felipe (afelipe) |
|
|
1 |
16 hours ago |
| pg_walinspect: add functions to locate and list WAL by time and LSN |
7315 |
Needs review |
Extensions
|
20 |
10/10
|
+1147−22
|
Chao Li (chaol) |
|
|
1 |
3 days ago |
| pg_rewind does not rewind diverging timelines |
7317 |
Needs review |
Bugfix
|
19 |
10/10
|
+772−34
|
Mats Kindahl (mkindahl) |
|
|
1 |
yesterday |
| psql single-step mode woes |
7318 |
Needs review |
Bugfix
psql
|
20 |
Needs rebase!
|
|
Heikki Linnakangas (heikki) |
|
|
1 |
2 months ago |
| postgres_fdw: Fix cost estimation for semi join pushdown |
7319 |
Needs review |
Bugfix
|
17 |
10/10
|
+67−1
|
Ziming Zhang (torenzhang) |
|
|
1 |
2 days ago |
| Two remaining shmem attachment issues in single-user mode |
7320 |
Needs review |
Bugfix
|
19 |
10/10
|
+102−23
|
Ayush Tiwari (aytiwari) |
|
|
1 |
yesterday |
| Temp schema drop leaves an inconsistent state behind |
7321 |
Needs review |
Bugfix
|
20 |
10/10
|
+99−7
|
Marko Grujic (gruuya) |
|
|
1 |
2 days ago |
| Cache invalidation for I/O Workers |
7322 |
Waiting on Author |
Bugfix
|
|
10/10
|
+31−0
|
Alexandre Felipe (afelipe) |
shihao zhong (zhong950419) |
|
1 |
12 hours ago |
| Use bounded GIN pending-list cleanup in parallel autovacuum |
7323 |
Needs review |
Bugfix
|
stable |
10/10
|
+9−3
|
Jingtang Zhang (mrdrivingduck) |
|
|
1 |
18 hours ago |
| [Patch] Fix pg_get_multixact_stats() over-reporting members on a hot standby |
7324 |
Needs review |
Bugfix
|
19 |
10/10
|
+9−0
|
Naga Appani (naga.appani) |
|
|
1 |
2 hours ago |
| Assertion in pg_get_shmem_pagesize() in single-user mode |
7325 |
Needs review |
Bugfix
|
stable |
10/10
|
+1−2
|
Ayush Tiwari (aytiwari) |
|
|
1 |
10 hours ago |