pgsql-hackers since 2026-01-26 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. 26, 2026

Thread	Author	Time
Re: Some tests for TOAST, STORAGE MAIN/EXTENDED	Michael Paquier	00:33
Re: [PATCH] Avoid potential NULL dereference in LIKE/ILIKE with C locale	Neil Chen	00:41
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY	Mihail Nikalayeu	01:09
Re: unnecessary executor overheads around seqscans	David Rowley	01:32
Re: [Proposal] Adding Log File Capability to pg_createsubscriber 📎	Gyan Sreejith	01:38
Re: [PATCH] Replace COUNT(NULL) with '0'::bigint	Junwang Zhao	02:41
Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions 📎	Chao Li	02:51
Re: unnecessary executor overheads around seqscans	David Rowley	03:03
RE: Newly created replication slot may be invalidated by checkpoint 📎	Zhijie Hou (Fujitsu)	03:03
Some questions about JIT optimization	ywgrit	03:11
Re:Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT	ocean_li_996	03:18
Re: Some questions about JIT optimization	David Rowley	03:35
Re: docs: clarify ALTER TABLE behavior on partitioned tables 📎	Chao Li	04:15
Re: docs: clarify ALTER TABLE behavior on partitioned tables	Chao Li	04:16
Re: docs: clarify ALTER TABLE behavior on partitioned tables	David G. Johnston	04:36
Re: docs: clarify ALTER TABLE behavior on partitioned tables	Chao Li	05:13
[BUG#19384] Fix Server crash at textout 📎	vaibhave postgres	05:16
docs: warn about post-data-only schema dumps with parallel restore. 📎	vaibhave postgres	05:23
RE: Newly created replication slot may be invalidated by checkpoint	Hayato Kuroda (Fujitsu)	05:35
Re: docs: clarify ALTER TABLE behavior on partitioned tables	David G. Johnston	05:38
Re: Flush some statistics within running transactions 📎	Bertrand Drouvot	06:59
Re: tablecmds: reject CLUSTER ON for partitioned tables earlier 📎	Chao Li	07:10
Re: docs: clarify ALTER TABLE behavior on partitioned tables 📎	Chao Li	07:20
Re: Adding REPACK [concurrently]	Antonin Houska	07:34
Re: Flush some statistics within running transactions	Bertrand Drouvot	07:35
Re: Extended Statistics set/restore/clear functions.	Michael Paquier	07:42
Re: unnecessary executor overheads around seqscans	Amit Langote	07:47
Re: support fast default for domain with constraints 📎	jian he	07:52
Re: Optimize IS DISTINCT FROM with non-nullable inputs 📎	Richard Guo	08:00
Re: Safer hash table initialization macro	Bertrand Drouvot	08:41
Re: unclear OAuth error message	Zsolt Parragi	08:53
Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions	Chao Li	08:56
Re: Batching in executor	Amit Langote	09:01
Re: alignas (C11)	Peter Eisentraut	09:34
Re: Batching in executor	Daniil Davydov	09:34
Re: Newly created replication slot may be invalidated by checkpoint	Chao Li	09:35
pg_stat_io_histogram 📎	Jakub Wartak	09:40
Re: Custom oauth validator options	Zsolt Parragi	09:51
Re: Is abort() still needed in WalSndShutdown()? 📎	Fujii Masao	09:52
Re: Safer hash table initialization macro 📎	Jelte Fennema-Nio	10:05
meson: Make test output much more useful on failure (both in CI and locally) 📎	Jelte Fennema-Nio	10:13
Re: get rid of Pointer type, mostly	Peter Eisentraut	10:20
Re: Safer hash table initialization macro	Bertrand Drouvot	10:26
Re: Make copyObject work in C++	Peter Eisentraut	10:29
Re: Make copyObject work in C++	Jelte Fennema-Nio	10:43
Re: Make copyObject work in C++	Jelte Fennema-Nio	10:47
Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed	David Rowley	10:49
Re: Safer hash table initialization macro 📎	Jelte Fennema-Nio	10:50
Re: Bypassing cursors in postgres_fdw to enable parallel plans 📎	Rafia Sabih	11:44
Re: DOCS - "\d mytable" also shows any publications that publish mytable	Fujii Masao	11:49
Re: unnecessary executor overheads around seqscans	Amit Kapila	11:57
Re: [oauth] Stabilize the libpq-oauth ABI (and allow alternative implementations?)	Zsolt Parragi	12:06
rename and move AssertVariableIsOfType 📎	Peter Eisentraut	12:17
Re: AIX support	Peter Eisentraut	12:22
Re: Is abort() still needed in WalSndShutdown()?	Heikki Linnakangas	12:33
Re: Time to drop RADIUS support?	Aleksander Alekseev	13:06
Re: Auto-tune shared_buffers to use available huge pages 📎	Anthonin Bonnefoy	13:16
Re: Use correct collation in pg_trgm	Zsolt Parragi	13:24
Re: Use correct collation in pg_trgm	Alexander Korotkov	13:33
Re: Exit walsender before confirming remote flush in logical replication	Fujii Masao	14:08
Re: Safer hash table initialization macro	Bertrand Drouvot	14:41
Re: docs: clarify ALTER TABLE behavior on partitioned tables	Zsolt Parragi	14:47
RE: AIX support	Srirama Kucherlapati	14:59
Re: pg_stat_io_histogram	Andres Freund	15:08
Re: Fix accidentally cast away qualifiers	Peter Eisentraut	15:09
Re: unnecessary executor overheads around seqscans	Heikki Linnakangas	15:23
Re: meson: Make test output much more useful on failure (both in CI and locally)	Zsolt Parragi	15:36
Re: AIX support	Andres Freund	15:41
Re: refactor architecture-specific popcount code 📎	Nathan Bossart	15:41
Re: pg_plan_advice 📎	Robert Haas	16:07
Re: meson: Make test output much more useful on failure (both in CI and locally)	Andres Freund	16:42
Re: unnecessary executor overheads around seqscans	Andres Freund	17:16
Patch: Add tsmatch JSONPath operator for granular Full Text Search 📎	Florents Tselai	17:22
Re: pg_waldump: support decoding of WAL inside tarfile	Robert Haas	17:22
LLVMJIT: introduce force-inlined functions 📎	Pierre Ducroquet	17:23
Re: tablecmds: reject CLUSTER ON for partitioned tables earlier	Zsolt Parragi	17:26
Re: AIX support	Tom Lane	17:45
Re: meson: Make test output much more useful on failure (both in CI and locally)	Jelte Fennema-Nio	17:46
Re: unnecessary executor overheads around seqscans	Andres Freund	18:08
Re: [BUG] [PATCH] pg_basebackup produces wrong incremental files after relation truncation in segmented tables	Robert Haas	18:14
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎	Álvaro Herrera	20:06
Re: Initial COPY of Logical Replication is too slow 📎	Masahiko Sawada	20:30
Re: pg_upgrade: optimize replication slot caught-up check	Masahiko Sawada	20:31
RepOrigin vs. replorigin	Masahiko Sawada	21:24
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY	Mihail Nikalayeu	21:33
Re: unclear OAuth error message	Jacob Champion	22:17
Re: docs: clarify ALTER TABLE behavior on partitioned tables 📎	Chao Li	22:41
Re: unclear OAuth error message	Jacob Champion	22:43
Re: Cleaning up PREPARE query strings?	Sami Imseih	22:48
Re: tablecmds: reject CLUSTER ON for partitioned tables earlier 📎	Chao Li	23:13
Re: unnecessary executor overheads around seqscans	Andres Freund	23:25
Re: failed NUMA pages inquiry status: Operation not permitted	Tomas Vondra	23:32
Re: pgsql: Implement WAIT FOR command	Heikki Linnakangas	23:33
Re: Parallel CREATE INDEX for GIN indexes	Tomas Vondra	23:33

Jan. 27, 2026

Thread	Author	Time
Re: DOCS - "\d mytable" also shows any publications that publish mytable	Peter Smith	00:59
Re: Implement waiting for wal lsn replay: reloaded 📎	Xuneng Zhou	01:14
RE: Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT	Hayato Kuroda (Fujitsu)	02:17
Re: Optimize IS DISTINCT FROM with non-nullable inputs	Tender Wang	02:32
Re: unnecessary executor overheads around seqscans	Amit Langote	02:39
RE: Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT	Zhijie Hou (Fujitsu)	02:39
Re: Is abort() still needed in WalSndShutdown()?	Fujii Masao	02:58
Re: Batching in executor	Amit Langote	03:00
Re: Proposal: Conflict log history table for Logical Replication	Peter Smith	03:08
Re: Remove PG_MMAP_FLAGS	Ashutosh Bapat	03:12
Re: Fix logical decoding not track transaction during SNAPBUILD_BUILDING_SNAPSHOT	cca5507	03:13
Pgbench: remove synchronous prepare 📎	Dmitrii Bondar	03:34
Re: display hot standby state in psql prompt	Fujii Masao	03:46
Re: Proposal: Conflict log history table for Logical Replication 📎	Dilip Kumar	03:53
Make T_CoalesceExpr executable on a foreign server 📎	p.gilev	04:33
Re: Extended Statistics set/restore/clear functions.	Michael Paquier	04:55
Re: Optional skipping of unchanged relations during ANALYZE?	VASUKI M	05:11
tablecmds: fix bug where index rebuild loses replica identity on partitions 📎	Chao Li	05:13
Re: Import Statistics in postgres_fdw before resorting to sampling.	Ashutosh Bapat	05:47
pgsql: Prevent invalidation of newly synced replication slots.	Amit Kapila	05:56
Fix the race condition for updating slot minimum LSN 📎	Zhijie Hou (Fujitsu)	06:32
Re: failed NUMA pages inquiry status: Operation not permitted	Bertrand Drouvot	06:36
Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions	Michael Paquier	06:56
Re: Unlinking Parallel Hash Join inner batch files sooner 📎	Andrey Borodin	06:59
Re: Remove PG_MMAP_FLAGS	Michael Paquier	07:09
Re: Optimize IS DISTINCT FROM with non-nullable inputs	Richard Guo	07:10
Re: [BUG] Incorrect historic snapshot may be serialized to disk during fast-forwarding	ocean_li_996	07:18
Add pg_stat_recovery system view 📎	Xuneng Zhou	07:23
Re: Fix gistkillitems & add regression test to microvacuum	Andrey Borodin	07:26
Re: Safer hash table initialization macro	Chao Li	07:26
Re: Proposal: Cascade REPLICA IDENTITY changes to leaf partitions	Chao Li	07:28
Re: Add WALRCV_CONNECTING state to walreceiver	Xuneng Zhou	07:31
Re: Some questions about JIT optimization	ywgrit	07:33
Re: tablecmds: fix bug where index rebuild loses replica identity on partitions	Michael Paquier	07:39
Re: tablecmds: reject CLUSTER ON for partitioned tables earlier	Michael Paquier	07:48
Re: pg_plan_advice	Ajay Pal	07:49
Re: tablecmds: fix bug where index rebuild loses replica identity on partitions	Chao Li	07:59
Re: Add SQL/JSON ON MISMATCH clause to JSON_VALUE	Florents Tselai	08:01
Re: Import Statistics in postgres_fdw before resorting to sampling.	Corey Huinker	08:04
Re: Periodic authorization expiration checks using GoAway message 📎	Ajit Awekar	08:19
could not find replacement targetlist entry for attno -6	jian he	08:27
Re: tablecmds: fix bug where index rebuild loses replica identity on partitions 📎	Chao Li	08:30
Re: display hot standby state in psql prompt 📎	Jim Jones	08:36
Re: tablecmds: reject CLUSTER ON for partitioned tables earlier	Zsolt Parragi	08:41
Re: Newly created replication slot may be invalidated by checkpoint	Amit Kapila	08:46
Re: Extended Statistics set/restore/clear functions. 📎	Corey Huinker	08:48
Re: tablecmds: reject CLUSTER ON for partitioned tables earlier	Zsolt Parragi	08:55
Re: Time to add FIDO2 support?	Joel Jacobson	09:35
Re: unnecessary executor overheads around seqscans	Heikki Linnakangas	10:16
Re: Time to add FIDO2 support?	Joel Jacobson	10:23
GSoC 2026: Call for Mentors, Project Ideas and Project Idea Reviews	Andrey Borodin	10:44
Re: GSoC 2026: Call for Mentors, Project Ideas and Project Idea Reviews	Pavlo Golub	10:54
Re: Adding REPACK [concurrently] 📎	Antonin Houska	10:57
Re: RepOrigin vs. replorigin	Amit Kapila	11:02
Re: unnecessary executor overheads around seqscans 📎	Dilip Kumar	11:10
Re: Time to add FIDO2 support?	Zsolt Parragi	11:10
logical apply worker's lock waits in subscriber can stall checkpointer in publisher	Fujii Masao	11:32
Re: could not find replacement targetlist entry for attno -6	Dean Rasheed	11:55
Re: pg_upgrade: optimize replication slot caught-up check	Amit Kapila	11:59
Re: pg_stat_io_histogram 📎	Jakub Wartak	12:06
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Amul Sul	12:06
Re: pg_waldump: support decoding of WAL inside tarfile	Amul Sul	12:23
Re: pg_plan_advice	Robert Haas	12:32
Re: pg_plan_advice	Ajay Pal	12:48
Re: SQL Property Graph Queries (SQL/PGQ)	Ajay Pal	12:49
Re: rename and move AssertVariableIsOfType	Bertrand Drouvot	12:55
Re: Add GoAway protocol message for graceful but fast server shutdown/switchover	Zsolt Parragi	12:56
Re: More speedups for tuple deformation 📎	David Rowley	13:34
Re: display hot standby state in psql prompt	Fujii Masao	13:51
Re: meson: Allow disabling static libraries 📎	Peter Eisentraut	14:03
Re: Skipping schema changes in publication 📎	vignesh C	14:37
Re: display hot standby state in psql prompt 📎	Jim Jones	14:43
Re: meson: Make test output much more useful on failure (both in CI and locally) 📎	Jelte Fennema-Nio	14:48
Re: pgsql: Prevent invalidation of newly synced replication slots.	Robert Haas	14:59
Re: pgsql: Prevent invalidation of newly synced replication slots.	Tom Lane	15:11
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY	Álvaro Herrera	15:22
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	15:40
Re: Enable partitionwise join for partition keys wrapped by RelabelType 📎	Matheus Alcantara	15:42
Re: Hash-based MCV matching for large IN-lists 📎	Ilia Evdokimov	15:43
Re: pgsql: Prevent invalidation of newly synced replication slots.	Tom Lane	15:49
Re: pgsql: Prevent invalidation of newly synced replication slots.	Robert Haas	15:51
Re: pg_waldump: support decoding of WAL inside tarfile	Robert Haas	15:55
Re: pgsql: Prevent invalidation of newly synced replication slots.	Tom Lane	16:11
Re: Extended Statistics set/restore/clear functions.	Corey Huinker	16:14
Re: RepOrigin vs. replorigin	Peter Eisentraut	16:15
Re: pgsql: Prevent invalidation of newly synced replication slots.	Thomas Munro	16:16
Re: pgsql: Prevent invalidation of newly synced replication slots.	Andres Freund	16:17
Re: pgsql: Prevent invalidation of newly synced replication slots.	Robert Haas	16:17
RE: AIX support	Srirama Kucherlapati	16:21
Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE	Steve Chavez	16:36
Re: pgsql: Prevent invalidation of newly synced replication slots.	Andres Freund	16:37
Re: docs: warn about post-data-only schema dumps with parallel restore.	David G. Johnston	16:51
Re: pgsql: Prevent invalidation of newly synced replication slots.	Greg Burd	16:53
Re: Flush some statistics within running transactions	Sami Imseih	16:53
Re: unnecessary executor overheads around seqscans	Andres Freund	17:02
Re: pgsql: Prevent invalidation of newly synced replication slots.	Robert Haas	17:11
Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE	Laurenz Albe	17:21
Re: [oauth] Stabilize the libpq-oauth ABI (and allow alternative implementations?)	Jacob Champion	17:36
Re: Report bytes and transactions actually sent downtream	Andres Freund	17:38
Re: Custom oauth validator options	Jacob Champion	17:40
Optimize CPU usage of dropping buffers during recovery 📎	Jingtang Zhang	17:41
Re: pgsql: Prevent invalidation of newly synced replication slots.	Robert Haas	17:42
Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE	Steve Chavez	17:46
Re: Add SECURITY_INVOKER_VIEWS option to CREATE DATABASE	David G. Johnston	18:02
Re: Safer hash table initialization macro 📎	Jelte Fennema-Nio	18:10
Re: pgsql: Prevent invalidation of newly synced replication slots.	Robert Haas	18:15

Browse Archives

Prev | Next