pgsql-hackers since 2026-01-31 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

Jan. 31, 2026

Thread Author Time
Re: index prefetching 📎 Peter Geoghegan 00:18
Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement 📎 Mark Wong 00:27
Re: Document NULL 📎 David G. Johnston 01:23
Re: Flush some statistics within running transactions Sami Imseih 01:33
Re: More speedups for tuple deformation John Naylor 02:47
Re: Change default of jit to off wenhui qiu 03:02
Re: More speedups for tuple deformation David Rowley 03:44
pg_dumpall --roles-only interact with other options jian he 03:50
Re: AIX support Michael Paquier 04:31
Re: Decoupling our alignment assumptions about int64 and double Tom Lane 04:46
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 📎 Kirill Reshke 05:09
Re: More speedups for tuple deformation John Naylor 06:01
slow SELECT expr INTO var in plpgsql Pavel Stehule 06:52
Re: Improvements and refactoring in shmem.c Ashutosh Bapat 08:59
splitting pg_resetwal output strings 📎 Álvaro Herrera 09:41
Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jelte Fennema-Nio 11:06
Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jelte Fennema-Nio 11:13
Re: Is there value in having optimizer stats for joins/foreignkeys? Andrei Lepikhov 11:18
Re: More speedups for tuple deformation 📎 David Rowley 11:27
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Matthias van de Meent 12:10
Re: ABI Compliance Checker GSoC Project David E. Wheeler 14:15
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part David E. Wheeler 14:44
Re: splitting pg_resetwal output strings 📎 Álvaro Herrera 15:08
Re: ABI Compliance Checker GSoC Project Tom Lane 15:54
Re: Speed up COPY FROM text/CSV parsing using SIMD 📎 KAZAR Ayoub 16:20
Re: pg_dumpall --roles-only interact with other options Nathan Bossart 16:21
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 📎 Florents Tselai 16:23
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part David E. Wheeler 16:31
Re: ABI Compliance Checker GSoC Project David E. Wheeler 16:32
Re: ABI Compliance Checker GSoC Project David E. Wheeler 16:35
Re: Flush some statistics within running transactions Sami Imseih 17:16
Re: using index to speedup add not null constraints to a table Álvaro Herrera 17:20
Re: Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect Alexander Lakhin 18:00
Re: IO wait events for COPY FROM/TO PROGRAM or file 📎 Nikolay Samokhvalov 19:51
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎 Lukas Fittl 20:11
Re: slow SELECT expr INTO var in plpgsql 📎 Tom Lane 20:58
Re: Add --system-identifier / -s option to pg_resetwal 📎 Nikolay Samokhvalov 21:33
Re: V18 change on EXPLAIN ANALYZE 📎 Maciek Sakrejda 22:55
Re: amcheck: support for GiST Nikolay Samokhvalov 23:32

Feb. 1, 2026

