pgsql-hackers since 2025-11-03 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

Nov. 3, 2025

Thread	Author	Time
Re: index prefetching	Tomas Vondra	00:06
Re: Avoid overflow (src/backend/utils/adt/formatting.c)	Ranier Vilela	00:31
Re: Avoid overflow (src/backend/utils/adt/formatting.c)	Ranier Vilela	00:34
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement	Philip Alger	01:18
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement	Philip Alger	01:22
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement	Josef Šimánek	01:30
Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement	Josef Šimánek	01:31
Re: meson's in-tree libpq header search order vs -Dextra_include_dirs 📎	Thomas Munro	02:09
Add CHECK_FOR_INTERRUPTS in Evict{Rel,All}UnpinnedBuffers 📎	邱宇航	02:15
Re: Implement waiting for wal lsn replay: reloaded 📎	Xuneng Zhou	02:20
Re: Add support for specifying tables in pg_createsubscriber. 📎	Shubham Khanna	04:40
Re: Import Statistics in postgres_fdw before resorting to sampling.	Corey Huinker	05:26
Re: meson's in-tree libpq header search order vs -Dextra_include_dirs	Tristan Partin	05:43
Re: meson's in-tree libpq header search order vs -Dextra_include_dirs	Tom Lane	06:14
Re: Non-text mode for pg_dumpall	Vaibhav Dalvi	06:35
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Peter Smith	06:37
Re: Report bytes and transactions actually sent downtream	Ashutosh Bapat	06:53
Re: Add support for specifying tables in pg_createsubscriber.	Peter Smith	07:24
Use stack-allocated StringInfoData 📎	Mats Kindahl	07:27
Re: Consistently use the XLogRecPtrIsInvalid() macro 📎	Bertrand Drouvot	07:47
Re: Issue with logical replication slot during switchover	Alexander Kukushkin	07:51
Re: Adding REPACK [concurrently]	Antonin Houska	07:56
Re: [PoC] XMLCast (SQL/XML X025) 📎	Jim Jones	08:41
Re: How can end users know the cause of LR slot sync delays?	shveta malik	09:44
Re: [PATCH] Add a guc parameter to control limit clause adjust path cost.	ocean_li_996	09:49
Re: Report bytes and transactions actually sent downtream	shveta malik	09:54
Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py	Bertrand Drouvot	09:55
Re: Use stack-allocated StringInfoData	David Rowley	10:27
Re: Improve pg_sync_replication_slots() to wait for primary to advance 📎	Ajin Cherian	10:33
Re: [PATCH] Add error message for out-of-memory in passwordFromFile()	Michael Paquier	10:35
Re: Avoid overflow (src/backend/utils/adt/formatting.c)	Bryan Green	10:45
Re: Add wal_fpi_bytes_[un]compressed to pg_stat_wal	Michael Paquier	10:50
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎	Heikki Linnakangas	11:02
Re: Logical Replication of sequences 📎	Amit Kapila	11:14
Re: Reorganize GUC structs	Peter Eisentraut	11:16
Re: Docs and tests for RLS policies applied by command type 📎	Dean Rasheed	11:21
BRIN autosummarization lacking a snapshot 📎	Álvaro Herrera	11:21
Re: Avoid overflow (src/backend/utils/adt/formatting.c)	Ranier Vilela	11:36
Re: Implement waiting for wal lsn replay: reloaded 📎	Alexander Korotkov	11:46
Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement 📎	Akshay Joshi	11:47
Re: 64 bit numbers vs format strings	Thomas Munro	11:54
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	11:54
Re: Non-text mode for pg_dumpall	Vaibhav Dalvi	11:59
Re: Fix comments for ChangeVarNodes() and related functions	Peter Eisentraut	12:14
Re: 64 bit numbers vs format strings	Wolfgang Walther	12:34
Re: Fix typo in Vietnamese translation file	Álvaro Herrera	12:56
Re: Asynchronous MergeAppend 📎	Matheus Alcantara	13:00
Re: tuple radix sort 📎	John Naylor	13:24
Re: fix NOT VALID NOT NULL with ALTER COLUMN SET IDENTITY	Álvaro Herrera	13:33
Re: Making jsonb_agg() faster	Chao Li	13:38
contrib/pg_stat_tcpinfo 📎	Jakub Wartak	14:09
Fix outdated comment of CopyStmt in gram.y 📎	cca5507	14:13
Re: Report bytes and transactions actually sent downtream 📎	Ashutosh Bapat	14:23
Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode	Daniel Gustafsson	14:24
Re: AIX support	AIX PG user	14:46
Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta 📎	Jelte Fennema-Nio	14:46
Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta	Andres Freund	14:59
Re: fix NOT VALID NOT NULL with ALTER COLUMN SET IDENTITY	Álvaro Herrera	14:59
Re: Implement waiting for wal lsn replay: reloaded	Álvaro Herrera	15:06
[PATCH] Fix orphaned backend processes on Windows using Job Objects 📎	Bryan Green	15:12
Re: Implement waiting for wal lsn replay: reloaded	Andres Freund	15:13
Re: Logical Replication of sequences 📎	vignesh C	15:16
Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects	Andres Freund	15:19
Re: Report bytes and transactions actually sent downtream	Andres Freund	15:20
Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects	Bryan Green	15:25
Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects	Andres Freund	15:29
Re: libpq: Bump protocol version to version 3.2 at least until the first/second beta	Jelte Fennema-Nio	15:41
Re: Confine vacuum skip logic to lazy_scan_skip	Melanie Plageman	15:59
Re: pg_plan_advice	Robert Haas	16:18
Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode	Jacob Champion	16:24
Re: Intention to start an [oauth] "working group"	Melanie Plageman	16:34
Re: pg_plan_advice	Robert Haas	16:41
Re: Add \pset options for boolean value display	Álvaro Herrera	16:44
Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode	Zsolt Parragi	16:53
Re: Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup 📎	Jelte Fennema-Nio	17:04
Re: Add \pset options for boolean value display	David G. Johnston	17:16
psql --help=variables missing csv_fieldsep 📎	Álvaro Herrera	17:44
Re: Improve LWLock tranche name visibility across backends 📎	Sami Imseih	17:50
Re: test_json_parser/002_inline is kind of slow	Jacob Champion	17:57
Re: psql --help=variables missing csv_fieldsep	Tom Lane	17:59
Re: psql --help=variables missing csv_fieldsep	Tom Lane	18:03
Re: Fix outdated comment of CopyStmt in gram.y	Masahiko Sawada	18:36
Re: Making jsonb_agg() faster	Tom Lane	18:40
[PATCH v1 1/1] PostgreSQL Patch: AVX-Optimized ASCII Validation 📎	Pickett, Eshe N	18:55
Re: MSVC: Improve warning options set	Peter Eisentraut	18:56
Re: Remaining dependency on setlocale()	Daniel Verite	19:14
Re: MSVC: Improve warning options set	Andres Freund	19:15
Re: [PG19-3 PATCH] Don't ignore passfile	Jacob Champion	19:19
Re: MSVC: Improve warning options set	Andres Freund	19:26
Re: Support getrandom() for pg_strong_random() source 📎	Masahiko Sawada	19:48
Re: Remaining dependency on setlocale()	Jeff Davis	19:59
Re: Add CHECK_FOR_INTERRUPTS in Evict{Rel,All}UnpinnedBuffers	Masahiko Sawada	20:06
Re: Eagerly evict bulkwrite strategy ring 📎	Melanie Plageman	20:06
Re: psql --help=variables missing csv_fieldsep	Álvaro Herrera	20:20
Re: Use stack-allocated StringInfoData	Mats Kindahl	20:20
Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)	Matheus Alcantara	20:38
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎	Mihail Nikalayeu	20:41
Re: psql --help=variables missing csv_fieldsep	Tom Lane	20:53
Re: Resetting recovery target parameters in pg_createsubscriber	Alexander Korotkov	21:27
Re: Use stack-allocated StringInfoData	David Rowley	21:32
Re: [PATCH] Write Notifications Through WAL 📎	Rishu Bagga	21:36
ago(interval) → timestamptz 📎	Florents Tselai	21:36
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎	Joel Jacobson	21:45
Re: Remaining dependency on setlocale()	Jeff Davis	21:54
Re: Use merge-based matching for MCVs in eqjoinsel	Tom Lane	21:55
Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects 📎	Bryan Green	22:12
Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)	David Rowley	22:47
Re: Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*)	David Rowley	22:49
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY	Noah Misch	22:52
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY	Mihail Nikalayeu	23:03
Re: Checkpointer write combining 📎	Melanie Plageman	23:34
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Manni Wood	23:49

Nov. 4, 2025

Thread	Author	Time
Re: COPY WHERE clause generated/system column reference	Masahiko Sawada	00:27
Re: pg_createsubscriber --dry-run logging concerns	Peter Smith	01:16
Re: Report oldest xmin source when autovacuum cannot remove tuples	Shinya Kato	01:29
Re: Should we say "wal_level = logical" instead of "wal_level >= logical" 📎	Peter Smith	01:43
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis 📎	Peter Smith	02:44
Re: DOCS: What SGML markup to use for user objects like tables, columns, etc?	Peter Smith	03:35
[PATCH] Add pretty formatting to pg_get_triggerdef 📎	Philip Alger	03:36
Re: [PATCH] Add error message for out-of-memory in passwordFromFile() 📎	Joshua Shanks	05:15
Re: meson's in-tree libpq header search order vs -Dextra_include_dirs 📎	Thomas Munro	05:30
Re: BRIN autosummarization lacking a snapshot	Michael Paquier	05:38
Re: ago(interval) → timestamptz	Laurenz Albe	05:55
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 📎	jian he	06:02
Re: meson's in-tree libpq header search order vs -Dextra_include_dirs	Tristan Partin	06:17
Re: Improve pg_sync_replication_slots() to wait for primary to advance	shveta malik	06:23
Re: meson's in-tree libpq header search order vs -Dextra_include_dirs	Tristan Partin	06:25
Re: Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions	Sadhuprasad Patro	06:50
Re: Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions	Michael Paquier	07:03
Re: Extended Statistics set/restore/clear functions.[	Michael Paquier	07:13
Re: [PATCH] Add pretty formatting to pg_get_triggerdef	Steven Niu	07:19
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs	Alexander Lakhin	08:00
Re: Use stack-allocated StringInfoData 📎	Mats Kindahl	08:25
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Jim Jones	08:27
Re: Extend injection_points_attach() to accept a user-defined function 📎	Rahila Syed	08:47
Re: ago(interval) → timestamptz	Quan Zongliang	08:53
Extra blank line in StrategyGetBuffer 📎	Ashutosh Bapat	08:57
Fix redundant memset after palloc0 in heap_form_minimal_tuple() 📎	Chao Li	09:05
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs	Richard Guo	09:19
Re: Confine vacuum skip logic to lazy_scan_skip	John Naylor	09:27
Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py	Mats Kindahl	09:31
Re: [PATCH v1 1/1] PostgreSQL Patch: AVX-Optimized ASCII Validation	John Naylor	09:35
Re: [PATCH] Add pretty formatting to pg_get_triggerdef	Chao Li	09:40
Re: How can end users know the cause of LR slot sync delays?	shveta malik	09:47
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs	David Rowley	09:54
Re: pg_createsubscriber --dry-run logging concerns	Álvaro Herrera	09:59
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs 📎	David Rowley	10:00
Re: Teaching planner to short-circuit empty UNION/EXCEPT/INTERSECT inputs 📎	Richard Guo	10:02
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Nishant Sharma	10:37
Re: Report bytes and transactions actually sent downtream	Ashutosh Bapat	10:58
Re: Issue with logical replication slot during switchover	Fabrice Chapuis	11:14
Re: [PATCH] Add error message for out-of-memory in passwordFromFile()	Michael Paquier	11:17
Re: [PATCH] Fix Korean typo 'checkpoint' in log	Peter Eisentraut	11:21
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Jim Jones	11:25
Re: tuple radix sort 📎	John Naylor	11:27
Re: COPY WHERE clause generated/system column reference 📎	jian he	11:43
Re: BRIN autosummarization lacking a snapshot 📎	Álvaro Herrera	11:47
Re: pg_plan_advice	John Naylor	11:47
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 📎	Heikki Linnakangas	12:09
Re: Adding basic NUMA awareness 📎	Jakub Wartak	12:10
Enhance security permissions 📎	Ranier Vilela	12:20
Re: Enhance security permissions	Bryan Green	12:44
Re: Non-text mode for pg_dumpall	tushar	12:53
Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode	Jonathan Gonzalez V.	13:00
Re: Issue with logical replication slot during switchover	Alexander Kukushkin	13:01
Re: Enhance security permissions	Ranier Vilela	13:17
Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode	Daniel Gustafsson	13:26
Re: bug: virtual generated column can be partition key	Peter Eisentraut	13:48
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Manni Wood	14:19
Re: BRIN autosummarization lacking a snapshot	Álvaro Herrera	14:22
Re: Enhance security permissions	Bryan Green	14:35
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Arseniy Mukhin	14:40
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Tom Lane	14:44
Re: MergeAppend could consider sorting cheapest child path	Andrei Lepikhov	14:46
Re: POC: make mxidoff 64 bits 📎	Alexander Korotkov	15:10
Re: Issue with logical replication slot during switchover	Fabrice Chapuis	15:13
Re: BRIN autosummarization lacking a snapshot	Arseniy Mukhin	15:13
Re: Report oldest xmin source when autovacuum cannot remove tuples	Fujii Masao	15:58
Re: LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue	Álvaro Herrera	16:27
Re: psql --help=variables missing csv_fieldsep 📎	Álvaro Herrera	16:39
Re: psql --help=variables missing csv_fieldsep	Tom Lane	16:44
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 📎	Melanie Plageman	16:48
Re: BRIN autosummarization lacking a snapshot	Álvaro Herrera	16:49
Re: Non-text mode for pg_dumpall	Andrew Dunstan	16:55
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters	Tom Lane	16:58
Re: foreign key on virtual generated column	Srinath Reddy Sadipiralla	17:12
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters	Andreas Karlsson	17:12
Re: BRIN autosummarization lacking a snapshot	Álvaro Herrera	17:22
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters	Tom Lane	17:24
Re: BRIN autosummarization lacking a snapshot 📎	Álvaro Herrera	17:37
Re: Fix redundant memset after palloc0 in heap_form_minimal_tuple()	Jeff Davis	17:51
pg_utility ?	Álvaro Herrera	17:52
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Jim Jones	17:59
Re: Fix ALTER TABLE DROP EXPRESSION with inheritance hierarchy	Peter Eisentraut	18:10
Re: Fix ALTER TABLE DROP EXPRESSION with inheritance hierarchy	Tom Lane	18:16
Re: Intention to start an [oauth] "working group"	Jacob Champion	18:23
Re: Fix ALTER TABLE DROP EXPRESSION with inheritance hierarchy	Tom Lane	18:31
Re: MinGW compiler warnings in ecpg tests	Andres Freund	18:34
Re: Upgrade Debian CI image from Bookworm to Trixie	Andres Freund	18:36
Re: [PATCH] Fix ALTER SYSTEM empty string bug for GUC_LIST_QUOTE parameters	Maciek Sakrejda	18:43

Browse Archives

Prev | Next