pgsql-hackers since 2026-03-21 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)

Advanced Search

Browse Archives

Prev | Next

March 21, 2026

Thread	Author	Time
Re: index prefetching	Andres Freund	00:33
Re: pg_stat_replication.*_lag sometimes shows NULL during active replication	Shinya Kato	02:04
Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE	Michael Paquier	02:46
Remove inner joins based on foreign keys 📎	Richard Guo	02:47
Re: pg_waldump: support decoding of WAL inside tarfile	Tom Lane	03:49
Re: Row pattern recognition	Tatsuo Ishii	05:02
Re: slow SELECT expr INTO var in plpgsql	Pavel Stehule	05:10
Re: remove bits* types	Michael Paquier	05:41
Re: Adding locks statistics	Michael Paquier	05:55
Re: basebackup: add missing deflateEnd() in gzip compression sink	Michael Paquier	06:09
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Amul Sul	06:19
Re: pg_waldump: support decoding of WAL inside tarfile	Michael Paquier	06:23
Re: Introduce XID age based replication slot invalidation	SATYANARAYANA NARLAPURAM	06:28
Re: pg_waldump: support decoding of WAL inside tarfile	Tom Lane	06:34
RE: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY)	Madyshev Egor	07:33
Re: Remove inner joins based on foreign keys	Michael Paquier	07:42
Re: Remove inner joins based on foreign keys	Richard Guo	08:01
Re: log XLogPrefetch stats at end of recovery	SATYANARAYANA NARLAPURAM	08:15
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 📎	jian he	08:16
Re: Patch for migration of the pg_commit_ts directory 📎	ls7777	08:59
Re: [Proposal] Adding Log File Capability to pg_createsubscriber	Amit Kapila	09:57
Re: SQL Property Graph Queries (SQL/PGQ)	Alexander Lakhin	10:00
Re: BUG: Cascading standby fails to reconnect after falling back to archive recovery	Xuneng Zhou	10:07
Re: tablecmds: fix bug where index rebuild loses replica identity on partitions	Xuneng Zhou	10:29
Re: BUG: Cascading standby fails to reconnect after falling back to archive recovery	Marco Nenciarini	10:37
Re: BUG: Cascading standby fails to reconnect after falling back to archive recovery 📎	Marco Nenciarini	10:52
Re: [19] CREATE SUBSCRIPTION ... SERVER	Amit Kapila	10:55
Re: Use-after-free issue in postgres_fdw	Etsuro Fujita	11:40
Re: Use-after-free issue in postgres_fdw	Etsuro Fujita	11:44
Re: Use-after-free issue in postgres_fdw	Etsuro Fujita	11:56
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Andrew Dunstan	12:21
Persistent data across SETOF calls	Ed Behn	12:22
Re: Row pattern recognition	Henson Choi	12:42
Re: SQL Property Graph Queries (SQL/PGQ)	Henson Choi	12:48
Re: basebackup: add missing deflateEnd() in gzip compression sink	Jianghua Yang	13:09
Re: pg_plan_advice	Robert Haas	13:13
Re: Add ssl_(supported|shared)_groups to sslinfo 📎	Dmitry Dolgov	13:25
Re: Row pattern recognition	Tatsuo Ishii	14:16
Re: pg_waldump: support decoding of WAL inside tarfile	Tom Lane	14:45
Re: another autovacuum scheduling thread	Sami Imseih	14:55
Re: Row pattern recognition	Henson Choi	14:57
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Amul Sul	15:35
Re: Persistent data across SETOF calls	Tom Lane	15:48
Re: Need help debugging SIGBUS crashes	Peter 'PMc' Much	16:35
Re: Use SIGTERM instead of SIGUSR1 for slotsync worker to exit during promotion?	Amit Kapila	16:52
Add RISC-V Zbb popcount optimization 📎	Greg Burd	16:54
Add pg_stat_vfdcache view for VFD cache statistics 📎	KAZAR Ayoub	16:58
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Amul Sul	17:26
Re: Fix slotsync worker busy loop causing repeated log messages	Amit Kapila	17:46
Re: pg_waldump: support decoding of WAL inside tarfile	Tom Lane	18:23
Re: Add RISC-V Zbb popcount optimization	Andres Freund	18:36
Re: Trying out <stdatomic.h> 📎	Greg Burd	18:39
Re: POC: PLpgSQL FOREACH IN JSON ARRAY 📎	Pavel Stehule	18:40
Proposal: Implementing Botan as an alternative TLS backend for PostgreSQL	Javier Gutierrez-Maturana sanchez	18:44
Re: Add RISC-V Zbb popcount optimization	Greg Burd	18:49
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Tom Lane	19:31
Re: index prefetching	Andres Freund	19:54
Re: Adding locks statistics 📎	Álvaro Herrera	20:01
Re: Proposal: Implementing Botan as an alternative TLS backend for PostgreSQL	Daniel Gustafsson	20:11
Avoid use of TopMemoryContext for resource owner cleanup in portals 📎	Lukas Fittl	20:18
Re: Proposal: Implementing Botan as an alternative TLS backend for PostgreSQL	Javier Gutierrez-Maturana sanchez	20:47
Re: Non-text mode for pg_dumpall	Tom Lane	21:10
Re: basebackup: add missing deflateEnd() in gzip compression sink 📎	Jianghua Yang	21:22
Re: pg_waldump: support decoding of WAL inside tarfile	Tom Lane	22:24
Re: index prefetching	Peter Geoghegan	23:01
Re: [Proposal] Adding Log File Capability to pg_createsubscriber 📎	Gyan Sreejith	23:09
Re: Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY 📎	Mihail Nikalayeu	23:50

March 22, 2026

Thread	Author	Time
Re: another autovacuum scheduling thread	Bharath Rupireddy	00:08
Re: Better shared data structure management and resizable shared data structures 📎	Heikki Linnakangas	00:14
Re: log XLogPrefetch stats at end of recovery	Bharath Rupireddy	00:43
Re: index prefetching	Peter Geoghegan	01:17
Re: Add RISC-V Zbb popcount optimization	John Naylor	02:14
Re: Use CASEFOLD() internally rather than LOWER() 📎	Mark Dilger	03:14
Re: pg_waldump: support decoding of WAL inside tarfile	Tom Lane	04:24
Re: Row pattern recognition 📎	Tatsuo Ishii	05:23
Re: vectorized CRC on ARM64	John Naylor	05:26
Re: Fix uninitialized xl_running_xacts padding	Michael Paquier	06:50
Re: Non-text mode for pg_dumpall	Andrew Dunstan	08:50
Copy from JSON FORMAT. 📎	Junwang Zhao	08:59
Re: Remove inner joins based on foreign keys	David Rowley	09:09
Re: Proposal: Implementing Botan as an alternative TLS backend for PostgreSQL	Enrique Soriano	10:53
Re: Bug in MultiXact replay compat logic for older minor version after crash-recovery 📎	Heikki Linnakangas	11:09
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Andrew Dunstan	11:24
Re: Proposal: Prevent Primary/Standby SLRU divergence during MultiXact truncation	Heikki Linnakangas	12:29
Re: Avoid use of TopMemoryContext for resource owner cleanup in portals	Heikki Linnakangas	12:39
Re: Copy from JSON FORMAT.	jian he	12:58
回复：Bug in MultiXact replay compat logic for older minor version after crash-recovery	段坤仁 (刻韧)	13:09
Re: Bug in MultiXact replay compat logic for older minor version after crash-recovery	Kirill Reshke	14:15
Re: Copy from JSON FORMAT. 📎	Junwang Zhao	14:16
Re: Bug in MultiXact replay compat logic for older minor version after crash-recovery	Kirill Reshke	14:22
Re: Compress prune/freeze records with Delta Frame of Reference algorithm 📎	Evgeny Voropaev	14:39
Re: Adding comments to help understand psql hidden queries 📎	Greg Sabino Mullane	15:15
Re: Avoid use of TopMemoryContext for resource owner cleanup in portals	Lukas Fittl	15:23
Re: Compress prune/freeze records with Delta Frame of Reference algorithm	Andres Freund	16:20
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Tom Lane	17:29
Re: Add RISC-V Zbb popcount optimization 📎	Greg Burd	17:43
Re: Add RISC-V Zbb popcount optimization	Andres Freund	18:01
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎	Lukas Fittl	18:13
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Tom Lane	18:17
Re: Add RISC-V Zbb popcount optimization	Greg Burd	19:13
Re: [PoC] XMLCast (SQL/XML X025) 📎	Jim Jones	19:13
Re: Adding locks statistics 📎	Álvaro Herrera	19:37
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 📎	Melanie Plageman	19:58
Add tab completion for SERVER and CONNECTION keywords in psql 📎	Yamaguchi Atsuo	20:30
Re: pg_waldump: support decoding of WAL inside tarfile	Andrew Dunstan	21:19
Re: pg_waldump: support decoding of WAL inside tarfile	Tom Lane	21:39
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Tom Lane	23:13
Re: Add ldapservice connection parameter 📎	Andrew Jackson	23:38

