pgsql-hackers since 2022-12-26 00:00

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Dec. 26, 2022

Thread Author Time
Re: [BUG] pg_upgrade test fails from older versions. Michael Paquier 02:52
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 04:22
Re: [BUG] pg_upgrade test fails from older versions. 📎 Anton A. Melnikov 06:22
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL 📎 Michael Paquier 07:28
Re: Avoid lost result of recursion (src/backend/optimizer/util/inherit.c) Amit Langote 08:01
Re: Force streaming every change in logical decoding Amit Kapila 08:34
Re: Time delayed LR (WAS Re: logical replication restrictions) Dilip Kumar 08:42
Re: Improve WALRead() to suck data directly from WAL buffers when possible 📎 Bharath Rupireddy 08:50
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 09:14
Re: Apply worker fails if a relation is missing on subscriber even if refresh publication has not been refreshed yet Melih Mutlu 10:11
Re: Apply worker fails if a relation is missing on subscriber even if refresh publication has not been refreshed yet Amit Kapila 10:32
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 10:48
Re: Perform streaming logical transactions by background workers and parallel apply 📎 Amit Kapila 11:51
RE: Exit walsender before confirming remote flush in logical replication Hayato Kuroda (Fujitsu) 12:27
Make use of assign_checkpoint_completion_target() to calculate CheckPointSegments correctly 📎 Bharath Rupireddy 12:42
Make IsInstallXLogFileSegmentActive() an assert-only function 📎 Bharath Rupireddy 12:42
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 13:02
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 13:29
Re: Error-safe user functions Andrew Dunstan 13:59
Re: Perform streaming logical transactions by background workers and parallel apply Dilip Kumar 14:05
Re: Time delayed LR (WAS Re: logical replication restrictions) Dilip Kumar 14:07
Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Michail Nikolaev 14:28
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Michail Nikolaev 15:19
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 17:13
Re: Error-safe user functions 📎 Tom Lane 17:47
Re: ARRNELEMS Out-of-bounds possible errors Nikita Malakhov 18:45
Re: ARRNELEMS Out-of-bounds possible errors Ranier Vilela 18:53
Re: Error-safe user functions Andrew Dunstan 19:12
Passing relation metadata to Exec routine Nikita Malakhov 19:15
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL David Christensen 20:00
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Justin Pryzby 20:39
Re: New strategies for freezing, advancing relfrozenxid early 📎 Peter Geoghegan 20:53
Re: Pluggable toaster 📎 Nikita Malakhov 21:01
Re: Passing relation metadata to Exec routine Tom Lane 21:56
Re: Error-safe user functions 📎 Tom Lane 23:00
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 23:32

Dec. 27, 2022

