pgsql-hackers before 2025-11-11 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. 7, 2025

Thread	Author	Time
Re: Missing calls to UnlockBuffers() - unify error handling?	Andres Freund	22:49
Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring	Tomas Vondra	22:50
Re: Enhancing Memory Context Statistics Reporting 📎	Rahila Syed	22:55
Re: Extended Statistics set/restore/clear functions.	Michael Paquier	22:56
Re: Sequence Access Methods, round two	Michael Paquier	23:02
Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting	Michael Paquier	23:03
Re: contrib/pg_stat_tcpinfo	Tomas Vondra	23:17
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Manni Wood	23:38
Re: IO in wrong state on riscv64	Thomas Munro	23:47

Nov. 8, 2025

Thread	Author	Time
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Jim Jones	00:03
Re: IO in wrong state on riscv64	Tom Lane	00:03
Re: IO in wrong state on riscv64	Andres Freund	00:10
Re: IO in wrong state on riscv64	Thomas Munro	00:13
Re: Thoughts on a "global" client configuration?	Jacob Champion	00:14
Re: contrib/pg_stat_tcpinfo	Andres Freund	00:18
Re: IO in wrong state on riscv64	Tom Lane	00:24
Support allocating memory for large strings 📎	Maxim Zibitsker	02:15
Re: Support allocating memory for large strings	Tom Lane	02:32
Re: Extra blank line in StrategyGetBuffer	Bruce Momjian	02:54
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Manni Wood	04:19
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Manni Wood	04:46
[PATCH] Fix text in comment of copyto.c 📎	河田達也	05:12
[PATCH] Add hints for invalid binary encoding names in encode/decode functions 📎	Sugamoto Shinya	06:25
Use bsearch() instead of a manual binary search in syscache.c 📎	cca5507	07:59
Re: ago(interval) → timestamptz	Andreas Karlsson	08:09
Re: display hot standby state in psql prompt	Andreas Karlsson	08:57
Re: [Patch] Windows relation extension failure at 2GB and 4GB 📎	Michael Paquier	09:40
Re: display hot standby state in psql prompt	Jim Jones	10:21
Re: Support allocating memory for large strings	Jose Luis Tallon	11:17
Re: Add tab completion support for WAIT FOR command 📎	Alexander Korotkov	11:33
Re: Use bsearch() instead of a manual binary search in syscache.c	Antonin Houska	12:12
Re: Optimize LISTEN/NOTIFY	Joel Jacobson	12:59
Re: Use bsearch() instead of a manual binary search in syscache.c	Thomas Munro	13:24
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Manni Wood	14:05
Re: DOCS: What SGML markup to use for user objects like tables, columns, etc?	Bruce Momjian	14:50
Re: Optimize LISTEN/NOTIFY 📎	Joel Jacobson	15:04
pg_dump not dumping default_text_search_config WAI?	Philip Warner	16:14
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Jim Jones	16:30
Re: MSVC: Improve warning options set	Peter Eisentraut	16:33
Re: Use bsearch() instead of a manual binary search in syscache.c	Tom Lane	17:01
Re: pg_dump not dumping default_text_search_config WAI?	Tom Lane	17:06
Re: ago(interval) → timestamptz	Laurenz Albe	17:30
Re: IO in wrong state on riscv64	Tom Lane	19:26
Re: should we have a fast-path planning for OLTP starjoins? 📎	Tomas Vondra	20:14
[PATCH] libpq: Wrap out-of-memory error messages with libpq_gettext() 📎	Joshua Shanks	20:21
Re: should we have a fast-path planning for OLTP starjoins?	Tom Lane	20:36
Re: MSVC: Improve warning options set	Thomas Munro	21:40
Re: MSVC: Improve warning options set	Tom Lane	21:58
Re: IO in wrong state on riscv64	Thomas Munro	22:50
Re: relfilenode statistics	Michael Paquier	23:33
Re: [PATCH] Fix text in comment of copyto.c	Michael Paquier	23:35
Re: Extend injection_points_attach() to accept a user-defined function	Michael Paquier	23:35