Thread Author Time
Re: Additional message in pg_terminate_backend 📎 Jim Jones 00:08
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎 Lukas Fittl 03:14
Re: slow SELECT expr INTO var in plpgsql Pavel Stehule 05:09
Re: Wake up backends immediately when sync standbys decrease 📎 Shinya Kato 06:24
Re: Optimize CPU usage of dropping buffers during recovery 📎 Jingtang Zhang 08:20
Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types Tatsuya Kawata 09:09
New access method for b-tree. 📎 Alexandre Felipe 10:02
Re: Patch: Add tsmatch JSONPath operator for granular Full Text Search 📎 Florents Tselai 11:02
Re: Additional message in pg_terminate_backend Jim Jones 13:58
Re: Improving tracking/processing of buildfarm test failures Alexander Lakhin 14:00
[PATCH] Fix error message in RemoveWalSummaryIfOlderThan to indicate file removal failure 📎 zengman 14:43
Re: Batching in executor Junwang Zhao 14:49
Re: [PATCH] Fix error message in RemoveWalSummaryIfOlderThan to indicate file removal failure Junwang Zhao 14:55
Re: Document NULL Junwang Zhao 15:11
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part David E. Wheeler 15:23
Re: Is there value in having optimizer stats for joins/foreignkeys? Tomas Vondra 16:19
Re: Is there value in having optimizer stats for joins/foreignkeys? Tomas Vondra 16:32
Re: Is there value in having optimizer stats for joins/foreignkeys? Tomas Vondra 16:39
Re: Is there value in having optimizer stats for joins/foreignkeys? Tomas Vondra 16:48
Re: Document NULL Marcos Pegoraro 17:09
Re: Decoupling our alignment assumptions about int64 and double Tom Lane 18:20
Re: Adding REPACK [concurrently] 📎 Mihail Nikalayeu 19:46
Re: Exit walsender before confirming remote flush in logical replication 📎 Andrey Silitskiy 19:52
Re: Adding REPACK [concurrently] Alvaro Herrera 22:31
Re: Adding REPACK [concurrently] Mihail Nikalayeu 22:37
Re: Wake up backends immediately when sync standbys decrease Chao Li 22:44
Re: [Proposal] Adding Log File Capability to pg_createsubscriber 📎 Gyan Sreejith 23:05
Re: New access method for b-tree. Tomas Vondra 23:54
Re: AIX support Michael Paquier 23:54

Feb. 2, 2026

