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

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
Re: Should io_method=worker remain the default? Thomas Munro 04:35
Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt 📎 jian he 04:54
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Michael Paquier 04:59
Re: Set log_lock_waits=on by default Shinya Kato 05:12
Re: Add log_autovacuum_{vacuum|analyze}_min_duration kasaharatt 06:16
Re: [PATCH] Hex-coding optimizations using SVE on ARM. John Naylor 06:20
Re: 回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c Michael Paquier 06:30
Re: Improve pg_sync_replication_slots() to wait for primary to advance shveta malik 06:35
Re: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c 📎 Michael Paquier 07:33
Re: 回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c Steven Niu 07:38
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Andrei Klychkov 07:41
Re: 回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c Rider 07:49
Re: plan shape work Richard Guo 08:21
Re: Timeline switching with partial WAL records can break replica recovery 📎 Nataliia 08:40
Re: [PG19-3 PATCH] Don't ignore passfile Paul Ohlhauser 08:59
Re: pg_restore --no-policies should not restore policies' comment jian he 09:00
Re: Cannot find a working 64-bit integer type on Illumos 📎 Peter Eisentraut 09:01
Re: Cannot find a working 64-bit integer type on Illumos Peter Eisentraut 09:05
Re: Refactoring: Use soft error reporting for *_opt_error functions Dean Rasheed 09:50
Re: MergeAppend could consider sorting cheapest child path 📎 Andrei Lepikhov 09:52
docs: Table 9.46. UUID Extraction Functions Erik Rijkers 09:54
Re: Improve LWLock tranche name visibility across backends Rahila Syed 09:59
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 09:59
Re: Solaris compiler status 📎 Peter Eisentraut 10:55
MPTCP - multiplexing many TCP connections through one socket to get better bandwidth 📎 Jakub Wartak 10:56
Re: docs: Table 9.46. UUID Extraction Functions Daniel Gustafsson 11:04
Re: Use merge-based matching for MCVs in eqjoinsel Ilia Evdokimov 11:05
Re: Fix replica identity checks for MERGE command on published table. Dean Rasheed 11:07
Re: Generate GUC tables from .dat file Peter Eisentraut 11:10
Re: Avoid retaining conflict-related data when no tables are subscribed Amit Kapila 11:37
Re: Potential problem in commit f777d773878 and 4f7f7b03758 Álvaro Herrera 11:43
Re: Orphan page in _bt_split Konstantin Knizhnik 11:44
Re: NOT NULL NOT ENFORCED Álvaro Herrera 12:00
Re: Potential problem in commit f777d773878 and 4f7f7b03758 Dilip Kumar 12:02
Re: Inconsistent update in the MERGE command 📎 Dean Rasheed 12:50
[PATCH] Referenced generic plan mode 📎 Vlada Pogozhelskaya 13:08
issue with synchronized_standby_slots Fabrice Chapuis 13:26
Re: Improve LWLock tranche name visibility across backends Nathan Bossart 13:51
Re: Solaris compiler status Andres Freund 13:55
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Arseniy Mukhin 14:14
Re: Unexpected changes of CurrentResourceOwner and CurrentMemoryContext Mihail Nikalayeu 14:16
Re: [PATCH] Hex-coding optimizations using SVE on ARM. 📎 Chiranmoy.Bhattacharya@fujitsu.com 14:55
Re: How can end users know the cause of LR slot sync delays? 📎 Shlok Kyal 14:56
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Jim Jones 14:58
Re: Inconsistent update in the MERGE command Yugo Nagata 15:03
Incorrect checksum in control file with pg_rewind test 📎 Maksim.Melnikov 15:18
Re: NOT NULL NOT ENFORCED 📎 jian he 15:20
Re: Improve LWLock tranche name visibility across backends 📎 Nathan Bossart 15:44
Re: Vacuum statistics 📎 Alena Rybakina 15:49
Re: [PG19-3 PATCH] Don't ignore passfile Tom Lane 15:56
PgStat_HashKey padding issue when passed by reference 📎 Sami Imseih 16:14
pg_recvlogical: Prevent flushed data from being re-sent after restarting replication 📎 Fujii Masao 16:16
Re: Vacuum statistics Alena Rybakina 16:18
Re: Solaris compiler status Tom Lane 16:29
Re: PgStat_HashKey padding issue when passed by reference Sami Imseih 16:32
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Fujii Masao 16:42
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Fujii Masao 16:44
Re: PgStat_HashKey padding issue when passed by reference Andres Freund 16:45
Re: PgStat_HashKey padding issue when passed by reference Sami Imseih 16:50
Re: Logical Replication of sequences 📎 vignesh C 16:50
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock Andres Freund 16:59
Re: [PATCH] ternary reloption type 📎 Nikolay Shaplov 17:07
Re: PgStat_HashKey padding issue when passed by reference Ranier Vilela 17:07
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock Greg Burd 17:24
Re: Improve LWLock tranche name visibility across backends Sami Imseih 17:30
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Tom Lane 17:40
Re: PgStat_HashKey padding issue when passed by reference Sami Imseih 17:56
Allow using replication origins in SQL level parallel sessions 📎 Emre Hasegeli 18:02
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 18:15
Re: GetNamedLWLockTranche crashes on Windows in normal backend Sami Imseih 18:23
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Tom Lane 18:24
Re: GetNamedLWLockTranche crashes on Windows in normal backend Nathan Bossart 18:41
Re: index prefetching Tomas Vondra 18:55
Re: Stack-based tracking of per-node WAL/buffer usage Andres Freund 20:23
Re: Improve LWLock tranche name visibility across backends Nathan Bossart 20:37
Re: GetNamedLWLockTranche crashes on Windows in normal backend 📎 Sami Imseih 21:12
--with-llvm on 32-bit platforms? Dmitry Mityugov 21:32
Re: Logical Replication of sequences Masahiko Sawada 21:34
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters 📎 Tom Lane 21:52
Fix race condition in SSI when reading PredXact->SxactGlobalXmin 📎 Josh Curtis 22:09
Re: Logical Replication of sequences Masahiko Sawada 22:30
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput 📎 Rishu Bagga 22:53
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Rishu Bagga 23:02
Re: Refactoring: Use soft error reporting for *_opt_error functions Michael Paquier 23:10
Re: [PG19-3 PATCH] Don't ignore passfile Paul Ohlhauser 23:22

