Commitfest 2022-07 (2022-07-01 – 2022-07-31)

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 3 days ago Remove self join on a unique column 1712 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 27 11 months ago Incremental Materialized View Maintenance 2138 Moved to different CF SQL Commands 16 Not processed Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) 17 3 years ago standby recovery fails when re-replaying due to missing directory which was removed in previous replay. 2161 Committed Bugfix stable Not processed Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) Michael Paquier (michael-kun) Álvaro Herrera (alvherre) 16 3 years ago Implement INSERT SET syntax 2218 Returned with feedback SQL Commands Not processed Gareth Palmer (gareth) Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj) 15 3 years ago Fix partitionwise join with partially-redundant join clauses 2266 Moved to different CF Not processed Richard Guo (richardguo) Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) Richard Guo (richardguo) 16 1 year ago Global temporary table 2349 Returned with feedback 16 Not processed Wenjing Zeng (wenjing.zwj) Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) 13 3 years 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 Moved to different CF 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 Fast COPY FROM command for the foreign tables 2601 Moved to different CF Performance Not processed Andrei Lepikhov (lepikhov) Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) Etsuro Fujita (efujita) 13 3 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 Fix behavior of geo_ops when NaN is involved 2710 Returned with feedback Not processed Kyotaro Horiguchi (horiguti) Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) 10 4 years ago fix spinlock contention in LogwrtResult 2716 Moved to different CF Performance Not processed Álvaro Herrera (alvherre) 11 1 year ago Add extra statistics to explain for Nested Loop 2765 Moved to different CF Monitoring Not processed Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) 10 3 years ago CREATE INDEX CONCURRENTLY on partitioned table 2815 Moved to different CF SQL Commands Not processed Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) 15 9 months ago Extended statistics / estimate Var op Var clauses 2831 Moved to different CF Not processed Tomas Vondra (fuzzycz) Dean Rasheed (deanr), Mark Dilger (mark.dilger) 9 3 years 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 Consider parallel for LATERAL subqueries having LIMIT/OFFSET 2851 Moved to different CF Performance Not processed James Coleman (jcole1989) Greg Nancarrow (gregn1234) 11 3 years 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 Fix pg_rewind race condition just after promotion 2864 Moved to different CF System Administration Not processed Heikki Linnakangas (heikki) Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) Heikki Linnakangas (heikki) 12 3 years ago New Table Access Methods for Multi and Single Inserts 2871 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) 9 1 year ago Faster pglz compression 2897 Moved to different CF Performance Not processed Andrey Borodin (x4m), Владимир Лесков (tinsane) Mark Dilger (mark.dilger) Tomas Vondra (fuzzycz) 12 3 years ago On client login event trigger 2900 Moved to different CF 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 Parallel Hash Full Join 2903 Moved to different CF Performance 16 Not processed Melanie Plageman (melanieplageman) Thomas Munro (macdice) Thomas Munro (macdice) 12 2 years ago New default role allowing to change per-role settings 2918 Returned with feedback System Administration Not processed Michael Banck (mbanck) Stephen Frost (sfrost), Shinya Kato (kato-shinya) 8 4 years ago Allow batched insert during cross-partition updates 2992 Moved to different CF Not processed Amit Langote (amitlan) Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Zhijie Hou (houzj) Etsuro Fujita (efujita) 10 3 years ago PROXY protocol support 3032 Moved to different CF Not processed Magnus Hagander (mha) Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) 7 3 years ago Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns 3041 Moved to different CF Bugfix Not processed Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) Amit Kapila (amitkapila) 7 3 years ago Allow multiple recursive self-references 3046 Returned with feedback Not processed Denis Hirn (brainy) Peter Eisentraut (petere) 6 3 years ago pg_stat_statements: Track statement entry timestamp 3048 Moved to different CF Monitoring 17 Not processed Andrei Zubkov (zubkov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 13 2 years ago Extended statistics in EXPLAIN 3050 Returned with feedback Not processed Tomas Vondra (fuzzycz) Tatsuro Yamada (tatsuro_yamada) 6 4 years ago tablesync early exit 3062 Withdrawn 15 Not processed Peter Smith (smithpb2250) 6 4 years ago Lazy JIT IR code generation to increase JIT speed with partitions 3071 Moved to different CF Performance Not processed David Geier (geidav), Luc Vlaming (luc.vlaming) Dmitry Dolgov (erthalion) 9 3 years ago Add callback table access method to reset filenode when dropping relation 3073 Moved to different CF Not processed Mats Kindahl (matski) Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) 7 3 years ago Asymmetric partition-wise JOIN 3099 Moved to different CF 15 Not processed KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) Alexander Pyhalov (a.pyhalov) 7 4 years ago Avoid orphaned dependencies 3106 Returned with feedback 16 Not processed Bertrand Drouvot (bdrouvot) Ronan Dunklau (rdunklau) 6 4 years ago psql - refactor echo code 3140 Moved to different CF Refactoring Only Not processed Fabien Coelho (calvin) Pavel Stehule (okbobcz), Peter Eisentraut (petere) 10 3 years ago Logging plan of the currently running query 3142 Moved to different CF Monitoring 16 Not processed atsushi torikoshi (atorik) Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) 9 3 weeks ago Parallel INSERT SELECT take 2 3143 Returned with feedback Performance Not processed Greg Nancarrow (gregn1234), Zhijie Hou (houzj) 6 3 years ago pre-allocating WAL files 3158 Withdrawn Performance 16 Not processed Nathan Bossart (bossartn) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) 6 3 years ago Add proper planner support for ORDER BY / DISTINCT aggregates 3164 Moved to different CF Performance Not processed David Rowley (davidrowley) Ronan Dunklau (rdunklau), Richard Guo (richardguo) David Rowley (davidrowley) 7 3 years ago Map WAL segment files on PMEM as WAL buffers 3181 Returned with feedback Performance Not processed Takashi Menjo (tmenjo) 6 4 years ago automatically generating node support functions 3182 Committed Refactoring Only Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 6 3 years ago pg_stats and range statistics 3184 Moved to different CF 17 Not processed Egor Rogov (egorius) Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) Alexander Korotkov (smagen) 13 2 years ago Write visibility map during CLUSTER/VACUUM FULL 3206 Returned with feedback Performance Not processed Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva) Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) 6 3 years ago PITR enhance getRecordTimestamp() 3222 Moved to different CF Not processed Simon Riggs (simon) 8 4 years ago Fix ExecRTCheckPerms() inefficiency with many prunable partitions 3224 Moved to different CF Performance 16 Not processed Amit Langote (amitlan) Álvaro Herrera (alvherre), Tom Lane (tgl) Álvaro Herrera (alvherre) 8 2 years ago pgbench: add multiconnect support 3227 Moved to different CF 16 Not processed David Christensen (davidchristensen) Jelte Fennema-Nio (jeltef) 9 3 years ago Using each rel as both outer and inner for anti-joins 3235 Moved to different CF Performance Not processed Richard Guo (richardguo) Ronan Dunklau (rdunklau) Tom Lane (tgl) 9 2 years ago Postgres picks suboptimal index after building extended statistics 3245 Moved to different CF Performance 14 Not processed Andrei Lepikhov (lepikhov) 7 3 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 pgbench: using prepared BEGIN statement in a pipeline could cause an error 3260 Moved to different CF Bugfix 15 Not processed Yugo Nagata (yugo.nagata) Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege) Álvaro Herrera (alvherre) 9 3 years ago schema change not getting invalidated, both renamed table and new table data were getting replicated 3262 Moved to different CF Not processed vigneshwaran C (vignesh.postgres) Tom Lane (tgl) Tom Lane (tgl) 8 3 years ago Cache tuple routing info during bulk loads into partitioned tables 3270 Moved to different CF Performance Not processed David Rowley (davidrowley), Amit Langote (amitlan), Zhijie Hou (houzj) Álvaro Herrera (alvherre), David Rowley (davidrowley) David Rowley (davidrowley) 6 3 years ago KnownAssignedXidsGetAndSetXmin performance 3271 Moved to different CF Performance Not processed Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Kirill Reshke (reshke), Andrey Borodin (x4mmm) 6 3 years ago Add system view tracking shared buffer actions 3272 Moved to different CF Monitoring 16 Not processed Melanie Plageman (melanieplageman) Justin Pryzby (justinpryzby) Andres Freund (andresfreund) 9 3 years ago Gather partial paths for subproblem's topmost scan/join rel 3274 Committed Not processed Richard Guo (richardguo) Antonin Houska (a.houska) Tom Lane (tgl) 5 3 years ago Push down time-related SQLValue functions to foreign server 3289 Returned with feedback Performance 15 Not processed Alexander Pyhalov (a.pyhalov) 5 4 years ago psql: add xheader_width option to handle very long record lines 3295 Committed libpq Not processed Platon Pronko (rogach) Andrew Dunstan (adunstan) Andrew Dunstan (adunstan) 5 3 years ago add guc: hugepages_active 3310 Moved to different CF System Administration Not processed Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda) Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) 7 2 years ago Support pg_ident mapping for LDAP 3314 Withdrawn Not processed Jacob Champion (jchampion) Magnus Hagander (mha) 5 4 years ago Asynchronous and "direct" IO support for PostgreSQL 3316 Moved to different CF Performance Not processed Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice) 6 3 years ago Upgrade pgcrypto to crypt_blowfish 1.3 3338 Returned with feedback Security Not processed Daniel Fone (daniel.fone) Daniel Gustafsson (d_gustafsson) 4 4 years ago Atomic rename feature for Windows 3347 Moved to different CF Not processed Victor Spirin (v.spirin) 6 3 years ago Update relfrozenxmin when truncating temp tables 3358 Moved to different CF 16 Not processed Greg Stark (stark) 12 2 years ago Allows database-specific role memberships 3374 Moved to different CF System Administration 18 Not processed Denis Laxalde (dlax), Kenaniah Cerny (kenaniah) Antonin Houska (a.houska) Stephen Frost (sfrost) 6 1 year ago Extend postgres_fdw_get_connections() to print the user_name 3388 Moved to different CF Monitoring Not processed Hayato Kuroda (ha-kun) Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Shinya Kato (shinyakato), Yuta Katsuragi (katsuragiy) Fujii Masao (masaofujii) 15 1 year ago Add checkpoint stats of snapshot and mapping files of pg_logical dir 3389 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) Nathan Bossart (bossartn) 5 3 years ago postgres_fdw: commit remote (sub)transactions in parallel during pre-commit 3392 Moved to different CF Performance 16 Not processed Etsuro Fujita (efujita) Fujii Masao (masaofujii), David Zhang (david.z) Etsuro Fujita (efujita) 8 3 years ago Logical insert/update/delete WAL records for custom table AMs 3394 Withdrawn 15 Not processed Jeff Davis (jdavis) Simon Riggs (simon) 4 3 years ago building postgres with meson 3395 Moved to different CF 16 Not processed Andres Freund (andresfreund) Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) Andres Freund (andresfreund) 5 3 years ago Use -fvisibility=hidden for shared libraries 3396 Committed Not processed Andres Freund (andresfreund) Tom Lane (tgl) Andres Freund (andresfreund) 4 3 years 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 explain_regress, explain(MACHINE), and default to explain(BUFFERS) 3409 Moved to different CF Monitoring 16 Not processed Justin Pryzby (justinpryzby), Nik Samokhvalov (nikolay) Laurenz Albe (laurenz), Justin Pryzby (justinpryzby) 6 3 years ago disallow HEAP_XMAX_COMMITTED and HEAP_XMAX_IS_LOCKED_ONLY 3434 Moved to different CF 16 Not processed Nathan Bossart (bossartn) Mark Dilger (mark.dilger) 7 3 years ago Add WAL recovery info such as current WAL file and WAL source to server logs 3443 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) Nathan Bossart (bossartn) 5 3 years 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 reduce impact of lengthy startup and checkpoint tasks 3448 Moved to different CF 17 Not processed Nathan Bossart (bossartn) Bharath Rupireddy (bharathrupireddy) 9 2 years ago WIN32 pg_import_system_collations 3450 Moved to different CF Not processed Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com) Peter Eisentraut (petere) Peter Eisentraut (petere) 6 3 years ago Daitch-Mokotoff soundex 3451 Moved to different CF Not processed Dag Lem (daglem) Paul Ramsey (pramsey) Tom Lane (tgl) 7 2 years ago partIndexlist for partitioned tables uniqueness 3452 Moved to different CF Performance Not processed Arne Roland (harks) David Rowley (davidrowley) David Rowley (davidrowley) 6 3 years ago pg_stat_toast 3457 Withdrawn Monitoring Not processed Gunnar "Nick" Bluth (bluthg) Ibrar Ahmed (ibrar) 3 3 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 Moved to different CF 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 Extensible RMgr 3469 Committed 15 Not processed Jeff Davis (jdavis) Julien Rouhaud (rjuju) Jeff Davis (jdavis) 3 3 years ago more descriptive message for process termination due to max_slot_wal_keep_size​ 3472 Moved to different CF Not processed Kyotaro Horiguchi (horiguti) Bertrand Drouvot (bdrouvot) Tom Lane (tgl) 4 3 years ago Add checkpoint and redo LSN to LogCheckpointEnd log message 3474 Committed Not processed Bharath Rupireddy (bharathrupireddy) Nathan Bossart (bossartn) Fujii Masao (masaofujii) 3 3 years 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 Allow specifying STORAGE attribute for a new table 3479 Committed SQL Commands 15 Not processed Fedor Sigaev (sigaev), Aleksander Alekseev (aalekseev) Kyotaro Horiguchi (horiguti), Peter Eisentraut (petere), Wenjing Zeng (wenjing.zwj), Matthias van de Meent (mmeent) Peter Eisentraut (petere) 3 3 years ago Extend compatibility of PostgreSQL::Test::Cluster 3480 Committed 15 Not processed Andrew Dunstan (adunstan) Michael Paquier (michael-kun) Andrew Dunstan (adunstan) 3 4 years 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 BufferAlloc: don't take two simultaneous locks 3483 Moved to different CF Performance 16 Not processed Yura Sokolov (funny_falcon) Michail Nikolaev (nkey) 4 3 years 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 Pluggable toaster 3490 Moved to different CF Not processed Fedor Sigaev (sigaev), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Nikita Malakhov (nmalakh) Andres Freund (andresfreund), Aleksander Alekseev (a.alekseev), Matthias van de Meent (mmeent) 7 3 years ago Add log messages when replication slots become active and inactive 3492 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) Amit Kapila (amitkapila) 10 2 years ago Per-table storage parameters for TableAM/IndexAM extensions 3495 Returned with feedback Not processed B Sadhu Prasad Patro (sadhuprasad) Jelte Fennema-Nio (jeltef) 3 4 years ago Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work 3496 Moved to different CF 16 Not processed Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) Nathan Bossart (bossartn) Michael Paquier (michael-kun) 4 3 years ago libpq compression 3499 Returned with feedback libpq Not processed Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) Justin Pryzby (justinpryzby) 3 4 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 CREATEROLE and role ownership hierarchies 3506 Returned with feedback Security 15 Not processed Mark Dilger (mark.dilger) Joshua Brindle (joshuab) 2 3 years ago Avoid smgrimmedsync() during index build and add unbuffered IO API 3508 Returned with feedback Performance Not processed Melanie Plageman (melanieplageman) 2 3 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 Move SLRU data into the regular buffer pool 3514 Moved to different CF Refactoring Only Not processed Heikki Linnakangas (heikki), Thomas Munro (macdice) Aleksander Alekseev (a.alekseev) 8 2 years ago Add last commit LSN to pg_last_committed_xact() 3515 Returned with feedback Monitoring Not processed James Coleman (jcole1989) 2 3 years ago Improve role attributes docs 3516 Moved to different CF Docs Only Not processed Shinya Kato (shinyakato) Fujii Masao (masaofujii), Swaha Miller (swaha) Bruce Momjian (bmomjian) 3 3 years ago Possible fails in pg_stat_statements test 3518 Committed Bugfix Not processed Anton Melnikov (antonmel) Robert Haas (rhaas) Robert Haas (rhaas) 2 3 years ago Suppressing useless wakeups in walreceiver 3520 Moved to different CF Not processed Thomas Munro (macdice), Nathan Bossart (bossartn) Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) Thomas Munro (macdice) 5 3 years ago Fix Windows network event handling 3523 Moved to different CF Bugfix Not processed Thomas Munro (macdice) Robert Haas (rhaas) 4 2 years ago [PATCH] Equivalence Class Filters 3524 Moved to different CF Performance 16 Not processed David Rowley (davidrowley), Andy Fan (andyf) Andrei Lepikhov (lepikhov) 4 3 years ago Allow pg_upgrade to copy segments of the same relfilenode in parallel 3525 Returned with feedback Not processed Jaime Casanova (jcasanov) 2 4 years ago support for MODULE 3528 Returned with feedback SQL Commands 16 Not processed Swaha Miller (swaha) Nathan Bossart (bossartn) 2 3 years ago wal_sync_method=fdatasync for Windows 3530 Committed Not processed Thomas Munro (macdice) Thomas Munro (macdice) 2 3 years ago Teach WaitEventSets to grow automatically 3533 Returned with feedback Refactoring Only Not processed Thomas Munro (macdice) 2 4 years ago postgres_fdw - use TABLESAMPLE when analyzing foreign tables 3535 Moved to different CF Performance Not processed Tomas Vondra (fuzzycz) Tom Lane (tgl), James Finnerty (jimfinnerty) Tomas Vondra (fuzzycz) 5 3 years ago New [relation] options engine 3536 Moved to different CF Refactoring Only Not processed Nikolay Shaplov (nataraj) 5 2 months ago new diagnostic items for the dynamic sql 3537 Moved to different CF Not processed Dinesh Kumar (dineshkumar) 4 3 years ago Allow parallel plan for referential integrity checks 3539 Moved to different CF Performance Not processed Frédéric Yhuel (yhuelf) Sami Imseih (simseih) 7 2 years ago Preventing indirection for IndexPageGetOpaque for known-size page special areas 3543 Moved to different CF 16 Not processed Matthias van de Meent (mmeent) 4 3 years ago Support custom authentication methods using hooks 3546 Returned with feedback 15 Not processed Samay Sharma (samaysharma) 2 4 years ago Documentation (mostly) of implementing TRANSFORM FOR TYPE in a PL 3554 Moved to different CF 15 Not processed Chapman Flack (chap) Pavel Stehule (okbobcz) 3 3 years ago reduce archiving overhead 3555 Committed Performance 16 Not processed Nathan Bossart (bossartn) Fujii Masao (masaofujii) 2 3 years ago speed up a logical replication setup (pg_subscriber) 3556 Returned with feedback Not processed Euler Taveira (eulerto) Peter Eisentraut (petere) 2 2 years ago Allow file inclusion in pg_hba and pg_ident files 3558 Moved to different CF Not processed Julien Rouhaud (rjuju) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 4 3 years ago TAP format output for pg_regress 3559 Returned with feedback 16 Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) 2 3 years ago Add native windows on arm64 support 3561 Moved to different CF Not processed Niyas Sait (niyassait) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 4 2 years ago Expose authenticated identity to extensions and triggers 3563 Moved to different CF Security Not processed Jacob Champion (jchampion) Bertrand Drouvot (bdrouvot) Michael Paquier (michael-kun) 3 3 years ago Reducing power consumption when idle 3566 Moved to different CF Not processed Simon Riggs (simon) Thomas Munro (macdice) 4 3 years ago doc: PQexecParams binary handling example for REAL data type 3568 Moved to different CF Docs Only Not processed Mark Wong (markwkm) 6 2 years ago Add LZ4 compression in pg_dump 3571 Moved to different CF libpq 16 Not processed Georgios Kokolatos (gkokolatos), Rachel Heaton (rheaton) Tomas Vondra (fuzzycz), Justin Pryzby (justinpryzby), Yu Shi (shiy.fnst) Tomas Vondra (fuzzycz) 6 3 years ago jit_warn_above_fraction parameter 3573 Moved to different CF Monitoring Not processed Magnus Hagander (mha) Julien Rouhaud (rjuju) 3 3 years ago Added Windows with MinGW environment in Cirrus CI 3575 Moved to different CF Testing Not processed Melih Mutlu (melihmutlu) Andres Freund (andresfreund), Justin Pryzby (justinpryzby) Andres Freund (andresfreund) 4 3 years ago Support for grabbing multiple consecutive values with nextval() 3577 Moved to different CF SQL Commands 15 Not processed Jille Timmermans (quis) Ronan Dunklau (rdunklau) 3 3 years ago Time-delayed logical replication subscriber 3581 Moved to different CF Not processed Euler Taveira (eulerto) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250) 6 3 years ago Kerberos delegation 3582 Moved to different CF Security Not processed Stephen Frost (sfrost), Peifeng Qiu (peifengq) Jacob Champion (jchampion) 3 2 years ago Fix checkpointer sync request queue problems 3583 Moved to different CF Bugfix Not processed Thomas Munro (macdice) 3 4 years ago Use "WAL segment" instead of "log segment" consistently in user-facing messages 3584 Moved to different CF Refactoring Only Not processed Bharath Rupireddy (bharathrupireddy) Nathan Bossart (bossartn) Tom Lane (tgl) 2 3 years ago Panic due to incorrect missingContrecPtr after promotion 3585 Committed Bugfix stable Not processed Sami Imseih (simseih) Álvaro Herrera (alvherre) 1 3 years ago Doc about how to set max_wal_senders when setting minimal wal_level 3586 Moved to different CF Docs Only Not processed Japin Li (japin) Lætitia AVROT (arkhena) Bruce Momjian (bmomjian) 2 3 years ago Harmonize "Hot Standby"<->"hot standby" in the documentation 3588 Committed Docs Only Not processed Daniel Westermann (sukhadukkham) Robert Treat (xzilla) Michael Paquier (michael-kun) 1 4 years ago Nonreplayable XLog records by means of overflows and >MaxAllocSize lengths 3590 Moved to different CF Bugfix stable Not processed Matthias van de Meent (mmeent) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 2 years ago Change the csv log to 'key:value' to facilitate the user to understanding and processing of log 3591 Rejected Monitoring Not processed lu peng (lupeng89) 1 3 years ago Declare PG_HAVE_8BYTE_SINGLE_COPY_ATOMICITY for aarch64 3593 Committed Performance Not processed Yura Sokolov (funny_falcon) Thomas Munro (macdice) 1 4 years ago 64-bit XIDs 3594 Moved to different CF Not processed Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Aleksander Alekseev (a.alekseev), Konstantin Knizhnik (knizhnik), Nikita Glukhov (n.glukhov), Yura Sokolov (funny_falcon), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Aleksander Alekseev (a.alekseev), Chris Travers (einhverfr) 6 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 avoid extra logging with 'postgres -C' for runtime-computed parameters 3596 Committed 15 Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun) 1 3 years ago Specify that the shared locks in pg_dump are actually ACCESS SHARE 3597 Committed Docs Only Not processed Florin Irion (irionr) Nathan Bossart (bossartn), shuli yan (xmasteryanshuli) John Naylor (john.naylor) 1 4 years ago Remove pgwin32_is_junction(), add lstat() for Windows 3598 Moved to different CF Bugfix Not processed Thomas Munro (macdice) Thomas Munro (macdice) 3 3 years ago Refactor add_path for clarity and extensibility 3599 Moved to different CF Refactoring Only Not processed Nils Dijk (nilsdijk) 2 3 years ago Summary Sort workers Stats in EXPLAIN ANALYZE 3601 Moved to different CF SQL Commands Not processed Jian Guo (jiang) 2 3 years ago Correct docs re: rewriting indexes when table rewrite is skipped 3603 Committed Docs Only Not processed James Coleman (jcole1989) Robert Haas (rhaas), Matthias van de Meent (mmeent) Robert Haas (rhaas) 1 4 years ago Restructure ALTER TABLE notes to clarify table rewrites and verification scans 3604 Returned with feedback Docs Only Not processed James Coleman (jcole1989) Matthias van de Meent (mmeent) 1 3 years ago PG DOCS - logical replication row filters 3605 Committed Docs Only Not processed Peter Smith (smithpb2250) Amit Kapila (amitkapila), Euler Taveira (eulerto) Amit Kapila (amitkapila) 1 3 years ago remove reset_shared() 3606 Committed Refactoring Only 16 Not processed Nathan Bossart (bossartn) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Tom Lane (tgl) 1 3 years ago Fix dsa_free() to re-bin segment 3607 Moved to different CF Bugfix Not processed Dongming Liu (inferyes) clundro infdahai (infdahai.outlook.com) Thomas Munro (macdice) 6 2 years ago Unit tests for SLRU 3608 Moved to different CF Testing 16 Not processed Aleksander Alekseev (a.alekseev) Daniel Gustafsson (d_gustafsson), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Michael Paquier (michael-kun) 3 3 years ago use has_privs_of_role() for pg_hba.conf 3609 Moved to different CF 16 Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun), Joe Conway (jconway), Joshua Brindle (joshuab) Joe Conway (jconway) 3 3 years ago Handle infinite recursion in logical replication setup 3610 Moved to different CF Not processed vigneshwaran C (vignesh.postgres) Amit Kapila (amitkapila), Ashutosh Bapat (ashutoshbapat), Hayato Kuroda (ha-kun), Peter Smith (smithpb2250) Amit Kapila (amitkapila) 2 3 years ago avoid multiple hard links to same WAL file after a crash 3611 Committed Bugfix 16 Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 3 years ago Add --schema and --exclude-schema options to vacuumdb 3612 Committed libpq 16 Not processed Gilles Darold (darold), Justin Pryzby (justinpryzby) Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) Andrew Dunstan (adunstan) 1 3 years ago Make XLogRecGetBlockTag API more error-proof 3613 Committed Refactoring Only 15 Not processed Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago make MaxBackends available in _PG_init 3614 Committed 15 Not processed Nathan Bossart (bossartn) Anton Melnikov (antonmel), alex lan (alex-xxx) Robert Haas (rhaas) 1 3 years ago Fix recovery conflict SIGUSR1 handling 3615 Moved to different CF Bugfix Not processed Thomas Munro (macdice) Michael Paquier (michael-kun), KARAM MOORE (global) Thomas Munro (macdice) 7 2 years ago remove unused CalculateMaxmumSafeLSN 3616 Committed Refactoring Only Not processed Sergei Kornilov (melkij) Tom Lane (tgl) 1 3 years ago Add index scan progress to pg_stat_progress_vacuum 3617 Moved to different CF Monitoring Not processed Sami Imseih (simseih) Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn) Masahiko Sawada (masahikosawada) 5 2 years ago Add --{no-,}bypassrls flags to createuser 3618 Committed libpq 16 Not processed Shinya Kato (shinyakato) Nathan Bossart (bossartn) Michael Paquier (michael-kun) 1 3 years ago allow specifying action when standby encounters incompatible parameter settings 3619 Withdrawn System Administration 16 Not processed Nathan Bossart (bossartn) 1 3 years ago Prohibit RESETing transaction-property GUCs 3620 Moved to different CF Bugfix Not processed Masahiko Sawada (masahikosawada) Michael Paquier (michael-kun) Tom Lane (tgl) 2 3 years ago Perform streaming logical transactions by background workers 3621 Moved to different CF Not processed Zhijie Hou (houzj) Peter Smith (smithpb2250) Amit Kapila (amitkapila) 5 2 years ago Logical replication timeout problem 3622 Committed Bugfix Not processed wei wang (wangwei) Amit Kapila (amitkapila), Masahiko Sawada (masahikosawada), Euler Taveira (eulerto), Hayato Kuroda (ha-kun), Ajin Cherian (ajinc), Zhijie Hou (houzj), Yu Shi (shiy.fnst), Fabrice Chapuis (fabricec) Amit Kapila (amitkapila) 1 3 years ago Data is copied twice when specifying both child and parent table in publication 3623 Moved to different CF Bugfix Not processed wei wang (wangwei), Yu Shi (shiy.fnst) Amit Kapila (amitkapila), Takamichi Osumi (tatatappp), vigneshwaran C (vignesh.postgres), Zhijie Hou (houzj) Amit Kapila (amitkapila) 5 3 years ago Fix mechanism for reserving OIDs for template0 and postgres DBs 3624 Committed Refactoring Only 15 Not processed Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago Fix file descriptor reuse bugs 3625 Committed Bugfix Not processed Andres Freund (andresfreund), Thomas Munro (macdice) Thomas Munro (macdice) 1 3 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 Add internal Numeric to Uint64 conversion function. 3627 Moved to different CF Refactoring Only 16 Not processed Amul Sul (sulamul) 3 3 years ago Teach pg_waldump to extract FPIs from the WAL stream 3628 Moved to different CF System Administration 16 Not processed David Christensen (davidchristensen) Bharath Rupireddy (bharathrupireddy) Michael Paquier (michael-kun) 4 3 years ago Use outerPlanState macro instead of referring to lefttree 3629 Committed Not processed Richard Guo (richardguo) Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago Fix controlfile inconsistency that can result in unrecoverable database 3630 Committed Bugfix Not processed Kyotaro Horiguchi (horiguti) Michael Paquier (michael-kun), Nathan Bossart (bossartn) Michael Paquier (michael-kun) 1 3 years ago Completed unaccent dictionary with many missing characters 3631 Moved to different CF 15 Not processed Przemysław Sztoch (psztoch) 4 3 years ago Log details for client certificate failures 3632 Committed Monitoring Not processed Jacob Champion (jchampion) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 3 years ago Costing elided SubqueryScans more nearly correctly 3633 Committed Performance Not processed Tom Lane (tgl) Richard Guo (richardguo) Tom Lane (tgl) 1 3 years ago Add initdb option to initialize cluster with non-standard xid/mxid/mxoff. 3634 Moved to different CF 16 Not processed Maxim Orlov (m.orlov), Pavel Borisov (pborisov) 5 3 years ago Hash index sort performance 3635 Committed Performance Not processed Simon Riggs (simon) Amit Kapila (amitkapila) Tom Lane (tgl) 1 3 years ago REINDEX syntax usability 3636 Committed Not processed Simon Riggs (simon) Michael Paquier (michael-kun) 1 3 years ago Remove support for Visual Studio 2013 3637 Committed 16 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 3 years ago postgres_fdw versus regconfig and similar constants 3638 Committed Bugfix Not processed Tom Lane (tgl) Robert Haas (rhaas) Tom Lane (tgl) 1 3 years ago Zstandard support for toast compression 3639 Withdrawn Not processed Michael Paquier (michael-kun) 1 3 years ago Fixes wrong memset api usage 3640 Rejected Bugfix Not processed Ranier Vilela (raniervilela) 1 3 years ago USAGE privilege on PUBLICATION 3641 Moved to different CF Security Not processed Antonin Houska (a.houska) 9 3 years ago Implicitly created operator family not listed by pg_event_trigger_ddl_commands 3642 Committed Bugfix Not processed Masahiko Sawada (masahikosawada) Álvaro Herrera (alvherre) 1 3 years ago bogus: logical replication rows/cols combinations 3643 Committed Bugfix Not processed Zhijie Hou (houzj) Amit Kapila (amitkapila) 1 3 years ago Add result_types column to pg_prepared_statements view 3644 Committed 16 Not processed Dagfinn Ilmari Mannsåker (ilmari) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 3 years ago Refactoring MemSet/memset api usage 3645 Moved to different CF Refactoring Only 16 Not processed Ranier Vilela (raniervilela) Peter Eisentraut (petere) 2 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 5 days ago allow building trusted languages without the untrusted versions 3647 Returned with feedback System Administration 16 Not processed Nathan Bossart (bossartn) 1 3 years ago ecpglib: call newlocale() once per process 3648 Committed Performance stable Not processed Noah Misch (nmisch) Tom Lane (tgl) Noah Misch (nmisch) 1 3 years ago Improve TAP tests of pg_upgrade for cross-version tests 3649 Moved to different CF Testing Not processed Michael Paquier (michael-kun) Justin Pryzby (justinpryzby), Anton Melnikov (antonmel) Michael Paquier (michael-kun) 2 3 years ago Expand palloc/pg_malloc API 3650 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 2 3 years ago Improving connection scalability 3651 Rejected Performance 16 Not processed Ranier Vilela (raniervilela) 1 3 years ago Bump MIN_WINNT to 0x0600 (Vista) as minimal runtime in 16~ 3652 Committed Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 3 years ago Allow makeaclitem() to accept multiple privileges 3653 Committed SQL Commands 16 Not processed Robins Tharakan (robins) Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago Support % wildcard in extension upgrade scripts 3654 Moved to different CF 16 Not processed Sandro Santilli (strk) Regina Obe (reginaobe) 6 2 years ago introduce pg_attribute_nonnull() 3655 Committed 16 Not processed Nathan Bossart (bossartn) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 3 years ago De-reserve "STRING" 3656 Committed Bugfix 15 Not processed Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago Fix the statistics gathering in case of commit and chain 3657 Moved to different CF Bugfix Not processed Lætitia AVROT (arkhena) 2 3 years ago Fix ECPG's handling of typedef names that match SQL keywords 3658 Committed Bugfix Not processed Tom Lane (tgl) Noah Misch (nmisch) Tom Lane (tgl) 1 3 years ago Add SPLIT PARTITION/MERGE PARTITIONS commands 3659 Moved to different CF SQL Commands 19 10/10 +8227−46 Dmitry Koval (d.koval) stephane tachoires (sttachoires) Alexander Korotkov (smagen) 17 3 months ago Log query parameters in auto_explain 3660 Committed Monitoring 16 Not processed Dagfinn Ilmari Mannsåker (ilmari) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 3 years ago ensure privilege checks in CREATE INDEX run as calling user 3661 Committed Bugfix stable Not processed Noah Misch (nmisch), Nathan Bossart (bossartn) Noah Misch (nmisch) 1 3 years ago Fix assertion failure with barriers in parallel hash join 3662 Moved to different CF Bugfix stable Not processed Thomas Munro (macdice), Melanie Plageman (melanieplageman) David Geier (geidav) Thomas Munro (macdice) 5 3 years 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 Deletion of the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off 3664 Returned with feedback Not processed Bharath Rupireddy (bharathrupireddy) 1 3 years ago An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication 3665 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) 6 2 years ago Add last failed connection error message to pg_stat_wal_receiver 3666 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) 2 3 years ago pg_walcleaner - new tool to detect, archive and delete the unneeded wal files 3667 Moved to different CF System Administration Not processed Bharath Rupireddy (bharathrupireddy) 2 3 years ago pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory 3668 Withdrawn Not processed Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) 1 2 years ago Fix unnecessary includes and comments in 019_replslot_limit.pl, 007_wal.pl and 004_timeline_switch.pl 3669 Committed Refactoring Only Not processed Bharath Rupireddy (bharathrupireddy) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Michael Paquier (michael-kun) 1 3 years ago pg_rewind: warn when checkpoint hasn't happened after promotion 3670 Moved to different CF Bugfix Not processed James Coleman (jcole1989) Keisuke Kuroda (kiskk) Heikki Linnakangas (heikki) 5 3 years ago BuildRelationExtStatistics should CHECK_FOR_INTERRUPTS 3671 Committed Bugfix 14 Not processed Tom Lane (tgl), Justin Pryzby (justinpryzby) Tom Lane (tgl) Tom Lane (tgl) 1 3 years 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 Reducing Memory Consumption (aset and generation) 3673 Rejected Performance 15 Not processed Ranier Vilela (raniervilela) 1 3 years ago pg_buffercache: add sql test 3674 Committed Not processed DongWook Lee (dongwooklee) Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago [BUG] Panic due to incorrect missingContrecPtr after promotion 3675 Moved to different CF Bugfix Not processed Sami Imseih (simseih) 2 3 years ago OAT_POST_CREATE object visibility 3676 Moved to different CF Not processed Mary Xu (maryxu-pg) Jeff Davis (jdavis) 2 3 years ago Add TAP test for auth_delay extension 3677 Moved to different CF Testing Not processed DongWook Lee (dongwooklee) 2 3 years ago Allow foreign keys to reference a superset of unique columns 3678 Moved to different CF 16 Not processed Kaiting Chen (ktchen14) 2 3 years ago Support load balancing in libpq 3679 Moved to different CF libpq 16 Not processed Jelte Fennema-Nio (jeltef) Daniel Gustafsson (d_gustafsson), Andrey Borodin (x4m), Michael Banck (mbanck) Daniel Gustafsson (d_gustafsson) 5 3 years ago Add description about using geqo to EXPLAIN or debug log. 3680 Moved to different CF Monitoring Not processed masaya kawamoto (kawamoto) 2 3 years ago Replica Identity check of partition table on subscriber 3681 Committed 15 Not processed Zhijie Hou (houzj), Yu Shi (shiy.fnst) Amit Langote (amitlan) Amit Kapila (amitkapila) 1 3 years ago Parse dates that include CE and BCE 3682 Returned with feedback 16 Not processed David Fetter (dfetter) 1 3 years ago In logs, use microsecond rather than millisecond granularity for timestamps 3683 Returned with feedback Monitoring 16 Not processed David Fetter (dfetter) 1 3 years ago Add checks on search_path for IMMUTABLE and SECURITY DEFINER functions 3684 Moved to different CF SQL Commands Not processed Greg Stark (stark) 2 3 years ago Remove trailing newlines from pg_upgrade's messages 3685 Committed Refactoring Only Not processed Tom Lane (tgl) Peter Eisentraut (petere) Tom Lane (tgl) 1 3 years 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 Add JIT deform_counter 3688 Moved to different CF Monitoring Not processed Dmitry Dolgov (erthalion) Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 7 2 years ago I thought it would be better to add a POSIx_fadvise description for the recovery_prefetch parameter here, to distinguish it from the database functions. 3689 Withdrawn Docs Only 15 Not processed 1 3 years ago I thought it would be better to add a POSIx_fadvise description for the recovery_prefetch parameter here, to distinguish it from the database functions. 3690 Withdrawn Docs Only 15 Not processed 1 3 years ago Clarify Savepoint Behavior 3691 Committed Docs Only Not processed David Johnston (polobo) Bruce Momjian (bmomjian) 1 3 years ago Clarify what "excluded" represents for INSERT ON CONFLICT 3692 Committed Docs Only Not processed David Johnston (polobo) Bruce Momjian (bmomjian) 1 3 years ago Clarify Routines and Extension Membership 3693 Moved to different CF Docs Only Not processed David Johnston (polobo) Bruce Momjian (bmomjian) 2 3 years ago Fix description of how the default user name is chosen 3694 Moved to different CF Docs Only Not processed David Johnston (polobo) Peter Eisentraut (petere) Peter Eisentraut (petere) 3 3 years ago Make selectivity example match wording 3695 Moved to different CF Docs Only Not processed David Johnston (polobo) Dian Fay (dmfay) 3 3 years ago Move enum storage commentary to top of section 3696 Returned with feedback Docs Only Not processed David Johnston (polobo) Matthias van de Meent (mmeent) 1 3 years ago Bring mention of unique index forced transaction wait behavior outside of the internal section 3697 Committed Docs Only Not processed David Johnston (polobo) Bruce Momjian (bmomjian) 1 3 years ago array_length produces null instead of 0 3698 Committed Docs Only Not processed David Johnston (polobo) Daniel Shelepanov (dshelepanov) Bruce Momjian (bmomjian) 1 3 years ago generate_series in selected timezone, date_add in selected timezone 3699 Moved to different CF 16 Not processed Gurjeet Singh (gurjeet), Przemysław Sztoch (psztoch) Tom Lane (tgl), Gurjeet Singh (gurjeet) Tom Lane (tgl) 5 3 years ago Detecting plan changes with plan_id in pg_stat_activity 3700 Returned with feedback Performance Not processed Sami Imseih (simseih) Julien Rouhaud (rjuju) 1 3 years 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 Autoconf update 3702 Returned with feedback Not processed Peter Eisentraut (petere) Tom Lane (tgl) 1 3 years ago SYSTEM_USER reserved word implementation 3703 Moved to different CF 16 Not processed Bertrand Drouvot (bdrouvot) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 3 years ago explain analyze rows=%.0f 3704 Moved to different CF Not processed Ibrar Ahmed (ibrar) Amit Kapila (amitkapila), Hamid Akhtar (hamidakhtar), Naeem Akhter (naeem) 5 1 year 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 Custom tuplesorts for extensions 3706 Committed Refactoring Only 16 Not processed Alexander Korotkov (smagen) Maxim Orlov (m.orlov), Pavel Borisov (pborisov), Matthias van de Meent (mmeent) Alexander Korotkov (smagen) 1 3 years ago Use fadvise in wal replay 3707 Moved to different CF Performance Not processed Kirill Reshke (reshke), Jakub Wartak (jakub.wartak.tomtom) Andrey Borodin (x4m), Pavel Borisov (pborisov) 5 2 years ago Make name optional in CREATE STATISTICS 3708 Committed SQL Commands Not processed Simon Riggs (simon) Matthias van de Meent (mmeent) Dean Rasheed (deanr) 1 3 years ago CI and test improvements 3709 Moved to different CF Testing Not processed Justin Pryzby (justinpryzby) 14 1 year ago Optimize json_lex_string by batching character copying 3710 Committed Performance 16 Not processed Jelte Fennema-Nio (jeltef) John Naylor (john.naylor) John Naylor (john.naylor) 1 3 years ago making relfilenodes 56 bit 3711 Moved to different CF Not processed Dilip Kumar (dilip.kumar) Robert Haas (rhaas) 4 3 years ago Make an unique type name generation routine more resistant to name collisions 3712 Committed 15 Not processed Andrei Lepikhov (lepikhov), Dmitry Koval (d.koval) Masahiko Sawada (masahikosawada) Tom Lane (tgl) 1 3 years ago Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row 3713 Moved to different CF 16 Not processed Hamid Akhtar (hamidakhtar) Ibrar Ahmed (ibrar), Asif Rehman (asifrana), Muhammad Usama (muhammad_usama), Bertrand Drouvot (bdrouvot), Naeem Akhter (naeem) Tom Lane (tgl) 2 3 years ago Make subquery alias optional in FROM clause 3714 Committed 16 Not processed Dean Rasheed (deanr) Tom Lane (tgl) Dean Rasheed (deanr) 1 3 years ago refactor some protocol message sending in walsender and basebackup 3715 Committed Refactoring Only Not processed Peter Eisentraut (petere) Nathan Bossart (bossartn) Peter Eisentraut (petere) 1 3 years ago Let libpq reject unexpected authentication requests 3716 Moved to different CF Security 16 Not processed Jacob Champion (jchampion) Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) Michael Paquier (michael-kun) 5 3 years ago pg_upgrade: check for old polymorphics from pre-14 3717 Committed System Administration 14 Not processed Justin Pryzby (justinpryzby) Andrey Borodin (x4m) Tom Lane (tgl) 1 3 years ago automatic client-side column-level encryption 3718 Moved to different CF Security Not processed Peter Eisentraut (petere) 6 1 year ago Export log_line_prefix(); useful for emit_log_hook. 3719 Committed Refactoring Only 16 Not processed Jeff Davis (jdavis) Jeff Davis (jdavis) 1 3 years ago Emit debug message when executing extension script. 3720 Committed 16 Not processed Jeff Davis (jdavis) Nathan Bossart (bossartn) Jeff Davis (jdavis) 1 3 years ago BRIN indexes and autosummarize 3721 Committed Docs Only 15 Not processed Roberto Mello (rmello) Álvaro Herrera (alvherre) 1 3 years ago Temporary file access API 3722 Moved to different CF Refactoring Only Not processed Antonin Houska (a.houska) 2 3 years ago Add test of pg_prewarm extension 3723 Committed Not processed DongWook Lee (dongwooklee) Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago add test: pg_rowlocks extension 3724 Moved to different CF Testing Not processed DongWook Lee (dongwooklee) Tom Lane (tgl) Tom Lane (tgl) 2 3 years ago Minor change for create_list_bounds() 3725 Committed Not processed Ted Yu (tedyu) Nathan Bossart (bossartn) David Rowley (davidrowley) 1 3 years ago Select Reference Page - Make Join Syntax More Prominent 3726 Moved to different CF Docs Only Not processed David Johnston (polobo) 2 3 years 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 ENABLE/DISABLE broken for statement triggers on partitioned tables 3728 Moved to different CF Bugfix Not processed Amit Langote (amitlan) Dmitry Koval (d.koval) Álvaro Herrera (alvherre) 2 3 years ago Testing autovacuum wraparound 3729 Moved to different CF Testing Not processed Andres Freund (andresfreund), Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 8 2 years ago New argument variation f(filename, missing_ok) of pg_read_file/pg_read_binary_file 3730 Committed Not processed Kyotaro Horiguchi (horiguti) Tom Lane (tgl) Tom Lane (tgl) 1 3 years ago Reloption tests iprovement. Test resetting illegal option that was actually set for some reason 3731 Withdrawn 15 Not processed Nikolay Shaplov (nataraj) 1 3 years ago pg_prewarm add configuration example 3732 Committed Docs Only Not processed DongWook Lee (dongwooklee) Bruce Momjian (bmomjian) 1 3 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 Remove useless param for create_groupingsets_path 3734 Committed Refactoring Only Not processed xuejing zhao (zxuejing) Richard Guo (richardguo) Tom Lane (tgl) 1 3 years ago New hooks in the connection path 3735 Moved to different CF 16 Not processed Bertrand Drouvot (bdrouvot) Joe Conway (jconway), Bharath Rupireddy (bharathrupireddy) 5 3 years 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 NLS: Put list of available languages into LINGUAS files 3737 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 3 years ago dual pivot quicksort 3738 Withdrawn Performance Not processed John Naylor (john.naylor) 1 3 years ago pg_visibility's pg_check_visible() yields false positive when working in parallel with autovacuum 3739 Moved to different CF Bugfix 17 Not processed Daniel Shelepanov (dshelepanov) Alexander Korotkov (smagen) 6 2 years ago Minimal logical decoding on standbys 3740 Moved to different CF 16 Not processed Bertrand Drouvot (bdrouvot) Bharath Rupireddy (bharathrupireddy) Andres Freund (andresfreund) 5 2 years ago document use of Table Access Methods with pgbench 3741 Committed Docs Only 16 Not processed Alexander Korotkov (smagen), Michel Pelletier (michelp) Alexander Korotkov (smagen) 1 3 years ago Add red-black tree missing comparison searches 3742 Committed Not processed Alexander Korotkov (smagen), Steve Chávez (steve-chavez) Alexander Korotkov (smagen) 1 3 years ago Allow specification of custom slot for custom nodes 3743 Moved to different CF Refactoring Only 16 Not processed Alexander Korotkov (smagen) Pavel Borisov (pborisov) Alexander Korotkov (smagen) 3 3 years ago grant-level NOINHERIT option 3744 Moved to different CF Security 16 Not processed Robert Haas (rhaas) Nathan Bossart (bossartn) Robert Haas (rhaas) 2 3 years ago pg_auth_members.grantor is bunk 3745 Moved to different CF Security 16 Not processed Robert Haas (rhaas) Robert Haas (rhaas) 2 3 years ago Patch to address creation of PgStat* contexts with null parent context 3746 Moved to different CF Bugfix Not processed Reid Thompson (jreidthompsoncd) Bertrand Drouvot (bdrouvot), Mingli Zhang (zml) Andres Freund (andresfreund) 2 3 years ago Reloption tests improvement. Test resetting illegal option that was actually set for some reason 3747 Returned with feedback Not processed Nikolay Shaplov (nataraj) 1 3 years ago Support multiple password-based authentication tokens concurrently 3748 Moved to different CF 17 Not processed Joshua Brindle (joshuab) Gurjeet Singh (gurjeet) 2 2 years ago Allow placeholders in ALTER ROLE w/o superuser 3749 Moved to different CF Not processed Steve Chávez (steve-chavez) Nathan Bossart (bossartn) 2 3 years ago Eliminating SPI from RI triggers 3750 Moved to different CF Performance Not processed Amit Langote (amitlan) 6 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 10 hours ago POC: Lock updated tuples in tuple_update() and tuple_delete() 3752 Moved to different CF Refactoring Only Not processed Alexander Korotkov (smagen) Aleksander Alekseev (a.alekseev), Pavel Borisov (pborisov) 2 2 years ago doc phrase: "inheritance child" 3753 Committed Docs Only Not processed Justin Pryzby (justinpryzby) Álvaro Herrera (alvherre) 1 3 years ago Improve test coverage of gistbuild.c 3754 Committed Not processed Matheus Alcantara (msalcantara) Aleksander Alekseev (a.alekseev) Tom Lane (tgl) 1 3 years ago Create subscription stats entry at CREATE SUBSCRIPTION 3776 Moved to different CF Not processed Masahiko Sawada (masahikosawada) Andres Freund (andresfreund) 2 3 years ago Improve description of XLOG_RUNNING_XACTS 3779 Moved to different CF Not processed Masahiko Sawada (masahikosawada) Bharath Rupireddy (bharathrupireddy) Amit Kapila (amitkapila) 3 3 years ago Introduce wait_for_subscription_sync for TAP tests 3780 Moved to different CF Testing Not processed Masahiko Sawada (masahikosawada) Amit Kapila (amitkapila) 2 3 years ago