Thread Author Time
Re: [PATCH] Fix error message in RemoveWalSummaryIfOlderThan to indicate file removal failure Michael Paquier 00:12
Re: Add expressions to pg_restore_extended_stats() 📎 Corey Huinker 00:39
relkind as an enum 📎 Álvaro Herrera 00:42
Re: AIX support Tom Lane 01:03
Re: Is there value in having optimizer stats for joins/foreignkeys? Corey Huinker 01:41
Re: BUG: Cascading standby fails to reconnect after falling back to archive recovery Xuneng Zhou 02:16
Re: AIX support 📎 Tom Lane 02:18
Re: relkind as an enum Chao Li 02:26
Re: Wake up backends immediately when sync standbys decrease Xuneng Zhou 02:28
Re: Re: A out of date comment of WaitForWALToBecomeAvailable Xuneng Zhou 02:37
Re: relkind as an enum Tom Lane 02:41
Re: [PATCH] Fix error message in RemoveWalSummaryIfOlderThan to indicate file removal failure zengman 03:02
Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting 📎 Xuneng Zhou 03:16
Re: [PATCH] Fix error message in RemoveWalSummaryIfOlderThan to indicate file removal failure Junwang Zhao 03:26
Re: [PATCH] Fix error message in RemoveWalSummaryIfOlderThan to indicate file removal failure Michael Paquier 03:34
Incorrect errno used in OpenWalSummaryFile() 📎 Michael Paquier 03:54
Re: Non-committer reviews: is it helpful? wenhui qiu 03:58
Re: splitting pg_resetwal output strings Chao Li 03:58
Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types 📎 Chengpeng Yan 04:05
Re: Incorrect errno used in OpenWalSummaryFile() Chao Li 04:07
Re: [PATCH] Fix error message in RemoveWalSummaryIfOlderThan to indicate file removal failure zengman 04:15
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 📎 Peter Smith 04:44
RE: logical apply worker's lock waits in subscriber can stall checkpointer in publisher Hayato Kuroda (Fujitsu) 04:50
Re: Skipping schema changes in publication shveta malik 05:31
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote 📎 Mahendra Singh Thalor 05:50
Re: Skipping schema changes in publication Peter Smith 05:57
Re: Skipping schema changes in publication shveta malik 06:12
walsender: Assert MyReplicationSlot is set before use Chao Li 06:25
Re: Wake up backends immediately when sync standbys decrease Chao Li 06:29
Re: walsender: Assert MyReplicationSlot is set before use vignesh C 06:41
RE: walsender: Assert MyReplicationSlot is set before use Zhijie Hou (Fujitsu) 06:43
Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions 📎 Chao Li 06:47
Re: walsender: Assert MyReplicationSlot is set before use 📎 Chao Li 06:49
use the malloc macros in pg_dump.c 📎 Peter Smith 07:04
Re: Add expressions to pg_restore_extended_stats() Michael Paquier 07:11
Re: walsender: Assert MyReplicationSlot is set before use Chao Li 07:15
Re: Row pattern recognition 📎 Tatsuo Ishii 07:20
Re: Adding REPACK [concurrently] Antonin Houska 07:25
RE: Improve pg_sync_replication_slots() to wait for primary to advance 📎 Zhijie Hou (Fujitsu) 07:26
RE: Improve pg_sync_replication_slots() to wait for primary to advance Zhijie Hou (Fujitsu) 07:27
Re: Flush some statistics within running transactions Michael Paquier 07:31
Re: IO wait events for COPY FROM/TO PROGRAM or file Michael Paquier 07:35
RE: walsender: Assert MyReplicationSlot is set before use Zhijie Hou (Fujitsu) 07:37
Re: walsender: Assert MyReplicationSlot is set before use Chao Li 07:47
Re: Exit walsender before confirming remote flush in logical replication Michael Paquier 07:55
Re: Add expressions to pg_restore_extended_stats() Corey Huinker 08:21
Re: Report bytes and transactions actually sent downtream 📎 Ashutosh Bapat 08:36
Re: Improve pg_sync_replication_slots() to wait for primary to advance shveta malik 09:10
Re: Adding REPACK [concurrently] Mihail Nikalayeu 09:17
Re: Adding REPACK [concurrently] Mihail Nikalayeu 09:18
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Jakub Wartak 09:22
Re: Hash-based MCV matching for large IN-lists David Geier 09:29
Re: Adding REPACK [concurrently] Antonin Houska 09:35
Re: Is there value in having optimizer stats for joins/foreignkeys? Andrei Lepikhov 09:53
Re: Proposal: Support Logical replication of large objects 📎 Nitin Motiani 10:02
Re: Adding REPACK [concurrently] Mihail Nikalayeu 10:04
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Álvaro Herrera 10:54
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Álvaro Herrera 11:16
Re: [PATCH] Add max_logical_replication_slots GUC Ahmed Et-tanany 11:18
Re: Undefined behavior detected by new clang's ubsan 📎 John Naylor 11:30
Re: Skipping schema changes in publication Shlok Kyal 11:48
Re: splitting pg_resetwal output strings Álvaro Herrera 11:50
Re: Exit walsender before confirming remote flush in logical replication Fujii Masao 11:58
Re: logical apply worker's lock waits in subscriber can stall checkpointer in publisher Fujii Masao 12:15
Re: Enhancing Memory Context Statistics Reporting 📎 Rahila Syed 12:28
Re: use the malloc macros in pg_dump.c Aleksander Alekseev 12:38
Re: [PATCH] ANALYZE: hash-accelerate MCV tracking for equality-only types Tatsuya Kawata 13:09
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows 📎 Álvaro Herrera 13:28
RE: AIX support 📎 Aditya Kamath 14:01
Re: Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect 📎 Fujii Masao 14:11
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Tom Lane 14:14
Re: refactor architecture-specific popcount code 📎 John Naylor 14:16
Re: Speed up COPY FROM text/CSV parsing using SIMD Manni Wood 14:17
Re: race condition when writing pg_control 📎 Álvaro Herrera 14:34
Fix pg_stat_get_backend_wait_event() for aux processes 📎 Heikki Linnakangas 14:38
Re: AIX support Tom Lane 15:19
Re: WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts Álvaro Herrera 15:26
Re: jsonb subscripting vs SQL/JSON array accessor semantics (SQL:2023) Andrew Dunstan 15:32
Re: Is there value in having optimizer stats for joins/foreignkeys? Tomas Vondra 15:57
Re: Wake up backends immediately when sync standbys decrease 📎 Fujii Masao 16:03
Re: Support logical replication of DDLs Vitaly Davydov 16:04
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl 16:11
doc: guidance on SQL/JSON functions vs jsonpath operators 📎 Florents Tselai 16:15
Re: display hot standby state in psql prompt Jim Jones 16:17
Re: AIX support Tom Lane 16:18
Re: Pasword expiration warning 📎 Nathan Bossart 17:04
Re: Flush some statistics within running transactions 📎 Bertrand Drouvot 17:16
Re: Flush some statistics within running transactions Bertrand Drouvot 17:19
[patch] Add process title to test_shm_mq worker 📎 Michael Banck 17:31
Re: [patch] Add process title to test_shm_mq worker Nathan Bossart 17:38
Re: Pasword expiration warning Gilles Darold 17:43
Re: Pasword expiration warning Nathan Bossart 17:55
RE: AIX support 📎 Aditya Kamath 18:10
Re: pg_plan_advice Alexandra Wang 19:36
Re: Adding REPACK [concurrently] Antonin Houska 19:39
Re: Pasword expiration warning Zsolt Parragi 20:25
Re: Pasword expiration warning 📎 Nathan Bossart 20:31
Re: Use correct collation in pg_trgm Zsolt Parragi 20:33
Re: Speed up COPY FROM text/CSV parsing using SIMD KAZAR Ayoub 20:45
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Nathan Bossart 20:52
Re: use the malloc macros in pg_dump.c Peter Smith 21:19
Re: Decoupling our alignment assumptions about int64 and double 📎 Tom Lane 21:46
Re: [patch] Add process title to test_shm_mq worker Nathan Bossart 21:46
Re: [patch] Add process title to test_shm_mq worker Michael Banck 22:03
Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jelte Fennema-Nio 22:27
Re: Buffer locking is special (hints, checksums, AIO writes) 📎 Andres Freund 22:33
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) Melanie Plageman 22:47
Re: refactor architecture-specific popcount code Nathan Bossart 22:51
Non-deterministic buffer counts reported in execution with EXPLAIN ANALYZE BUFFERS Radim Marek 22:54
Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta Jacob Champion 23:35
Re: Non-deterministic buffer counts reported in execution with EXPLAIN ANALYZE BUFFERS David Rowley 23:37

