pgsql-hackers since 2025-10-17 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

Browse Archives

Prev | Next

Oct. 17, 2025

Thread Author Time
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring torikoshia 00:28
Re: bug, ALTER TABLE call ATPostAlterTypeCleanup twice for the same relation Chao Li 01:23
Why cannot alter a column's type when it's used by a generated column Chao Li 02:04
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring 📎 Xuneng Zhou 02:10
Re: Fix an unnecessary cast calling elog in ExecHashJoinImpl Xuneng Zhou 02:31
Re: Optimizing ResouceOwner to speed up COPY Chao Li 03:13
Re: doc: Improve description of io_combine_limit and io_max_combine_limit GUCs Xuneng Zhou 03:17
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Amit Kapila 03:25
Question for coverage report 📎 Hayato Kuroda (Fujitsu) 03:40
RE: Question for coverage report 📎 Hayato Kuroda (Fujitsu) 03:41
Fix lag columns in pg_stat_replication not advancing when replay LSN stalls 📎 Fujii Masao 03:56
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 04:06
Re: Fix an unnecessary cast calling elog in ExecHashJoinImpl 📎 Tender Wang 04:20
Re: Logical Replication of sequences Amit Kapila 04:23
Re: Issue with logical replication slot during switchover shveta malik 04:24
Re: Logical Replication of sequences Amit Kapila 04:31
Re: pg_restore --no-policies should not restore policies' comment Alexander Lakhin 05:00
Re: Extend documentation for pg_stat_replication.backend_xmin Fujii Masao 05:06
Re: Instability of phycodorus in pg_upgrade tests with JIT Fujii Masao 05:21
Re: Question for coverage report Steven Niu 05:22
Re: Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions Michael Paquier 05:41
pg_running_stats - mergeable running statistics (Welford/Chan) extension for postgresql Chanukya SDS 05:55
Re: Fix an unnecessary cast calling elog in ExecHashJoinImpl Chao Li 06:20
Re: Proposal for enabling auto-vectorization for checksum calculations 📎 Andrew Kim 07:15
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 07:17
Re: Question about InvalidatePossiblyObsoleteSlot() Bertrand Drouvot 07:18
Minor spelling fix in memnodes.h 📎 Rafia Sabih 07:39
Re: Preserve index stats during ALTER TABLE ... TYPE ... Bertrand Drouvot 07:45
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls Chao Li 08:11
ci: Skip minfree file in the cores_backtrace.sh 📎 Nazir Bilal Yavuz 08:26
Re: Optimizing ResouceOwner to speed up COPY Heikki Linnakangas 08:31
Re: Executing pg_createsubscriber with a non-compatible control file 📎 Michael Banck 08:32
Re: Logical Replication of sequences shveta malik 08:35
Re: Logical Replication of sequences Amit Kapila 08:50
Re: ci: Skip minfree file in the cores_backtrace.sh Daniel Gustafsson 09:15
Re: Minor spelling fix in memnodes.h David Rowley 09:18
Re: Minor spelling fix in memnodes.h Daniel Gustafsson 09:22
Re: postgres_fdw: Use COPY to speed up batch inserts Jakub Wartak 09:28
Re: Logical Replication of sequences Chao Li 09:34
Re: pg_restore --no-policies should not restore policies' comment Fujii Masao 10:23
Re: Logical Replication of sequences Dilip Kumar 10:27
Re: ci: Skip minfree file in the cores_backtrace.sh Nazir Bilal Yavuz 10:28
Re: pg_restore --no-policies should not restore policies' comment Fujii Masao 10:32
Re: Optimizing ResouceOwner to speed up COPY Tomas Vondra 10:32
Re: Changing shared_buffers without restart Dmitry Dolgov 10:33
Re: Proposal for enabling auto-vectorization for checksum calculations Oleg Tselebrovskiy 10:53
RE: Question for coverage report Hayato Kuroda (Fujitsu) 10:55
Re: Add support for specifying tables in pg_createsubscriber. 📎 Shubham Khanna 11:20
Unused stricture field in xlogreader:DecodedBkpBlock 📎 Mikhail Gribkov 11:37
Re: Unused stricture field in xlogreader:DecodedBkpBlock Nazir Bilal Yavuz 12:06
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 12:07
Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt 📎 Álvaro Herrera 12:13
Re: ci: Skip minfree file in the cores_backtrace.sh Álvaro Herrera 12:25
Re: Inconsistent LSN format in pg_waldump output 📎 Álvaro Herrera 12:26
Re: ci: Skip minfree file in the cores_backtrace.sh Daniel Gustafsson 12:31
Re: ci: Skip minfree file in the cores_backtrace.sh Nazir Bilal Yavuz 12:38
Re: [PATCH] Write Notifications Through WAL Arseniy Mukhin 13:33
Re: ci: Skip minfree file in the cores_backtrace.sh Álvaro Herrera 13:46
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Álvaro Herrera 13:51
Re: anonymous unions (C11) Nathan Bossart 14:23
Getting the SQLSTATE after a failed connection Daniele Varrazzo 14:26
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls 📎 Fujii Masao 14:28
Re: Minor spelling fix in memnodes.h Tom Lane 14:37
Re: Getting the SQLSTATE after a failed connection Tom Lane 14:49
Re: new environment variable INITDB_LOCALE_PROVIDER Peter Eisentraut 15:04
Re: Change initdb default to the builtin collation provider Peter Eisentraut 15:23
Re: make tsearch use the database default locale Peter Eisentraut 16:15
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Tom Lane 16:18
Re: Getting the SQLSTATE after a failed connection Daniele Varrazzo 16:26
Re: Question for coverage report Jacob Champion 16:39
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Tom Lane 16:40
Re: Getting the SQLSTATE after a failed connection Tom Lane 16:53
abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 16:54
Re: Clarification on Role Access Rights to Table Indexes Nathan Bossart 16:56
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 17:15
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Peter Geoghegan 17:22
Re: Getting the SQLSTATE after a failed connection Ranier Vilela 17:28
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Jim Jones 17:37
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Masahiko Sawada 17:38
Re: Question for coverage report Álvaro Herrera 17:46
Re: Getting the SQLSTATE after a failed connection Daniele Varrazzo 18:01
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 18:06
Re: Unused stricture field in xlogreader:DecodedBkpBlock Masahiko Sawada 18:22
Re: Unused stricture field in xlogreader:DecodedBkpBlock Masahiko Sawada 18:31
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Tom Lane 18:41
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 18:45
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Philip Alger 19:07
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() 📎 Nathan Bossart 19:11
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Peter Geoghegan 19:20
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 19:27
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 19:28
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 19:30
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Peter Geoghegan 19:33
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 19:35
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 19:39
Re: Logical Replication of sequences Masahiko Sawada 19:44
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 19:52
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 19:53
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 20:01
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 20:06
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 20:11
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 20:19
pg18: leaks io-uring FDs during restart_after_crash Justin Pryzby 20:29
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎 Arseniy Mukhin 20:50
Re: Fix overflow of nbatch Tomas Vondra 20:51
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 📎 Tom Lane 21:14
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 21:41
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 21:51
Re: Change initdb default to the builtin collation provider Jeff Davis 22:02
Re: Making pg_rewind faster Justin Kwan 22:08
Re: Question about InvalidatePossiblyObsoleteSlot() Masahiko Sawada 22:08
Re: new environment variable INITDB_LOCALE_PROVIDER Jeff Davis 22:23
Re: Optimizing ResouceOwner to speed up COPY 📎 Tomas Vondra 22:49
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 22:51
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 23:07
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Jim Jones 23:44
Re: Minor spelling fix in memnodes.h David Rowley 23:51
Re: Executing pg_createsubscriber with a non-compatible control file Michael Paquier 23:55

