pgsql-hackers

Messages by Date

2026/10/16 Re: First draft of PG 19 release notes shihao zhong
2026/10/16 Re: [PG19] Wrong results from NOT NULL-based expression simplification shihao zhong
2026/10/16 Re: First draft of PG 19 release notes Tom Lane
2026/10/16 Re: First draft of PG 19 release notes shihao zhong
2026/10/16 Re: [PG19] Wrong results from NOT NULL-based expression simplification Manu
2026/10/16 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong
2026/10/16 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces shihao zhong
2026/10/16 Re: [PG19] Indexes from 18 miss rows after pg_upgrade shihao zhong
2026/10/16 Re: [PATCH] Fix grouping-set nulling of variable-free grouping expressions shihao zhong
2026/10/16 Add Dockerfile for OSS Scanner Noah Misch
2026/10/16 Re: Row pattern recognition jian he
2026/10/16 Re: Fix doc: explanation of how postgres works when OOM killer is invoked C W
2026/10/16 Re: Fix doc: explanation of how postgres works when OOM killer is invoked Takeshi Ideriha
2026/10/16 Re: [PG19] Indexes from 18 miss rows after pg_upgrade Jeff Davis
2026/10/16 Re: ERROR: failed to apply nullingrels to a non-Var Richard Guo
2026/10/16 Re: Two more RI fast-path issues Amit Langote
2026/10/16 Re: Fix stale allocChunkLimit when recycling AllocSet Donghang Lin
2026/10/16 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Masahiko Sawada
2026/10/16 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Haibo Yan
2026/10/16 Re: Use instr_time for pg_stat_database block read/write time counters Bernd Reiß
2026/10/16 Re: postgres_fdw: transaction mode inheritance corner cases Matheus Alcantara
2026/10/16 Re: Use WALReadFromBuffers in more places Bharath Rupireddy
2026/10/16 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Fujii Masao
2026/10/16 Re: Add a hook for handling logical decoding messages on subscribers. Bharath Rupireddy
2026/10/16 Re: Prevent foreign key references to unlogged partitions Zsolt Parragi
2026/10/16 Re: Add a hook for handling logical decoding messages on subscribers. Masahiko Sawada
2026/10/16 Re: pg_*_advice: tsv load failure, etc. Robert Haas
2026/10/16 Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773 Michael Banck
2026/10/16 Re: Proposal: Conflict log history table for Logical Replication Zsolt Parragi
2026/10/16 Re: pg_*_advice: tsv load failure, etc. Robert Haas
2026/10/16 Re: Teach pg_upgrade to deal with invalid databases Bharath Rupireddy
2026/10/16 [PG19] pg_upgrade transfers temporal keys using gist_inet_ops with the wrong opclass Zsolt Parragi
2026/10/16 Re: Add a hook for handling logical decoding messages on subscribers. Masahiko Sawada
2026/10/16 Re: Parallel vacuum: workers together with leader could overrun cost budget Masahiko Sawada
2026/10/16 Re: Reapply graceful socket shutdown on Windows (revert 29992a6a509) Jacob Champion
2026/10/16 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
2026/10/16 Re: ALTER TABLE uses a bistate but not for toast tables Bertrand Drouvot
2026/10/16 Re: Patch for migration of the pg_commit_ts directory Maxim Orlov
2026/10/16 Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects Harrison Booth
2026/10/16 Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Fujii Masao
2026/10/16 Re: [PATCH] pg_upgrade: handle failed nonblocking connects on Windows Harrison Booth
2026/10/16 Re: Reject COPY TO of unlogged relations during recovery Masahiko Sawada
2026/10/16 Re: Use instr_time for pg_stat_database block read/write time counters Lukas Fittl
2026/10/16 Remove obsolete locking comment from AddBufferToRing() Chao Li
2026/10/16 [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Zsolt Parragi
2026/10/16 Re: pg_*_advice: tsv load failure, etc. Zsolt Parragi
2026/10/16 Re: use radix tree for bitmap heap scan John Naylor
2026/10/16 Re: Historic snapshot doesn't track txns committed inBUILDING_SNAPSHOT state Álvaro Herrera
2026/10/16 Re: Add a pg_wal_preallocate() SQL function to eagerly create future WAL segments Ayush Tiwari
2026/10/16 Re: Fix doc: explanation of how postgres works when OOM killer is invoked Fujii Masao
2026/10/16 Parallel vacuum: check XID wraparound failsafe between indexes Bharath Rupireddy
2026/10/16 Re: PoC: Simplify recovery after dropping a table by LOGGING the restore LSN Jim Jones
2026/10/16 pgstat: don't assert on dropped entries when writing stats file Sami Imseih
2026/10/16 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) David Geier
2026/10/16 Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound shihao zhong
2026/10/16 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Álvaro Herrera
2026/10/16 Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() David Geier
2026/10/16 Re: REPACK: warn about skipping foreign partitions Fujii Masao
2026/10/16 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/16 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Fujii Masao
2026/10/16 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Matthias van de Meent
2026/10/16 Re: Two more RI fast-path issues Tom Lane
2026/10/16 Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound Heikki Linnakangas
2026/10/16 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/16 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces jian he
2026/10/16 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/16 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/16 [PATCH] Small gaps in IoWorkerMain() error handling Ayush Tiwari
2026/10/16 Re: postgres_fdw: transaction mode inheritance corner cases Etsuro Fujita
2026/10/16 Re: Reject COPY TO of unlogged relations during recovery Jim Jones
2026/10/16 Re: PSQL schema "describe" \dn is not escaping quotes surya poondla
2026/10/16 Re: gcc 15 "array subscript 0" warning at level -O3 Tristan Partin
2026/10/16 Re: Fix pg_restore gzip stream validation (bug #19754) stefangrassl
2026/10/16 Re: UNDO with constant time recovery (CTR) Matthias van de Meent
2026/10/16 Re: [PATCH] Preserve replication origin OIDs in pg_upgrade Ajin Cherian
2026/10/16 Re: contrib/pg_stat_tcpinfo Jakub Wartak
2026/10/16 Re: Assert failure in find_var_for_subquery_tle Richard Guo
2026/10/16 Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound Álvaro Herrera
2026/10/16 Re: Fix pg_restore gzip stream validation (bug #19754) Daniel Gustafsson
2026/10/16 Use a bulk-write buffer access strategy for TOAST inserts Bertrand Drouvot
2026/10/16 Re: Persist slot invalidations before publishing them Bertrand Drouvot
2026/10/16 Re: Fix pg_restore gzip stream validation (bug #19754) Chao Li
2026/10/16 RE: Include schema-qualified names in publication error messages (generalised to all of LR). Hayato Kuroda (Fujitsu)
2026/10/16 Re: Weird usages of sentinel_ok() David Rowley
2026/10/16 Re: Improving scalability of Parallel Bitmap Heap/Index Scan David Geier
2026/10/16 Re: Reject COPY TO of unlogged relations during recovery Jim Jones
2026/10/16 Re: ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18) Álvaro Herrera
2026/10/15 Re: Fix WITHOUT OVERLAPS multirange with location replication Nisha Moond
2026/10/15 Re: [PG19] Wrong results from NOT NULL-based expression simplification Richard Guo
2026/10/15 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Tom Lane
2026/10/15 Re: Weird usages of sentinel_ok() David Rowley
2026/10/15 Re: [PATCH] Report no unpinned buffers as insufficient resources Ma Xueting
2026/10/15 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong
2026/10/15 Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Michael Paquier
2026/10/15 Re: PSQL schema "describe" \dn is not escaping quotes Peter Smith
2026/10/15 回复：logical decoding: skip unnecessary snapshot distribution. yangboyu
2026/10/15 Re: Parallel TID Range Scan returns wrong results on rescan David Rowley
2026/10/15 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
2026/10/15 Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound shihao zhong
2026/10/15 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client shihao zhong
2026/10/15 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/15 Re: Improving scalability of Parallel Bitmap Heap/Index Scan shihao zhong
2026/10/15 Re：logical decoding: skip unnecessary snapshot distribution. 杨伯宇(长堂)
2026/10/15 Re: Parallel TID Range Scan returns wrong results on rescan shihao zhong
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Chao Li
2026/10/15 Re: Weird usages of sentinel_ok() shihao zhong
2026/10/15 Re: [PG19] pg_dump --statistics restores extended statistics by attribute number shihao zhong
2026/10/15 Re: Fix numeric log() with an infinite value and 0<base<=1 Chao Li
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
2026/10/15 Re: ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18) Manu
2026/10/15 Assert failure in create_lateral_join_info Richard Guo
2026/10/15 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Fujii Masao
2026/10/15 Re: [PATCH 0/2] Improve ndistinct estimates for flattened UNION ALL zengxx
2026/10/15 Re: UNDO with FILEOPS, and the FLUX table AM Manu
2026/10/15 Re: PSQL schema "describe" \dn is not escaping quotes surya poondla
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
2026/10/15 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Fujii Masao
2026/10/15 Re: Revert libpq servicefile connection option in v19 (info leak and uninterruptible backend DoS) Michael Paquier
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Fujii Masao
2026/10/15 Revert libpq servicefile connection option in v19 (info leak and uninterruptible backend DoS) Sehrope Sarkuni
2026/10/15 Re: Use WALReadFromBuffers in more places Michael Paquier
2026/10/15 Re: [PATCH] Fix segmentation fault caused by reentrancy in RI_Fkey_cascade_del (ri_triggers.c) Tomas Vondra
2026/10/15 Re: Showing "Table Block Fetches" in EXPLAIN ANALYZE for index-only scans Sami Imseih
2026/10/15 Re: Parallel vacuum: avoid dangling shared memory pointers Masahiko Sawada
2026/10/15 Re: Unlogged materialized views Zsolt Parragi
2026/10/15 Re: index prefetching Bilal Kahraman
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
2026/10/15 Re: Bug in logical decoding with DDL and subtransactions Tom Lane
2026/10/15 Re: Reject COPY TO of unlogged relations during recovery Zsolt Parragi
2026/10/15 Re: [PATCH 0/2] Improve ndistinct estimates for flattened UNION ALL David Rowley
2026/10/15 Re: PoC: Simplify recovery after dropping a table by LOGGING the restore LSN Zsolt Parragi
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Sami Imseih
2026/10/15 Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers Masahiko Sawada
2026/10/15 Re: [***DKIM violation***] Re: [PATCH] Fix JSON_SERIALIZE() coercion placeholder type for jsonb input Staroverov Ilja
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
2026/10/15 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Sami Imseih
2026/10/15 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Masahiko Sawada
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
2026/10/15 Parallel TID Range Scan returns wrong results on rescan Zsolt Parragi
2026/10/15 Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
2026/10/15 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Tom Lane
2026/10/15 [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound Zsolt Parragi
2026/10/15 Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Naga Appani
2026/10/15 Re: Fix numeric log() with an infinite value and 0<base<=1 Tom Lane
2026/10/15 Showing "Table Block Fetches" in EXPLAIN ANALYZE for index-only scans Peter Geoghegan
2026/10/15 RE: [PG19] Promotion hangs behind a backend blocked on a stuck client Hayato Kuroda (Fujitsu)
2026/10/15 Re: Let an ordering index scan hand its ORDER BY value to the target list Greg Burd
2026/10/15 Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Sami Imseih
2026/10/15 Re: Serverside SNI support in libpq Daniel Gustafsson
2026/10/15 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Tom Lane
2026/10/15 Reject COPY TO of unlogged relations during recovery Jim Jones
2026/10/15 Re: Fix WITHOUT OVERLAPS multirange with location replication Paul A Jungwirth
2026/10/15 doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Naeem Akhter
2026/10/15 [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
2026/10/15 Re: [PATCH] Add memory/disk usage for Function Scan nodes in EXPLAIN David Rowley
2026/10/15 Re: Fix WITHOUT OVERLAPS multirange with location replication Paul A Jungwirth
2026/10/15 Re: Serverside SNI support in libpq Zsolt Parragi
2026/10/15 Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Fujii Masao
2026/10/15 Re: Unlogged materialized views Jim Jones
2026/10/15 Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Haibo Yan
2026/10/15 Re: Wrong results from self-join elimination with different restriction operators Tom Lane
2026/10/15 [PATCH 0/2] Improve ndistinct estimates for flattened UNION ALL zengxx
2026/10/15 Re: [PATCH] Halve peak memory allocation for toast_flatten_tuple Pavel Borisov
2026/10/15 Re: [PATCH] Add memory/disk usage for Function Scan nodes in EXPLAIN Tatsuya Kawata
2026/10/15 Re: Bug in logical decoding with DDL and subtransactions [email protected]
2026/10/15 Re: Deprecation warnings on Rocky 10.2 with current dev branch Tom Lane
2026/10/15 Re: PoC: Simplify recovery after dropping a table by LOGGING the restore LSN Salma El-Sayed
2026/10/15 Re: Disable startup progress timeout during standby WAL replay Aidar Imamov
2026/10/15 Re: postgres_fdw: Emit message when batch_size is reduced Corey Huinker
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() Heikki Linnakangas
2026/10/15 Re: postgres_fdw: Emit message when batch_size is reduced Robert Haas
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() Tom Lane
2026/10/15 Re: [PATCH] Halve peak memory allocation for toast_flatten_tuple Johannes Edmeier
2026/10/15 Re: Disable startup progress timeout during standby WAL replay Aidar Imamov
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() David Rowley
2026/10/15 Re: [PATCH] Fix recovery connection detail in EXEC_BACKEND builds Nitin Jadhav
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
2026/10/15 Re: enhancing pg_basebackup speeds up to ~23Gbps (small fixes + io_uring/Direct I/O) Heikki Linnakangas
2026/10/15 Re: Asynchronous MergeAppend Etsuro Fujita
2026/10/15 walreceiver: stale hot_standby_feedback xmin on primary when wal_receiver_status_interval = 0 (PG16 and later) Vaibhav Dalvi
2026/10/15 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/15 Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Matthias Dötsch
2026/10/15 Re: Fix numeric log() with an infinite value and 0<base<=1 Matthias van de Meent
2026/10/15 Re: SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator David Rowley
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() David Rowley
2026/10/15 Re: Bug in logical decoding with DDL and subtransactions David Rowley
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() Japin Li
2026/10/15 Re: Proposal: Conflict log history table for Logical Replication Zhijie Hou
2026/10/15 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/15 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/15 Re: Parallel vacuum: avoid dangling shared memory pointers Masahiko Sawada
2026/10/15 Re: Avoid repeated scans of the output buffer in oidvectortypes() Heikki Linnakangas
2026/10/15 Re: [PG19] jsonb_object_agg as a window function returns stale values Tom Lane
2026/10/15 Re: [PATCH] pg_test_fsync: close Windows alarm thread handles Heikki Linnakangas
2026/10/15 Re: Assorted Win32 error handling fixes (CreateThread, pgwin32_select, pg_usleep) Heikki Linnakangas
2026/10/15 Re: Add TOAST statistics columns to pg_stat_all_tables solai v
2026/10/15 Fwd: [patch] bufmgr Half state CAS Alexandre Felipe
2026/10/15 Re: Wrong results from self-join elimination with inheritance and ONLY Tom Lane