pgsql-hackers since 2025-09-02 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

Sept. 2, 2025

Thread	Author	Time
Re: Extension security improvement: Add support for extensions with an owned schema	Julien Rouhaud	00:03
Re: MergeAppend could consider sorting cheapest child path	Richard Guo	01:27
Re: SQL:2023 JSON simplified accessor support	Chao Li	02:43
Re: SQL:2023 JSON simplified accessor support	Chao Li	02:46
Re: Fixing MSVC's inability to detect elog(ERROR) does not return 📎	David Rowley	02:57
Re: SQL:2023 JSON simplified accessor support	Chao Li	02:59
Re: SQL:2023 JSON simplified accessor support	Chao Li	03:32
Re: SQL:2023 JSON simplified accessor support	David G. Johnston	03:53
Re: Refactoring: Use soft error reporting for *_opt_error functions	Michael Paquier	04:16
Re: Orphan page in _bt_split	Michael Paquier	04:27
Re: Orphan page in _bt_split	Michael Paquier	04:42
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	shveta malik	04:54
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	shveta malik	04:55
RE: Avoid retaining conflict-related data when no tables are subscribed 📎	Zhijie Hou (Fujitsu)	05:21
Re: SQL:2023 JSON simplified accessor support	Chao Li	05:27
Re: Refactoring: Use soft error reporting for *_opt_error functions	Amul Sul	07:10
Concurrency Issue with pg_ctl causing processes to hang in PostgreSQL 15.12	Srirama Kucherlapati	07:26
Re: Refactoring: Use soft error reporting for *_opt_error functions	Michael Paquier	07:29
Fix use of variable after pfree 📎	Shlok Kyal	07:32
Re: Allow to collect statistics on virtual generated columns 📎	Yugo Nagata	07:33
Re: Extension security improvement: Add support for extensions with an owned schema	Jelte Fennema-Nio	07:37
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Yura Sokolov	07:37
Re: Get rid of pgstat_count_backend_io_op*() functions	Bertrand Drouvot	07:41
Re: Fix use of variable after pfree	Amit Kapila	07:42
Re: Increase OpenBSD CI task's RAM disk size	Daniel Gustafsson	08:24
Fix pg_waldump to exit cleanly at end of WAL 📎	Chao Li	08:42
Re: Fix use of variable after pfree	Daniel Gustafsson	08:56
Re: Extension security improvement: Add support for extensions with an owned schema	Julien Rouhaud	09:02
Re: Refactoring: Use soft error reporting for *_opt_error functions 📎	Amul Sul	09:11
Re: Conflict detection for update_deleted in logical replication	shveta malik	10:00
Re: Pathify RHS unique-ification for semijoin planning	Richard Guo	10:10
Re: Adding REPACK [concurrently] 📎	Mihail Nikalayeu	10:44
Re: Pathify RHS unique-ification for semijoin planning	Andrei Lepikhov	10:55
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Amit Kapila	11:35
Re: Performance issues with parallelism and LIMIT 📎	David Geier	11:38
Re: Add support for specifying tables in pg_createsubscriber. 📎	Shubham Khanna	11:42
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Shlok Kyal	12:12
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters	Jim Jones	12:16
Re: Resetting recovery target parameters in pg_createsubscriber 📎	Alyona Vinter	12:36
Use bool with synced field (src/include/replication/slot.h) 📎	Ranier Vilela	12:47
Re: Serverside SNI support in libpq	Daniel Gustafsson	12:48
Re: Extension security improvement: Add support for extensions with an owned schema	Robert Haas	13:35
Re: Logical Replication of sequences 📎	vignesh C	13:42
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible	Nathan Bossart	14:43
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	14:45
Re: split func.sgml to separated individual sgml files	Andrew Dunstan	14:54
Re: pgsql: Preserve conflict-relevant data during logical replication.	Robert Haas	15:03
Re: pgsql: oauth: Add unit tests for multiplexer handling	Jacob Champion	15:18
Re: Get rid of pgstat_count_backend_io_op*() functions 📎	Bertrand Drouvot	15:25
Re: Improve LWLock tranche name visibility across backends 📎	Nathan Bossart	15:38
Re: psql client does not handle WSAEWOULDBLOCK on Windows	Tom Lane	15:51
Re: Use bool with synced field (src/include/replication/slot.h)	Nathan Bossart	16:02
Re: Fixes a trivial bug in dumped parse/query/plan trees	Tom Lane	16:08
Re: Get rid of pgstat_count_backend_io_op*() functions	Andres Freund	16:42
Re: aio/README.md comments	Jeff Davis	16:45
Disabling memory overcommit deemed dangerous	David Geier	17:06
Avoid use of uninitialized variable (src/pl/plperl/plperl.c) 📎	Ranier Vilela	17:39
Re: Avoid use of uninitialized variable (src/pl/plperl/plperl.c)	Andres Freund	17:42
Re: Avoid use of uninitialized variable (src/pl/plperl/plperl.c)	Ranier Vilela	17:46
Re: Improve error message for duplicate labels in enum types	Tom Lane	18:00
Re: Disabling memory overcommit deemed dangerous	Tom Lane	18:10
Re: INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2	v@viktorh.net	18:56
Get ride of pqbool artifact (src/interfaces/libpq/libpq-fe.h) 📎	Ranier Vilela	19:19
Re: Get ride of pqbool artifact (src/interfaces/libpq/libpq-fe.h)	Tom Lane	19:44
Re: Get ride of pqbool artifact (src/interfaces/libpq/libpq-fe.h)	Jacob Champion	19:51
Re: Get ride of pqbool artifact (src/interfaces/libpq/libpq-fe.h)	Ranier Vilela	19:53
Re: plan shape work 📎	Robert Haas	20:07
Fix segfault while accessing half-initialized hash table in pgstat_shmem.c 📎	Mikhail Kot	20:09
Re: Use bool with synced field (src/include/replication/slot.h)	Nathan Bossart	21:02
Re: Improve the performance of Unicode Normalization Forms. 📎	Alexander Borisov	21:07
Re: pull-up subquery if JOIN-ON contains refs to upper-query 📎	Ilia Evdokimov	21:07
Checkpointer write combining 📎	Melanie Plageman	21:10
Re: pull-up subquery if JOIN-ON contains refs to upper-query 📎	Alena Rybakina	21:20
Re: CREATE SCHEMA ... CREATE DOMAIN support	Tom Lane	21:24
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)	Melanie Plageman	21:52
Re: Use bool with synced field (src/include/replication/slot.h)	Nathan Bossart	21:54
Re: Use bool with synced field (src/include/replication/slot.h)	Nathan Bossart	21:57
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 📎	Melanie Plageman	23:11
Re: COPY TO: provide hint when WHERE clause is used	Fujii Masao	23:38
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)	Andres Freund	23:54