Nov. 9, 2025

Thread	Author	Time
Re: MSVC: Improve warning options set	Thomas Munro	00:29
Re: Use bsearch() instead of a manual binary search in syscache.c	Thomas Munro	01:55
Re: Add tab completion support for WAIT FOR command	Xuneng Zhou	03:11
Re: MSVC: Improve warning options set	Andres Freund	03:21
Re: pg_dump not dumping default_text_search_config WAI?	Philip Warner	06:15
Re: Use bsearch() instead of a manual binary search in syscache.c	cca5507	07:50
Re: BUG #19095: Test if function exit() is used fail when linked static	Torsten Rupp	08:33
Re: Avoid orphaned objects dependencies, take 3	Roman Eskin	08:33
Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 📎	Mihail Nikalayeu	11:20
Re: isolation tester limitation in case of multiple injection points in a single command	Mihail Nikalayeu	12:53
Re: pg_dump not dumping default_text_search_config WAI?	Tom Lane	16:03
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎	Mihail Nikalayeu	18:02
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	18:14
Re: should we have a fast-path planning for OLTP starjoins?	Tom Lane	18:42
Re: Don't synchronously wait for already-in-progress IO in read stream	Peter Geoghegan	19:51
Re: index prefetching 📎	Peter Geoghegan	20:13
Re: DOCS: What SGML markup to use for user objects like tables, columns, etc?	Peter Smith	21:30
Re: Adding REPACK [concurrently]	Robert Treat	22:13
Re: Don't synchronously wait for already-in-progress IO in read stream	Thomas Munro	22:20
Re: isolation tester limitation in case of multiple injection points in a single command	Michael Paquier	22:34
Re: isolation tester limitation in case of multiple injection points in a single command	Mihail Nikalayeu	22:51
Re: DOCS: What SGML markup to use for user objects like tables, columns, etc?	Bruce Momjian	22:59

Nov. 10, 2025