Thread Author Time
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Michael Paquier 03:31
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 03:45
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 04:02
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 04:54
RE: Perform streaming logical transactions by background workers and parallel apply [email protected] 04:57
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Amit Kapila 04:57
Re: Perform streaming logical transactions by background workers and parallel apply Dilip Kumar 05:06
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 05:16
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 05:24
Re: [BUG] pg_upgrade test fails from older versions. Michael Paquier 05:44
build gcc warning Pavel Stehule 05:55
Re: Perform streaming logical transactions by background workers and parallel apply Masahiko Sawada 05:57
Re: Time delayed LR (WAS Re: logical replication restrictions) Dilip Kumar 06:12
Re: Support logical replication of DDLs 📎 vignesh C 06:13
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 06:39
Re: Perform streaming logical transactions by background workers and parallel apply 📎 Amit Kapila 06:43
Re: Time delayed LR (WAS Re: logical replication restrictions) Amit Kapila 06:44
Re: Allow placeholders in ALTER ROLE w/o superuser Justin Pryzby 06:54
Re: build gcc warning Tom Lane 06:55
RE: New strategies for freezing, advancing relfrozenxid early Hayato Kuroda (Fujitsu) 06:57
Re: Allow placeholders in ALTER ROLE w/o superuser Tom Lane 06:58
RE: Time delayed LR (WAS Re: logical replication restrictions) Hayato Kuroda (Fujitsu) 07:09
Re: An oversight in ExecInitAgg for grouping sets 📎 Richard Guo 07:12
Re: New strategies for freezing, advancing relfrozenxid early Peter Geoghegan 07:30
Re: Exit walsender before confirming remote flush in logical replication Dilip Kumar 07:40
RE: New strategies for freezing, advancing relfrozenxid early Hayato Kuroda (Fujitsu) 07:47
Re: Parallel Aggregates for string_agg and array_agg Pavel Stehule 07:48
RE: Exit walsender before confirming remote flush in logical replication 📎 Hayato Kuroda (Fujitsu) 08:14
Re: Making Vars outer-join aware Richard Guo 08:27
Refactor recordExtObjInitPriv() 📎 Peter Eisentraut 08:56
Underscores in numeric literals 📎 Peter Eisentraut 09:15
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila 09:20
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila 09:25
RE: Time delayed LR (WAS Re: logical replication restrictions) 📎 Hayato Kuroda (Fujitsu) 09:29
Re: [feature]COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns Melih Mutlu 11:02
Re: Perform streaming logical transactions by background workers and parallel apply Amit Kapila 11:37
Add a new pg_walinspect function to extract FPIs from WAL records 📎 Bharath Rupireddy 11:48
Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Bharath Rupireddy 11:52
Re: Support logical replication of DDLs 📎 vignesh C 12:03
Re: Passing relation metadata to Exec routine Nikita Malakhov 12:18
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Michail Nikolaev 12:19
Re: [BUG] pg_upgrade test fails from older versions. Anton A. Melnikov 12:26
Re: Error-safe user functions 📎 Andrew Dunstan 13:31
Re: Error-safe user functions Andrew Dunstan 13:36
Re: [BUG] pg_upgrade test fails from older versions. Michael Paquier 13:50
Re: [BUG] pg_upgrade test fails from older versions. Anton A. Melnikov 13:55
Re: Underscores in numeric literals Tom Lane 14:55
Re: Underscores in numeric literals Justin Pryzby 15:16
Re: Making Vars outer-join aware Tom Lane 15:31
False positive warning in verify_heapam.c with GCC 03 📎 Maxim Orlov 15:35
[PATCH] Support using "all" for the db user in pg_ident.conf 📎 Jelte Fennema 15:54
Re: [PATCH] Support using "all" for the db user in pg_ident.conf Isaac Morland 16:21
Re: Error-safe user functions Tom Lane 17:47
Re: Error-safe user functions Andrew Dunstan 18:05
recovery modules 📎 Nathan Bossart 19:24
Re: Error-safe user functions Tom Lane 19:51
Re: Force streaming every change in logical decoding Andres Freund 20:12
Re: Patch: Global Unique Index David Zhang 21:13
Re: recovery modules Andres Freund 22:11
Re: build gcc warning Andres Freund 22:17
Removing redundant grouping columns 📎 Tom Lane 22:18
Re: Support logical replication of DDLs 📎 Zheng Li 22:32
Re: Make EXPLAIN generate a generic plan for a parameterized query Michel Pelletier 22:37
Re: recovery modules Nathan Bossart 22:37
Re: recovery modules Andres Freund 22:45
Re: recovery modules Nathan Bossart 23:04
Re: build gcc warning Tom Lane 23:10
Re: Removing redundant grouping columns 📎 Tom Lane 23:24

Dec. 28, 2022

Thread Author Time
Re: [PATCH] Support using "all" for the db user in pg_ident.conf Michael Paquier 00:10
Re: recovery modules Michael Paquier 00:26
Re: recovery modules Andres Freund 00:43
Re: Allow placeholders in ALTER ROLE w/o superuser Justin Pryzby 01:06
Re: Force streaming every change in logical decoding Amit Kapila 02:19
RE: Exit walsender before confirming remote flush in logical replication 📎 Hayato Kuroda (Fujitsu) 02:47
RE: Exit walsender before confirming remote flush in logical replication Hayato Kuroda (Fujitsu) 02:49
Re: Exit walsender before confirming remote flush in logical replication Amit Kapila 03:56
Re: POC, WIP: OR-clause support for indexes 📎 Andrey Lepikhov 04:19
Re: Allow placeholders in ALTER ROLE w/o superuser Tom Lane 04:29
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Amit Kapila 04:33
RE: Perform streaming logical transactions by background workers and parallel apply 📎 [email protected] 04:38
CFM for 2023-01 vignesh C 05:22
Re: Error-safe user functions 📎 Amul Sul 06:00
SQL/JSON revisited 📎 Amit Langote 07:28
Re: SQL/JSON revisited Amit Langote 07:31
Re: Making Vars outer-join aware Richard Guo 08:49
Re: [PATCH] Support using "all" for the db user in pg_ident.conf 📎 Jelte Fennema 09:11
RE: Exit walsender before confirming remote flush in logical replication Hayato Kuroda (Fujitsu) 09:15
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov 10:14
Add BufFileRead variants with short read and EOF detection 📎 Peter Eisentraut 10:47
Re: Add SHELL_EXIT_CODE to psql Maxim Orlov 10:58
Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION Michail Nikolaev 11:22
Re: add \dpS to psql Maxim Orlov 11:46
split TOAST support out of postgres.h 📎 Peter Eisentraut 13:07
Re: split TOAST support out of postgres.h Isaac Morland 14:07
Re: Underscores in numeric literals Andrew Dunstan 14:28
Re: Error-safe user functions Andrew Dunstan 15:04
Re: split TOAST support out of postgres.h Tom Lane 15:07
Re: Making Vars outer-join aware Tom Lane 15:36
Re: Allow placeholders in ALTER ROLE w/o superuser Justin Pryzby 17:28
Re: New strategies for freezing, advancing relfrozenxid early 📎 Peter Geoghegan 17:34
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local 📎 Andres Freund 18:24
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Tom Lane 18:43
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) 📎 Tom Lane 20:13
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) 📎 Nathan Bossart 21:12
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 21:20
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Nathan Bossart 21:21
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Nathan Bossart 21:23
Re: add \dpS to psql Nathan Bossart 21:26
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 22:05
Re: Support logical replication of DDLs 📎 Zheng Li 22:42
Re: Support logical replication of DDLs Zheng Li 22:50
Avoiding unnecessary clog lookups while freezing 📎 Peter Geoghegan 23:24
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Andres Freund 23:56