Sept. 5, 2025

Thread Author Time
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Mihail Nikalayeu 00:25
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible 📎 Nathan Bossart 01:23
Re: GetNamedLWLockTranche crashes on Windows in normal backend Nathan Bossart 01:35
Re: Update outdated references to SLRU ControlLock 📎 Julien Rouhaud 01:47
Re: [PATCH] Add tests for Bitmapset Nathan Bossart 02:00
Allow logical replication in the same cluster 📎 Chao Li 02:50
RE: Resetting recovery target parameters in pg_createsubscriber Hayato Kuroda (Fujitsu) 02:55
RE: issue with synchronized_standby_slots Zhijie Hou (Fujitsu) 04:07
Re: Refactoring: Use soft error reporting for *_opt_error functions Michael Paquier 04:58
Re: Update outdated references to SLRU ControlLock Michael Paquier 05:11
Re: Refactoring: Use soft error reporting for *_opt_error functions Amul Sul 05:12
pg_dump, pg_dumpall, pg_restore HELP progname descrption of "--no-table-access-method" is wrong? jian he 05:13
Appetite for syntactic sugar to match result set columns to UDT fields? Philip Warner 05:31
Re: Update outdated references to SLRU ControlLock Julien Rouhaud 05:41
Re: Logical Replication of sequences 📎 vignesh C 05:49
Appetite for syntactic sugar to match result set columns to UDT fields? David G. Johnston 05:50
Re: Resetting recovery target parameters in pg_createsubscriber 📎 Alyona Vinter 05:51
Re: Appetite for syntactic sugar to match result set columns to UDT fields? Tom Lane 05:54
Re: Conflict detection for update_deleted in logical replication shveta malik 06:01
Fix inconsistencies with code and beautify xlog structures description and fin hash_xlog.h 📎 Kirill Reshke 06:17
Re: Fix inconsistencies with code and beautify xlog structures description and fin hash_xlog.h 📎 Kirill Reshke 06:24
Re: Skipping schema changes in publication 📎 Shlok Kyal 06:27
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Michael Paquier 06:35
Differential Code Coverage report for Postgres Nazir Bilal Yavuz 07:09
Re: How can end users know the cause of LR slot sync delays? Ashutosh Sharma 07:19
Re: Appetite for syntactic sugar to match result set columns to UDT fields? Philip Warner 07:22
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters Jim Jones 07:33
Re: Eager aggregation, take 3 📎 Richard Guo 07:35
Re: Inconsistent update in the MERGE command Dean Rasheed 07:47
Re: --with-llvm on 32-bit platforms? Dmitry Mityugov 08:11
Re: Logical Replication of sequences Chao Li 08:24
Re: Fix inconsistencies with code and beautify xlog structures description and fin hash_xlog.h Chao Li 08:29
Re: Fix inconsistencies with code and beautify xlog structures description and fin hash_xlog.h Chao Li 08:35
Re: MergeAppend could consider sorting cheapest child path 📎 Andrei Lepikhov 08:45
Re: Raw parse tree is not dumped to log 📎 Chao Li 08:56
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters 📎 Andrei Klychkov 09:08
Re: Logical Replication of sequences vignesh C 09:16
Re: When deleting the plpgsql function, release the CachedPlan of the function 📎 zengman 09:20
Re: Parallel Apply Dilip Kumar 09:29
RE: Avoid retaining conflict-related data when no tables are subscribed 📎 Zhijie Hou (Fujitsu) 09:30
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Joel Jacobson 09:38
Re: Remove traces of long in dynahash.c Dean Rasheed 09:40
Re: Raw parse tree is not dumped to log Tatsuo Ishii 10:06
回复: Differential Code Coverage report for Postgres Oreo Yang 10:39
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Matheus Alcantara 10:44
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Matheus Alcantara 10:45
Re: Parallel Apply Amit Kapila 11:14
Re: Logical Replication of sequences Amit Kapila 11:20
Re: Allow using replication origins in SQL level parallel sessions Amit Kapila 11:25
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring Ashutosh Bapat 11:27
Re: pull-up subquery if JOIN-ON contains refs to upper-query 📎 Alena Rybakina 11:31
Re: --with-llvm on 32-bit platforms? Dmitry Mityugov 11:32
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 11:33
Re: Parallel Apply Mihail Nikalayeu 11:44
Re: Raw parse tree is not dumped to log Chao Li 12:22
Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt Peter Eisentraut 12:30
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Arseniy Mukhin 12:56
Re: Eager aggregation, take 3 Robert Haas 13:09
Re: Eager aggregation, take 3 Robert Haas 13:12
[PATCH] Update parser README to include parse_jsontable.c 📎 Karthik 13:19
Re: Improve pg_sync_replication_slots() to wait for primary to advance Ashutosh Bapat 13:21
Re: Use merge-based matching for MCVs in eqjoinsel David Geier 14:03
Re: Appetite for syntactic sugar to match result set columns to UDT fields? Tom Lane 14:08
Only one version can be installed when using extension_control_path Pierrick 14:22
Re: Differential Code Coverage report for Postgres Nazir Bilal Yavuz 14:23
Re: Eager aggregation, take 3 Robert Haas 14:37
Re: [PATCH] Add tests for Bitmapset Burd, Greg 14:48
Re: Eager aggregation, take 3 Robert Haas 14:50
Re: Differential Code Coverage report for Postgres Jacob Champion 15:14
Re: Differential Code Coverage report for Postgres Andres Freund 15:14
Re: plan shape work Robert Haas 15:51
Re: plan shape work Tom Lane 16:00
Re: Differential Code Coverage report for Postgres Nazir Bilal Yavuz 16:22
Re: Differential Code Coverage report for Postgres Nazir Bilal Yavuz 16:23
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock Andres Freund 16:27
Re: plan shape work Robert Haas 16:40
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Arseniy Mukhin 17:31
Re: plan shape work 📎 Robert Haas 17:38
Re: [PG19-3 PATCH] Don't ignore passfile Robert Haas 18:02
Re: Improve pg_sync_replication_slots() to wait for primary to advance Ashutosh Sharma 18:09
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible 📎 Nathan Bossart 18:12
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock Greg Burd 18:26
Re: Improve pg_sync_replication_slots() to wait for primary to advance Ashutosh Sharma 18:34
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock Robert Haas 18:36
Re: [PATCH] Add tests for Bitmapset Nathan Bossart 18:43
Re: Differential Code Coverage report for Postgres Álvaro Herrera 19:14
Re: NOT NULL NOT ENFORCED Álvaro Herrera 19:23
Re: Differential Code Coverage report for Postgres Nazir Bilal Yavuz 20:12
Re: RFC: extensible planner state Robert Haas 20:19
Re: Should io_method=worker remain the default? 📎 Jeff Davis 20:25
Re: 回复: Fix segfault while accessing half-initialized hash table in pgstat_shmem.c Mikhail Kot 20:46
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters 📎 Tom Lane 21:06
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Masahiko Sawada 22:15
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 📎 Melanie Plageman 22:20
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) Melanie Plageman 22:27
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 22:27
Re: Raw parse tree is not dumped to log Tatsuo Ishii 22:58
Re: Should io_method=worker remain the default? 📎 Jeff Davis 23:07
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Masahiko Sawada 23:21

Sept. 6, 2025

Thread Author Time
Re: Extension security improvement: Add support for extensions with an owned schema Julien Rouhaud 00:17

Browse Archives

Prev | Next