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 yesterday Remove self join on a unique column 1712 Committed Performance Not processed Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 27 11 months ago Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) 2377 Moved to different CF System Administration Not processed Justin Pryzby (justinpryzby) Fabien Coelho (calvin) 21 2 years ago Make message at end-of-recovery less scary 2490 Moved to different CF Not processed Kyotaro Horiguchi (horiguti) Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) 20 2 years ago pg_dump - read data for some options from external file 2573 Committed libpq Not processed Pavel Stehule (okbobcz) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v) Daniel Gustafsson (d_gustafsson) 18 2 years ago More scalable multixacts buffers and locking 2627 Moved to different CF Performance Not processed Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) Álvaro Herrera (alvherre) 20 1 year ago 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 Moved to different CF Not processed vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) Christoph Berg (myon), Maciek Sakrejda (msakrejda) 17 2 years ago On client login event trigger 2900 Committed 17 Not processed Konstantin Knizhnik (knizhnik), Greg Nancarrow (gregn1234), Mikhail Gribkov (youzhick) Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234) Alexander Korotkov (smagen) 15 2 years ago Dynamic result sets from procedures 2911 Withdrawn SQL Commands Not processed Peter Eisentraut (petere) 12 3 years ago pg_stat_statements: Track statement entry timestamp 3048 Committed Monitoring 17 Not processed Andrei Zubkov (zubkov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 13 2 years ago pg_stats and range statistics 3184 Committed 17 Not processed Egor Rogov (egorius) Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) Alexander Korotkov (smagen) 13 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 Update relfrozenxmin when truncating temp tables 3358 Moved to different CF 16 Not processed Greg Stark (stark) 12 2 years 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 Error "initial slot snapshot too large" in create replication slot 3445 Moved to different CF Bugfix Not processed Kyotaro Horiguchi (horiguti), Dilip Kumar (dilip.kumar) Akshat Jaimini (akshatj) 11 2 years 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 Add Amcheck option for checking unique constraints in btree indexes 3464 Committed Monitoring Not processed Anastasia Lubennikova (lubennikovaav), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Peter Geoghegan (pgeoghegan), Aleksander Alekseev (a.alekseev), Mark Dilger (mark.dilger) Alexander Korotkov (smagen) 10 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 Index SLRUs by 64-bit integers rather than by 32-bit integers 3489 Moved to different CF 16 Not processed Aleksander Alekseev (a.alekseev), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Alexander Korotkov (smagen), Jacob Champion (jchampion) Alexander Korotkov (smagen) 11 2 years ago Add log messages when replication slots become active and inactive 3492 Committed Not processed Bharath Rupireddy (bharathrupireddy) Amit Kapila (amitkapila) 10 2 years 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 pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory 3503 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) 11 2 years ago Add non-blocking version of PQcancel 3511 Moved to different CF 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 Moved to different CF 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 Compression dictionaries 3626 Moved to different CF 17 Not processed Aleksander Alekseev (a.alekseev) Matthias van de Meent (mmeent), Nikita Malakhov (nmalakh) 9 2 years ago USAGE privilege on PUBLICATION 3641 Moved to different CF Security Not processed Antonin Houska (a.houska) 9 3 years ago Skip replicating the tables specified in except table option 3646 Moved to different CF Not processed vigneshwaran C (vignesh.postgres) Takamichi Osumi (tatatappp), Peter Smith (smithpb) 9 3 days 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 Moved to different CF 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 Moved to different CF Not processed Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 10 2 years ago Testing autovacuum wraparound 3729 Committed Testing Not processed Andres Freund (andresfreund), Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 8 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 Check consistency of GUC defaults between .sample.conf and pg_settings.boot_val 3736 Moved to different CF Not processed Kyotaro Horiguchi (horiguti), Justin Pryzby (justinpryzby) Justin Pryzby (justinpryzby) 9 2 years ago Reduce timing overhead of EXPLAIN ANALYZE using rdtsc 3751 Moved to different CF Performance 16 Not processed Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) Lukas Fittl (lfittl), Hannu Krosing (hannukrosing) 8 2 hours ago Push aggregation down to base relations and joins 3764 Moved to different CF Not processed Yuki Fujii (fujiiyuki) Tomas Vondra (fuzzycz) 8 2 years ago Provide the facility to set binary format output for specific OID's per session 3777 Moved to different CF Not processed Dave Cramer (dcramer) Peter Eisentraut (petere), Gurjeet Singh (gurjeet) 8 2 years ago Reuse Workers and Replication Slots during Logical Replication 3784 Moved to different CF Not processed Melih Mutlu (melihmutlu) Daniel Gustafsson (d_gustafsson) 8 2 years ago asynchronous execution support for Custom Scan 3813 Moved to different CF Performance Not processed KaiGai Kohei (kaigai), kazutaka onishi (onishi) 8 2 years ago COPY FROM IGNORE_ERRORS - ignores rows with errors while copying 3817 Moved to different CF SQL Commands 17 Not processed Atsushi Torikoshi (atsushitorikoshi), Damir Belyalov (xhevx) Daniel Gustafsson (d_gustafsson), Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 8 2 years 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 semi-join pushdown to postgres_fdw 3838 Moved to different CF Performance 17 Not processed Alexander Pyhalov (a.pyhalov) Yuki Fujii (fujiiyuki) Alexander Korotkov (smagen) 8 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 Add document is_superuser 3889 Returned with feedback Docs Only 16 Not processed Kotaro Kawamoto (kawamochi) Shinya Kato (kato-shinya), Masao Fujii (fujiimso) Fujii Masao (masaofujii) 6 2 years ago BRIN Sort - sorting using BRIN indexes 3949 Moved to different CF Performance Not processed Tomas Vondra (fuzzycz) Greg Stark (stark), Matthias van de Meent (mmeent) 7 2 years ago Multi-version ICU 3956 Moved to different CF Not processed Thomas Munro (macdice) 10 2 years ago Periodic burst growth of the checkpoint_req counter on replica. 3961 Moved to different CF Monitoring 17 Not processed Anton Melnikov (antonmel) Alexander Korotkov (smagen) Alexander Korotkov (smagen) 7 2 years ago Prefetch the next tuple's memory during seqscans 3978 Moved to different CF Performance Not processed David Rowley (davidrowley), Thomas Munro (macdice) 7 2 years ago ResourceOwner refactoring 3982 Committed Refactoring Only Not processed Heikki Linnakangas (heikki) Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) Heikki Linnakangas (heikki) 6 2 years ago Lockless queue of waiters based on atomic operations for LWLock 3983 Moved to different CF Performance Not processed Alexander Korotkov (smagen), Pavel Borisov (pborisov) 7 2 years ago TDE key management patches 3985 Moved to different CF Not processed David Christensen (davidchristensen) Chris Travers (einhverfr) 7 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 User functions for building SCRAM secrets 3988 Moved to different CF Security Not processed Jonathan Katz (jkatz05) 7 2 years ago SetLatches() 3998 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) 12 1 year ago Rework LogicalOutputPluginWriterUpdateProgress 4004 Moved to different CF Refactoring Only Not processed wei wang (wangwei) 6 2 years ago Introduce a new view for checkpointer related stats 4014 Committed Monitoring Not processed Bharath Rupireddy (bharathrupireddy) Nitin Jadhav (nitinjadhav11), Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 5 2 years ago Partial aggregates push down 4019 Moved to different CF Performance Not processed Yuki Fujii (fujiiyuki) 6 1 year ago Fixes for non-atomic read of read of control file on ext4 + ntfs 4025 Moved to different CF Bugfix Not processed Thomas Munro (macdice) Robert Haas (rhaas), Anton Melnikov (antonmel) 6 2 years ago Use AF_UNIX for tests on Windows (ie drop fallback TCP code) 4033 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) 6 2 years ago Transaction timeout 4040 Moved to different CF 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 Moved to different CF 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 Moved to different CF SQL Commands Not processed Dean Rasheed (deanr) Vik Fearing (xocolatl) Dean Rasheed (deanr) 7 2 years ago Fix inconsistency in reporting checkpointer stats 4078 Moved to different CF Monitoring Not processed Nitin Jadhav (nitinjadhav11) 6 1 year 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 Moved to different CF 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 Add TAP tests for psql \g piped into program 4101 Committed Testing Not processed Daniel Vérité (danielverite) Heikki Linnakangas (heikki) 5 2 years ago pgbench - adding pl/pgsql versions of tests 4105 Moved to different CF Testing 19 10/10 +247−14 Hannu Krosing (hannukrosing) Fabien Coelho (calvin), Yugo Nagata (yugo.nagata), Robert Treat (xzilla) 10 2 months ago Some revises in adding sorting path 4119 Moved to different CF Refactoring Only Not processed Richard Guo (richardguo) David Rowley (davidrowley) 5 2 years ago Infinite interval values 4127 Committed Not processed Ashutosh Bapat (ashutoshbapat), Joseph Koshakow (jkoshakow), jian he (universality) Dean Rasheed (deanr) Dean Rasheed (deanr) 4 2 years ago Clarify the behavior of the system when approaching XID wraparound 4128 Committed Docs Only Not processed Aleksander Alekseev (a.alekseev) John Naylor (john.naylor), Pavel Borisov (pborisov) Robert Haas (rhaas) 4 2 years ago Direct SSL Connections 4135 Returned with feedback Not processed Greg Stark (stark) Heikki Linnakangas (heikki) 4 1 year ago Fix assertion failure in SnapBuildInitialSnapshot() 4149 Moved to different CF Bugfix Not processed Masahiko Sawada (masahikosawada) 5 3 months ago stopgap fix for signal handling during restore_command 4159 Committed Bugfix stable Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 2 years ago New [relation] options engine 4160 Returned with feedback Refactoring Only Not processed Nikolay Shaplov (nataraj) 4 2 months ago Add new protocol message to make GUC_REPORT configurable and use it for psql prompt substitution of %N with the current user 4166 Moved to different CF libpq Not processed Pavel Stehule (okbobcz) 5 2 years ago MERGE ... RETURNING 4168 Moved to different CF SQL Commands Not processed Dean Rasheed (deanr) Jeff Davis (jdavis), Gurjeet Singh (gurjeet) Dean Rasheed (deanr) 6 2 years ago pg_usleep for multisecond delays 4175 Returned with feedback 17 Not processed Nathan Bossart (bossartn) Tom Lane (tgl) 4 2 years ago Support SK_SEARCHNULL / SK_SEARCHNOTNULL for heap-only scans 4180 Returned with feedback 17 Not processed Aleksander Alekseev (a.alekseev), Jacob Champion (jchampion) Heikki Linnakangas (heikki) 3 2 years ago BRIN - SK_SEARCHARRAY and scan key preprocessing 4187 Moved to different CF Not processed Tomas Vondra (fuzzycz) Heikki Linnakangas (heikki) 5 2 years ago archive modules loose ends 4192 Moved to different CF Not processed Nathan Bossart (bossartn) Yong Li (yoli) Nathan Bossart (bossartn) 6 2 years ago Preserve subscription relation state during pg_upgrade 4199 Moved to different CF Not processed Julien Rouhaud (rjuju), vigneshwaran C (vignesh.postgres) Michael Paquier (michael-kun) Amit Kapila (amitkapila) 5 1 year ago pg_upgrade data type check connection overhead reduction 4200 Moved to different CF Performance Not processed Daniel Gustafsson (d_gustafsson) Nathan Bossart (bossartn) 5 2 years ago Improvements to Meson docs 4208 Moved to different CF Docs Only Not processed Samay Sharma (samaysharma) Tristan Partin (tristan957) 5 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 some namespace.c refactoring 4212 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) 5 2 years 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 Moved to different CF 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 2 days ago Add some checks to avoid stack overflow 4239 Moved to different CF 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 get_extension_version 4242 Returned with feedback Not processed Pavel Stehule (okbobcz) 3 3 years ago Requiring recovery.signal or standby.signal when recovering with a backup_label 4244 Rejected Bugfix Not processed Michael Paquier (michael-kun) David Steele (dsteele), Bowen Shi (zxwsbg) 3 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_dump: don't require SELECT permission for undumped extension table 4255 Committed Bugfix stable Not processed Jacob Champion (jchampion) Akshat Jaimini (akshatj) Tom Lane (tgl) 3 2 years ago Add XMLText function (SQL/XML X038) 4257 Committed SQL Commands 17 Not processed Jim Jones (jimus) Daniel Gustafsson (d_gustafsson), Vik Fearing (xocolatl) Daniel Gustafsson (d_gustafsson) 3 2 years ago Use variadic macros for syscache lookup functions 4261 Withdrawn Refactoring Only Not processed Thomas Munro (macdice) John Naylor (john.naylor) 3 2 years ago Add PQsendPipelineSync() to libpq 4262 Moved to different CF libpq Not processed Anton Kirilov (volyrique) Álvaro Herrera (alvherre), Michael Paquier (michael-kun), Álvaro Herrera (alvarofherrera), Jelte Fennema-Nio (jeltef) Michael Paquier (michael-kun) 4 2 years ago pg_column_toast_chunk_id: a function to get a chunk ID of a TOASTed value 4267 Moved to different CF 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 Moved to different CF Performance 17 Not processed Andy Fan (andyf) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 5 2 years ago make add_paths_to_append_rel aware of startup cost 4270 Committed Performance Not processed Andy Fan (andyf) David Rowley (davidrowley) David Rowley (davidrowley) 3 2 years ago allow to upgrade publisher node 4273 Committed 17 Not processed Hayato Kuroda (ha-kun) Bharath Rupireddy (bharathrupireddy), Peter Smith (smithpb2250) Amit Kapila (amitkapila) 3 2 years ago Tab complete time zone names after AT TIME ZONE 4274 Committed libpq Not processed Dagfinn Ilmari Mannsåker (ilmari) Jim Jones (jimus) Michael Paquier (michael-kun) 3 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 Moved to different CF 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 vector search support 4292 Returned with feedback 17 Not processed Nathan Bossart (bossartn) 3 2 years ago Correct the documentation for work_mem 4300 Committed Docs Only 16 Not processed Sami Imseih (simseih) Bruce Momjian (bmomjian) 3 2 years ago Skip hidden files in serverside utilities 4301 Moved to different CF Not processed Daniel Gustafsson (d_gustafsson) Tobias Bussmann (t.bussmann) Daniel Gustafsson (d_gustafsson) 5 2 years ago Cleaning up array_in() 4306 Committed Bugfix Not processed Tom Lane (tgl) Nathan Bossart (bossartn) Tom Lane (tgl) 3 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 Moved to different CF 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 Moved to different CF 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 LLVM 16 and 17 4325 Committed Refactoring Only Not processed Dmitry Dolgov (erthalion), Thomas Munro (macdice) Thomas Munro (macdice) 3 2 years ago Clarify the "38.10.10. Shared Memory and LWLocks" section 4328 Committed Docs Only 17 Not processed Aleksander Alekseev (a.alekseev) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 2 years ago Issue in postgres_fdw causing unnecessary wait for cancel request reply 4329 Moved to different CF Bugfix Not processed Fujii Masao (masaofujii) Masaki Kuwamura (mackyson) 4 2 years ago Use atomic ops for unlogged LSN 4330 Moved to different CF 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 Document that server will start even if it's unable to open some TCP/IP ports 4333 Committed Docs Only Not processed Gurjeet Singh (gurjeet) Nathan Bossart (bossartn) Bruce Momjian (bmomjian) 3 2 years 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_regress.c: Fix "make check" on Mac OS X: Pass DYLD_LIBRARY_PATH 4340 Returned with feedback Bugfix Not processed Evan Jones (evanjonesdd) David Zhang (david.z) 3 2 years ago Add support for AT LOCAL 4343 Committed SQL Commands 17 Not processed Vik Fearing (xocolatl) Michael Paquier (michael-kun), Cary Huang (cary) Michael Paquier (michael-kun) 3 2 years ago generate syscache info automatically 4344 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) John Naylor (john.naylor) Peter Eisentraut (petere) 4 2 years 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 Parallel CREATE INDEX for BRIN indexes 4350 Moved to different CF Performance Not processed Tomas Vondra (fuzzycz) Matthias van de Meent (mmeent) Tomas Vondra (fuzzycz) 4 2 years ago Index Prefetching 4351 Moved to different CF Performance 9/10 +5481−2592 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 Remove distprep 4357 Committed Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 3 2 years ago abidiff tests 4358 Moved to different CF Testing Not processed Peter Eisentraut (petere) Christoph Berg (myon) 5 2 years ago Support TZ format code in to_timestamp() 4362 Moved to different CF SQL Commands Not processed Tom Lane (tgl) Aleksander Alekseev (a.alekseev) Tom Lane (tgl) 4 2 years ago Built-in collation provider for "C" and "C.UTF-8" 4365 Moved to different CF 17 Not processed Jeff Davis (jdavis) Peter Eisentraut (petere), Daniel Vérité (danielverite) Jeff Davis (jdavis) 5 1 year ago CREATE COLLATION default provider 4366 Moved to different CF SQL Commands 17 Not processed Jeff Davis (jdavis) Peter Eisentraut (petere) 4 2 years ago Fix search_path for maintenance commands 4367 Moved to different CF Security 17 Not processed Jeff Davis (jdavis) Nathan Bossart (bossartn) 4 2 years ago pg_get_indexdef modification to access catalog based on the TxnSnapshot 4369 Moved to different CF Bugfix Not processed vigneshwaran C (vignesh.postgres) 4 2 years ago Remove always true checks (src/backend/storage/buffer/bufmgr.c) 4371 Moved to different CF 17 Not processed Gurjeet Singh (gurjeet), Ranier Vilela (raniervilela) Gurjeet Singh (gurjeet) 4 2 years ago ltree hash functions 4375 Moved to different CF Not processed Tommy Pavlicek (tommyp) Tom Lane (tgl) 5 2 years ago Refactor fork+exec code 4376 Moved to different CF Refactoring Only Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 5 1 year ago Remaining sql/json patches 4377 Moved to different CF 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 Optimizing "boundary cases" during backward scan B-Tree index descents 4380 Moved to different CF Performance 17 Not processed Peter Geoghegan (pgeoghegan) Matthias van de Meent (mmeent) Peter Geoghegan (pgeoghegan) 4 2 years ago Opportunistically pruning page before insert 4384 Moved to different CF Performance Not processed James Coleman (jcole1989) Melanie Plageman (melanieplageman) 7 2 years ago pg_stat_statements correct toplevel with track_utility=off 4385 Committed Bugfix Not processed Sergei Kornilov (melkij) Akshat Jaimini (akshatj) Tom Lane (tgl) 3 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 Extend ALTER OPERATOR to support adding commutator, negator, hashes, and merges 4389 Committed SQL Commands Not processed Tommy Pavlicek (tommyp) Tom Lane (tgl) Tom Lane (tgl) 3 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 Improve "user mapping not found" error message 4392 Committed 17 Not processed Ian Barwick (barwick) Peter Eisentraut (petere) Peter Eisentraut (petere) 3 2 years ago Optimize walsender handling invalid messages of 'drop publication' 4393 Withdrawn 13 Not processed Bowen Shi (zxwsbg) 3 2 years ago \d+ tablename, \d+ indexname about subpartition 4398 Moved to different CF libpq 16 Not processed team querytricks (querytricks2023.gmail.com) Daniel Vérité (danielverite) 4 2 years 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 bgwriter doesn't flush WAL stats 4405 Committed Bugfix Not processed Nazir Bilal Yavuz (nbyavuz) Matthias van de Meent (mmeent) Heikki Linnakangas (heikki) 3 2 years ago Add bump memory context type and use it for tuplesorts 4406 Moved to different CF 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 Fix locale breakage caused by newer libperl 4413 Moved to different CF Bugfix stable Not processed Joe Conway (jconway) Tristan Partin (tristan957) Joe Conway (jconway) 4 2 years ago Show WAL stats on pg_stat_io 4416 Moved to different CF Monitoring Not processed Nazir Bilal Yavuz (nbyavuz) Michael Paquier (michael-kun), Akshat Jaimini (akshatj) 4 1 year ago vacuumdb/clusterdb/reindexdb: allow specifying objects to process in all databases 4417 Moved to different CF 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 Unified file access using virtual file descriptors 4420 Moved to different CF Refactoring Only 17 Not processed John Morris (coyotebush) 4 2 years ago tablecmds.c/MergeAttributes() cleanup 4421 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) Álvaro Herrera (alvherre), Ashutosh Bapat (ashutoshbapat) Peter Eisentraut (petere) 4 2 years ago Synchronizing slots from primary to standby 4423 Moved to different CF 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 Moved to different CF 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 Variable Block Size 4429 Moved to different CF 17 Not processed David Christensen (davidchristensen) 4 2 years ago pg_stat_logmsg 4431 Moved to different CF Not processed Joe Conway (jconway) 7 1 year ago Multiple passwords, interval expirations 4432 Moved to different CF Not processed Gurjeet Singh (gurjeet), Joshua Brindle (joshuab) 4 2 years ago Optimise index range scan by performing first check with upper page boundary 4434 Committed Performance 17 Not processed Konstantin Knizhnik (knizhnik) Alexander Korotkov (smagen) 3 2 years ago Skip collecting decoded changes of already-aborted transactions 4436 Moved to different CF Not processed Masahiko Sawada (masahikosawada) 3 1 year ago Forcing new tuples of updates off the page 4440 Moved to different CF Not processed Matthias van de Meent (mmeent) Laurenz Albe (laurenz) 4 2 years ago Reindex toast table's index before main table's indexes 4443 Moved to different CF SQL Commands Not processed Gurjeet Singh (gurjeet) Nathan Bossart (bossartn) Michael Paquier (michael-kun) 3 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 Moved to different CF 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 Small refactoring of inval.c and inval.h 4457 Committed Refactoring Only Not processed Aleksander Alekseev (a.alekseev) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 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 Ignore is not null quals on not null columns 4459 Moved to different CF Performance Not processed David Rowley (davidrowley), Richard Guo (richardguo) David Rowley (davidrowley) 3 2 years 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 14 hours ago Remove unused fields in ReorderBufferTupleBuf 4461 Moved to different CF Refactoring Only Not processed Masahiko Sawada (masahikosawada), Aleksander Alekseev (a.alekseev) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 3 2 years ago Add REINDEX tag to event triggers 4462 Committed Monitoring 17 Not processed Garrett Thornburg (film42) Jim Jones (jimus) Michael Paquier (michael-kun) 2 2 years ago CHECK constraint deferrable Support 4463 Moved to different CF Not processed Himanshu Upadhyaya (himanshuu) Dean Rasheed (deanr) 3 2 years ago add timing information to pg_upgrade 4464 Withdrawn 17 Not processed Nathan Bossart (bossartn) 2 2 years ago Faster "SET search_path" 4466 Moved to different CF Performance 17 Not processed Jeff Davis (jdavis) Nathan Bossart (bossartn) Jeff Davis (jdavis) 3 2 years ago ALTER COLUMN ... SET EXPRESSION syntax 4473 Moved to different CF SQL Commands Not processed Amul Sul (sulamul) Peter Eisentraut (petere), Vik Fearing (xocolatl), Maxim Orlov (m.orlov), ajitpostgres awekar (ajit.awekar) Peter Eisentraut (petere) 3 2 years ago Allow SIGINT to cancel psql database reconnections 4474 Moved to different CF Bugfix Not processed Tristan Partin (tristan957) Robert Haas (rhaas) 4 2 years ago Clean up some signal usage mainly related to Windows 4475 Moved to different CF Not processed Tristan Partin (tristan957) Nathan Bossart (bossartn) 3 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 yesterday Postpone reparameterization of paths until when creating plans 4477 Moved to different CF Bugfix Not processed Richard Guo (richardguo) Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) Tom Lane (tgl) 4 2 years ago Fix bogus Asserts in calc_non_nestloop_required_outer 4478 Moved to different CF Bugfix Not processed Richard Guo (richardguo) Tom Lane (tgl) 3 2 years ago Make --help output fit within 80 columns per line 4479 Committed Docs Only 17 Not processed Atsushi Torikoshi (atsushitorikoshi) Masahiro Ikeda (masahiro.ikeda) Peter Eisentraut (petere) 2 2 years ago Add pg_wait_for_lockers() function 4480 Moved to different CF Not processed Will Mortensen (will-extrahop) 5 1 year ago brininsert optimization opportunity 4484 Committed Performance 17 Not processed Ashwin Agrawal (ashwinstar), Soumyadeep Chakraborty (soumyadeep2007) Matthias van de Meent (mmeent) Tomas Vondra (fuzzycz) 2 1 year ago Add force flag while doing pg_restore to force dropping database in case of existing connections 4485 Moved to different CF libpq stable Not processed Ahmed Ibrahim (ahmedibrahim) Gurjeet Singh (gurjeet) 3 2 years ago Support % wildcard in extension upgrade script filenames 4489 Moved to different CF 16 Not processed Sandro Santilli (strk) Regina Obe (reginaobe) 3 2 years ago psql: Add tab-complete for optional view parameters 4491 Committed libpq Not processed Christoph Heiss (christoph.heiss) Dean Rasheed (deanr), Shubham Khanna (skhanna) Dean Rasheed (deanr) 2 2 years ago Report planning memory usage in EXPLAIN ANALYZE 4492 Moved to different CF System Administration 17 Not processed Ashutosh Bapat (ashutoshbapat) Andy Fan (andyf) Álvaro Herrera (alvherre) 3 2 years 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 CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } 4497 Withdrawn 17 Not processed Jeff Davis (jdavis) 2 2 years ago logicalrep_worker_launch - counting/checking the type limits 4499 Moved to different CF Not processed Peter Smith (smithpb2250) 4 2 years ago Memory consumed by child SpecialJoinInfo in partitionwise join planning 4500 Moved to different CF Performance Not processed Ashutosh Bapat (ashutoshbapat) Amit Langote (amitlan) Amit Langote (amitlan) 4 2 years ago Archive current timeline history file on archiver startup if needed 4502 Moved to different CF Bugfix Not processed Jimmy Yih (jyih) 3 2 years ago Add flush handling to LogLogicalMessage() and pg_logical_emit_message() 4505 Committed Not processed Michael Paquier (michael-kun) Tung Nguyen (tngngn) Michael Paquier (michael-kun) 2 2 years ago Rethink the wait event names for postgres_fdw, dblink and etc 4506 Committed Monitoring Not processed Masahiro Ikeda (masahiro.ikeda) Michael Paquier (michael-kun) 2 2 years ago Allow parallel plan for referential integrity checks 4507 Moved to different CF Performance 17 Not processed Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com), Frédéric Yhuel (yhuelf) 3 2 years ago Allow excluding pg_temp or pg_catalog from search_path. 4508 Withdrawn Security 17 Not processed Jeff Davis (jdavis) Nathan Bossart (bossartn) 2 2 years ago Improve pg_restore toc file parsing and format for better performances 4509 Moved to different CF System Administration 17 Not processed Pierre Ducroquet (pinaraf) Nathan Bossart (bossartn) 3 2 years ago Examine simple variable for Var in CTE. 4510 Committed Not processed Jian Guo (aegeaner) Tom Lane (tgl), Richard Guo (richardguo) Tom Lane (tgl) 2 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 Checks in RegisterBackgroundWorker() 4514 Committed Refactoring Only 17 Not processed Heikki Linnakangas (heikki) Thomas Munro (macdice) Heikki Linnakangas (heikki) 2 2 years ago Fix false report of wraparound in pg_serial 4516 Committed Bugfix 17 Not processed Sami Imseih (simseih) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 2 years ago Unlogged relation copy is not fsync'd 4517 Moved to different CF Bugfix Not processed Heikki Linnakangas (heikki) 3 2 years 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 [PoC] Implementation of distinct in Window Aggregates: take two 4519 Moved to different CF SQL Commands Not processed Ankit Kumar Pandey (ankitkpandey) 3 2 years ago CI speed improvements for FreeBSD 4520 Moved to different CF Testing Not processed Thomas Munro (macdice) Maxim Orlov (m.orlov) Thomas Munro (macdice) 4 2 years ago Refactor ListenSockets array 4525 Committed Refactoring Only Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 2 1 year ago More new SQL/JSON item methods 4526 Moved to different CF 17 Not processed Jeevan Chalke (jeevan.chalke) Andrew Dunstan (adunstan) Andrew Dunstan (adunstan) 3 2 years ago Remove IndexInfo.ii_OpclassOptions field 4527 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 2 2 years ago Use libpq for connection testing in pg_regress 4528 Committed Testing Not processed Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 2 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 Make documentation builds reproducible 4530 Moved to different CF Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 3 2 years ago Change tuple table slot for Unique node to "virtual" 4531 Moved to different CF Performance Not processed Denis Smirnov (darthunix) Heikki Linnakangas (heikki) 4 2 years ago Streaming I/O, vectored I/O 4532 Moved to different CF Performance Not processed Thomas Munro (macdice) Heikki Linnakangas (heikki), Melanie Plageman (melanieplageman), Nazir Bilal Yavuz (nbyavuz) Thomas Munro (macdice) 4 1 year ago pg_resetwal tests, logging, and docs update 4533 Committed Testing Not processed Peter Eisentraut (petere) Aleksander Alekseev (aalekseev) Peter Eisentraut (petere) 2 2 years 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 Revised tracking of memory use 4537 Returned with feedback Monitoring 17 Not processed Reid Thompson (jreidthompson), John Morris (coyotebush) 2 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 Document efficient self-joins / UPDATE LIMIT techniques. 4539 Moved to different CF Docs Only Not processed Corey Huinker (coreyh) Laurenz Albe (laurenz) 3 1 year ago Eliminate redundant tuple visibility check in vacuum 4540 Committed Performance Not processed Melanie Plageman (melanieplageman) Robert Haas (rhaas) 2 2 years ago Move bki file pre-processing from initdb to bootstrap 4543 Moved to different CF Refactoring Only Not processed Krishnakumar Ravi (kkpgdev) Peter Eisentraut (petere) 3 2 years ago Reduce size of postgres.bki 4544 Moved to different CF Not processed Matthias van de Meent (mmeent) 4 1 year ago Add inline comments to the pg_hba_file_rules view 4546 Withdrawn 17 Not processed Jim Jones (jimus) 1 2 years ago Create shorthand for including all extra tests 4547 Moved to different CF Testing Not processed Nazir Bilal Yavuz (nbyavuz) Peter Eisentraut (petere) 2 2 years ago document the need to analyze partitioned tables 4548 Committed Docs Only 17 Not processed Laurenz Albe (laurenz) David Rowley (davidrowley), Nathan Bossart (bossartn) Bruce Momjian (bmomjian) 1 2 years 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 Remove unnecessary 'always:' from CompilerWarnings task 4550 Withdrawn Refactoring Only Not processed Nazir Bilal Yavuz (nbyavuz) 1 2 years ago Output affected rows in EXPLAIN 4551 Rejected SQL Commands 17 Not processed Damir Belyalov (xhevx) 1 2 years ago Simplify sql query cancellation test using IPC::Run signal() 4552 Committed libpq Not processed Yugo Nagata (yugo.nagata) Michael Paquier (michael-kun) 1 2 years 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 Fix misidentification of expression volatility in two places 4556 Committed Bugfix stable Not processed Tom Lane (tgl) Aleksander Alekseev (a.alekseev) Tom Lane (tgl) 1 2 years ago Add const qualifiers 4557 Committed Refactoring Only 17 Not processed David Steele (dsteele) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 2 years ago Fixing PSQL error: total cell count of XXX exceeded 4558 Committed Bugfix Not processed hongxu ma (interma) Julien Rouhaud (rjuju) Álvaro Herrera (alvherre) 1 2 years 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 Jumble the CALL command in pg_stat_statements 4560 Committed Monitoring 17 Not processed Sami Imseih (simseih) Michael Paquier (michael-kun) 1 2 years ago Tab completion for ATTACH PARTITION 4561 Moved to different CF libpq Not processed Tung Nguyen (tngngn) 2 2 years ago GROUP BY optimization 4562 Moved to different CF Performance Not processed Fedor Sigaev (sigaev), Tomas Vondra (fuzzycz), Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 2 2 years ago do not refill the hashkey after hash_search with HASH_ENTER action 4563 Committed Refactoring Only 17 Not processed Zhao Junwang (zhjwpku) Nathan Bossart (bossartn), John Naylor (john.naylor) John Naylor (john.naylor) 1 2 years 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 Bug fix for psql's meta-command \ev 4565 Committed Bugfix Not processed Ryoga Yoshida (bt23yoshidar) Kyotaro Horiguchi (horiguti), Aleksander Alekseev (a.alekseev) Michael Paquier (michael-kun) 1 2 years ago Improve the log message output of basic_archive when basic_archive.archive_directory parameter is not set 4566 Moved to different CF 17 Not processed Nathan Bossart (bossartn), Tung Nguyen (tngngn) Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn) Nathan Bossart (bossartn) 3 2 years ago bug fix and documentation improvement about vacuumdb 4567 Committed Bugfix stable Not processed Nathan Bossart (bossartn), Masaki Kuwamura (mackyson) Kyotaro Horiguchi (horiguti), Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn) Daniel Gustafsson (d_gustafsson) 1 2 years ago Add pg_basetype() function to obtain a DOMAIN base type 4568 Moved to different CF Not processed Steve Chávez (steve-chavez) Tom Lane (tgl) Tom Lane (tgl) 3 2 years ago Fix GIST readme on LSN vs NSN 4569 Committed Comments Only Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 1 2 years ago Make the am_xxx function Asserts consistent 4570 Moved to different CF 17 Not processed Peter Smith (smithpb2250) 2 2 years ago ALTER ROLE documentation improvement 4571 Moved to different CF Docs Only 17 Not processed Yurii Rashkovskii (yrashk) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 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 Fix bug in VACUUM and ANALYZE docs 4574 Committed Docs Only Not processed Ryoga Yoshida (bt23yoshidar) Karl Pinc (kop) Michael Paquier (michael-kun) 1 2 years ago Relation bulk write facility 4575 Moved to different CF Refactoring Only Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 3 2 years ago Fix incorrect memory access in ExecBRUpdateTriggers() 4576 Moved to different CF Bugfix Not processed Alexander Lakhin (law) Tom Lane (tgl) 2 2 years ago Bug fix in vacuumdb --buffer-usage-limit xxx -Z 4577 Committed Bugfix Not processed Ryoga Yoshida (bt23yoshidar) David Rowley (davidrowley) 1 2 years ago Remove MSVC scripts from the tree 4578 Moved to different CF 17 Not processed Michael Paquier (michael-kun) Peter Eisentraut (petere) Michael Paquier (michael-kun) 2 2 years ago Switch logtape and tuplesort to use int64 instead of long 4579 Withdrawn 17 Not processed Michael Paquier (michael-kun) 1 2 years ago Doesn't pgstat_report_wal() handle the argument "force" incorrectly 4580 Committed Bugfix Not processed Ryoga Yoshida (bt23yoshidar) Michael Paquier (michael-kun) 1 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 Clarify where the severity level is defined 4582 Committed Docs Only Not processed Masaki Kuwamura (mackyson) Daniel Gustafsson (d_gustafsson) 1 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 BUG #18129: GiST index produces incorrect query results 4584 Committed Bugfix stable Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 1 2 years ago Fix a wrong comment in setrefs.c 4585 Committed Comments Only Not processed Richard Guo (richardguo) shihao zhong (zhong950419) Heikki Linnakangas (heikki) 1 2 years ago Fix pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} 4586 Committed Bugfix Not processed Nazir Bilal Yavuz (nbyavuz) Michael Paquier (michael-kun) 1 2 years ago Improve tab completion for ALTER DEFAULT PRIVILEGE and ALTER TABLE 4587 Moved to different CF libpq 17 Not processed vigneshwaran C (vignesh.postgres) Suraj Khamkar (suraj.khamkar), Shubham Khanna (skhanna) Masahiko Sawada (masahikosawada) 3 1 year ago Add test module for Table Access Method 4588 Moved to different CF Testing Not processed Fabrízio Mello (fabriziomello) 2 2 years ago Change logtape/tuplestore code to use int64 for block numbers 4589 Committed 17 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 2 years ago Incorrect handling of OOM in WAL replay leading to data loss 4590 Withdrawn Bugfix 17 Not processed Michael Paquier (michael-kun) 1 2 years ago Fail hard if xlogreader.c fails on out-of-memory 4591 Committed Bugfix stable Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 2 years ago pg_stat_get_activity(): integer overflow due to (int) * (int) for MemoryContextAllocHuge() 4592 Committed Bugfix 17 Not processed Jakub Wartak (jakub.wartak.tomtom) Michael Paquier (michael-kun) 1 2 years ago Fix output of zero privileges in psql 4593 Committed libpq 17 Not processed Erik Wienhold (ewie) Laurenz Albe (laurenz) Tom Lane (tgl) 1 2 years ago Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag 4594 Committed 17 Not processed Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 1 2 years ago Invalidate the subscription worker in cases where a user loses their superuser status 4595 Committed Bugfix 17 Not processed vigneshwaran C (vignesh.postgres) Peter Smith (smithpb2250) Amit Kapila (amitkapila) 1 2 years ago Fix receiving large legal tsvector from binary format 4596 Committed Bugfix Not processed Tom Lane (tgl) 1 2 years ago HOT - correct claim about indexes not referencing old line pointers 4597 Moved to different CF Docs Only Not processed James Coleman (jcole1989) Peter Geoghegan (pgeoghegan), Robert Haas (rhaas), David Johnston (polobo) Robert Haas (rhaas) 3 2 years ago Fix incorrect Assert in bloom_init() 4598 Committed Bugfix stable Not processed Alexander Lakhin (law) shihao zhong (zhong950419) Michael Paquier (michael-kun) 1 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 Defend against encoding ID version skew between libpq.so and callers 4600 Committed Bugfix Not processed Tom Lane (tgl) Tom Lane (tgl) 1 2 years ago Defend against encoding ID version skew 4601 Withdrawn Bugfix Not processed Tom Lane (tgl) 1 2 years ago PGDOCS - inconsistent linkends to "monitoring" views 4602 Rejected Docs Only Not processed Peter Smith (smithpb2250) 1 2 years ago make psql backslash commands honor "\pset null" 4603 Withdrawn libpq 17 Not processed Laurenz Albe (laurenz) 1 2 years ago Unicode character general category functions. 4604 Committed 17 Not processed Jeff Davis (jdavis) Jeff Davis (jdavis) 1 1 year ago Check each of base restriction clauses for constant-FALSE-or-NULL 4605 Committed Performance Not processed Richard Guo (richardguo) Tom Lane (tgl) 1 2 years 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 Clean up some pg_dump tests 4607 Committed Testing Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 2 years ago Allow all tests to pass in OpenSSL FIPS mode 4608 Committed Testing Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 1 2 years ago Refactoring after adding frontend tools use syncfs 4609 Committed Refactoring Only Not processed Maxim Orlov (m.orlov) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 2 years ago Retire has_multiple_baserels() 4610 Committed Refactoring Only Not processed Richard Guo (richardguo) Tom Lane (tgl) 1 2 years ago Avoid using SearchSysCacheExists in has_foo_privilege() functions 4611 Committed Bugfix Not processed Tom Lane (tgl) Tom Lane (tgl) 1 2 years ago PGDOCS - Add more pub/sub links 4612 Committed Docs Only Not processed Peter Smith (smithpb2250) vigneshwaran C (vignesh.postgres) Amit Kapila (amitkapila) 1 2 years ago Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] 4613 Moved to different CF 17 Not processed Zongliang Quan (quanzl) Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) 2 2 years ago Allow ALTER SYSTEM SET on unrecognized custom GUCs 4614 Committed Bugfix 17 Not processed Tom Lane (tgl) shihao zhong (zhong950419) Tom Lane (tgl) 1 2 years ago Add unicode_assigned() and unicode_version() 4615 Committed 17 Not processed Jeff Davis (jdavis) Jeff Davis (jdavis) 1 1 year ago Avoid race condition for event_triggers regress test 4616 Committed Testing 17 Not processed Mikhail Gribkov (youzhick) Aleksander Alekseev (a.alekseev) Alexander Korotkov (smagen) 1 2 years 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 pg_basebackup: mention that spread checkpoints are the default 4618 Moved to different CF Not processed Michael Banck (mbanck) Michael Paquier (michael-kun), Aleksander Alekseev (a.alekseev) Magnus Hagander (mha) 2 2 years 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 Fix a performance issue with Memoize 4621 Moved to different CF Performance Not processed Richard Guo (richardguo) David Rowley (davidrowley) 2 2 years ago Index Insert Prefetching 4622 Moved to different CF Performance Not processed Tomas Vondra (fuzzycz) 4 2 years ago Fix incorrect asserts in heap_update/heap_delete 4623 Committed Bugfix Not processed Alexander Lakhin (law) Heikki Linnakangas (heikki) 1 2 years ago Patch: Improve Boolean Predicate JSON Path Docs 4624 Moved to different CF Docs Only 16 Not processed David Wheeler (theory) Jian He (stayreal), Erik Wienhold (ewie), shihao zhong (zhong950419) Tom Lane (tgl) 2 2 years ago Adding facility for injection points (or probe points?) for more advanced tests 4625 Moved to different CF Testing Not processed Michael Paquier (michael-kun) Ashutosh Bapat (ashutoshbapat), Nathan Bossart (bossartn) Michael Paquier (michael-kun) 2 2 years ago SLRU optimizations 4626 Moved to different CF 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 Add new for_each macros for iterating over a List that do not require ListCell pointer 4628 Moved to different CF Refactoring Only Not processed Jelte Fennema-Nio (jeltef) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 2 years ago Add recovery to pg_control and remove backup_label 4629 Moved to different CF 17 Not processed David Steele (dsteele) Michael Paquier (michael-kun) 2 2 years ago Recovering from detoast-related catcache invalidations 4630 Moved to different CF Bugfix stable Not processed Tom Lane (tgl) Tom Lane (tgl) 2 2 years ago Simplify documentation of unnest(multirange) 4631 Committed Docs Only stable Not processed Laurenz Albe (laurenz) Jeff Davis (jdavis) 1 2 years ago Clarify that you can create unique constraints on ONLY partitioned_table 4632 Moved to different CF Docs Only stable Not processed Laurenz Albe (laurenz) Magnus Hagander (mha), shihao zhong (zhong950419) Magnus Hagander (mha) 2 2 years ago ALTER DEFAULT PRIVILEGES only affects objects created by the target role 4633 Committed Docs Only stable Not processed Laurenz Albe (laurenz) Michael Banck (mbanck) Bruce Momjian (bmomjian) 1 2 years ago always use runtime checks for CRC-32C instructions 4634 Withdrawn Refactoring Only 17 Not processed Nathan Bossart (bossartn), xiang gao (xiang.gao) 1 2 years 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_subscriber) 4636 Withdrawn Not processed 1 2 years ago speed up a logical replication setup (pg_createsubscriber) 4637 Moved to different CF 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 Moved to different CF Docs Only 17 Not processed shihao zhong (zhong950419) Daniel Vérité (danielverite), Shubham Khanna (skhanna) Tom Lane (tgl) 3 1 year ago Set minimum LLVM version to 10 4640 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) Thomas Munro (macdice) 2 2 years ago Generate Doxygen documentation 4641 Moved to different CF Docs Only Not processed John Morris (coyotebush) 2 2 years ago Properly pathify the UNION planner 4642 Moved to different CF 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