pgsql-hackers since 2025-11-05 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

Nov. 5, 2025

Thread	Author	Time
Re: [BUG] PostgreSQL crashes with ThreadSanitizer during early initialization	Jacob Champion	00:14
Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) 📎	David Rowley	00:16
Re: Optimize LISTEN/NOTIFY 📎	Joel Jacobson	00:58
Re: Optimize LISTEN/NOTIFY	Joel Jacobson	01:06
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Joel Jacobson	01:10
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring 📎	Naga Appani	01:13
Re: [BUG] PostgreSQL crashes with ThreadSanitizer during early initialization	Tom Lane	01:19
Re: ubsan	Tom Lane	01:34
Re: meson's in-tree libpq header search order vs -Dextra_include_dirs	Thomas Munro	01:50
Re: Adding REPACK [concurrently]	jian he	02:48
Re: Extend injection_points_attach() to accept a user-defined function	Michael Paquier	03:02
Re: Fix comments for ChangeVarNodes() and related functions	Richard Guo	03:47
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs	Alexander Lakhin	04:00
Re: [PATCH] Add archive_mode=follow_primary to prevent unarchived WAL on standby promotion	Fujii Masao	04:33
Re: Add support for specifying tables in pg_createsubscriber. 📎	Shubham Khanna	04:41
Re: DOCS: ALTER PUBLICATION - Synopsis for DROP is a bit misleading	Fujii Masao	04:44
Re: Adding REPACK [concurrently]	Robert Treat	05:10
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs	David Rowley	05:26
pgsql: Drop unnamed portal immediately after execution to completion	Michael Paquier	05:43
Re: [BUG] temporary file usage report with extended protocol and unnamed portals	Michael Paquier	05:44
[PATCH] Fix fragile walreceiver test. 📎	Bryan Green	06:03
GiST README typos 📎	Paul A Jungwirth	06:18
Re: How can end users know the cause of LR slot sync delays?	shveta malik	06:19
Re: Asynchronous MergeAppend	Alexander Pyhalov	06:30
Re: Extended Statistics set/restore/clear functions. 📎	Corey Huinker	06:38
Re: [PATCH] Fix fragile walreceiver test.	Michael Paquier	06:50
Re: Non-text mode for pg_dumpall 📎	Vaibhav Dalvi	06:59
Re: Decouple C++ support in Meson's PGXS from LLVM enablement 📎	BharatDB	07:04
Re: Adding REPACK [concurrently]	Antonin Houska	07:12
Re: [PATCH] Fix fragile walreceiver test. 📎	Xuneng Zhou	07:30
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Nishant Sharma	07:32
Re: [PATCH] Fix fragile walreceiver test.	Michael Paquier	07:55
Re: ubsan	Alexander Lakhin	08:00
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Álvaro Herrera	08:21
Re: Logical Replication of sequences	Amit Kapila	08:28
Re: Adding REPACK [concurrently]	jian he	08:46
Re: Changing the state of data checksums in a running cluster 📎	Daniel Gustafsson	08:56
Re: Making jsonb_agg() faster	Chao Li	09:14
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Heikki Linnakangas	09:21
Re: Optimize LISTEN/NOTIFY	Chao Li	09:21
Re: [PATCH] Add pretty formatting to pg_get_triggerdef	Chao Li	09:28
Re: Logical Replication of sequences	shveta malik	09:41
pgsql: Implement WAIT FOR command	Alexander Korotkov	09:44
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs 📎	David Rowley	09:44
Re: Implement waiting for wal lsn replay: reloaded 📎	Alexander Korotkov	09:51
Re: [PATCH] Fix fragile walreceiver test.	Xuneng Zhou	10:12
Re: Newly created replication slot may be invalidated by checkpoint 📎	Alexander Korotkov	10:17
Re: Use stack-allocated StringInfoData	David Rowley	11:01
inconsistent tableoid handling in COPY WHERE clause	Peter Eisentraut	11:05
Re: inconsistent tableoid handling in COPY WHERE clause	Kirill Reshke	11:13
Re: inconsistent tableoid handling in COPY WHERE clause	Peter Eisentraut	11:35
Re: COPY WHERE clause generated/system column reference 📎	Peter Eisentraut	11:43
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Nishant Sharma	11:53
Re: mxid and mxoff wraparound issues in pg_upgrade 📎	Heikki Linnakangas	12:15
Re: Logical Replication of sequences	vignesh C	12:27
Re: Logical Replication of sequences	Amit Kapila	12:39
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Matheus Alcantara	12:40
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Heikki Linnakangas	12:59
Re: Non-text mode for pg_dumpall	Vaibhav Dalvi	13:16
Re: [PATCH] Fix fragile walreceiver test.	Bryan Green	13:38
Re: Add notification on BEGIN ATOMIC SQL functions using temp relations 📎	Jim Jones	13:44
Re: Logical Replication of sequences 📎	vignesh C	13:47
Re: doc: Improve description of io_combine_limit and io_max_combine_limit GUCs 📎	Karina Litskevich	13:58
Re: Implement waiting for wal lsn replay: reloaded	Xuneng Zhou	14:03
Re: Unnecessary delay in streaming replication due to replay lag 📎	sunil s	14:05
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	14:05
Re: Use stack-allocated StringInfoData	Chao Li	14:40
Re: Logical Replication of sequences 📎	vignesh C	14:44
Re: Suggestion to add --continue-client-on-abort option to pgbench 📎	Fujii Masao	15:12
Re: POC: make mxidoff 64 bits 📎	Heikki Linnakangas	15:37
Re: SQL:2011 Application Time Update & Delete	Peter Eisentraut	15:46
Re: [BUG] PostgreSQL crashes with ThreadSanitizer during early initialization	Jacob Champion	15:59
Re: SQL:2011 Application Time Update & Delete	Paul A Jungwirth	16:04
Re: [BUG] PostgreSQL crashes with ThreadSanitizer during early initialization	Tom Lane	16:05
Re: [PATCH] Add pretty formatting to pg_get_triggerdef	Philip Alger	16:21
Re: Spacing of options in getopt_long processing	Peter Eisentraut	16:41
Re: [PATCH] Add pretty formatting to pg_get_triggerdef 📎	Philip Alger	17:03
Re: Optimize LISTEN/NOTIFY	Arseniy Mukhin	17:51
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Arseniy Mukhin	18:17
Re: COPY WHERE clause generated/system column reference	Masahiko Sawada	18:19
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Matheus Alcantara	19:02
Re: [PATCH] Add pretty formatting to pg_get_triggerdef	Tom Lane	19:29
Re: inconsistent tableoid handling in COPY WHERE clause	Masahiko Sawada	19:42
Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)	Matheus Alcantara	21:05
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions	Corey Huinker	22:00
Re: [PATCH] Fix fragile walreceiver test.	Michael Paquier	22:58
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎	Masahiko Sawada	23:02
Re: Optimize LISTEN/NOTIFY	Chao Li	23:21
Re: Suggestion to add --continue-client-on-abort option to pgbench	Chao Li	23:37
Re: Proposal for enabling auto-vectorization for checksum calculations 📎	Andrew Kim	23:49
Re: doc: Improve description of io_combine_limit and io_max_combine_limit GUCs	Chao Li	23:59