Dec. 29, 2022

Thread Author Time
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Andres Freund 00:02
[PATCH] two minor fixes to MVCC docs 📎 Will Mortensen 00:02
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Tom Lane 00:05
Re: Avoiding unnecessary clog lookups while freezing Andres Freund 00:20
windows/meson cfbot warnings Justin Pryzby 00:35
Re: Avoiding unnecessary clog lookups while freezing Peter Geoghegan 00:37
Re: Avoiding unnecessary clog lookups while freezing Andres Freund 00:43
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Justin Pryzby 01:23
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Justin Pryzby 01:29
Re: windows/meson cfbot warnings Andres Freund 01:44
GSOC2023 📎 diaa 02:10
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 02:17
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Andres Freund 03:03
psql: stop at error immediately during \copy 📎 Peifeng Qiu 03:18
Re: Avoiding unnecessary clog lookups while freezing Peter Geoghegan 06:36
Re: split TOAST support out of postgres.h Nikita Malakhov 07:39
Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler? 📎 Noah Misch 08:40
Re: Perform streaming logical transactions by background workers and parallel apply 📎 Amit Kapila 13:24
Re: [PoC] Implementation of distinct in Window Aggregates Ankit Kumar Pandey 15:28
Re: split TOAST support out of postgres.h Andres Freund 17:15
Re: Avoiding unnecessary clog lookups while freezing Andres Freund 17:21
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 17:22
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Andres Freund 17:23
Re: split TOAST support out of postgres.h Matthias van de Meent 17:23
Re: Avoiding unnecessary clog lookups while freezing Tom Lane 17:25
Re: Avoiding unnecessary clog lookups while freezing Peter Geoghegan 17:43
Re: split TOAST support out of postgres.h Tom Lane 17:47
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Nathan Bossart 18:26
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local 📎 Andres Freund 18:42
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 18:45
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Tom Lane 18:51
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Nathan Bossart 18:52
Re: recovery modules 📎 Nathan Bossart 19:43
Re: Avoiding unnecessary clog lookups while freezing Andres Freund 20:00
Re: Avoiding unnecessary clog lookups while freezing 📎 Peter Geoghegan 20:20
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Tom Lane 20:29
Re: Avoiding unnecessary clog lookups while freezing Peter Geoghegan 20:50
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Thomas Munro 21:31
Re: BUG #17717: Regression in vacuumdb (15 is slower than 10/11 and possible memory issue) Nathan Bossart 21:37
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Tom Lane 21:37
Re: perl 5.36, C99, -Wdeclaration-after-statement -Wshadow=compatible-local Andres Freund 21:40
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Andres Freund 21:54
Re: Avoiding unnecessary clog lookups while freezing 📎 Peter Geoghegan 23:10

Dec. 30, 2022

Thread Author Time
add PROCESS_MAIN to VACUUM 📎 Nathan Bossart 00:00
Re: Missing update of all_hasnulls in BRIN opclasses 📎 Tomas Vondra 00:18
Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier Thomas Munro 01:14
Re: Getting rid of SQLValueFunction 📎 Ian Lawrence Barwick 01:57
Re: Check lateral references within PHVs for memoize cache keys 📎 Richard Guo 03:00
Re: Decoupling antiwraparound autovacuum from special rules around auto cancellation 📎 Peter Geoghegan 03:01
Re: CI and test improvements 📎 Thomas Munro 03:59
Re: Getting rid of SQLValueFunction Michael Paquier 05:21

Browse Archives

Prev | Next