Thread	Author	Time
Add MERGE and VALUES statements to tab completion for PREPARE 📎	Haruna Miwa	00:40
Re: Emitting JSON to file using COPY TO 📎	jian he	00:53
Re: Some efforts to get rid of "long" in our codebase 📎	David Rowley	00:53
Re: Extend injection_points_attach() to accept a user-defined function	Michael Paquier	00:57
Re: isolation tester limitation in case of multiple injection points in a single command	Michael Paquier	00:59
Add tests for object size limits of injection points 📎	Michael Paquier	01:11
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	01:26
Re: Suggestion to add --continue-client-on-abort option to pgbench	Chao Li	02:06
Re: Add tests for object size limits of injection points	Chao Li	02:30
Re: add function argument name to substring and substr 📎	jian he	02:30
Re: Extra blank line in StrategyGetBuffer	Ashutosh Bapat	03:07
Re: Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array 📎	Xuneng Zhou	03:22
Re: Add tests for object size limits of injection points	Michael Paquier	03:31
Re: pg_dump not dumping default_text_search_config WAI?	Philip Warner	03:43
Re: pg_createsubscriber --dry-run logging concerns 📎	Peter Smith	04:00
Re: Suggestion to add --continue-client-on-abort option to pgbench	Fujii Masao	04:45
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Peter Smith	04:50
Re: Resetting recovery target parameters in pg_createsubscriber	Alena Vinter	05:02
pg_getaddrinfo_all() with hintp=NULL 📎	Sergey Tatarintsev	05:14
Re: Add MERGE and VALUES statements to tab completion for PREPARE	Fujii Masao	05:15
Re: [PATCH] Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement	Akshay Joshi	05:16
Re: Remove unused for_all_tables field from AlterPublicationStmt	Peter Smith	05:20
Re: Extended Statistics set/restore/clear functions. 📎	Corey Huinker	05:33
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring	Ashutosh Bapat	06:13
Re: proposal: schema variables 📎	Pavel Stehule	06:40
Re: [PATCH] libpq: Wrap out-of-memory error messages with libpq_gettext()	Fujii Masao	07:04
Re: display hot standby state in psql prompt	Fujii Masao	07:30
Re: Consistently use the XLogRecPtrIsInvalid() macro 📎	Bertrand Drouvot	07:57
Re: Some efforts to get rid of "long" in our codebase 📎	Andreas Karlsson	08:00
Improve logical replication usability when tables lack primary keys 📎	Chao Li	08:06
Re: display hot standby state in psql prompt	Jim Jones	08:14
Re: contrib/pg_stat_tcpinfo	Jakub Wartak	08:30
Re: contrib/pg_stat_tcpinfo	Jakub Wartak	08:34
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Fujii Masao	08:39
gen_guc_tables.pl: Validate required GUC fields before code generation 📎	Chao Li	08:42
Re: relfilenode statistics	Michael Paquier	08:53
Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring	Jakub Wartak	08:59
Re: Logical Replication of sequences 📎	Shlok Kyal	09:03
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Chao Li	09:06
Re: Newly created replication slot may be invalidated by checkpoint	Amit Kapila	09:11
Re: ON CONFLICT DO SELECT (take 3) 📎	Dean Rasheed	09:21
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Nishant Sharma	09:27
Re: [PATCH] pg_bsd_indent: improve formatting of multiline comments 📎	Aleksander Alekseev	09:28
Re: Improve pg_sync_replication_slots() to wait for primary to advance	shveta malik	09:31
Re: ON CONFLICT DO SELECT (take 3)	Viktor Holmberg	10:18
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row 📎	jian he	10:22
Re: Add tests for object size limits of injection points 📎	Xuneng Zhou	10:27
Re: Non-blocking archiver process 📎	BharatDB	10:41
Re: Improve pg_sync_replication_slots() to wait for primary to advance	Ashutosh Bapat	10:44
Re: Logical Replication of sequences	vignesh C	10:52
Minor adjustment: Update the range of the commit_siblings parameter. 📎	zengman	11:04
Fix a typo in the comment for gettuple_eval_partition() 📎	Tender Wang	11:11
Re: [PATCH] Refactor bytea_sortsupport(), take two 📎	Aleksander Alekseev	11:22
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Álvaro Herrera	11:27
Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h 📎	Heikki Linnakangas	11:29
Re: Remove unused for_all_tables field from AlterPublicationStmt	Álvaro Herrera	11:30
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Daniel Gustafsson	11:41
Re: Fix a typo in the comment for gettuple_eval_partition()	Daniel Gustafsson	11:58
Re: gen_guc_tables.pl: Validate required GUC fields before code generation	Dagfinn Ilmari Mannsåker	12:02
Re: Issue with logical replication slot during switchover	Amit Kapila	12:10
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Álvaro Herrera	12:13
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Heikki Linnakangas	12:18
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Daniel Gustafsson	12:22
Re: [PATCH] pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement 📎	Tim Waizenegger	12:44
Trying out <stdatomic.h> 📎	Thomas Munro	13:17
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Manni Wood	13:47
[PATCH} Move instrumentation structs 📎	Mario González Troncoso	13:48
Re: Minor adjustment: Update the range of the commit_siblings parameter.	Chao Li	13:53
Re: Trying out <stdatomic.h>	Heikki Linnakangas	13:57
Re: Add tests for object size limits of injection points	Daniel Gustafsson	14:14
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Heikki Linnakangas	14:17
Re: Use merge-based matching for MCVs in eqjoinsel 📎	Ilia Evdokimov	14:20
Re: Minor adjustment: Update the range of the commit_siblings parameter.	Daniel Gustafsson	14:21
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Daniel Gustafsson	14:43
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	14:45
Fix a minor typo in the comment of read_stream_start_pending 📎	Xuneng Zhou	14:56
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Tom Lane	15:16
Re: Trying out <stdatomic.h>	Tom Lane	15:19
Re: Sequence Access Methods, round two	Andrei Lepikhov	15:31
Re: MSVC: Improve warning options set	Peter Eisentraut	15:34
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Andres Freund	16:11
Remove redundant initialization of smgr pointer for relcache 📎	Jingtang Zhang	16:19
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Heikki Linnakangas	16:24
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	16:26
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Heikki Linnakangas	16:38
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	16:49
Re: Extend injection_points_attach() to accept a user-defined function	Rahila Syed	16:50
Re: AIX support	AIX PG user	17:00
Make PQgetResult() not return NULL on out-of-memory error 📎	Yugo Nagata	17:07
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h	Tom Lane	17:36
Re: Move SLRU_PAGES_PER_SEGMENT to pg_config_manual.h 📎	Heikki Linnakangas	17:46
Re: Improve LWLock tranche name visibility across backends 📎	Nathan Bossart	18:05
Re: Include extension path on pg_available_extensions	Manni Wood	18:25
Re: GNU/Hurd portability patches	Alexander Lakhin	19:00
2025-11-13 release announcement draft 📎	Jonathan S. Katz	19:01
Re: [WiP] B-tree page merge during vacuum to reduce index bloat	Darafei Komяpa Praliaskouski	19:16
Re: GNU/Hurd portability patches	Michael Banck	19:33
vacuumdb: add --dry-run 📎	Corey Huinker	19:44
Re: [Proposal] Adding callback support for custom statistics kinds	Sami Imseih	19:56
Re: GNU/Hurd portability patches	Alexander Lakhin	20:00
obsolete autovacuum comment	Nathan Bossart	20:03
Re: GNU/Hurd portability patches	Thomas Munro	20:03
Re: Trying out <stdatomic.h>	Thomas Munro	20:25
Re: GNU/Hurd portability patches	Thomas Munro	20:27
Re: Support allocating memory for large strings	Nathan Bossart	20:35
Re: Remaining dependency on setlocale()	Jeff Davis	20:39
Re: GNU/Hurd portability patches	Alexander Lakhin	21:00
Re: RFC: adding pytest as a supported test framework 📎	Jelte Fennema-Nio	21:11
Re: pgsql: Drop unnamed portal immediately after execution to completion	Robert Haas	21:13
Re: vacuumdb: add --dry-run	Nathan Bossart	21:19
Re: pgsql: Drop unnamed portal immediately after execution to completion	Tom Lane	21:28
Re: Support allocating memory for large strings	Tom Lane	21:37
Re: 2025-11-13 release announcement draft	Nathan Bossart	21:37
Re: 2025-11-13 release announcement draft	Tom Lane	21:40
Re: 2025-11-13 release announcement draft	Nathan Bossart	21:47
Re: GNU/Hurd portability patches	Michael Banck	21:48
Re: Dead code in ps_status.c	Thomas Munro	22:04
Re: Serverside SNI support in libpq 📎	Daniel Gustafsson	22:32
Re: vacuumdb: add --dry-run	Corey Huinker	22:33
Re: Include extension path on pg_available_extensions	Matheus Alcantara	22:48
Re: Include extension path on pg_available_extensions	Michael Banck	23:10
Re: Improve LWLock tranche name visibility across backends	Sami Imseih	23:17
Re: [Proposal] Adding callback support for custom statistics kinds	Michael Paquier	23:21
Re: pgsql: Drop unnamed portal immediately after execution to completion	Michael Paquier	23:31
Re: Add tests for object size limits of injection points	Michael Paquier	23:34
Re: index prefetching	Peter Geoghegan	23:59

Browse Archives

Prev | Next