March 23, 2026

Thread	Author	Time
Re: basebackup: add missing deflateEnd() in gzip compression sink	Michael Paquier	00:31
Re: amcheck: fix bug of missing corruption in allequalimage validation	Chao Li	00:42
Re: amcheck: fix bug of missing corruption in allequalimage validation 📎	Chao Li	00:44
Re: Change checkpoint‑record‑missing PANIC to FATAL	Michael Paquier	00:55
Re: index prefetching 📎	Peter Geoghegan	01:14
Re: basebackup: add missing deflateEnd() in gzip compression sink	Jianghua Yang	01:36
Check some unchecked fclose() results	Chao Li	02:04
Re: CREATE TABLE LIKE INCLUDING TRIGGERS 📎	jian he	02:12
Re: Check some unchecked fclose() results 📎	Chao Li	02:22
Re: Use-after-free issue in postgres_fdw	Chao Li	02:48
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Tom Lane	03:02
Re: [Proposal] Adding Log File Capability to pg_createsubscriber	shveta malik	03:15
Re: TupleDescAttr bounds checks	Tom Lane	03:54
Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication	surya poondla	04:21
Re: create table like including storage parameter 📎	jian he	04:44
Re: Avoid multiple calls to memcpy (src/backend/access/index/genam.c)	lakshmi	04:45
Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication	Ashutosh Sharma	05:32
Re: Use SIGTERM instead of SIGUSR1 for slotsync worker to exit during promotion?	Fujii Masao	05:50
Fwd: Extension - multilingual_fuzzy_match : Multilingual phonetic matching extension for PostgreSQL 📎	Blessy Thomas	05:52
Re: Remove inner joins based on foreign keys	Richard Guo	06:12
Re: Remove inner joins based on foreign keys	Pavel Stehule	06:22
Bug in pg_get_aios()	cca5507	06:23
Re: [Proposal] Adding Log File Capability to pg_createsubscriber	Chao Li	06:23
Fix "could not find memoization table entry" 📎	Tender Wang	06:29
Re: Bug in pg_get_aios()	Chao Li	06:30
Re: Change default of jit to off	Pierre Ducroquet	06:33
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	John Naylor	07:00
Re: [PATCH] Add `headerscheck` run_target to meson	Peter Eisentraut	07:00
Re: Skipping schema changes in publication	shveta malik	07:05
Re: [Proposal] Adding Log File Capability to pg_createsubscriber	Amit Kapila	07:16
Teach isolation tester about injection points in background workers 📎	Antonin Houska	07:22
log_checkpoints: count WAL segment creations from all processes 📎	Xuneng Zhou	07:39
Re: headerscheck ccache support	Peter Eisentraut	07:45
Re: tablecmds: fix bug where index rebuild loses replica identity on partitions 📎	Chao Li	07:56
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	David Geier	08:00
Re: Propagate XLogFindNextRecord error to callers 📎	Anthonin Bonnefoy	08:15
Re: Adding locks statistics	Bertrand Drouvot	08:18
Reduce log level of some logical decoding messages to DEBUG1 📎	Fujii Masao	08:23
Re: tablecmds: fix bug where index rebuild loses replica identity on partitions	Xuneng Zhou	08:41
Re: Bug in pg_get_aios()	Michael Paquier	08:44
headerscheck: Avoid mutual inclusion of pg_config.h and c.h 📎	Peter Eisentraut	08:50
Re: Read-only connection mode for AI workflows.	Jelte Fennema-Nio	09:10
Re: Make copyObject work in C++ 📎	Peter Eisentraut	09:27
Re: [PATCH] Add CANONICAL option to xmlserialize 📎	Jim Jones	09:52
RE: [Proposal] Adding Log File Capability to pg_createsubscriber		09:54
Re: [Proposal] Adding Log File Capability to pg_createsubscriber	shveta malik	09:55
Re: Race conditions in logical decoding	Antonin Houska	09:58
Re: Make copyObject work in C++	Jelte Fennema-Nio	09:58
Re: Adding REPACK [concurrently]	Antonin Houska	10:20
Re: Fix bug with accessing to temporary tables of other sessions	Soumya S Murali	10:22
Re: 回复：Bug in MultiXact replay compat logic for older minor version after crash-recovery	Heikki Linnakangas	10:35
[doc] pg_ctl: fix wrong description for -l 📎		10:55
Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication 📎	Ashutosh Sharma	10:58
Re: Read-only connection mode for AI workflows.	Isaac Morland	11:04
Re: Avoid multiple calls to memcpy (src/backend/access/index/genam.c)	Ranier Vilela	11:12
Re: Add pg_stat_vfdcache view for VFD cache statistics	Jakub Wartak	11:22
Re: log XLogPrefetch stats at end of recovery	Jakub Wartak	11:29
[PATCH] Add prepared_orphaned_transaction_timeout GUC 📎	Nikhil Chawla	11:47
Re: Trying out <stdatomic.h>	Peter Eisentraut	11:57
Re: Propagate XLogFindNextRecord error to callers 📎	Fujii Masao	12:00
Re: Adding REPACK [concurrently] 📎	Antonin Houska	12:00
Re: Propagate XLogFindNextRecord error to callers	Anthonin Bonnefoy	12:07
Re: Add pg_stat_vfdcache view for VFD cache statistics	David Geier	12:35
Re: Trying out <stdatomic.h>	Greg Burd	12:50
Add logical_decoding_spill_limit to cap spill file disk usage per slot	shawn wang	13:19
Re: Add logical_decoding_spill_limit to cap spill file disk usage per slot 📎	shawn wang	13:23
Re: Fix bug with accessing to temporary tables of other sessions 📎	Jim Jones	13:31
Re: meson vs. llvm bitcode files 📎	Nazir Bilal Yavuz	13:39
Re: Fix bug with accessing to temporary tables of other sessions	Tom Lane	13:44
Re: Reduce log level of some logical decoding messages to DEBUG1	Bharath Rupireddy	13:53
Re: [PATCH] no table rewrite when set column type to constrained domain 📎	jian he	13:57
Re: Trying out <stdatomic.h>	Tom Lane	14:13
Re: [Patch] Add WHERE clause support to REFRESH MATERIALIZED VIEW	Adam Brusselback	14:23
Re: Add logical_decoding_spill_limit to cap spill file disk usage per slot	Bharath Rupireddy	14:24
Re: Trying out <stdatomic.h>	Greg Burd	14:24
Re: Avoid use of TopMemoryContext for resource owner cleanup in portals	Heikki Linnakangas	14:33
Re: Stack-based tracking of per-node WAL/buffer usage	Heikki Linnakangas	14:41
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Ashutosh Bapat	15:00
Re: Add RISC-V Zbb popcount optimization	Nathan Bossart	15:09
Re: Enable -Wstrict-prototypes and -Wold-style-definition by default 📎	Peter Eisentraut	15:13
Re: Enable -Wstrict-prototypes and -Wold-style-definition by default	Tom Lane	15:20
Re: another autovacuum scheduling thread	Nathan Bossart	15:22
Re: pg_stat_replication.*_lag sometimes shows NULL during active replication 📎	Fujii Masao	15:31
Re: feature freeze for v19 begins April 8th at 12:00 UTC	Nathan Bossart	15:39
Re: Reduce log level of some logical decoding messages to DEBUG1	Fujii Masao	15:44
Re: Bug in pg_get_aios()	Andres Freund	15:50
Re: Introduce XID age based replication slot invalidation 📎	Bharath Rupireddy	16:00
Re: Adding REPACK [concurrently] 📎	Jim Jones	16:07
Re: DOCS - System Applications 'datadir' parameter	Bruce Momjian	16:14
Re: [PATCH] no table rewrite when set column type to constrained domain	Viktor Holmberg	16:17
Re: [PATCH] rewriteGraphTable: Fix missing RTEs in FROM clause by setting inFromCl=true	Ashutosh Bapat	16:39
Re: Adding comments to help understand psql hidden queries 📎	Tom Lane	17:35

Browse Archives

Prev | Next