Commitfest 2021-09

Shortcuts
Text Status Target version Author Reviewer
Clear


Status summary: Committed: 54. Moved to next CF: 209. Withdrawn: 2. Rejected: 3. Returned with Feedback: 49. Total: 317.

Closed patches

Status Ver Author Reviewers Committer Num cfs Latest activity Latest mail
Bug Fixes
standby recovery fails when re-replaying due to missing directory which was removed in previous replay. Moved to next CF stable Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) Michael Paquier (michael-kun) alvherre 16 2022-07-28
06:42
2022-08-01
02:01
pg_upgrade fails with non-standard ACL Moved to next CF Anastasia Lubennikova (lubennikovaav), Artur Zakirov (a.zakirov) Grigory Smolkin (g.smolkin.postgrespro.ru) nmisch 12 2021-11-26
12:46
2021-11-26
12:46
Corruption during WAL replay Moved to next CF stable Teja Mupparti (tejam) Robert Haas (rhaas), Daniel Shelepanov (dshelepanov) rhaas 10 2022-03-24
19:33
2022-03-29
17:04
archive status ".ready" files may be created too early Committed stable Nathan Bossart (bossartn) Álvaro Herrera (alvherre) alvherre 7 2021-08-23
20:24
2021-09-01
02:15
DROP relation IF EXISTS Docs and Tests - Bug Fix Withdrawn David Johnston (polobo) Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com) 7 2021-08-11
14:42
2021-08-11
14:41
Fix collation handling in postgres_fdw Returned with feedback Tom Lane (tgl) Etsuro Fujita (efujita) 6 2021-09-25
14:57
2021-10-01
19:37
Fix checksum verification in base backups for zero page headers Returned with feedback Michael Banck (mbanck) Anastasia Lubennikova (lubennikovaav), David Steele (dsteele) 6 2021-09-13
11:45
2021-09-13
11:45
brin: avoid errors processing work item following concurrent reindex Moved to next CF stable Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby) Gurjeet Singh (gurjeet) 5 2021-12-02
10:59
2021-12-02
10:59
Fix firing of RI triggers during cross-partition updates of partitioned tables Moved to next CF Amit Langote (amitlan) Masahiko Sawada (masahikosawada) alvherre 7 2022-03-20
17:58
2022-03-22
01:18
Fix DROP TABLESPACE on Windows with ProcSignalBarrier? Moved to next CF Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) macdice 6 2022-02-11
23:27
2022-02-11
21:22
Set default transactions to read-only at servers start in pg_upgrade Moved to next CF Denis Laxalde (dlax) Julien Rouhaud (rjuju) 4 2021-12-01
14:22
2022-03-14
21:12
Autovacuum dynamic cost_limit, cost_delay Returned with feedback Scott Mead (meads-amazon) Masahiko Sawada (masahikosawada) 3 2021-10-01
06:50
2021-05-26
08:00
Removing unused trailing linepointers from heap pages Moved to next CF Matthias van de Meent (mmeent) 3 2021-12-02
10:18
2022-04-08
11:38
Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Moved to next CF Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) amitkapila 7 2022-08-12
13:35
2022-08-29
06:17
Eliminating "Permission denied" errors on stat() (on Windows) Moved to next CF Alexander Lakhin (law) 4 2021-12-03
12:51
2021-12-03
03:00
generate fractional cheapest paths in generate_orderedappend_paths Moved to next CF Tomas Vondra (fuzzycz) Arne Roland (harks) fuzzycz 4 2022-01-12
23:16
2022-03-22
00:33
badly calculated width of emoji in psql Committed Jacob Champion (jchampion) Pavel Stehule (okbobcz) john.naylor 2 2021-08-26
15:07
2021-08-26
15:47
pg_upgrade: copy the source oldestXid Committed stable Bertrand Drouvot (bdrouvot) bmomjian 2 2021-08-03
12:49
2021-08-15
14:44
psql: exclude valid constraints in tab-complete for ALTER TABLE .. VALIDATE CONSTRAINT Moved to next CF David Fetter (dfetter) Aleksander Alekseev (aalekseev) tgl 4 2022-01-03
23:14
2022-01-03
23:15
Support of time zone patterns - of, tzh and tzm Moved to next CF Nitin Jadhav (nitinjadhav11) David Zhang (david.z) rhaas 5 2022-03-14
20:52
2022-03-15
09:32
Parallel scan with SubTransGetTopmostTransaction assert coredump Committed Robert Haas (rhaas), Greg Nancarrow (gregn1234), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Pavel Borisov (pborisov) rhaas 2 2021-08-25
23:25
2021-08-25
13:39
Bug in query rewriter - hasModifyingCTE not getting set Returned with feedback 15 Takayuki Tsunakawa (maumau) Tom Lane (tgl) 2 2021-09-08
14:42
2021-09-08
14:28
Incorrect snapshots while promoting hot standby node when 2PC is used Moved to next CF stable Michael Paquier (michael-kun) michael-kun 3 2021-11-23
13:08
2021-11-22
16:50
Update Toast data failure in logical replication Moved to next CF Dilip Kumar (dilip.kumar) Euler Taveira (eulerto), Haiying Tang (tanghy) amitkapila 5 2022-02-16
02:55
2022-02-15
03:20
Fix around conn_duration in pgbench Committed 14 Yugo Nagata (yugo.nagata) Asif Rehman (asifrana) masaofujii 2 2021-09-01
08:08
2021-09-01
09:33
Avoid stuck of pgbench due to skipped transactions Committed stable Yugo Nagata (yugo.nagata) Greg Sabino Mullane (greg) masaofujii 2 2021-09-09
16:31
2021-09-09
16:30
Extended protocol COPY FROM STDIN fix Moved to next CF Jeff Davis (jdavis) 3 2021-12-01
10:59
2021-12-01
10:59
Fix pkg-config file for static linking Committed Filip Gospodinov (fil) Peter Eisentraut (petere) petere 2 2021-09-06
07:59
2021-09-06
08:30
Fix numeric power for negative bases and other corner cases Moved to next CF Dean Rasheed (deanr) Yugo Nagata (yugo.nagata) deanr 3 2021-10-06
12:40
2021-10-01
14:25
Fix pgbench's exit status and log messages for connection failures Moved to next CF stable Fabien Coelho (calvin), Yugo Nagata (yugo.nagata) masaofujii 3 2021-11-02
14:12
2021-11-04
00:31
ECPG bug fix: allow using connection-associated prepared_name Committed Hayato Kuroda (ha-kun) meskes 2 2021-09-01
01:25
2021-08-25
05:34
Fix uninitialized variable access (freepages) Moved to next CF 15 Ranier Vilela (raniervilela) Greg Nancarrow (gregn1234), David Zhang (david.z) 4 2022-03-14
19:15
2022-03-14
19:30
when the blocksize is 32k, the function page_header of pageinspect returns negative numbers. Committed Zongliang Quan (quanzl) michael-kun 1 2021-07-12
02:18
2021-07-12
02:16
[bug] Logical Decoding of relation rewrite with toast does not reset toast_hash Committed stable Bertrand Drouvot (bdrouvot) David Zhang (david.z) amitkapila 1 2021-08-25
05:57
2021-08-26
08:17
Fix handling of outer GroupingFunc within subqueries Moved to next CF Richard Guo (richardguo) Tom Lane (tgl), Platon Pronko (rogach) tgl 4 2022-03-21
21:45
2022-03-21
21:09
corruption of WAL page header is never reported Moved to next CF stable Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii) masaofujii 2 2021-10-05
15:19
2021-10-05
15:18
pgbench: using prepared BEGIN statement in a pipeline could cause an error Moved to next CF 15 Yugo Nagata (yugo.nagata) Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege) alvherre 9 2023-02-21
15:39
2023-02-21
16:32
Fix postgres_fdw's ORDER BY pushdown handling Moved to next CF Ronan Dunklau (rdunklau) Tom Lane (tgl), David Zhang (david.z) tgl 4 2022-03-31
18:51
2022-03-31
18:51
Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Committed 15 Artur Zakirov (a.zakirov) Tom Lane (tgl) tgl 1 2021-09-14
21:18
2021-09-15
12:03
wrong refresh when ALTER SUBSCRIPTION ADD/DROP PUBLICATION Committed Hou Zhijie (houzj) amitkapila 1 2021-08-24
05:22
2021-08-25
04:30
Support reset of Shared objects statistics Committed B Sadhu Prasad Patro (sadhuprasad) Mahendra Singh Thalor (mahithalor) masaofujii 1 2021-09-02
05:05
2021-09-02
05:04
Failed Assertion in ReorderBufferChangeMemoryUpdate() Committed stable Bertrand Drouvot (bdrouvot) amitkapila 1 2021-09-13
06:35
2021-09-14
09:10
Error out if SKIP LOCKED and WITH TIES are both specified Moved to next CF stable David Christensen (davidchristensen) alvherre 2 2023-03-06
15:41
2021-10-02
17:24
pg_dump handling of ALTER DEFAULT PRIVILEGES IN SCHEMA Moved to next CF stable Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn) Muhammad Usama (muhammad_usama) tgl 2 2021-10-22
19:23
2021-10-22
20:14
Do not start bgworker processes during binary upgrade Moved to next CF Denis Laxalde (dlax) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju) 4 2022-03-14
21:13
2022-03-14
21:12
Fix ATTACH/DETACH PARTITION to invalidate partitions of table being attached/detached Moved to next CF stable Álvaro Herrera (alvherre), Amit Langote (amitlan) Maxim Orlov (m.orlov), Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) alvherre 2 2021-10-19
23:17
2021-10-19
01:23
\dP and \dX use ::regclass without "pg_catalog." Committed 12 Justin Pryzby (justinpryzby) alvherre 1 2021-08-30
00:27
2021-08-28
12:57
Fix erroneous parallel execution when modifying CTE is present in rewritten query Committed 15 Greg Nancarrow (gregn1234) Tom Lane (tgl) tgl 1 2021-09-08
16:07
2021-09-08
16:11
Patch: shouldn't timezone(text, timestamp[tz]) be STABLE? Committed Aleksander Alekseev (aalekseev) Tom Lane (tgl) tgl 1 2021-09-06
19:00
2021-09-06
15:49
Check for STATUS_DELETE_PENDING on Windows Moved to next CF Thomas Munro (macdice) macdice 3 2021-12-10
03:34
2021-12-10
03:25
Clients
psql - add SHOW_ALL_RESULTS option Moved to next CF Fabien Coelho (calvin) Peter Eisentraut (petere) petere 13 2022-04-04
21:33
2022-04-06
17:05
pg_dump - read data for some options from external file Moved to next CF Pavel Stehule (okbobcz) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v) d_gustafsson 18 2023-11-29
14:44
2023-11-30
15:45
libpq compression Moved to next CF 15 Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag) 6 2021-12-03
07:31
2021-12-03
07:31
Support tab completion for upper character inputs in psql Moved to next CF Haiying Tang (tanghy) Tom Lane (tgl), Peter Eisentraut (petere) tgl 5 2022-01-30
18:33
2022-02-04
23:41
Refactor ECPGconnect() and allow IPv6 connection Returned with feedback Hayato Kuroda (ha-kun) 3 2021-10-01
07:14
2021-08-07
20:36
Using COPY FREEZE in pgbench Committed 15 Tatsuo Ishii (ishii) Fabien Coelho (calvin) ishii 2 2021-09-02
02:00
2021-09-02
01:56
pg_dump new feature: exporting functions only Moved to next CF 15 Lætitia AVROT (arkhena) ahsan hadi (ahsan.hadi), Ryan Lambert (ryanlambert) 5 2022-04-07
05:43
2022-04-08
06:36
Add option --drop-cascade for pg_dump/restore Moved to next CF Wu Haotian (whtsky) Greg Sabino Mullane (greg) 3 2021-12-01
10:46
2021-12-01
10:45
pgbench - allow retries on some errors Returned with feedback 15 Yugo Nagata (yugo.nagata), Marina Polyakova (whipping.top1991) Fabien Coelho (calvin) 2 2021-10-01
07:59
2022-04-06
01:00
Emit namespace in post-copy output Committed Mike Fiedler (miketheman) Daniel Gustafsson (d_gustafsson), Corey Huinker (coreyh) d_gustafsson 2 2021-08-16
18:14
2021-08-16
18:13
test pgbench time-related features Moved to next CF 15 Fabien Coelho (calvin) 2 2021-12-02
12:40
2021-12-02
12:40
Tab completion for CREATE SCHEMA AUTHORIZATION Moved to next CF Dagfinn Ilmari Mannsåker (ilmari) Suraj Khamkar (suraj.khamkar) 2 2021-12-03
01:18
2023-06-30
09:33
functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) Moved to next CF Justin Pryzby (justinpryzby) David Christensen (davidchristensen) 15 2024-10-08
00:59
2024-06-03
20:48
improve tab-completion behavior when parse text in single quote Moved to next CF Haiying Tang (tanghy) 2 2021-12-03
06:17
2021-12-03
06:16
Add tab-complete for full name backslash commands Committed Haiying Tang (tanghy) Dagfinn Ilmari Mannsåker (ilmari) tgl 1 2021-09-08
17:22
2021-09-08
17:25
Allow escape sequence in application_name Moved to next CF Hayato Kuroda (ha-kun) Fujii Masao (masaofujii) masaofujii 3 2021-12-24
08:03
2022-01-04
05:03
Tab completion for EXECUTE after EXPLAIN Committed Dagfinn Ilmari Mannsåker (ilmari) michael-kun 1 2021-08-25
03:03
2021-08-25
03:03
Tab completion for ALTER TABLE … ADD … Committed Dagfinn Ilmari Mannsåker (ilmari) michael-kun 1 2021-08-30
01:05
2021-08-31
08:36
psql: add xheader_width option to handle very long record lines Moved to next CF Platon Pronko (rogach) Andrew Dunstan (adunstan) adunstan 5 2022-07-25
18:27
2022-07-25
18:27
psql: \dl+ to list large objects privileges Moved to next CF Pavel Luzanov (pluzanov) Daniel Gustafsson (d_gustafsson), Georgios Kokolatos (gkokolatos) tgl 3 2022-01-06
18:09
2022-01-06
20:50
Code Comments
Extend comments on signal handling and cross-reference comments on signal handling functions Returned with feedback Craig Ringer (ringerc) Mark Dilger (mark.dilger) 3 2021-09-27
12:21
2021-09-27
12:21
Documentation
Further note require activity aspect of automatic checkpoint and archiving Moved to next CF David Johnston (polobo) 6 2021-11-04
09:36
2021-11-04
09:36
Extend docs on how to write correct postgres-dialect C including extensions and bgworkers Moved to next CF Craig Ringer (ringerc) Laurenz Albe (laurenz) 4 2021-11-04
10:55
2021-11-04
10:55
fix ICU explorer link in locale documentation Moved to next CF Anton Voloshin (a.voloshin) Laurenz Albe (laurenz) bmomjian 3 2021-11-02
19:44
2021-11-03
00:33
Improve documentation for pg_upgrade, standbys and rsync Moved to next CF 15 Laurenz Albe (laurenz) David Fetter (dfetter) 5 2022-04-08
05:15
2022-04-08
05:14
Clarify how triggers relate to transactions Committed 15 Laurenz Albe (laurenz) Simon Riggs (simon) tgl 2 2021-09-01
21:27
2021-09-01
21:25
Document the 1GB memory limit for VACUUM Committed 15 David Rowley (davidrowley), Laurenz Albe (laurenz) Greg Sabino Mullane (greg) davidrowley 2 2021-08-09
04:51
2021-08-09
04:53
Consistent use of SSL/TLS in docs Moved to next CF Daniel Gustafsson (d_gustafsson) Robert Haas (rhaas), Lætitia AVROT (arkhena) d_gustafsson 5 2022-03-30
11:44
2022-03-30
11:43
Fix documentation for COPY protocol flow Moved to next CF Jeff Davis (jdavis) 3 2021-12-01
14:18
2021-12-01
10:59
Small documentation improvement for ALTER SUBSCRIPTION Committed Masahiko Sawada (masahikosawada) Peter Eisentraut (petere) d_gustafsson 1 2021-09-15
07:59
2021-09-21
00:04
CREATE SUBSCRIPTION option list order Committed 15 Peter Smith (smithpb2250) Euler Taveira (eulerto) amitkapila 1 2021-09-13
18:27
2021-09-14
03:09
Document pg_encoding_to_char() and pg_char_to_encoding() Moved to next CF 15 Ian Barwick (barwick) Fujii Masao (masaofujii) masaofujii 2 2021-10-05
04:00
2021-10-05
03:55
Added documentation for cascade and restrict option of drop statistics Committed vigneshwaran C (vignesh.postgres) michael-kun 1 2021-07-22
06:37
2021-07-19
15:31
glossary definitions for auxiliary processes Committed 15 Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby) alvherre 1 2021-09-20
15:29
2021-09-20
15:28
Miscellaneous
Add table expansion hook Returned with feedback Erik Nordström (enordstr) Euler Taveira (eulerto), Aleksander Alekseev (aalekseev) 7 2021-09-13
14:16
2021-09-09
18:26
Fix behavior of geo_ops when NaN is involved Moved to next CF Kyotaro Horiguchi (horiguti) Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) 10 2022-08-01
20:29
2021-12-15
08:31
Reduce the number of special cases to build contrib modules on windows Committed David Rowley (davidrowley) davidrowley 5 2021-08-09
07:46
2021-08-09
07:55
Functions for sorting GiST build of gist_btree types Moved to next CF Andrey Borodin (x4m) Heikki Linnakangas (heikki), Emre Hasegeli (hasegeli) heikki 7 2022-04-08
15:16
2021-12-16
09:18
move pg_upgrade test.sh kludges to a SQL script Moved to next CF Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) michael-kun 6 2021-12-02
01:37
2021-12-02
01:49
Function to log backtrace of postgres processes Moved to next CF vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) Christoph Berg (myon), Maciek Sakrejda (msakrejda) 17 2024-04-01
03:32
2024-02-27
02:46
Introduce ProcessInterrupts_hook for C extensions Returned with feedback Craig Ringer (ringerc) 3 2021-10-06
13:11
2021-10-01
17:24
postgres_fdw: suppress explicit casts in text:text comparisons Moved to next CF Dian Fay (dmfay) Tom Lane (tgl), Georgios Kokolatos (gkokolatos) tgl 4 2021-11-12
16:54
2021-11-12
16:54
Add some tests for pg_stat_statements compatibility verification Moved to next CF Erica Zhang (zerica) Julien Rouhaud (rjuju) michael-kun 3 2021-10-02
08:44
2021-10-04
05:08
Allow multiple recursive self-references Moved to next CF Denis Hirn (brainy) Peter Eisentraut (petere) 6 2022-08-02
21:01
2022-04-23
15:14
use AV work items infrastructure for GIN pending list's cleanup Returned with feedback 15 Jaime Casanova (jcasanov) Masahiko Sawada (masahikosawada) 2 2021-09-08
14:08
2021-09-08
14:07
Avoid orphaned dependencies Moved to next CF 16 Bertrand Drouvot (bdrouvot) Ronan Dunklau (rdunklau) 6 2022-08-02
21:03
2022-03-30
19:18
Extending amcheck to check toast size and compression Moved to next CF Mark Dilger (mark.dilger) Greg Stark (stark), Aleksander Alekseev (aalekseev) michael-kun 3 2021-11-18
04:43
2021-11-06
08:04
Rewriting the test of pg_upgrade as a TAP test - take three Moved to next CF Michael Paquier (michael-kun) 3 2021-11-18
07:49
2022-04-02
03:10
TAP test for contrib/sslinfo Moved to next CF Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) d_gustafsson 3 2021-11-30
10:53
2021-11-30
10:52
Change internal PRNG (from rand48 to something better, with a cleaner interface) Moved to next CF 15 Fabien Coelho (calvin) Aleksander Alekseev (aalekseev) tgl 3 2021-11-29
02:34
2021-11-30
07:37
btree_gist: Support bool Moved to next CF Emre Hasegeli (hasegeli) fuzzycz 3 2021-11-06
16:07
2021-11-08
01:24
Use tuple-level SIREAD locks for index-only scans Moved to next CF Thomas Munro (macdice) 3 2021-12-02
10:37
2021-12-02
10:37
Fully WAL logged CREATE DATABASE - No Checkpoints Moved to next CF Dilip Kumar (dilip.kumar) Ashutosh Sharma (ashu_coek) rhaas 5 2022-03-29
17:10
2022-04-04
10:24
Expose get_query_def() Moved to next CF Julien Rouhaud (rjuju) Pavel Stehule (okbobcz), Gilles Darold (darold) tgl 5 2022-03-28
15:20
2022-03-28
15:48
pgbench: add multiconnect support Moved to next CF 16 David Christensen (davidchristensen) Jelte Fennema-Nio (jeltef) 9 2023-03-06
15:38
2023-01-31
17:30
psql tab auto-complete for CREATE PUBLICATION Committed 15 Peter Smith (smithpb2250) vigneshwaran C (vignesh.postgres) masaofujii 1 2021-09-01
13:05
2021-09-01
22:54
Dissallow sending SI messages when excuting ROLLBACK PREPARED command Committed huailing liu (haylee) michael-kun 1 2021-08-19
07:47
2021-08-19
07:52
disallow external access to MaxBackends Moved to next CF Nathan Bossart (bossartn) Greg Sabino Mullane (greg) michael-kun 4 2022-02-10
19:29
2022-05-16
13:25
perlcritic: prohibit map and grep in void conext Committed Dagfinn Ilmari Mannsåker (ilmari) Daniel Gustafsson (d_gustafsson) d_gustafsson 1 2021-08-31
09:30
2021-08-31
09:55
Allow special values in GUC configurations Moved to next CF 16 David Christensen (davidchristensen) Cary Huang (cary) 4 2023-03-06
15:40
2022-03-22
19:04
Add PGDLLIMPORT to all direct or indirect GUC variables Moved to next CF 15 Robert Haas (rhaas), Julien Rouhaud (rjuju) rhaas 4 2022-04-08
12:43
2022-04-06
23:56
Showing I/O timings spent reading/writing temp buffers in EXPLAIN Moved to next CF 15 Masahiko Sawada (masahikosawada) Julien Rouhaud (rjuju), Melanie Plageman (melanieplageman), Georgios Kokolatos (gkokolatos) michael-kun 4 2022-04-08
04:20
2022-04-08
05:19
AIX: Symbols are missing in libpq.a Committed 14 Tony Reix (trex58) Noah Misch (nmisch) nmisch 1 2021-09-06
18:35
2021-09-06
07:31
Monitoring & Control
Shared-memory based stats collector Returned with feedback Kyotaro Horiguchi (horiguti) Tomas Vondra (fuzzycz), Antonin Houska (a.houska) 17 2021-10-01
17:20
2022-04-08
04:44
Add extra statistics to explain for Nested Loop Moved to next CF Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) 10 2022-10-12
06:05
2022-07-31
03:49
pg_stat_statements and "IN" conditions Moved to next CF Dmitry Dolgov (erthalion) Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun) 20 2024-10-07
14:19
2024-08-13
20:06
Track wal_level drop for backup management Returned with feedback Takamichi Osumi (tatatappp) 3 2021-10-01
07:44
2021-07-14
11:58
Add system views pg_permissions and pg_ownerships Moved to next CF Joel Jacobson (joeljacobson) 5 2022-04-08
13:38
2024-10-08
16:58
pg_stat_statements: Track statement entry timestamp Moved to next CF 17 Andrei Zubkov (zubkov) Alena Rybakina (a.rybakina) smagen 13 2023-11-27
00:53
2023-11-29
07:00
Logging plan of the currently running query Moved to next CF 16 atsushi torikoshi (atorik) Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) 9 2023-06-06
06:47
2024-03-26
02:34
Add statistics refresh materialized view Returned with feedback Yuki Seino (seinoyu) Fujii Masao (masaofujii) 1 2021-10-01
06:48
2021-10-01
06:49
Log the activity of startup process Moved to next CF 15 Nitin Jadhav (nitinjadhav) Justin Pryzby (justinpryzby), Bharath Rupireddy (bharathrupireddy) rhaas 2 2021-11-06
15:48
2023-02-10
23:25
Add system view tracking shared buffer actions Moved to next CF 16 Melanie Plageman (melanieplageman) Justin Pryzby (justinpryzby) andresfreund 9 2023-02-12
17:27
2023-04-05
00:41
Trap SIGCHLD in pg_basebackup to exit early on stream child failure Moved to next CF Daniel Gustafsson (d_gustafsson) Magnus Hagander (mha), Bharath Rupireddy (bharathrupireddy) d_gustafsson 4 2022-02-23
19:58
2022-02-23
19:58
Performance
Protect syscache from bloating with negative cache entries Returned with feedback Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha) 23 2021-10-05
16:21
2021-03-24
05:26
GROUP BY optimization Moved to next CF 15 Fedor Sigaev (sigaev), Pavel Borisov (pborisov) Tomas Vondra (fuzzycz) fuzzycz 12 2022-03-30
23:19
2024-01-26
15:41
Remove self join on a unique column Moved to next CF Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) Alena Rybakina (a.rybakina) smagen 27 2023-10-25
10:02
2024-10-28
21:18
Using multicolumn statistics for more precise join selectivity estimatation Returned with feedback Konstantin Knizhnik (knizhnik) Yugo Nagata (yugo.nagata) 9 2021-10-01
07:13
2021-11-04
09:56
Erase the distinctClause if the result is unique by definition Moved to next CF Andy Fan (andyf) David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Hou Zhijie (houzj) 11 2022-04-05
03:43
2022-03-31
20:33
INSERT SELECT: BulkInsertState and table_multi_insert Moved to next CF 15 Justin Pryzby (justinpryzby) 8 2021-11-24
00:32
2021-11-04
12:24
Fast COPY FROM command for the foreign tables Moved to next CF Andrei Lepikhov (lepikhov) Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) efujita 13 2022-10-31
08:40
2022-10-31
08:50
More scalable multixacts buffers and locking Moved to next CF Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) alvherre 20 2024-04-07
12:52
2024-04-07
19:13
Optimizing NULL check on pkey column Returned with feedback Surafel Temesgen (surafel) Ashutosh Bapat (ashutoshbapat) 6 2021-09-27
00:52
2021-09-27
00:52
fix spinlock contention in LogwrtResult Moved to next CF Álvaro Herrera (alvherre) 11 2022-09-23
08:50
2024-04-08
16:13
parallel distinct union and aggregate support patch Moved to next CF bucoo hsiao (bucoo) 6 2021-11-08
22:19
2021-11-08
22:19
Replace polyphase merge with a simple k-way balanced merge Moved to next CF Heikki Linnakangas (heikki) John Naylor (john.naylor) heikki 6 2021-10-18
12:15
2021-10-18
12:15
Make Append Cost aware of some run time partition prune case Moved to next CF Andy Fan (andyf) 5 2021-11-04
10:10
2021-11-04
10:10
Consider parallel for LATERAL subqueries having LIMIT/OFFSET Moved to next CF James Coleman (jcole1989) Greg Nancarrow (gregn1234) 11 2023-03-23
18:43
2023-03-23
18:42
Faster pglz compression Moved to next CF Andrey Borodin (x4m), Владимир Лесков (tinsane) Mark Dilger (mark.dilger) fuzzycz 12 2023-02-28
18:55
2023-02-14
00:09
Parallel Hash Full Join Moved to next CF 16 Melanie Plageman (melanieplageman) Thomas Munro (macdice) macdice 12 2023-03-30
23:01
2023-04-09
23:33
WIP: Track relation size in shared memory Returned with feedback Thomas Munro (macdice) 3 2021-10-01
07:21
2021-07-14
12:38
increase size of pg_commit_ts buffers Moved to next CF Álvaro Herrera (alvherre) Noah Misch (nmisch) alvherre 4 2021-11-30
20:20
2021-12-01
15:57
Full support for index LP_DEAD hint bits on standby Moved to next CF Michail Nikolaev (nkey) Antonin Houska (a.houska) 6 2022-04-07
22:00
2022-03-31
23:58
Simplify some RI checks to reduce SPI overhead Moved to next CF Amit Langote (amitlan) Tom Lane (tgl), Corey Huinker (coreyh) alvherre 6 2022-04-09
16:59
2022-04-07
01:05
Adaptive query optimization: create extented statistics using auto_explain extension Moved to next CF Konstantin Knizhnik (knizhnik) 4 2021-11-04
09:56
2021-11-04
09:56
Improve join selectivity estimation using extended statistics Returned with feedback Konstantin Knizhnik (knizhnik) 3 2021-10-01
10:14
2021-10-01
10:13
partial heap only tuples Moved to next CF 15 Nathan Bossart (bossartn) 4 2021-11-04
10:23
2021-11-10
17:17
Allow setting parallel_workers on partitioned tables Returned with feedback Seamus Abshere (seamusabshere) Amit Langote (amitlan), Laurenz Albe (laurenz), Hou Zhijie (houzj) 3 2021-09-04
06:14
2021-09-04
06:14
speed up pg_rewind by using copy_file_range() and skipping some fsync Returned with feedback Paul Guo (paulguo-vmware) Michael Paquier (michael-kun) 3 2021-10-01
06:55
2021-08-20
05:23
Speed up verifying UTF-8 Moved to next CF John Naylor (john.naylor) Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan) john.naylor 5 2021-12-20
14:26
2021-12-20
14:24
Speeding up GIST index builds using popcount Returned with feedback Amit Khandekar (amitdkhan) John Naylor (john.naylor) 3 2021-10-01
07:19
2021-08-02
10:26
Make relfile tombstone files conditional on WAL level Moved to next CF Thomas Munro (macdice) 3 2021-10-29
03:56
2023-01-06
06:13
More sort-related specialisation Moved to next CF Thomas Munro (macdice) John Naylor (john.naylor) john.naylor 5 2022-04-04
02:14
2022-04-06
10:31
Built-in connection pooler Returned with feedback Konstantin Knizhnik (knizhnik) Antonin Houska (a.houska) 2 2021-10-01
06:51
2021-04-28
10:14
add explicit partial union-all and improve parallel subquery costing Moved to next CF Luc Vlaming (luc.vlaming) Ronan Dunklau (rdunklau) 3 2021-12-02
14:10
2021-12-02
14:10
Lazy JIT IR code generation to increase JIT speed with partitions Moved to next CF David Geier (geidav), Luc Vlaming (luc.vlaming) Dmitry Dolgov (erthalion) 9 2023-01-27
09:03
2023-01-30
09:13
Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation Moved to next CF 15 Matthias van de Meent (mmeent) 4 2022-02-07
02:41
2021-12-02
10:21
Use simplehash.h instead of dynahash in SMgr Moved to next CF David Rowley (davidrowley) Yura Sokolov (funny_falcon) 3 2021-12-03
06:55
2021-12-03
06:55
Toast compression method options Moved to next CF Dilip Kumar (dilip.kumar) 3 2021-10-01
09:12
2021-10-01
09:11
Reducing memory consumption for pending inval messages Committed Tom Lane (tgl) Nathan Bossart (bossartn) tgl 2 2021-08-16
20:49
2021-08-16
20:18
Parallel INSERT SELECT take 2 Moved to next CF Greg Nancarrow (gregn1234), Hou Zhijie (houzj) 6 2022-07-28
15:51
2022-07-28
15:51
pre-allocating WAL files Moved to next CF 16 Nathan Bossart (bossartn) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) 6 2022-07-25
16:24
2022-07-25
16:24
Add proper planner support for ORDER BY / DISTINCT aggregates Moved to next CF David Rowley (davidrowley) Ronan Dunklau (rdunklau), Richard Guo (richardguo) davidrowley 7 2022-08-02
12:47
2022-08-17
23:38
Map WAL segment files on PMEM as WAL buffers Moved to next CF Takashi Menjo (tmenjo) 6 2022-08-01
20:40
2022-03-23
08:58
Using indexUnchanged with nbtree Returned with feedback 15 Simon Riggs (simon) 2 2021-10-01
14:21
2021-10-01
14:21
Write visibility map during CLUSTER/VACUUM FULL Moved to next CF Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva) Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) 6 2022-06-30
18:24
2022-06-30
18:25
Don't block HOT update by BRIN index Moved to next CF Josef Šimánek (retro) Tomas Vondra (fuzzycz) fuzzycz 3 2021-11-30
19:14
2021-12-01
10:31
Speed up LockReleaseAll Moved to next CF David Rowley (davidrowley) 3 2021-12-03
07:36
2024-01-09
06:24
Fix ExecRTCheckPerms() inefficiency with many prunable partitions Moved to next CF 16 Amit Langote (amitlan) Álvaro Herrera (alvherre), Tom Lane (tgl) alvherre 8 2022-12-06
19:34
2023-06-30
06:54
Window function run conditions Moved to next CF David Rowley (davidrowley) davidrowley 5 2022-04-07
23:16
2022-04-07
22:40
Using each rel as both outer and inner for anti-joins Moved to next CF Richard Guo (richardguo) Ronan Dunklau (rdunklau) tgl 9 2023-04-05
20:59
2023-04-07
07:28
Use optimized single-datum tuplesort in ExecSort Committed 15 Ronan Dunklau (rdunklau) James Coleman (jcole1989), Ranier Vilela (raniervilela) davidrowley 1 2021-07-22
04:38
2021-07-22
02:04
Postgres picks suboptimal index after building extended statistics Moved to next CF 14 Andrei Lepikhov (lepikhov) 7 2022-11-24
04:38
2022-11-22
17:14
Parallelize correlated subqueries that execute within each worker Moved to next CF James Coleman (jcole1989) Akshat Jaimini (akshatj) 15 2024-10-07
07:22
2024-07-20
23:06
Remove repeated PQfnumber() in pg_dump Committed Hou Zhijie (houzj) Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn) d_gustafsson 1 2021-08-27
14:27
2021-08-27
16:35
Cache tuple routing info during bulk loads into partitioned tables Moved to next CF David Rowley (davidrowley), Amit Langote (amitlan), Hou Zhijie (houzj) Álvaro Herrera (alvherre), David Rowley (davidrowley) davidrowley 6 2022-08-01
22:00
2022-08-02
07:19
KnownAssignedXidsGetAndSetXmin performance Moved to next CF Michail Nikolaev (nkey) Kirill Reshke (reshke), Andrey Borodin (x4mmm) 6 2022-11-15
17:19
2022-11-30
06:53
Skip useless paren-captures in regexps Committed Tom Lane (tgl) Mark Dilger (hornschnorter) tgl 1 2021-09-01
17:05
2021-08-24
18:29
Native spinlock support on RISC-V Committed Marek Szuba (mkszuba) tgl 1 2021-08-16
18:15
2021-09-01
09:21
Push down time-related SQLValue functions to foreign server Moved to next CF 15 Alexander Pyhalov (a.pyhalov) 5 2022-08-02
20:59
2022-01-21
19:57
mitigate O(n^2) behavior of WAL archiver process Moved to next CF 15 Nathan Bossart (bossartn), Dipesh Pandit (dpandit) Nathan Bossart (bossartn) rhaas 2 2021-11-11
21:05
2021-11-11
21:12
Optimize parallel tuple queue Moved to next CF Dilip Kumar (dilip.kumar) rhaas 2 2021-10-26
09:02
2021-10-26
09:03
Asynchronous and "direct" IO support for PostgreSQL Moved to next CF Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice) 6 2022-10-12
05:45
2022-10-12
05:45
Procedural Languages
declarative session variables, LET command Moved to next CF 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) 33 2024-10-07
16:04
2024-11-21
04:07
UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR Returned with feedback John Dent (denty) Daniel Vérité (danielverite) 9 2021-10-01
10:20
2021-10-01
10:20
enhancing plpgsql API for debugging and tracing Moved to next CF Pavel Stehule (okbobcz) Aleksander Alekseev (aalekseev) tgl 9 2022-03-31
21:06
2022-04-01
04:51
possibility to rename root namespace in plpgsql Moved to next CF Pavel Stehule (okbobcz) Julien Rouhaud (rjuju) 7 2022-03-07
05:49
2022-03-07
05:48
proposal of adding 2 new diag items related to parsing the dynamic sql statement Moved to next CF Dinesh Chemuduru (dineshc) Pavel Stehule (okbobcz) 2 2021-12-03
07:39
2022-08-02
22:55
Refactoring
Remove page-read callback from XLogReaderState Moved to next CF Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Antonin Houska (a.houska), Takashi Menjo (tmenjo) macdice 13 2021-10-04
06:18
2021-10-07
08:28
Split StdRdOptions into HeapOptions and ToastOptions Moved to next CF Nikolay Shaplov (nataraj) 10 2021-10-04
07:11
2021-07-22
08:30
ResourceOwner refactoring Returned with feedback Heikki Linnakangas (heikki) Aleksander Alekseev (a.alekseev) 4 2021-10-01
07:18
2023-11-17
20:52
PoC Refactor AM analyse API Returned with feedback Denis Smirnov (darthunix) Heikki Linnakangas (heikki) 4 2021-10-01
06:57
2021-10-01
18:24
Infrastructure changes to make the code less sensitive to transaction id bit width Returned with feedback James Finnerty (jimfinnerty) 3 2021-10-01
06:53
2021-10-01
06:53
Rework the sslfiles Makefile target Moved to next CF Jacob Champion (jchampion) Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson) d_gustafsson 3 2021-10-19
18:22
2021-10-19
18:25
Extend portability of client_connection_check_interval Moved to next CF Thomas Munro (macdice) Maksim Milyutin (maksm90) macdice 5 2022-02-14
04:16
2022-02-14
04:15
psql - refactor echo code Moved to next CF Fabien Coelho (calvin) Pavel Stehule (okbobcz), Peter Eisentraut (petere) 10 2023-04-03
20:03
2023-04-03
20:03
A micro-optimisation for ProcSendSignal() Moved to next CF Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) macdice 4 2021-12-16
03:02
2021-12-16
03:00
procarray.c: two refactorings Committed Ranier Vilela (raniervilela) Aleksander Alekseev (aalekseev) masaofujii 2 2021-09-16
04:14
2021-09-16
11:03
Split xlog.c Moved to next CF Heikki Linnakangas (heikki) 3 2021-11-15
10:11
2021-11-24
19:44
automatically generating node support functions Moved to next CF Peter Eisentraut (petere) Tom Lane (tgl) petere 6 2022-07-09
14:37
2022-08-09
13:16
improvements in Unicode tables generation code Moved to next CF Peter Eisentraut (petere) petere 3 2021-10-04
18:32
2021-10-04
18:36
Extensible storage manager API - smgr hooks Moved to next CF Anastasia Lubennikova (lubennikovaav) 5 2022-03-22
00:20
2022-03-22
00:20
Remove redundant initializations Returned with feedback Peter Eisentraut (petere) Noah Misch (nmisch) 2 2021-10-01
07:17
2021-10-01
07:17
Use lfoo_node(...) instead of castNode(..., lfoo(...)) Committed Dagfinn Ilmari Mannsåker (ilmari) petere 1 2021-07-19
06:30
2021-07-19
09:33
Use WaitLatch for {pre, post}_auth_delay instead of pg_usleep Rejected Bharath Rupireddy (bharathrupireddy) Nathan Bossart (bossartn) 1 2021-07-29
00:52
2021-07-29
23:27
use regular expressions to simplify less_greater and not_equals Rejected Fan Xiaojian (funnyxj.qq.com), Shihao Sun (sunshihao.ssh.alibaba-inc.com) Tom Lane (tgl) 1 2021-09-05
20:11
2021-09-05
20:11
Remove obsolete macro CHECKFLOATVAL in contrib/btree_gist Committed Haiying Tang (tanghy) michael-kun 1 2021-08-19
05:05
2021-08-19
05:10
Separate out FileSet from SharedFileSet Committed Dilip Kumar (dilip.kumar) Masahiko Sawada (masahikosawada) amitkapila 1 2021-09-11
07:05
2021-09-02
05:36
Remove Value node struct Committed Peter Eisentraut (petere) petere 1 2021-09-09
10:16
2021-09-09
07:23
Some RELKIND macro refactoring Moved to next CF Peter Eisentraut (petere) Michael Paquier (michael-kun) petere 3 2021-12-03
13:13
2021-12-03
13:12
improve pg_receivewal code Committed Bharath Rupireddy (bharathrupireddy) Ronan Dunklau (rdunklau) michael-kun 1 2021-09-18
01:52
2021-09-18
01:52
pg_receivewal: remove extra conn = NULL; in StreamLog Committed Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson) d_gustafsson 1 2021-09-02
11:12
2021-09-02
11:19
Replication & Recovery
Make async slave to wait for lsn to be replayed Returned with feedback Ivan Kartyshov (fenimorkin) Thomas Munro (macdice), Dmitry Ivanov (funbringer), Anna Akenteva (a.akenteva), Alexandra Pervushina (a.pervushina) 14 2021-10-01
06:56
2021-03-22
05:05
Make message at end-of-recovery less scary Moved to next CF Kyotaro Horiguchi (horiguti) Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) 20 2024-01-31
01:57
2024-01-23
04:13
Background writer and checkpointer in crash recovery Committed Thomas Munro (macdice) Aleksander Alekseev (aalekseev) macdice 6 2021-08-03
02:22
2021-08-03
02:19
Row filtering for logical replication Moved to next CF 15 Euler Taveira (eulerto), Peter Smith (smithpb), Ajin Cherian (ajinc), Hou Zhijie (houzj) Dilip Kumar (dilip.kumar), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Hou Zhijie (houzj), Rahila Syed (rahila) amitkapila 7 2022-02-27
18:02
2022-03-07
02:31
wal_sessioninfo Returned with feedback Simon Riggs (simon) Cleysson Lima (cleyssonlima) 4 2021-10-01
16:28
2021-07-31
12:30
logical decoding of two-phase transactions Committed 15 Stas Kelvich (kelvich), Nikhil Sontakke (nikkhils), Ajin Cherian (ajinc), Peter Smith (smithpb2250) Amit Kapila (amitkapila), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) amitkapila 4 2021-08-09
02:57
2021-08-09
03:00
Reduce the time required for a database recovery from archive. Returned with feedback Anna Akenteva (a.akenteva), Dmitry Shulga (d.shulga), Ivan Taranov (i.taranov) 3 2021-10-01
06:58
2021-03-19
12:50
Identify missing publications from publisher while create/alter subscription. Moved to next CF vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Euler Taveira (eulerto), Ashutosh Sharma (ashu_coek), Japin Li (japin), Bharath Rupireddy (bharathrupireddy) amitkapila 6 2022-04-01
14:59
2022-03-31
09:45
Minimal logical decoding on standbys (take 6) Moved to next CF Amit Khandekar (amitdkhan) Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) 5 2022-02-07
02:49
2023-04-08
17:12
Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation Moved to next CF Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson), vigneshwaran C (vignesh.postgres) d_gustafsson 3 2021-11-17
13:43
2021-11-17
13:43
tablesync early exit Moved to next CF 15 Peter Smith (smithpb2250) 6 2022-04-05
04:09
2022-04-05
05:55
A test for replay of regression tests Moved to next CF Thomas Munro (macdice) Anastasia Lubennikova (lubennikovaav) macdice 4 2022-01-19
22:47
2022-02-02
03:14
avoid logical replication empty transactions Moved to next CF 15 Euler Taveira (eulerto), Ajin Cherian (ajinc) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb), Greg Nancarrow (gregn1234) amitkapila 5 2022-03-31
19:19
2022-03-30
08:30
Diagnostic comment in LogicalIncreaseXminForSlot Committed Ashutosh Bapat (ashutoshbapat) Masahiko Sawada (masahikosawada) amitkapila 2 2021-10-01
02:24
2021-10-01
02:25
Replicates changes for all tables in schema Moved to next CF 15 vigneshwaran C (vignesh.postgres) Greg Nancarrow (gregn1234), Haiying Tang (tanghy), Mark Dilger (mark.dilger), Hou Zhijie (houzj), Rahila Syed (rahila) amitkapila 3 2021-11-16
04:40
2021-11-16
04:44
Detectable crashes and unlogged table resets Moved to next CF Jeff Davis (jdavis) 5 2022-03-07
01:41
2022-03-05
10:33
Skipping logical replication transactions on subscriber side Moved to next CF Masahiko Sawada (masahikosawada) vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Mark Dilger (mark.dilger), Hou Zhijie (houzj) amitkapila 5 2022-03-29
05:10
2022-04-07
11:39
Allow providing restore_command as a command line option to pg_rewind Moved to next CF Alexey Kondratov (ololobus) Andrey Borodin (x4m) 5 2022-04-07
05:52
2022-04-07
05:53
PITR enhance getRecordTimestamp() Moved to next CF Simon Riggs (simon) 8 2022-09-16
12:37
2022-01-31
19:11
Column filtering in logical replication Moved to next CF 15 Álvaro Herrera (alvherre), Rahila Syed (rahila.syed), Tomas Vondra (fuzzycz) Álvaro Herrera (alvherre), Peter Eisentraut (petere), vigneshwaran C (vignesh.postgres) fuzzycz 5 2022-03-26
18:21
2022-03-30
12:01
Teach pg_receivewal to use lz4 compression Moved to next CF 15 Georgios Kokolatos (gkokolatos) Michael Paquier (michael-kun) michael-kun 3 2021-11-05
04:39
2021-11-24
11:54
parse_subscription_options - some suggested improvements Moved to next CF 15 Peter Smith (smithpb2250) Nathan Bossart (bossartn) michael-kun 3 2021-12-08
17:34
2021-12-08
04:09
schema change not getting invalidated, both renamed table and new table data were getting replicated Moved to next CF vigneshwaran C (vignesh.postgres) Tom Lane (tgl) tgl 8 2023-01-06
16:12
2023-01-06
16:21
New READ_REPLICATION_SLOT command & usage in pg_receivewal Returned with feedback Ronan Dunklau (rdunklau) Michael Paquier (michael-kun), Bharath Rupireddy (bharathrupireddy) 1 2021-10-01
07:03
2021-10-01
07:05
Invalidations were missing in case of for all tables publication Committed amitkapila 1 2021-09-13
02:14
2021-09-13
02:15
Security
public schema default ACL Committed Noah Misch (nmisch) Peter Eisentraut (petere) nmisch 3 2021-09-10
07:03
2021-09-08
09:45
Convert contrib SQL functions to new style Returned with feedback Tom Lane (tgl) 2 2021-09-01
17:28
2024-11-14
04:30
Improve sepgsql logging so it follows the behaviour of selinux's logging. Moved to next CF Dave Page (dpage) Jacob Champion (jchampion) tgl 4 2022-01-12
19:24
2022-01-12
19:24
Support for NSS as a libpq TLS backend Moved to next CF Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) Joshua Brindle (joshuab) 5 2022-02-23
10:32
2022-02-04
20:18
Delegating superuser tasks to new security roles Moved to next CF 15 Mark Dilger (mark.dilger) Andrew Dunstan (adunstan), Nathan Bossart (bossartn) 3 2021-11-15
20:47
2021-11-01
22:42
Kerberos delegation support in libpq and postgres_fdw Moved to next CF Peifeng Qiu (pqiu) 2 2021-11-26
13:42
2023-04-08
02:00
Server Features
Transactions involving multiple postgres foreign servers Returned with feedback Masahiko Sawada (masahikosawada), Ashutosh Bapat (ashutoshbapat) Takayuki Tsunakawa (maumau), Ashutosh Bapat (ashutoshbapat), Chris Travers (einhverfr), Muhammad Usama (muhammad_usama), Masahiro Ikeda (masahiro.ikeda) 18 2021-10-04
01:00
2021-10-06
03:03
Index Skip Scan Moved to next CF 16 Dmitry Dolgov (erthalion), Thomas Munro (macdice), Jesper Pedersen (jpedersen) Peter Geoghegan (pgeoghegan), Dilip Kumar (dilip.kumar), Thomas Munro (macdice), Chris Travers (einhverfr), James Coleman (jcole1989), Cristiano Duarte (cunha17), Andy Fan (andyf), Yuming Wang (yumwang), Jet Zhang (thinkj), Alexandre Felipe (bob.tpro) 19 2022-03-24
11:32
2022-03-29
03:19
A hook for path-removal decision on add_path Returned with feedback KaiGai Kohei (kaigai) 11 2022-03-24
13:27
2022-10-02
16:59
Fix partitionwise join with partially-redundant join clauses Moved to next CF Richard Guo (richardguo) Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) richardguo 16 2024-07-30
07:25
2024-07-30
07:36
Global temporary table Moved to next CF 16 Wenjing Zeng (wenjing.zwj) Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) 13 2022-06-30
20:54
2022-06-30
20:54
GUC to disable cancellation of awaiting for synchronous replication Returned with feedback Andrey Borodin (x4m) Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev) 9 2021-10-06
13:13
2021-04-23
10:19
jsonpath syntax extensions Moved to next CF 15 Nikita Glukhov (n.glukhov) 12 2023-02-13
18:18
2022-03-31
19:21
ALTER SYSTEM READ { ONLY | WRITE } Moved to next CF Amul Sul (sulamul) 9 2022-01-10
04:22
2021-12-01
04:59
Extended statistics / estimate Var op Var clauses Moved to next CF Tomas Vondra (fuzzycz) Dean Rasheed (deanr), Mark Dilger (mark.dilger) 9 2022-10-12
08:03
2022-10-12
08:04
Xact event callback at command start Rejected Gilles Darold (darold) Julien Rouhaud (rjuju) 4 2021-09-01
14:23
2021-09-04
11:00
New Table Access Methods for Multi and Single Inserts Moved to next CF Bharath Rupireddy (bharathrupireddy) 9 2022-10-12
05:31
2024-10-31
04:17
On client login event trigger Moved to next CF 17 Konstantin Knizhnik (knizhnik), Greg Nancarrow (gregn1234), Mikhail Gribkov (youzhick) Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234) smagen 15 2023-10-18
10:31
2023-10-29
22:21
SQL/JSON: functions Moved to next CF 15 Nikita Glukhov (n.glukhov) adunstan 7 2022-04-08
03:47
2022-04-08
12:15
SQL/JSON: JSON_TABLE Moved to next CF 15 Nikita Glukhov (n.glukhov) adunstan 7 2022-04-08
03:48
2022-04-06
18:05
Allow batched insert during cross-partition updates Moved to next CF Amit Langote (amitlan) Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Hou Zhijie (houzj) efujita 10 2022-12-20
10:23
2022-12-20
11:19
Hooks and API to allow loadable wire protocol extensions Returned with feedback Jan Wieck (wieck) 3 2021-10-01
06:56
2021-03-05
01:38
Add regexp_positions(string text, pattern text, flags text) → setof record (starts integer[], lengths integer[]) Moved to next CF Joel Jacobson (joeljacobson) Tom Lane (tgl) 3 2021-12-03
08:46
2021-09-21
17:55
PROXY protocol support Moved to next CF Magnus Hagander (mha) Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) 7 2022-10-12
05:27
2022-07-28
20:05
Add common functions regexp_like, regexp_count, regexp_instr, regexp_substr and regexp_replace Committed Gilles Darold (darold) Tom Lane (tgl) tgl 2 2021-08-03
17:09
2021-08-03
17:10
Extended statistics in EXPLAIN Moved to next CF Tomas Vondra (fuzzycz) Tatsuro Yamada (tatsuro_yamada) 6 2022-08-01
20:38
2022-01-18
11:31
Merging statistics from children instead of re-sampling everything Moved to next CF Tomas Vondra (fuzzycz) 5 2022-04-08
13:24
2022-02-18
11:50
Add missing function abs (interval) Moved to next CF Isaac Morland (ijmorlan) Tom Lane (tgl) 3 2021-12-03
07:41
2021-12-03
07:41
estimating joins using extended statistics Moved to next CF Tomas Vondra (fuzzycz) Andy Fan (andyf) 4 2022-02-07
03:20
2022-01-19
10:18
Remove 64K hard limit on rangetable size Committed Tom Lane (tgl) Aleksander Alekseev (a.alekseev) tgl 2 2021-09-15
18:12
2021-09-15
08:01
Add callback table access method to reset filenode when dropping relation Moved to next CF Mats Kindahl (matski) Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) 7 2022-10-12
07:38
2022-10-12
07:39
Addition of authenticated ID to pg_stat_activity Returned with feedback 15 Michael Paquier (michael-kun) Aleksander Alekseev (aalekseev) 2 2021-10-01
01:08
2021-10-01
01:08
Asymmetric partition-wise JOIN Moved to next CF 15 KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) Alexander Pyhalov (a.pyhalov) 7 2022-10-12
05:27
2022-01-17
10:42
Extensible parsing Moved to next CF 15 Julien Rouhaud (rjuju) 4 2022-01-17
00:33
2022-01-17
00:33
postgres_fdw: Handle boolean comparison predicates Returned with feedback Emre Hasegeli (hasegeli) Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat), Cary Huang (cary) 2 2021-10-01
07:10
2021-10-01
07:10
logical decoding and replication of sequences Moved to next CF Tomas Vondra (fuzzycz) Peter Eisentraut (petere) fuzzycz 5 2022-03-24
22:07
2022-08-29
21:42
Range Merge Join Moved to next CF 15 Thomas Mannhart (thomasmannhart97) 4 2022-02-07
03:12
2022-01-17
07:39
unnesting multirange data types Returned with feedback 14 Alexander Korotkov (smagen) Justin Pryzby (justinpryzby), Jonathan Katz (jkatz05) smagen 2 2021-10-01
07:13
2021-09-08
20:30
pg_stats and range statistics Moved to next CF 17 Egor Rogov (egorius) Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) smagen 13 2023-11-27
00:54
2023-11-25
16:57
Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands Returned with feedback Yuzuko Hosoya (yuzu) 2 2021-10-01
06:49
2021-10-01
06:50
PoC: improving join estimates using sampling Moved to next CF Tomas Vondra (fuzzycz) 5 2022-03-22
00:25
2022-03-22
00:17
Cleaning up orphaned files using undo logs Moved to next CF Antonin Houska (a.houska) Dmitry Dolgov (erthalion) 4 2022-02-07
03:08
2022-01-12
08:27
Automatic notification of top transaction IDs Moved to next CF Gurjeet Singh (gurjeet) Cary Huang (cary) 3 2021-11-04
13:05
2021-11-04
15:01
Gather partial paths for subproblem's topmost scan/join rel Moved to next CF Richard Guo (richardguo) Antonin Houska (a.houska) tgl 5 2022-07-30
17:05
2022-07-30
17:15
Tags in errordata Moved to next CF 15 Ronan Dunklau (rdunklau) Greg Stark (stark), Justin Pryzby (justinpryzby) 4 2022-04-07
06:44
2022-04-07
06:44
Preserving db/ts/relfilenode OIDs across pg_upgrade Moved to next CF Antonin Houska (a.houska), Shruthi Gowda (shruthi) Robert Haas (rhaas), Rushabh Lathia (rlathia) rhaas 4 2022-03-22
15:38
2022-06-16
23:24
Support pg_ident mapping for LDAP Moved to next CF Jacob Champion (jchampion) Magnus Hagander (mha) 5 2022-08-17
17:16
2022-02-17
19:15
SQL Commands
SQL:2011 application time Moved to next CF Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) Peter Eisentraut (petere) 12 2022-02-07
03:18
2024-11-15
06:38
Incremental Materialized View Maintenance Moved to next CF 16 Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) 17 2022-10-12
07:49
2022-10-12
07:53
FETCH FIRST clause PERCENT option Returned with feedback Surafel Temesgen (surafel) 12 2021-10-03
16:16
2021-09-30
18:31
Implement INSERT SET syntax Moved to next CF Gareth Palmer (gareth) Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj) 15 2022-08-01
20:18
2022-07-14
10:45
WITH SYSTEM VERSIONING Temporal Tables Moved to next CF Surafel Temesgen (surafel) Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre) 11 2021-11-16
12:31
2021-11-16
12:31
Automatic HASH and LIST partition creation Moved to next CF Anastasia Lubennikova (lubennikovaav) Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) 7 2021-12-02
11:20
2021-12-02
11:20
Allow COPY "text" to output a header and add header matching mode to COPY FROM Moved to next CF Rémi Lapeyre (remilapeyre) Peter Eisentraut (petere) petere 8 2022-03-30
07:11
2022-03-30
07:11
CLUSTER on partitioned table Moved to next CF 15 Justin Pryzby (justinpryzby) Matthias van de Meent (mmeent) alvherre 8 2022-04-02
17:11
2022-04-04
12:59
CREATE INDEX CONCURRENTLY on partitioned table Moved to next CF Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) 15 2023-09-18
14:48
2024-10-25
18:32
create table like: ACCESS METHOD Returned with feedback 15 Justin Pryzby (justinpryzby) Simon Riggs (simon) 4 2021-10-01
08:00
2021-10-01
08:01
Dynamic result sets from procedures Moved to next CF Peter Eisentraut (petere) 12 2023-10-30
09:26
2023-02-24
11:26
MERGE SQL command Returned with feedback 15 Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) 4 2021-09-01
12:58
2022-03-28
15:06
Partial foreign key updates in referential integrity triggers Moved to next CF 15 Paul Martinez (pauljulius) Peter Eisentraut (petere) petere 5 2021-12-08
10:29
2021-12-08
10:29
NOT VALID for Unique Indexes Returned with feedback Simon Riggs (simon) 3 2021-10-01
07:21
2021-09-01
11:02
Foreign Key Arrays Returned with feedback Mark Rofail (markmoheb) Joel Jacobson (joeljacobson), Justin Pryzby (justinpryzby) 3 2021-09-14
18:59
2021-10-05
19:15
Release SPI plans for referential integrity with DISCARD Returned with feedback Yuzuko Hosoya (yuzu) 2 2021-10-01
07:15
2021-09-26
19:05
rename column if exists Moved to next CF David Oksman (oks) Yagiz Nizipli (yagiznizipli) 4 2022-01-17
00:30
2022-01-17
00:29
Allow queries in WHEN expression of FOR EACH STATEMENT triggers Withdrawn Joe Wildish (joewildish) 2 2021-10-03
22:18
2021-09-23
20:02
DELETE CASCADE Moved to next CF 15 David Christensen (davidchristensen) 4 2023-03-06
15:40
2022-01-31
16:30
Non-decimal integer literals Moved to next CF Peter Eisentraut (petere) John Naylor (john.naylor) petere 6 2022-12-14
06:13
2023-01-23
21:20
UNIQUE null treatment option Moved to next CF Peter Eisentraut (petere) Vik Fearing (xocolatl), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) petere 4 2022-02-03
10:54
2022-02-03
10:54
System Administration
Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) Moved to next CF Justin Pryzby (justinpryzby) Fabien Coelho (calvin) 21 2024-01-22
01:15
2024-01-22
01:16
Fix pg_rewind race condition just after promotion Moved to next CF Heikki Linnakangas (heikki) Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) heikki 12 2023-02-23
13:43
2023-02-23
13:43
Mitigate pg_rewind race condition, if config file is enlarged concurrently. Moved to next CF Heikki Linnakangas (heikki) Daniel Gustafsson (d_gustafsson), Cary Huang (cary) d_gustafsson 7 2022-04-05
13:03
2022-04-05
08:11
New default role allowing to change per-role settings Moved to next CF Michael Banck (mbanck) Stephen Frost (sfrost), Shinya Kato (kato-shinya) 8 2022-08-01
20:31
2022-01-29
11:10
Catalog version access Moved to next CF Vik Fearing (xocolatl), Nathan Bossart (bossartn) Nathan Bossart (bossartn) 5 2022-01-31
07:57
2022-01-31
18:10
Add --create-only option to pg_dump/pg_dumpall Returned with feedback Michael Banck (mbanck) Cary Huang (cary), Nitin Jadhav (nitinjadhav11) 3 2021-09-13
13:26
2021-09-13
13:26
Reduce lock level for ALTER TABLE ... ADD CHECK Moved to next CF 15 Simon Riggs (simon) Greg Sabino Mullane (greg) 3 2021-11-21
21:05
2021-10-03
16:51
add pg_ctl option that returns amount of shmem required Committed Nathan Bossart (bossartn) Michael Paquier (michael-kun) michael-kun 2 2021-09-21
02:11
2022-05-11
15:57
Slightly improve initdb --sync-only option's help message Committed Gurjeet Singh (gurjeet) Daniel Gustafsson (d_gustafsson), Nathan Bossart (bossartn) d_gustafsson 1 2021-08-23
11:10
2021-08-16
16:06
Warn if initdb's --sync-only option is mixed with other options Returned with feedback Gurjeet Singh (gurjeet) Daniel Gustafsson (d_gustafsson) 1 2021-10-01
11:22
2021-10-01
11:22
add guc: hugepages_active Moved to next CF Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda) Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) michael-kun 7 2023-07-06
06:05
2023-07-06
06:20
Add JSON logging via jsonlog log_destination Moved to next CF 15 Michael Paquier (michael-kun), Sehrope Sarkuni (sehrope) michael-kun 3 2022-01-17
01:22
2022-01-17
02:12