pgsql-hackers since 2025-10-18 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. 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
Re: Why cannot alter a column's type when it's used by a generated column 📎 jian he 07:51
Re: Channel binding for post-quantum cryptography Michael Paquier 08:06
Re: Import Statistics in postgres_fdw before resorting to sampling. Michael Paquier 08:07
Re: [PATCH] Add Windows support for backtrace_functions (MSVC only) Jakub Wartak 08:10
Re: Use CompactAttribute more often, when possible Michael Paquier 08:15
Re: Use CompactAttribute more often, when possible 📎 Chao Li 08:34
Re: Executing pg_createsubscriber with a non-compatible control file Michael Banck 08:35
Re: Random pg_upgrade 004_subscription test failure on drongo Michael Paquier 08:38
Re: [PATCH] Add Windows support for backtrace_functions (MSVC only) Michael Paquier 08:40
Re: Use CompactAttribute more often, when possible David Rowley 08:43
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array 📎 Xuneng Zhou 08:46
Re: Use CompactAttribute more often, when possible David Rowley 08:49
RE: How can end users know the cause of LR slot sync delays? Hayato Kuroda (Fujitsu) 08:57
Re: Use CompactAttribute more often, when possible Álvaro Herrera 09:13
Re: [PATCH] Add Windows support for backtrace_functions (MSVC only) Jakub Wartak 09:18
Re: doc: create table improvements Laurenz Albe 09:23
RE: Logical Replication of sequences 📎 Zhijie Hou (Fujitsu) 09:31
RE: Logical Replication of sequences Zhijie Hou (Fujitsu) 09:31
RE: Logical Replication of sequences Zhijie Hou (Fujitsu) 09:32
Re: Use CompactAttribute more often, when possible 📎 Chao Li 09:33
Re: Proposal: Adding compression of temporary files Álvaro Herrera 09:36
Re: BRIN: Prevent the heapblk overflow during index summarization on very large tables resulting in an infinite loop 📎 sunil s 09:41
formatting.c cleanup 📎 Peter Eisentraut 09:50
Re: Use CompactAttribute more often, when possible David Rowley 10:03
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array Kirill Reshke 10:06
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array Xuneng Zhou 11:08
Re: PATCH for BUG #18785: Pointer bmr.rel, dereferenced by passing as 1st parameter to function is checked for NULL later Nikolay Shaplov 11:14
Re: doc: create table improvements David G. Johnston 11:41
Re: Proposal: Adding compression of temporary files Filip Janus 11:53
RE: Logical Replication of sequences 📎 Hayato Kuroda (Fujitsu) 11:59
Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt jian he 12:03
Re: Question on ThrowErrorData Tom Lane 12:05
Re: RFC: Logging plan of the running query 📎 torikoshia 12:15
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎 Matheus Alcantara 12:37
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Matheus Alcantara 12:41
Re: Question on ThrowErrorData Zhenghua Lyu 13:04
Re: formatting.c cleanup Chao Li 13:31
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 📎 Richard Guo 13:32
Re: Docs and tests for RLS policies applied by command type 📎 Viktor Holmberg 14:02
Re: Speed up COPY FROM text/CSV parsing using SIMD Andrew Dunstan 14:02
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Tom Lane 14:15
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Álvaro Herrera 14:18
Re: Add \pset options for boolean value display 📎 Álvaro Herrera 14:24
Re: pg_waldump: support decoding of WAL inside tarfile Robert Haas 14:34
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 14:39
Re: Proposal for enabling auto-vectorization for checksum calculations Oleg Tselebrovskiy 15:05
Re: Should we say "wal_level = logical" instead of "wal_level >= logical" Robert Haas 15:11
Re: misleading error message in ProcessUtilitySlow T_CreateStatsStmt Álvaro Herrera 15:29
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 15:36
Re: Docs and tests for RLS policies applied by command type 📎 Viktor Holmberg 16:00
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 📎 Tom Lane 16:27
Re: Optimize LISTEN/NOTIFY 📎 Arseniy Mukhin 16:43
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() 📎 Nathan Bossart 16:46
Re: Speed up COPY FROM text/CSV parsing using SIMD Nathan Bossart 17:04
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 17:07
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 17:14
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Matheus Alcantara 18:19
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() 📎 Nathan Bossart 18:30
Skip unregistered custom kinds on stats load 📎 Sami Imseih 18:39
[PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward 📎 Dimitrios Apostolou 18:40
Re: Accessing an invalid pointer in BufferManagerRelation structure Daniil Davydov 19:03
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎 Mihail Nikalayeu 19:27
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 19:33
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Robert Haas 19:55
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Robert Haas 19:59
Re: speedup COPY TO for partitioned table. Masahiko Sawada 20:06
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Tom Lane 20:14
Re: Speed up COPY FROM text/CSV parsing using SIMD Andrew Dunstan 20:31
Client-only Meson Build From Sources Benjamin Leff 20:43
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward Dimitrios Apostolou 20:50
Re: Add \pset options for boolean value display David G. Johnston 20:51
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() Nathan Bossart 20:52
Can we make pg_strcasecmp(), pg_tolower(), pg_toupper() plain ASCII semantics? 📎 Jeff Davis 21:02
Re: Add \pset options for boolean value display Álvaro Herrera 21:08
Re: Speed up COPY FROM text/CSV parsing using SIMD Nazir Bilal Yavuz 21:09
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward Dimitrios Apostolou 21:12
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 21:18
Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward Tom Lane 21:21
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 21:22
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward Tom Lane 21:29
Re: Fix race condition in SSI when reading PredXact->SxactGlobalXmin Mihail Nikalayeu 21:30
Re: abi-compliance-check failure due to recent changes to pg_{clear,restore}_{attribute,relation}_stats() David E. Wheeler 21:39
Re: Making pg_rewind faster John H 22:03
Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward Dimitrios Apostolou 22:09
Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward Tom Lane 22:15
Re: Logical Replication of sequences Masahiko Sawada 22:18
Re: [PATCH v4] parallel pg_restore: avoid disk seeks when jumping short distance forward Tom Lane 22:23
Re: isolation tester limitation in case of multiple injection points in a single command Mihail Nikalayeu 22:26
Re: [PATCH] Fix POSIX compliance in pgwin32_unsetenv() Michael Paquier 23:11
Re: Skip unregistered custom kinds on stats load Michael Paquier 23:23
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array Michael Paquier 23:31
Re: Fix lag columns in pg_stat_replication not advancing when replay LSN stalls Fujii Masao 23:44

Oct. 21, 2025

Thread Author Time
Re: Skip unregistered custom kinds on stats load Sami Imseih 00:54
Re: Fix race condition in SSI when reading PredXact->SxactGlobalXmin Mihail Nikalayeu 00:55
Re: Suggestion to add --continue-client-on-abort option to pgbench Fujii Masao 00:58
Re: Skip unregistered custom kinds on stats load Sami Imseih 01:16
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue Masahiko Sawada 01:31
Re: Skip unregistered custom kinds on stats load Michael Paquier 01:36
Re: Add \pset options for boolean value display Chao Li 01:38
Re: [PATCH] Remove make_temptable_name_n() Shinya Kato 01:42
Re: Add \pset options for boolean value display David G. Johnston 02:29
Re: Add \pset options for boolean value display David G. Johnston 02:48
Re: Add \pset options for boolean value display Chao Li 02:51
Re: BRIN: Prevent the heapblk overflow during index summarization on very large tables resulting in an infinite loop Michael Paquier 02:55
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master 📎 Richard Guo 03:16
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Tom Lane 03:26
Re: Proposal for enabling auto-vectorization for checksum calculations John Naylor 03:30
Re: Add \pset options for boolean value display Tom Lane 03:37
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Richard Guo 03:58
Re: remove unnecessary include in src/backend/commands/policy.c 📎 jian he 04:00
Re: Logical Replication of sequences shveta malik 04:03
Re: Eliminating SPI / SQL from some RI triggers - take 3 Amit Langote 04:07
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Richard Guo 04:12
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Tom Lane 04:18
Re: Making pg_rewind faster Srinath Reddy Sadipiralla 04:36
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array Kirill Reshke 05:04
Re: Eliminating SPI / SQL from some RI triggers - take 3 Pavel Stehule 05:10
Re: Inconsistent Behavior of GROUP BY ROLLUP in v17 vs master Richard Guo 05:26

Browse Archives

Prev | Next