Oct. 18, 2025

Thread Author Time
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls Chao Li 00:16
Re: Logical Replication of sequences Masahiko Sawada 01:24
Re: Use opresulttype instead of calling SearchSysCache1() in match_orclause_to_indexcol() 📎 Tender Wang 03:12
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement 📎 Philip Alger 04:08
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Joel Jacobson 05:43
Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array 📎 Xuneng Zhou 07:49
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array Kirill Reshke 08:59
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring Tomas Vondra 11:17
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() 📎 Mankirat Singh 13:04
Re: Making pg_rewind faster Srinath Reddy Sadipiralla 14:17
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 15:14
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Jim Jones 15:19
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 15:46
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 15:47
Re: Making pg_rewind faster Srinath Reddy Sadipiralla 16:04
Re: Optimize LISTEN/NOTIFY Arseniy Mukhin 16:41
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Marcos Pegoraro 17:01
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls Shinya Kato 17:04
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Philip Alger 18:22
[PATCH] Fix POSIX compliance in pgwin32_unsetenv() 📎 Bryan Green 18:26
Re: Speed up COPY FROM text/CSV parsing using SIMD KAZAR Ayoub 18:46
Re: Speed up COPY FROM text/CSV parsing using SIMD Nazir Bilal Yavuz 20:01
Re: Speed up COPY FROM text/CSV parsing using SIMD Nazir Bilal Yavuz 20:01
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Mankirat Singh 20:48
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Marcos Pegoraro 20:55
Re: A tidyup of pathkeys.c David Rowley 21:15
Re: Proposal for enabling auto-vectorization for checksum calculations 📎 Andrew Kim 21:30
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement 📎 Philip Alger 21:34

