pgsql-hackers

Messages by Date

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
2026/10/14 Re: [PATCH] pg_upgrade: handle failed nonblocking connects on Windows Heikki Linnakangas
2026/10/14 Re: Fwd: [patch] bufmgr Half state CAS Andres Freund
2026/10/14 Re: parallel data loading for pgbench -i Mircea Cadariu
2026/10/14 Re: updates for handling optional argument in system functions Mark Wong
2026/10/14 RE: Incorrect CONTEXT reported for errors from parallel apply worker in logical replication Hayato Kuroda (Fujitsu)
2026/10/14 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Sami Imseih
2026/10/14 Re: Parallel autovacuum: honor reduced parallel workers after heap scan phase Masahiko Sawada
2026/10/14 Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Andres Freund
2026/10/14 Re: postgres_fdw: Emit message when batch_size is reduced Corey Huinker
2026/10/14 Re: Bug in logical decoding with DDL and subtransactions [email protected]
2026/10/14 Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Haibo Yan
2026/10/14 Re: Bug in logical decoding with DDL and subtransactions [email protected]
2026/10/14 Re: Bug in logical decoding with DDL and subtransactions [email protected]
2026/10/14 Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically Heikki Linnakangas
2026/10/14 Re: Incorrect CONTEXT reported for errors from parallel apply worker in logical replication Takeshi Ideriha
2026/10/14 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Zsolt Parragi
2026/10/14 Re: Incremental backups report progress as if they were full backups Daria Lepikhova
2026/10/14 Re: log XLogPrefetch stats at end of recovery Ashutosh Sharma
2026/10/14 Re: postgres_fdw: transaction mode inheritance corner cases Matheus Alcantara
2026/10/14 Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block Valeriy Degtyarev
2026/10/14 Re: Unlogged materialized views Zsolt Parragi
2026/10/14 Re: PG19: two RI fast-path issues found while testing the batching revert Melanie Plageman
2026/10/14 Re: [PG19] jsonb_object_agg as a window function returns stale values Tom Lane
2026/10/14 Re: [PG19] jsonb_object_agg as a window function returns stale values Melanie Plageman
2026/10/14 Re: meson: pass OpenSSL/ICU include dirs to extensions Aidar Imamov
2026/10/14 Re: Fix numeric log() with an infinite value and 0<base<=1 Tom Lane
2026/10/14 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/14 Re: Improving scalability of Parallel Bitmap Heap/Index Scan David Geier
2026/10/14 Re: Reducing relcache memory usage: deduping index shapes David Rowley
2026/10/14 Re: serializable anomaly - duplicate primary keys Aleksander Alekseev
2026/10/14 Re: SQL-level pg_datum_image_equal Matthias van de Meent
2026/10/14 Re: pg_upgrade fails with a config-only datadir and no --new-bindir Heikki Linnakangas
2026/10/14 Re: Fix numeric log() with an infinite value and 0<base<=1 Matthias van de Meent
2026/10/14 Re: pg_upgrade fails with a config-only datadir and no --new-bindir Tom Lane
2026/10/14 Re: log XLogPrefetch stats at end of recovery Jakub Wartak
2026/10/14 Re: Memoize shows only the last execution's stats for parallel workers Tatsuya Kawata
2026/10/14 Re: Reducing relcache memory usage: deduping index shapes Matthias van de Meent
2026/10/14 Re: [PATCH v1] Batch B-tree TIDs when building a bitmap David Geier
2026/10/14 Re: addFkRecurseReferencing use unassigned fkconstraint->fk_with_period value solai v
2026/10/14 Re: Publication DDL can race with a concurrent UPDATE Nikhil Sontakke
2026/10/14 Re: Bug in logical decoding with DDL and subtransactions Zhijie Hou
2026/10/14 Re: Incremental backups report progress as if they were full backups Fujii Masao
2026/10/14 Re: Memoize shows only the last execution's stats for parallel workers David Rowley
2026/10/14 Re: Fix doc: explanation of how postgres works when OOM killer is invoked Fujii Masao
2026/10/14 Re: Continuous re-validation of session credentials Jakub Wartak
2026/10/14 Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block Ashutosh Sharma
2026/10/14 Fix numeric log() with an infinite value and 0<base<=1 Chao Li
2026/10/14 Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Matthias Dötsch
2026/10/14 Re: PG19: flat-copied RelOptInfos share extension_state with the original rel Shubhankar Anand Kulkarni
2026/10/14 Re: find_all_inheritors() with NoLock fails on concurrently dropped sub-partitions Zsolt Parragi
2026/10/14 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Fujii Masao
2026/10/14 Re: SSI: A patch for a Serializability violation Vaijayanti Bharadwaj
2026/10/14 RE: Test publication.sql racing with subscription.sql might fail due to cache lookup error Hayato Kuroda (Fujitsu)
2026/10/14 RE: Bug in logical decoding with DDL and subtransactions Bingshuai Li
2026/10/14 Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically Bohyun Lee
2026/10/14 Re: GIN jsonpath scans miss rows when methods follow a predicate Fujii Masao
2026/10/14 Re: pg_upgrade fails with a config-only datadir and no --new-bindir Bohyun Lee
2026/10/14 Fix pg_restore gzip stream validation (bug #19754) Chao Li
2026/10/14 Re: Compression of bigger WAL records Michael Paquier
2026/10/14 Re: Incorrect argument passed to buffer_readv_encode_error() Steven Niu
2026/10/14 Re: Assert failure in standard_join_search() Tender Wang
2026/10/14 Re: ERROR: SubPlan found with no parent plan Richard Guo
2026/10/14 Re: pg_upgrade fails with a config-only datadir and no --new-bindir Heikki Linnakangas
2026/10/14 Re: Improving scalability of Parallel Bitmap Heap/Index Scan John Naylor
2026/10/14 Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers Masahiko Sawada
2026/10/13 Re: Test publication.sql racing with subscription.sql might fail due to cache lookup error vignesh C
2026/10/13 Incorrect argument passed to buffer_readv_encode_error() Antonin Houska
2026/10/13 Re: "failed to build any N-way joins" from a five-relation query Richard Guo
2026/10/13 Re: REPACK: warn about skipping foreign partitions solai v
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication Zhijie Hou
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong