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

Thread	Author	Time
Re: Add mode column to pg_stat_progress_vacuum 📎	Masahiko Sawada	00:03
Re: Issue with logical replication slot during switchover	Masahiko Sawada	00:55
Re: Add a berief general comment on BTScanInsertData's nextkey and backward	Peter Geoghegan	01:15
Re: Post-release followup: pg_add_size_overflow()	Chao Li	01:17
Re: Proposal for enabling auto-vectorization for checksum calculations	Andrew Kim	01:18
Re: Proposal: Conflict log history table for Logical Replication	Peter Smith	01:30
Re: Eagerly evict bulkwrite strategy ring	Chao Li	01:45
Re: Checkpointer write combining	Chao Li	02:00
Re: Checkpointer write combining	Chao Li	02:09
Re: PRI?64 vs Visual Studio (2022) 📎	Thomas Munro	02:13
Re: Fix typos in ExecChooseHashTableSize()	Richard Guo	02:18
Re: Use merge-based matching for MCVs in eqjoinsel 📎	Tom Lane	02:19
Re: PRI?64 vs Visual Studio (2022)	Tom Lane	02:28
Re: make -C src/test/isolation failure in index-killtuples due to btree_gist	Michael Paquier	02:30
Re: Fix typos in ExecChooseHashTableSize()	Tender Wang	02:32
Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects	Bryan Green	02:33
Re: [PATCH] Add pg_get_subscription_ddl() function	Peter Smith	02:49
Re: PRI?64 vs Visual Studio (2022)	Thomas Munro	02:50
Re: transformJsonFuncExpr pathspec cache lookup failed 📎	jian he	02:55
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Chao Li	03:13
Re: Optimize LISTEN/NOTIFY	Joel Jacobson	03:14
Re: PRI?64 vs Visual Studio (2022)	Tom Lane	03:15
Re: Why is_admin_of_role() use ROLERECURSE_MEMBERS rather than ROLERECURSE_PRIVS?	cca5507	03:42
Re: RFC: Logging plan of the running query	torikoshia	03:43
Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting	Xuneng Zhou	03:44
Re: Row pattern recognition	Chao Li	04:14
Re: nbtree VACUUM's REDO routine doesn't clear page's VACUUM cycle ID	Andrey Borodin	04:36
Re: Add mode column to pg_stat_progress_vacuum 📎	Shinya Kato	05:10
Re: Post-release followup: pg_add_size_overflow()	Michael Paquier	05:18
Re: Improve pg_sync_replication_slots() to wait for primary to advance	Amit Kapila	06:10
Re: Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect 📎	Fujii Masao	06:22
Re: Issue with logical replication slot during switchover	Amit Kapila	06:27
Re: Proposal: Conflict log history table for Logical Replication	Peter Smith	06:29
Re: Row pattern recognition 📎	Tatsuo Ishii	06:51
Re: Improve pg_sync_replication_slots() to wait for primary to advance	shveta malik	07:04
Re: Proposal: Conflict log history table for Logical Replication	Peter Smith	07:10
Re: Row pattern recognition	Tatsuo Ishii	07:19
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	David Geier	07:20
Re: Row pattern recognition	Tatsuo Ishii	07:20
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	David Geier	07:25
Re: Trying out read streams in pgvector (an extension)	Nazir Bilal Yavuz	07:27
Re: Extended Statistics set/restore/clear functions. 📎	jian he	07:49
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement	Jim Jones	07:52
Re: Add mode column to pg_stat_progress_vacuum	Maciek Sakrejda	07:56
Re: Reorganize GUC structs	Peter Eisentraut	07:57
Re: Consistently use the XLogRecPtrIsInvalid() macro	Bertrand Drouvot	07:58
Re: GUC thread-safety approaches	Peter Eisentraut	08:04
Re: pg_waldump: support decoding of WAL inside tarfile	Jakub Wartak	08:20
RE: Newly created replication slot may be invalidated by checkpoint 📎	Zhijie Hou (Fujitsu)	08:23
Re: gen_guc_tables.pl: Validate required GUC fields before code generation	Peter Eisentraut	08:33
Re: BUG #19095: Test if function exit() is used fail when linked static 📎	BharatDB	09:08
Re: PRI?64 vs Visual Studio (2022) 📎	Peter Eisentraut	09:19
Re: gen_guc_tables.pl: Validate required GUC fields before code generation 📎	Chao Li	09:19
Re: PRI?64 vs Visual Studio (2022)	Peter Eisentraut	09:20
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	shveta malik	09:21
Re: Add os_page_num to pg_buffercache	Bertrand Drouvot	09:28
Re: Update timezone to C99	Peter Eisentraut	09:31
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)	Kirill Reshke	09:35
Re: backend/nodes cleanup: Move loop variables definitions into for statement	Peter Eisentraut	09:36
Re: Skipping schema changes in publication 📎	Shlok Kyal	10:04
Re: Skipping schema changes in publication	Shlok Kyal	10:05
Re: Proposal: Conflict log history table for Logical Replication	Dilip Kumar	10:16
Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement	Japin Li	10:17
Re: backend/nodes cleanup: Move loop variables definitions into for statement 📎	Chao Li	10:32
Re: Allow GUC settings in CREATE SUBSCRIPTION CONNECTION to take effect 📎	Fujii Masao	10:38
Re: log_min_messages per backend type	Alvaro Herrera	10:44
Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement	Álvaro Herrera	10:47
Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement	Akshay Joshi	11:06
Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement	Akshay Joshi	11:07
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Sugamoto Shinya	11:07
Re: Doc: add XML ID attributes to <varlistentry> tags for create_foreign_table, alter_foreign_table 📎	jian he	11:19
Re: Proposal: Conflict log history table for Logical Replication	shveta malik	11:19
Re: Checkpointer write combining	BharatDB	11:21
Re: Trying out <stdatomic.h>	Peter Eisentraut	11:23
RE: Newly created replication slot may be invalidated by checkpoint 📎	Zhijie Hou (Fujitsu)	11:40
Re: Exit walsender before confirming remote flush in logical replication	Fujii Masao	11:46
Re: pg_utility ?	Christoph Berg	11:52
Re: gen_guc_tables.pl: Validate required GUC fields before code generation	Dagfinn Ilmari Mannsåker	11:56
Re: Issue with logical replication slot during switchover	Fabrice Chapuis	12:02
Re: Performance issues with parallelism and LIMIT	David Geier	12:28
Re: BUG #19095: Test if function exit() is used fail when linked static 📎	BharatDB	12:29
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions 📎	Fujii Masao	13:01
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Daniel Gustafsson	13:04
Re: BUG #19095: Test if function exit() is used fail when linked static 📎	Nazir Bilal Yavuz	13:17
Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting	Xuneng Zhou	13:39
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Fujii Masao	13:47
Re: Add os_page_num to pg_buffercache	Michael Paquier	13:49
Re: regarding statistics retaining with 18 Upgrade 📎	Fujii Masao	13:51
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Peter Eisentraut	13:56
Re: Trying out <stdatomic.h>	Aleksander Alekseev	14:03
Re: ON CONFLICT DO SELECT (take 3) 📎	Dean Rasheed	14:08
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Fujii Masao	14:17
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Daniel Gustafsson	14:18
Re: pg_recvlogical: Prevent flushed data from being re-sent after restarting replication 📎	Mircea Cadariu	14:36
Re: pg_recvlogical: Prevent flushed data from being re-sent after restarting replication	Fujii Masao	14:54
PG17 version getting installed by default with every package installation	Rambabu V	15:22
Use strtoi64() in pgbench, replacing its open-coded implementation 📎	Heikki Linnakangas	15:37
Re: Use merge-based matching for MCVs in eqjoinsel	David Geier	15:38
Re: PRI?64 vs Visual Studio (2022)	Tom Lane	15:43
Re: Update timezone to C99	Tom Lane	15:48
Re: Use merge-based matching for MCVs in eqjoinsel	Ilia Evdokimov	15:52
Re: pgsql: doc: remove verbiage about "receiving" data from rep. slots	Robert Haas	16:02
Re: Trigger more frequent autovacuums of heavy insert tables	Nathan Bossart	16:08
Re: Consistently use the XLogRecPtrIsInvalid() macro	Robert Haas	16:14
Re: POC: make mxidoff 64 bits	Heikki Linnakangas	16:20
Re: Consistently use the XLogRecPtrIsInvalid() macro	Álvaro Herrera	16:49
Re: ON CONFLICT DO SELECT (take 3)	Viktor Holmberg	16:51
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	Lukas Fittl	16:54
Re: pgsql: doc: remove verbiage about "receiving" data from rep. slots	Bruce Momjian	16:56
Re: Use merge-based matching for MCVs in eqjoinsel	Tom Lane	17:05
Re: PRI?64 vs Visual Studio (2022)	Álvaro Herrera	17:07
Re: ON CONFLICT DO SELECT (take 3)	Dean Rasheed	17:19
Re: RFC: Logging plan of the running query	Robert Haas	17:23
Re: Consistently use the XLogRecPtrIsInvalid() macro	Robert Haas	17:27
Re: [PATCH] Add memory usage reporting to VACUUM VERBOSE 📎	河田達也	17:30
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎	Masahiko Sawada	17:33
Re: Post-release followup: pg_add_size_overflow()	Jacob Champion	17:45
Re: Post-release followup: pg_add_size_overflow() 📎	Jacob Champion	17:46
Re: Consistently use the XLogRecPtrIsInvalid() macro	Bertrand Drouvot	17:47
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis	Fujii Masao	17:50
Re: Consistently use the XLogRecPtrIsInvalid() macro	Andres Freund	17:53
Re: Expanding HOT updates for expression and partial indexes 📎	Greg Burd	18:00
Re: PRI?64 vs Visual Studio (2022)	Jacob Champion	18:05
Re: Expanding HOT updates for expression and partial indexes 📎	Greg Burd	18:21
Avoid unnecessary processing of DISTINCT clause (Was: Unique Keys) 📎	Antonin Houska	18:42
Re: Type assertions without GCC builtins 📎	Peter Eisentraut	18:44
Re: SQL:2011 Application Time Update & Delete 📎	Paul A Jungwirth	18:49
Re: Intention to start an [oauth] "working group"	Jacob Champion	18:52
Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode	Jacob Champion	18:55
Re: ON CONFLICT DO SELECT (take 3)	Marko Tiikkaja	19:06
Re: GUC thread-safety approaches	Matthias van de Meent	19:16
Re: Consistently use the XLogRecPtrIsInvalid() macro	Robert Haas	19:17
Re: Make PGOAUTHCAFILE in libpq-oauth work out of debug mode	Jacob Champion	19:26
Re: should we have a fast-path planning for OLTP starjoins?	Tomas Vondra	19:35
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	Robert Haas	19:36
Re: warning on the current head	Viktor Holmberg	19:43
Re: Non-blocking archiver process	Robert Haas	19:47
Re: Resetting recovery target parameters in pg_createsubscriber	Robert Haas	19:49
Re: ON CONFLICT DO SELECT (take 3)	Viktor Holmberg	19:54
Re: pg_recvlogical: Prevent flushed data from being re-sent after restarting replication	Mircea Cadariu	19:57
10% drop in code line count in PG 17	Bruce Momjian	19:59
Re: Performance issues with parallelism and LIMIT	Tomas Vondra	20:03
Re: [Proposal] Adding callback support for custom statistics kinds 📎	Sami Imseih	20:10
Re: 10% drop in code line count in PG 17	Tom Lane	20:21
Re: 10% drop in code line count in PG 17	Bruce Momjian	20:34
Re: PRI?64 vs Visual Studio (2022)	Thomas Munro	20:49
Re: System views for versions reporting	Laurenz Albe	20:57
Re: Speed up COPY FROM text/CSV parsing using SIMD	Nathan Bossart	21:01
Re: PRI?64 vs Visual Studio (2022)	Thomas Munro	21:02
Re: Changing the state of data checksums in a running cluster	Andreas Karlsson	21:03
Unexpected flood or keepalive messages during logical replication 📎	Petros Angelatos	21:14
Re: 10% drop in code line count in PG 17	Tom Lane	21:22
Re: PRI?64 vs Visual Studio (2022)	Tom Lane	21:30
Re: Parallel Apply	Tomas Vondra	21:30
Re: Issue with logical replication slot during switchover	Masahiko Sawada	21:43
Re: Asynchronous MergeAppend 📎	Matheus Alcantara	21:51
Re: 10% drop in code line count in PG 17 📎	Bruce Momjian	21:58
Re: 10% drop in code line count in PG 17	Álvaro Herrera	22:00
Re: Consistently use the XLogRecPtrIsInvalid() macro	Álvaro Herrera	22:03
Re: Checkpointer write combining 📎	Melanie Plageman	22:12
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis 📎	Peter Smith	22:18
Re: vacuumdb: add --dry-run 📎	Corey Huinker	22:23
Re: PRI?64 vs Visual Studio (2022) 📎	Tom Lane	22:23
Re: Eagerly evict bulkwrite strategy ring 📎	Melanie Plageman	22:32
Re: PRI?64 vs Visual Studio (2022)	Thomas Munro	22:43
Re: vacuumdb: add --dry-run	Nathan Bossart	22:44
Re: GNU/Hurd portability patches	Samuel Thibault	22:45
Re: [PATCH] Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 📎	Manni Wood	22:52
Re: Add support for COPY TO in tablesync for partitioned tables.	Masahiko Sawada	22:56
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 📎	Melanie Plageman	23:13
Re: 10% drop in code line count in PG 17	David Rowley	23:23
Re: postgres_fdw: Use COPY to speed up batch inserts	Masahiko Sawada	23:32
Re: vacuumdb: add --dry-run	Corey Huinker	23:55

