pgsql-hackers  

Messages by Thread

• [PG19] A canceled notify read leaves the NOTIFY queue stuck shihao zhong
• [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS shihao zhong
• query_int wrongly parses zero-padded input Marko Grujic
  • Re: query_int wrongly parses zero-padded input Tom Lane
  • Re: query_int wrongly parses zero-padded input Manu
  • Re: query_int wrongly parses zero-padded input Tom Lane
  • Re: query_int wrongly parses zero-padded input Manu
  • Re: query_int wrongly parses zero-padded input Tom Lane
  • Re: query_int wrongly parses zero-padded input Manu
• Bug in multi-level nbtree page deletion Peter Geoghegan
• Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows harrisontbooth
• [PATCH] Add immediate_global_insert_visibility GUC for immediate frozen inserts Hannu Krosing
  • Re: [PATCH] Add immediate_global_insert_visibility GUC for immediate frozen inserts Osama Abdul Qader
• An intro about myself and an important notification Osama Abdul Qader
• pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF Manu
  • Re: pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF Zsolt Parragi
  • Re: pg_upgrade stores an invalid datminmxid/relminmxid when the old cluster's newest multixact is 0xFFFFFFFF Manu
• [PG19] CREATE SCHEMA puts an index or trigger on a same-named temp table shihao zhong
• Add Dockerfile for OSS Scanner Noah Misch
  • Re: Add Dockerfile for OSS Scanner Sehrope Sarkuni
  • Re: Add Dockerfile for OSS Scanner Noah Misch
  • Re: Add Dockerfile for OSS Scanner Ayush Tiwari
  • Re: Add Dockerfile for OSS Scanner Noah Misch
  • Re: Add Dockerfile for OSS Scanner Ayush Tiwari
  • Re: Add Dockerfile for OSS Scanner Andres Freund
  • Re: Add Dockerfile for OSS Scanner Noah Misch
  • Re: Add Dockerfile for OSS Scanner Sehrope Sarkuni
• Re: Fix stale allocChunkLimit when recycling AllocSet Donghang Lin
• Re: Prevent foreign key references to unlogged partitions Zsolt Parragi
• Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773 Michael Banck
• [PG19] pg_upgrade transfers temporal keys using gist_inet_ops with the wrong opclass Zsolt Parragi
• Re: ALTER TABLE uses a bistate but not for toast tables Bertrand Drouvot
• Re: [PATCH] Fix orphaned backend processes on Windows using Job Objects Harrison Booth
• Remove obsolete locking comment from AddBufferToRing() Chao Li
• [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Zsolt Parragi
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Zhijie Hou
• Re: Historic snapshot doesn't track txns committed inBUILDING_SNAPSHOT state Álvaro Herrera
• Parallel vacuum: check XID wraparound failsafe between indexes Bharath Rupireddy
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Sami Imseih
• pgstat: don't assert on dropped entries when writing stats file Sami Imseih
• [PATCH] Small gaps in IoWorkerMain() error handling Ayush Tiwari
• Re: gcc 15 "array subscript 0" warning at level -O3 Tristan Partin
• Use a bulk-write buffer access strategy for TOAST inserts Bertrand Drouvot
• Re：logical decoding: skip unnecessary snapshot distribution. 杨伯宇(长堂)
• Assert failure in create_lateral_join_info Richard Guo
  • Re: Assert failure in create_lateral_join_info Ayush Tiwari
• Revert libpq servicefile connection option in v19 (info leak and uninterruptible backend DoS) Sehrope Sarkuni
  • Re: Revert libpq servicefile connection option in v19 (info leak and uninterruptible backend DoS) Michael Paquier
• Re: [***DKIM violation***] Re: [PATCH] Fix JSON_SERIALIZE() coercion placeholder type for jsonb input Staroverov Ilja
• Parallel TID Range Scan returns wrong results on rescan Zsolt Parragi
  • Re: Parallel TID Range Scan returns wrong results on rescan shihao zhong
  • Re: Parallel TID Range Scan returns wrong results on rescan David Rowley
• [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound Zsolt Parragi
  • Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound shihao zhong
  • Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound Álvaro Herrera
  • Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound Heikki Linnakangas
  • Re: [PG19] pg_upgrade from <= 18 loses the newest multixid if its members end at offset wraparound shihao zhong
• Showing "Table Block Fetches" in EXPLAIN ANALYZE for index-only scans Peter Geoghegan
  • Re: Showing "Table Block Fetches" in EXPLAIN ANALYZE for index-only scans Sami Imseih
• Reject COPY TO of unlogged relations during recovery Jim Jones
  • Re: Reject COPY TO of unlogged relations during recovery Zsolt Parragi
  • Re: Reject COPY TO of unlogged relations during recovery Jim Jones
  • Re: Reject COPY TO of unlogged relations during recovery Jim Jones
  • Re: Reject COPY TO of unlogged relations during recovery Masahiko Sawada
  • Re: Reject COPY TO of unlogged relations during recovery Jim Jones
• doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Naeem Akhter
  • Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Naga Appani
  • Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Fujii Masao
  • Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Michael Paquier
  • Re: doc: fix pg_get_multixact_stats() num_mxids type (integer -> bigint) Fujii Masao
• [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Sami Imseih
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Sami Imseih
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Sami Imseih
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Fujii Masao
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Baji Shaik
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Chao Li
  • Re: [PATCH] Doc fix for autovacuum_max_parallel_workers Fujii Masao
• [PATCH 0/2] Improve ndistinct estimates for flattened UNION ALL zengxx
  • Re: [PATCH 0/2] Improve ndistinct estimates for flattened UNION ALL David Rowley
  • Re: [PATCH 0/2] Improve ndistinct estimates for flattened UNION ALL zengxx
• walreceiver: stale hot_standby_feedback xmin on primary when wal_receiver_status_interval = 0 (PG16 and later) Vaibhav Dalvi
• Re: SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator David Rowley
• Re: Add TOAST statistics columns to pg_stat_all_tables solai v
• Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() Heikki Linnakangas
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() Japin Li
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() David Rowley
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() David Rowley
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() Tom Lane
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() Heikki Linnakangas
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
  • Re: Avoid repeated scans of the output buffer in oidvectortypes() Chao Li
• Re: Randomize B-Tree page split location to avoid oscillating patterns Dmitry Dolgov
• Re: Publication of same parent table with ONLY-ness mismatch should error Takeshi Ideriha
• [PATCH] plpgsql: detoast a returned record before keeping it in a non-atomic context Muzzammil Sarwar
• RE: Patch for migration of the pg_commit_ts directory Hayato Kuroda (Fujitsu)
  • Re: Patch for migration of the pg_commit_ts directory Maxim Orlov
• [PG19] Indexes from 18 miss rows after pg_upgrade shihao zhong
  • Re: [PG19] Indexes from 18 miss rows after pg_upgrade Jeff Davis
  • Re: [PG19] Indexes from 18 miss rows after pg_upgrade shihao zhong
• [PG19] Promotion hangs behind a backend blocked on a stuck client shihao zhong
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Fujii Masao
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Fujii Masao
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Masahiko Sawada
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Fujii Masao
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client shihao zhong
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Masahiko Sawada
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Manu
  • RE: [PG19] Promotion hangs behind a backend blocked on a stuck client Hayato Kuroda (Fujitsu)
• Weird usages of sentinel_ok() David Rowley
  • Re: Weird usages of sentinel_ok() shihao zhong
  • Re: Weird usages of sentinel_ok() David Rowley
  • Re: Weird usages of sentinel_ok() David Rowley
• Re: log XLogPrefetch stats at end of recovery Jakub Wartak
  • Re: log XLogPrefetch stats at end of recovery Ashutosh Sharma
• Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block Ashutosh Sharma
  • Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block Valeriy Degtyarev
• Fix numeric log() with an infinite value and 0<base<=1 Chao Li
  • Re: Fix numeric log() with an infinite value and 0<base<=1 Matthias van de Meent
  • Re: Fix numeric log() with an infinite value and 0<base<=1 Tom Lane
  • Re: Fix numeric log() with an infinite value and 0<base<=1 Chao Li
  • Re: Fix numeric log() with an infinite value and 0<base<=1 Matthias van de Meent
  • Re: Fix numeric log() with an infinite value and 0<base<=1 Tom Lane
  • Re: Fix numeric log() with an infinite value and 0<base<=1 Chao Li
• Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Matthias Dötsch
  • Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Haibo Yan
  • Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Andres Freund
  • Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Haibo Yan
  • Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Matthias Dötsch
  • Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() Haibo Yan
  • Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() David Geier
• Re: SSI: A patch for a Serializability violation Vaijayanti Bharadwaj
• Fix pg_restore gzip stream validation (bug #19754) Chao Li
  • Re: Fix pg_restore gzip stream validation (bug #19754) Chao Li
  • Re: Fix pg_restore gzip stream validation (bug #19754) stefangrassl
  • Re: Fix pg_restore gzip stream validation (bug #19754) Chao Li
  • Re: Fix pg_restore gzip stream validation (bug #19754) Daniel Gustafsson
• Incorrect argument passed to buffer_readv_encode_error() Antonin Houska
  • Re: Incorrect argument passed to buffer_readv_encode_error() Steven Niu
  • Re: Incorrect argument passed to buffer_readv_encode_error() Michael Paquier
• Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Corey Huinker
• Parallel vacuum: workers together with leader could overrun cost budget Bharath Rupireddy
  • Re: Parallel vacuum: workers together with leader could overrun cost budget Masahiko Sawada
• Parallel vacuum: avoid dangling shared memory pointers Bharath Rupireddy
  • Re: Parallel vacuum: avoid dangling shared memory pointers Masahiko Sawada
  • Re: Parallel vacuum: avoid dangling shared memory pointers Bharath Rupireddy
  • Re: Parallel vacuum: avoid dangling shared memory pointers Masahiko Sawada
• Parallel autovacuum: honor reduced parallel workers after heap scan phase Bharath Rupireddy
  • Re: Parallel autovacuum: honor reduced parallel workers after heap scan phase Masahiko Sawada
  • Re: Parallel autovacuum: honor reduced parallel workers after heap scan phase Bharath Rupireddy
• Re: UNDO with FILEOPS, and the FLUX table AM Manu
  • Re: UNDO with FILEOPS, and the FLUX table AM Manu
  • Re: UNDO with FILEOPS, and the FLUX table AM Manu
• GIN jsonpath scans miss rows when methods follow a predicate Fujii Masao
  • Re: GIN jsonpath scans miss rows when methods follow a predicate Tom Lane
  • Re: GIN jsonpath scans miss rows when methods follow a predicate Fujii Masao
• [DEPARSE] Operators on ROW() constructors read back as row comparisons Henson Choi
• [DEPARSE] IS DOCUMENT as an operand loses needed parentheses Henson Choi
• Re: use radix tree for bitmap heap scan David Geier
  • Re: use radix tree for bitmap heap scan David Geier
  • Re: use radix tree for bitmap heap scan John Naylor
• [PATCH] pg_test_fsync: close Windows alarm thread handles harrisontbooth
  • Re: [PATCH] pg_test_fsync: close Windows alarm thread handles Álvaro Herrera
  • Re: [PATCH] pg_test_fsync: close Windows alarm thread handles Heikki Linnakangas
• pg_upgrade fails with a config-only datadir and no --new-bindir Heikki Linnakangas
  • Re: pg_upgrade fails with a config-only datadir and no --new-bindir Chao Li
  • Re: pg_upgrade fails with a config-only datadir and no --new-bindir Heikki Linnakangas
  • Re: pg_upgrade fails with a config-only datadir and no --new-bindir Bohyun Lee
  • Re: pg_upgrade fails with a config-only datadir and no --new-bindir Heikki Linnakangas
  • Re: pg_upgrade fails with a config-only datadir and no --new-bindir Tom Lane
• Re: CREATE OR REPLACE MATERIALIZED VIEW Robert Haas
• [PATCH] pg_upgrade: handle failed nonblocking connects on Windows Harrison Booth
  • Re: [PATCH] pg_upgrade: handle failed nonblocking connects on Windows Heikki Linnakangas
  • Re: [PATCH] pg_upgrade: handle failed nonblocking connects on Windows Harrison Booth
• CF6204 test module: explicitly mark the Windows fixture sparse harrisontbooth
• Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Matthias van de Meent
  • Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Haibo Yan
  • Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Haibo Yan
  • Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) David Geier
  • Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Matthias van de Meent
  • Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Álvaro Herrera
• pg_stat_statements: simplify SQL API version tracking Sami Imseih
• Re: Available disk space per tablespace harrisontbooth
• Re: postgres_fdw: Emit message when batch_size is reduced Robert Haas
  • Re: postgres_fdw: Emit message when batch_size is reduced Corey Huinker
  • Re: postgres_fdw: Emit message when batch_size is reduced Robert Haas
  • Re: postgres_fdw: Emit message when batch_size is reduced Corey Huinker
• [PATCH] reindexdb: Fix schema name lookup in parallel mode Koshi Shibagaki (Fujitsu)
• Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned Álvaro Herrera
  • Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned Richard Guo
  • Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned shihao zhong

• Earlier messages