Sept. 3, 2025

Thread	Author	Time
Re: COPY TO: provide hint when WHERE clause is used	torikoshia	00:08
Re: Fix pg_waldump to exit cleanly at end of WAL	Fujii Masao	00:11
Re: Use bool with synced field (src/include/replication/slot.h)	Ranier Vilela	00:14
Re: Update outdated references to SLRU ControlLock	Michael Paquier	01:21
Re: Raw parse tree is not dumped to log	Tatsuo Ishii	01:57
Re: Add support for specifying tables in pg_createsubscriber.	Peter Smith	01:57
Re: SQL:2023 JSON simplified accessor support 📎	Alexandra Wang	02:16
Re: SQL:2023 JSON simplified accessor support	Alexandra Wang	02:20
Re: Update outdated references to SLRU ControlLock	Julien Rouhaud	02:22
Re: Fix pg_waldump to exit cleanly at end of WAL	Michael Paquier	02:47
RE: POC: enable logical decoding when wal_level = 'replica' without a server restart	Hayato Kuroda (Fujitsu)	03:11
Re: Fix pg_waldump to exit cleanly at end of WAL	Chao Li	03:20
Re: SQL:2023 JSON simplified accessor support	Chao Li	03:56
Re: Conflict detection for update_deleted in logical replication	shveta malik	04:19
Re: Timeline switching with partial WAL records can break replica recovery 📎	Alyona Vinter	05:37
Re: Timeline switching with partial WAL records can break replica recovery 📎	Alyona Vinter	05:39
Solaris compiler status	Peter Eisentraut	05:47
Re: Get rid of pgstat_count_backend_io_op*() functions	Michael Paquier	05:47
Re: Orphan page in _bt_split	Konstantin Knizhnik	06:25
Re: Improve pg_sync_replication_slots() to wait for primary to advance 📎	Ajin Cherian	06:28
Re: Orphan page in _bt_split	Konstantin Knizhnik	06:32
Re: VM corruption on standby	Alexander Korotkov	06:37
Re: Refactoring: Use soft error reporting for *_opt_error functions	Michael Paquier	06:47
Re: VM corruption on standby	Andrey Borodin	06:47
Should io_method=worker remain the default?	Jeff Davis	06:47
Re: SQL:2023 JSON simplified accessor support	Chao Li	06:56
Re: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c	Michael Paquier	07:10
Re: SQL:2023 JSON simplified accessor support	Chao Li	07:11
回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c	Steven Niu	07:22
Re: Get rid of pgstat_count_backend_io_op*() functions	Bertrand Drouvot	07:33
RE: Logical Replication of sequences	Hayato Kuroda (Fujitsu)	07:34
Re: Refactoring: Use soft error reporting for *_opt_error functions	Dean Rasheed	07:34
Re: VM corruption on standby	Alexander Korotkov	08:28
fix NOT VALID NOT NULL with ALTER COLUMN SET IDENTITY 📎	jian he	08:30
Re: Should io_method=worker remain the default?	Tomas Vondra	08:34
Re: Generate GUC tables from .dat file	Peter Eisentraut	08:37
Re: Generate GUC tables from .dat file	Peter Eisentraut	08:39
Re: Generate GUC tables from .dat file	Peter Eisentraut	08:41
Re: Generate GUC tables from .dat file	Daniel Gustafsson	08:41
Re: Improve pg_sync_replication_slots() to wait for primary to advance	shveta malik	08:47
Re: Disabling memory overcommit deemed dangerous	David Geier	08:59
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)	Kirill Reshke	09:06
Re: Pathify RHS unique-ification for semijoin planning	Richard Guo	09:12
Re: Generate GUC tables from .dat file	Richard Guo	09:39
Re: 回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c	Michael Paquier	09:43
Unexpected changes of CurrentResourceOwner and CurrentMemoryContext 📎	Antonin Houska	09:49
Re: Improve pg_sync_replication_slots() to wait for primary to advance 📎	Ajin Cherian	09:49
Re: Adding REPACK [concurrently]	Antonin Houska	09:55
回复: 回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c	Steven Niu	09:55
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters 📎	Andrei Klychkov	09:59
Re: Pathify RHS unique-ification for semijoin planning	Andrei Lepikhov	10:00
Re: Generate GUC tables from .dat file	Peter Eisentraut	10:15
Re: Improve error message for duplicate labels in enum types	Yugo Nagata	11:05
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Chiranmoy.Bhattacharya@fujitsu.com	11:11
Re: Fixing MSVC's inability to detect elog(ERROR) does not return	Peter Eisentraut	11:31
Re: Solaris compiler status	Andrew Dunstan	11:33
RE: pgsql: Preserve conflict-relevant data during logical replication.	Zhijie Hou (Fujitsu)	11:40
Re: Solaris compiler status	Daniel Gustafsson	11:42
Re: pg_restore --no-policies should not restore policies' comment 📎	Fujii Masao	11:50
Re: Refactoring: Use soft error reporting for *_opt_error functions 📎	Amul Sul	11:51
Re: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c	Ranier Vilela	11:55
Re: split func.sgml to separated individual sgml files	Florents Tselai	12:16
Re: How can end users know the cause of LR slot sync delays?	Ashutosh Sharma	12:22
Re: [Patch] add new parameter to pg_replication_origin_session_setup	Doruk Yilmaz	12:43
Re: Remove traces of long in dynahash.c	Peter Eisentraut	12:48
expand virtual generated columns in get_relation_constraints() 📎	Peter Eisentraut	14:05
Re: Refactoring: Use soft error reporting for *_opt_error functions	jian he	14:41
Re: Solaris compiler status	Tom Lane	14:42
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters	Fujii Masao	14:47
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Nathan Bossart	14:48
Re: Should io_method=worker remain the default?	Jeff Davis	14:50
Re: Cannot find a working 64-bit integer type on Illumos	Peter Eisentraut	15:04
Re: Should io_method=worker remain the default?	Álvaro Herrera	15:53
Re: Should io_method=worker remain the default?	Andres Freund	15:55
Re: Explicitly enable meson features in CI	Jacob Champion	15:58
Re: Should io_method=worker remain the default?	Andres Freund	16:05
Re: Solaris compiler status	Peter Eisentraut	16:15
RE: AIX support 📎	Srirama Kucherlapati	16:44
Re: Use merge-based matching for MCVs in eqjoinsel 📎	Ilia Evdokimov	16:53
Re: Generate GUC tables from .dat file	Nathan Bossart	17:14
Re: Non-reproducible AIO failure	Dmitry Mityugov	17:37
Re: [BUG?] check_exclusion_or_unique_constraint false negative 📎	Mihail Nikalayeu	18:20
Re: index prefetching	Andres Freund	18:47
Re: Should io_method=worker remain the default?	Jeff Davis	18:50
Re: Non-reproducible AIO failure	Konstantin Knizhnik	18:50
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	19:01
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Arseniy Mukhin	19:28
Re: Should io_method=worker remain the default?	Andres Freund	19:31
Re: index prefetching	Peter Geoghegan	19:33
Re: Non-reproducible AIO failure	Andres Freund	19:42
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	19:53
Re: index prefetching	Andres Freund	20:06
Re: index prefetching	Peter Geoghegan	20:25
Re: Use merge-based matching for MCVs in eqjoinsel	Tom Lane	20:26
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎	Matheus Alcantara	20:35
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Matheus Alcantara	21:04
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring 📎	Naga Appani	21:10
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Matheus Alcantara	21:14
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Nathan Bossart	21:36
Re: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c 📎	Mikhail Kot	21:39
Re: Solaris compiler status	Thomas Munro	21:56
[PG19-3 PATCH] Don't ignore passfile 📎	postgresql.cache976	22:17
Re: Should io_method=worker remain the default?	Thomas Munro	22:22
Re: Should io_method=worker remain the default?	Jeff Davis	22:47
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Rishu Bagga	23:51

Sept. 4, 2025

Thread	Author	Time
Re: index prefetching	Andres Freund	00:16
Re: Refactoring: Use soft error reporting for *_opt_error functions	Michael Paquier	00:17
Re: Solaris compiler status	Andres Freund	00:24
Re: index prefetching	Peter Geoghegan	00:28
Re: Orphan page in _bt_split	Michael Paquier	00:39
Re: Cannot find a working 64-bit integer type on Illumos	Thomas Munro	00:39
Re: Orphan page in _bt_split	Peter Geoghegan	00:55
回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c	Steven Niu	02:31
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	kasaharatt	02:31
NOT NULL NOT ENFORCED 📎	jian he	02:56
Re: Sequence Access Methods, round two 📎	Michael Paquier	03:15
Re: Incorrect logic in XLogNeedsFlush()	Dilip Kumar	03:38
Re: Remove traces of long in dynahash.c	Michael Paquier	03:57
Re: Add log_autovacuum_{vacuum|analyze}_min_duration 📎	Shinya Kato	04:13
Re: [PG19-3 PATCH] Don't ignore passfile	Umar Hayat	04:25

Browse Archives

Prev | Next