pgsql-hackers

Messages by Date

2026/10/18 HashAggregate loses worker spill stats on rescan Ayush Tiwari
2026/10/18 Re: ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases Manu
2026/10/18 Re: BUG #19686: Rolling back SET TABLESPACE Manu
2026/10/18 Re: [DEPARSE] An alias named 'set' on an UPDATE, DELETE or MERGE target does not read back Tom Lane
2026/10/18 Re: [DEPARSE] Pretty-printed sublink test expressions lose needed parentheses Tom Lane
2026/10/18 ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases Greg Burd
2026/10/18 Reject access to unlogged tables in contrib modules Jim Jones
2026/10/18 Re: Reject COPY TO of unlogged relations during recovery Jim Jones
2026/10/18 Re: index prefetching Peter Geoghegan
2026/10/18 Re: [PATCH v1] Batch B-tree TIDs when building a bitmap Peter Geoghegan
2026/10/18 Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting Xuneng Zhou
2026/10/18 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) David Geier
2026/10/18 Re: psql single-step mode woes Rui Zhao
2026/10/18 Re: [DEPARSE] Pretty-printed sublink test expressions lose needed parentheses Sho Ito
2026/10/18 [PATCH] Fix plpgsql's R/W optimization for simple expressions run via SPI Muzzammil Sarwar
2026/10/18 Re: [PATCH] Fix recovery connection detail in EXEC_BACKEND builds Nitin Jadhav
2026/10/18 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Alexander Lakhin
2026/10/17 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Michael Paquier
2026/10/17 Re: PG19: flat-copied RelOptInfos share extension_state with the original rel Shubhankar Anand Kulkarni
2026/10/17 Re: json/jsonb cleanup + FmgrInfo caching Manu
2026/10/17 Re: [PG19] Bugs found comparing 19 with 18, list before I open threads shihao zhong
2026/10/17 Re: BUG #19686: Rolling back SET TABLESPACE shihao zhong
2026/10/17 [PG19] A canceled notify read leaves the NOTIFY queue stuck shihao zhong
2026/10/17 Re: Improving scalability of Parallel Bitmap Heap/Index Scan shihao zhong
2026/10/17 [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS shihao zhong
2026/10/17 Re: Wrong results from a parameterized Append shihao zhong
2026/10/17 Re: json/jsonb cleanup + FmgrInfo caching shihao zhong
2026/10/17 Re: query_int wrongly parses zero-padded input Manu
2026/10/17 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Sami Imseih
2026/10/17 Re: query_int wrongly parses zero-padded input Tom Lane
2026/10/17 Re: query_int wrongly parses zero-padded input Tom Lane
2026/10/17 Re: query_int wrongly parses zero-padded input Manu
2026/10/17 Re: query_int wrongly parses zero-padded input Manu
2026/10/17 Re: UNDO with FILEOPS, and the FLUX table AM Manu
2026/10/17 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Tom Lane
2026/10/17 Re: query_int wrongly parses zero-padded input Tom Lane
2026/10/17 Re: [PATCH] Extensible ReadyForQuery wire protocol message and C hook, for connection pools and WAIT FOR LSN Manu
2026/10/17 Re: Possible race condition in pg_basebackup Raja Sai pranav
2026/10/17 query_int wrongly parses zero-padded input Marko Grujic
2026/10/17 Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
2026/10/17 Re: Parallel vacuum: check XID wraparound failsafe between indexes Sami Imseih
2026/10/17 Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...) Manu
2026/10/17 Re: Add Dockerfile for OSS Scanner Andres Freund
2026/10/17 Re: Add Dockerfile for OSS Scanner Sehrope Sarkuni
2026/10/17 Re: Add Dockerfile for OSS Scanner Noah Misch
2026/10/17 Re: Add Dockerfile for OSS Scanner Noah Misch
2026/10/17 Re: Add Dockerfile for OSS Scanner Ayush Tiwari
2026/10/17 Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Zhijie Hou
2026/10/17 Bug in multi-level nbtree page deletion Peter Geoghegan
2026/10/17 Re: Add Dockerfile for OSS Scanner Ayush Tiwari
2026/10/17 Re: Add Dockerfile for OSS Scanner Noah Misch
2026/10/17 Re: Assert failure in create_lateral_join_info Ayush Tiwari
2026/10/17 Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows harrisontbooth
2026/10/17 Re: Add Dockerfile for OSS Scanner Sehrope Sarkuni
2026/10/17 Re: Reduce logging during prepared transaction recovery Pierre Forstmann
2026/10/17 Re: [PATCH] Add immediate_global_insert_visibility GUC for immediate frozen inserts Osama Abdul Qader
2026/10/17 [PATCH] Add immediate_global_insert_visibility GUC for immediate frozen inserts Hannu Krosing
2026/10/17 An intro about myself and an important notification Osama Abdul Qader
2026/10/17 Re: Assert failure in standard_join_search() Richard Guo
2026/10/17 Re: Bug in logical decoding with DDL and subtransactions Manu
2026/10/17 Re: pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF Manu
2026/10/17 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
2026/10/17 Re: Internal error codes triggered by regression tests and user queries, take 2 Alexander Lakhin
2026/10/17 Re: Reject COPY TO of unlogged relations during recovery Jim Jones
2026/10/17 Re: regress: query discrepancy between explain vs execution Pierre Forstmann
2026/10/17 Re: pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF Zsolt Parragi
2026/10/17 Re: [PG19] Eager aggregation runs a volatile join clause once per group Manu
2026/10/17 pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF Manu
2026/10/17 Re: PG19: flat-copied RelOptInfos share extension_state with the original rel Sho Ito
2026/10/16 Re: Bug in logical decoding with DDL and subtransactions Ayush Tiwari
2026/10/16 [PG19] CREATE SCHEMA puts an index or trigger on a same-named temp table shihao zhong
2026/10/16 Re: First draft of PG 19 release notes shihao zhong
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