pgsql-hackers

Messages by Date

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
2026/10/15 Re: Fwd: [patch] bufmgr Half state CAS Alexandre Felipe
2026/10/15 Re: Wrong results from self-join elimination with different restriction operators Tom Lane
2026/10/15 Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
2026/10/15 Re: Fix doc: explanation of how postgres works when OOM killer is invoked Takeshi Ideriha
2026/10/15 Re: Randomize B-Tree page split location to avoid oscillating patterns Dmitry Dolgov
2026/10/15 Re: [PATCH] Discard aborted updaters when expanding a multixact Heikki Linnakangas
2026/10/15 Re: Improving scalability of Parallel Bitmap Heap/Index Scan David Geier
2026/10/15 Re: PG19: two RI fast-path issues found while testing the batching revert Amit Langote
2026/10/15 Re: Fix doc: explanation of how postgres works when OOM killer is invoked Takeshi Ideriha
2026/10/15 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
2026/10/14 Re: Publication of same parent table with ONLY-ness mismatch should error Takeshi Ideriha
2026/10/14 [PATCH] plpgsql: detoast a returned record before keeping it in a non-atomic context Muzzammil Sarwar
2026/10/14 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/14 Re: [PATCH v2] Fix races in Windows pthread emulation Alexander Lakhin
2026/10/14 RE: [PATCH] Preserve replication origin OIDs in pg_upgrade Hayato Kuroda (Fujitsu)
2026/10/14 Re: Fix pg_restore gzip stream validation (bug #19754) Chao Li
2026/10/14 Re: [PATCH] Report no unpinned buffers as insufficient resources solai v
2026/10/14 Re: Bug in logical decoding with DDL and subtransactions Tom Lane
2026/10/14 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Fujii Masao
2026/10/14 RE: Patch for migration of the pg_commit_ts directory Hayato Kuroda (Fujitsu)
2026/10/14 Re: DDL deparse Nikhil Sontakke
2026/10/14 Re: meson: pass OpenSSL/ICU include dirs to extensions Aidar Imamov
2026/10/14 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces shihao zhong
2026/10/14 Re: [PG19] Stale state after the join removal restart gives wrong results Tom Lane
2026/10/14 Re: Reducing relcache memory usage: deduping index shapes David Rowley
2026/10/14 [PG19] Indexes from 18 miss rows after pg_upgrade shihao zhong
2026/10/14 Re: Reducing relcache memory usage: deduping index shapes David Rowley
2026/10/14 Re: Bug in logical decoding with DDL and subtransactions David Rowley
2026/10/14 Re: parallel data loading for pgbench -i Koshi Shibagaki (Fujitsu)
2026/10/14 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/14 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong
2026/10/14 [PG19] Promotion hangs behind a backend blocked on a stuck client shihao zhong
2026/10/14 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Haibo Yan
2026/10/14 Re: Parallel autovacuum: honor reduced parallel workers after heap scan phase Bharath Rupireddy
2026/10/14 Weird usages of sentinel_ok() David Rowley
2026/10/14 Re: Wrong results from self-join elimination with different restriction operators Tender Wang
2026/10/14 Re: [PATCH] vacuumdb: Add --exclude-database option Ben Mejia
2026/10/14 Re: REPACK: warn about skipping foreign partitions surya poondla
2026/10/14 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Michael Paquier
2026/10/14 Re: Parallel vacuum: avoid dangling shared memory pointers Bharath Rupireddy
2026/10/14 Re: Fix numeric log() with an infinite value and 0<base<=1 Chao Li
2026/10/14 Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers Bharath Rupireddy
2026/10/14 Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Haibo Yan
2026/10/14 Re: REPACK: warn about skipping foreign partitions Fujii Masao
2026/10/14 Re: Optimize MCV stats for sortable types and utilize sorted-order properties ZizhuanLiu X-MAN
2026/10/14 Re: PG19: two RI fast-path issues found while testing the batching revert Amit Langote
2026/10/14 Re: [PATCH] Report no unpinned buffers as insufficient resources Fujii Masao
2026/10/14 Re: Incorrect CONTEXT reported for errors from parallel apply worker in logical replication Takeshi Ideriha
2026/10/14 Re: Incorrect argument passed to buffer_readv_encode_error() Michael Paquier
2026/10/14 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Sami Imseih
2026/10/14 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Zsolt Parragi
2026/10/14 Re: [PG19] btree_gin misses rows for a timestamptz bound in the repeated DST hour Tom Lane
2026/10/14 Re: find_all_inheritors() with NoLock fails on concurrently dropped sub-partitions Zsolt Parragi
2026/10/14 Re: REPACK: warn about skipping foreign partitions Zsolt Parragi
2026/10/14 Re: find_all_inheritors() with NoLock fails on concurrently dropped sub-partitions surya poondla
2026/10/14 Re: REPACK: warn about skipping foreign partitions surya poondla
2026/10/14 Re: [PG19] pg_dump --statistics restores extended statistics by attribute number Corey Huinker