Oct. 19, 2025

Thread Author Time
Re: Extended Statistics set/restore/clear functions. 📎 Corey Huinker 00:27
Re: make tsearch use the database default locale 📎 Jeff Davis 00:29
Re: Import Statistics in postgres_fdw before resorting to sampling. 📎 Corey Huinker 00:32
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 00:38
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 01:02
gzgetc() is hazardous to your health Tom Lane 04:06
BRIN: Prevent the heapblk overflow during index summarization on very large tables resulting in an infinite loop 📎 sunil s 06:03
Re: BRIN: Prevent the heapblk overflow during index summarization on very large tables resulting in an infinite loop David Rowley 08:52
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 09:53
Re: FSM doesn't recover after zeroing damaged page. Álvaro Herrera 10:43
Re: Accessing an invalid pointer in BufferManagerRelation structure 📎 Álvaro Herrera 11:32
Re: Suggestion to add --continue-client-on-abort option to pgbench 📎 Rintaro Ikeda 13:12
isolation tester limitation in case of multiple injection points in a single command Mihail Nikalayeu 13:41
[PROPOSAL] Platform-native resource usage stats for Windows 📎 Bryan Green 15:58
Re: gzgetc() is hazardous to your health Tom Lane 16:57
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎 Joel Jacobson 17:14
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎 Álvaro Herrera 18:16
Re: [PATCH] random_normal function David E. Wheeler 18:58
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement Philip Alger 19:30
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 20:37
Re: Optimize LISTEN/NOTIFY 📎 Joel Jacobson 22:06
Re: Optimize LISTEN/NOTIFY 📎 Joel Jacobson 22:10

Oct. 20, 2025

Thread Author Time
Re: isolation tester limitation in case of multiple injection points in a single command Michael Paquier 00:50
Re: Executing pg_createsubscriber with a non-compatible control file Michael Paquier 00:54
Re: [PATCH] Fix POSIX compliance in pgwin32_unsetenv() Michael Paquier 01:02
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls Fujii Masao 01:12
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls 📎 Fujii Masao 01:17
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls Fujii Masao 01:20
Re: [PATCH] Fix POSIX compliance in pgwin32_unsetenv() Bryan Green 01:34
Re: get rid of RM_HEAP2_ID Michael Paquier 01:36
Re: Preserve index stats during ALTER TABLE ... TYPE ... Michael Paquier 01:53
Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Peter Smith 02:01
Re: IO in wrong state on riscv64 Thomas Munro 02:05
Re: pg_restore --no-policies should not restore policies' comment Fujii Masao 02:47
Re: Logical Replication of sequences Chao Li 02:52
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array 📎 Xuneng Zhou 03:12
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Chao Li 03:22
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array Kirill Reshke 03:36
Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt jian he 03:41
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 03:58
Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Michael Paquier 04:32
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls Shinya Kato 04:45
Question on ThrowErrorData 正华吕 04:46
Use CompactAttribute more often, when possible 📎 David Rowley 04:46
Re: Optimize LISTEN/NOTIFY 📎 Joel Jacobson 05:12
Re: Question about InvalidatePossiblyObsoleteSlot() Bertrand Drouvot 06:11
Re: Preserve index stats during ALTER TABLE ... TYPE ... Bertrand Drouvot 06:22
Re: using index to speedup add not null constraints to a table 📎 jian he 06:26
Re: Import Statistics in postgres_fdw before resorting to sampling. Michael Paquier 06:45
Re: Preserve index stats during ALTER TABLE ... TYPE ... Michael Paquier 06:53
Channel binding for post-quantum cryptography 📎 Filip Janus 07:12
Re: Should we say "wal_level = logical" instead of "wal_level >= logical" 📎 Peter Smith 07:19
Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt Álvaro Herrera 07:31
Clarification on pg_dump behavior for security labels and policies on extension objects Fujii Masao 07:45

Browse Archives

Prev | Next