Nov. 20, 2025

Thread	Author	Time
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis	Chao Li	00:01
Re: [PATCH] Add hints for invalid binary encoding names in encode/decode functions	Fujii Masao	00:15
Re: [PATCH] Add memory usage reporting to VACUUM VERBOSE	Masahiko Sawada	00:19
Re: regarding statistics retaining with 18 Upgrade	Fujii Masao	00:22
Re: Add mode column to pg_stat_progress_vacuum	Shinya Kato	00:34
Re: vacuumdb: add --dry-run 📎	Corey Huinker	00:54
Re: Use strtoi64() in pgbench, replacing its open-coded implementation	Yuefei Shi	00:58
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis	Peter Smith	00:59
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis	Fujii Masao	01:03
Re: Use strtoi64() in pgbench, replacing its open-coded implementation	Neil Chen	01:04
Re: PRI?64 vs Visual Studio (2022) 📎	Tom Lane	01:23
Re: Use strtoi64() in pgbench, replacing its open-coded implementation	Tom Lane	01:27
Re: ON CONFLICT DO SELECT (take 3)	Andreas Karlsson	01:29
Re: Add mode column to pg_stat_progress_vacuum	Sami Imseih	01:34
Re: [PATCH] Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement	Japin Li	01:39
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis	Peter Smith	01:41
Re: Use strtoi64() in pgbench, replacing its open-coded implementation	Neil Chen	01:49
Re: RFC: Logging plan of the running query 📎	torikoshia	01:52
Re: Skipping schema changes in publication	Peter Smith	01:55
Re: [Proposal] Adding callback support for custom statistics kinds	Sami Imseih	02:10
Re: pg_utility ?	Andreas Karlsson	02:23
Re: Checkpointer write combining	Chao Li	02:31
Re: Buffer locking is special (hints, checksums, AIO writes) 📎	Andres Freund	02:47
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis	Chao Li	03:05
Re: Use strtoi64() in pgbench, replacing its open-coded implementation	Chao Li	03:36
Re: CREATE/ALTER PUBLICATION improvements for syntax synopsis	Peter Smith	04:07
Re: GNU/Hurd portability patches	Thomas Munro	04:20

Browse Archives

Prev | Next