Nov. 6, 2025

Thread	Author	Time
Re: Logical Replication of sequences	Peter Smith	00:48
Re: Add support for specifying tables in pg_createsubscriber.	Peter Smith	01:48
Re: pgstattuple: Use streaming read API in pgstatindex functions	Xuneng Zhou	02:01
Re: Use stack-allocated StringInfoData	David Rowley	02:09
Re: Logical Replication of sequences 📎	Shinya Kato	02:29
Re: Docs and tests for RLS policies applied by command type	jian he	02:45
Re: GiST README typos	John Naylor	02:59
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs	David Rowley	03:35
Re: postgres_fdw: Add more test coverage for EvalPlanQual testing	Etsuro Fujita	03:39
Re: Obsolete comment in ExecScanReScan()	Etsuro Fujita	03:41
Re: Add support for specifying tables in pg_createsubscriber. 📎	Shubham Khanna	04:05
Re: Logical Replication of sequences	Amit Kapila	04:40
Re: index prefetching 📎	Peter Geoghegan	04:55
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Michael Paquier	05:05
[PATCH] Fix socket handle inheritance on Windows 📎	Bryan Green	05:06
Re: Logical Replication of sequences 📎	vignesh C	05:18
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	05:33
Re: Consistently use the XLogRecPtrIsInvalid() macro 📎	Bertrand Drouvot	05:56
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Bryan Green	06:05
RE: Assertion failure in SnapBuildInitialSnapshot()	Zhijie Hou (Fujitsu)	06:33
Re: GiST README typos	Paul A Jungwirth	06:36
Re: inconsistent tableoid handling in COPY WHERE clause 📎	jian he	07:16
Re: [PATCH] Add pg_get_role_ddl() functions for role recreation	Quan Zongliang	07:20
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 📎	Peter Smith	07:22
Re: Use stack-allocated StringInfoData	Mats Kindahl	07:37
LTO aggressively optimizing out function despite explicit calls in logical decoding	Arkady Skvorcov	07:39
Re: Improve pg_sync_replication_slots() to wait for primary to advance 📎	Ajin Cherian	07:53
Re: Extended Statistics set/restore/clear functions.	Michael Paquier	08:26
Re: Optimize LISTEN/NOTIFY 📎	Joel Jacobson	08:33
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Amul Sul	09:03
Re: Consistently use the XLogRecPtrIsInvalid() macro	Álvaro Herrera	09:06
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Thomas Munro	09:20
Re: ago(interval) → timestamptz	Andreas Karlsson	09:37
Re: GiST README typos	John Naylor	09:38
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎	Heikki Linnakangas	10:05
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Thomas Munro	10:10
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Álvaro Herrera	10:18
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Álvaro Herrera	10:24
Re: Use stack-allocated StringInfoData	Álvaro Herrera	10:31
Re: Assertion failure in SnapBuildInitialSnapshot()	Amit Kapila	10:36
Re: Logical Replication of sequences	Amit Kapila	10:37
Re: ago(interval) → timestamptz	Florents Tselai	11:15
Re: Skipping schema changes in publication 📎	Shlok Kyal	11:16
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Arseniy Mukhin	11:20
Re: Use stack-allocated StringInfoData	David Rowley	11:28
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Heikki Linnakangas	11:35
Refactor StringInfo usage in subscriptioncmds.c 📎	Mats Kindahl	11:38
Some efforts to get rid of "long" in our codebase 📎	David Rowley	11:46
Re: Refactor StringInfo usage in subscriptioncmds.c	David Rowley	11:54
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎	Heikki Linnakangas	12:05
Re: Refactor StringInfo usage in subscriptioncmds.c	Amit Kapila	12:09
Re: Some efforts to get rid of "long" in our codebase	Heikki Linnakangas	12:17
Re: Refactor StringInfo usage in subscriptioncmds.c	Mats Kindahl	12:34
Re: Refactor StringInfo usage in subscriptioncmds.c	Álvaro Herrera	12:40
Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects	Thomas Munro	12:46
Re: Calling PGReserveSemaphores() from CreateOrAttachShmemStructs	Heikki Linnakangas	12:46
Re: Refactor StringInfo usage in subscriptioncmds.c 📎	Mats Kindahl	12:47
Re: Calling PGReserveSemaphores() from CreateOrAttachShmemStructs	Ashutosh Bapat	12:59
Re: log_min_messages per backend type 📎	Euler Taveira	13:09
Re: COPY WHERE clause generated/system column reference	Peter Eisentraut	13:17
Re: [PATCH] O_CLOEXEC not honored on Windows - handle inheritance chain	Thomas Munro	13:43
Re: Adding basic NUMA awareness	Jakub Wartak	14:02
Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects	Bryan Green	14:13
Re: Spacing of options in getopt_long processing	Andrew Dunstan	14:21
Re: Consistently use the XLogRecPtrIsInvalid() macro 📎	Bertrand Drouvot	14:27
Re: [PATCH] O_CLOEXEC not honored on Windows - handle inheritance chain	Bryan Green	14:42
Re: log_min_messages per backend type	Chao Li	14:53
Re: ago(interval) → timestamptz	Laurenz Albe	14:54
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Bryan Green	14:56
Re: [PATCH] Add pg_get_subscription_ddl() function 📎	Vaibhav Dalvi	14:58
Re: Use stack-allocated StringInfoData	Tom Lane	15:11
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Arseniy Mukhin	15:13
Re: Calling PGReserveSemaphores() from CreateOrAttachShmemStructs	Chao Li	15:22
Re: Include extension path on pg_available_extensions	Matheus Alcantara	15:29
Missing calls to UnlockBuffers() - unify error handling?	Andres Freund	15:34
Re: [PATCH] Add pg_get_subscription_ddl() function	Álvaro Herrera	15:48
Re: POC: make mxidoff 64 bits 📎	Maxim Orlov	15:50
Re: log_min_messages per backend type	Alvaro Herrera	16:01
Re: [PATCH] Add pg_get_role_ddl() functions for role recreation 📎	Bryan Green	16:20
Re: [PoC] XMLCast (SQL/XML X025) 📎	Jim Jones	16:32
Re: psql --help=variables missing csv_fieldsep	Álvaro Herrera	16:37
Re: Suggestion to add --continue-client-on-abort option to pgbench	Fujii Masao	16:38
Re: pg_plan_advice 📎	Robert Haas	16:45
warning on the current head	Rafia Sabih	16:47
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array	Xuneng Zhou	16:54
Re: warning on the current head	Álvaro Herrera	16:58
Re: [Patch] Windows relation extension failure at 2GB and 4GB 📎	Bryan Green	17:17
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Andres Freund	17:45
Re: Some efforts to get rid of "long" in our codebase	Peter Eisentraut	18:26
Re: Some efforts to get rid of "long" in our codebase	Peter Eisentraut	18:33
Re: Extended Statistics set/restore/clear functions. 📎	Corey Huinker	18:35
Re: Assertion failure in SnapBuildInitialSnapshot()	Masahiko Sawada	18:36
Re: [PATCH] Fix socket handle inheritance on Windows 📎	Bryan Green	18:53
Re: Consistently use the XLogRecPtrIsInvalid() macro	Álvaro Herrera	19:48
Re: Some efforts to get rid of "long" in our codebase	David Rowley	20:06
Re: [PATCH] Add pretty formatting to pg_get_triggerdef	Philip Alger	20:19
Re: Refactor StringInfo usage in subscriptioncmds.c	David Rowley	20:50
Re: Built-in case-insensitive collation pg_unicode_ci	Jeff Davis	21:54
Tuesday at 2026.pgconf.dev	Robert Haas	21:57
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Manni Wood	22:08
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Michael Paquier	22:13
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Michael Paquier	22:20
Re: another autovacuum scheduling thread 📎	Sami Imseih	22:21
Re: [Patch] Windows relation extension failure at 2GB and 4GB	Michael Paquier	22:28
Re: [PATCH] Fix fragile walreceiver test.	Michael Paquier	22:34
Re: another autovacuum scheduling thread	David Rowley	23:05
Re: High CPU consumption in cascade replication with large number of walsenders 📎	Alexey Makhmutov	23:17
Re: alter check constraint enforceability	Robert Treat	23:29
Re: postgres_fdw: Use COPY to speed up batch inserts 📎	Matheus Alcantara	23:49

Browse Archives

Prev | Next