Feb. 3, 2026

Thread Author Time
Re: Row pattern recognition 📎 Tatsuo Ishii 00:00
Re: CREATE OR REPLACE MATERIALIZED VIEW Paul A Jungwirth 00:19
Re: More speedups for tuple deformation Andres Freund 00:33
Re: Change default of jit to off Euler Taveira 00:42
Re: Wake up backends immediately when sync standbys decrease Shinya Kato 00:43
Re: [PATCH] Refactor *_abbrev_convert() functions John Naylor 01:07
Re: Add expressions to pg_restore_extended_stats() Michael Paquier 01:40
Re: display hot standby state in psql prompt Fujii Masao 01:42
pg_resetwal: Fix wrong directory in log output 📎 zhang_tian_chen@163.com 01:58
Re: pg_resetwal: Fix wrong directory in log output Michael Paquier 02:04
Re: pg_resetwal: Fix wrong directory in log output Chao Li 02:13
Re: pg_dumpall --roles-only interact with other options 📎 jian he 02:15
Re: Wake up backends immediately when sync standbys decrease Fujii Masao 02:16
Re: Add expressions to pg_restore_extended_stats() 📎 Corey Huinker 02:17
Re: pg_resetwal: Fix wrong directory in log output Kyotaro Horiguchi 02:25
Re: use the malloc macros in pg_dump.c 📎 Peter Smith 02:29
Re: Add expressions to pg_restore_extended_stats() Michael Paquier 02:41
Re: IO wait events for COPY FROM/TO PROGRAM or file Michael Paquier 03:27
Re: Add expressions to pg_restore_extended_stats() Corey Huinker 03:34
Re: walsender: Assert MyReplicationSlot is set before use 📎 Chao Li 03:37
Re: pg_resetwal: Fix wrong directory in log output Chao Li 03:46

Browse Archives

Prev | Next