pgsql-hackers  

Messages by Thread

• • Re: Internal error codes triggered by regression tests and user queries, take 2 Andres Freund
  • Re: Internal error codes triggered by regression tests and user queries, take 2 Kirill Reshke
• Re: regress: query discrepancy between explain vs execution Pierre Forstmann
  • Re: regress: query discrepancy between explain vs execution David Rowley
  • Re: regress: query discrepancy between explain vs execution Matthias van de Meent
  • Re: regress: query discrepancy between explain vs execution David Rowley
• 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
  • Re: [PG19] CREATE SCHEMA puts an index or trigger on a same-named temp table Tom Lane
  • Re: [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: Add Dockerfile for OSS Scanner Noah Misch
• Re: Fix stale allocChunkLimit when recycling AllocSet Donghang Lin
  • Re: Fix stale allocChunkLimit when recycling AllocSet Chao Li
  • Re: Fix stale allocChunkLimit when recycling AllocSet David Rowley
  • Re: Fix stale allocChunkLimit when recycling AllocSet Chao Li
• 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: Add a hook for handling logical decoding messages on subscribers. Masahiko Sawada
  • Re: Add a hook for handling logical decoding messages on subscribers. Masahiko Sawada
  • Re: Add a hook for handling logical decoding messages on subscribers. Bharath Rupireddy
  • Re: Add a hook for handling logical decoding messages on subscribers. Zhijie Hou
  • Re: Add a hook for handling logical decoding messages on subscribers. Amit Kapila
  • Re: Add a hook for handling logical decoding messages on subscribers. torikoshia
• 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
  • Re: Remove obsolete locking comment from AddBufferToRing() Pierre Forstmann
  • Re: Remove obsolete locking comment from AddBufferToRing() Heikki Linnakangas
  • Re: 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: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Amit Kapila
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Zhijie Hou
  • RE: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Hayato Kuroda (Fujitsu)
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Zhijie Hou
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner vignesh C
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Zhijie Hou
  • Re: [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 Amit Kapila
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner vignesh C
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Amit Kapila
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Ajin Cherian
  • Re: [PG19] Sequence sync stops when the subscription owner can't SET ROLE to a sequence owner Ajin Cherian
• Re: Historic snapshot doesn't track txns committed inBUILDING_SNAPSHOT state Álvaro Herrera
  • Re: Historic snapshot doesn't track txns committed inBUILDING_SNAPSHOT state Zhijie Hou
• Parallel vacuum: check XID wraparound failsafe between indexes Bharath Rupireddy
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Sami Imseih
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Bharath Rupireddy
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Sami Imseih
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Zsolt Parragi
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Bharath Rupireddy
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Zsolt Parragi
  • Re: Parallel vacuum: check XID wraparound failsafe between indexes Bharath Rupireddy
• pgstat: don't assert on dropped entries when writing stats file Sami Imseih
  • Re: pgstat: don't assert on dropped entries when writing stats file Michael Paquier
  • Re: pgstat: don't assert on dropped entries when writing stats file Michael Paquier
  • Re: pgstat: don't assert on dropped entries when writing stats file Sami Imseih
  • Re: pgstat: don't assert on dropped entries when writing stats file Michael Paquier
  • Re: pgstat: don't assert on dropped entries when writing stats file Michael Paquier
• [PATCH] Small gaps in IoWorkerMain() error handling Ayush Tiwari
• Re: gcc 15 "array subscript 0" warning at level -O3 Tristan Partin
• Re: contrib/pg_stat_tcpinfo Jakub Wartak
• Use a bulk-write buffer access strategy for TOAST inserts Bertrand Drouvot
  • Re: Use a bulk-write buffer access strategy for TOAST inserts Andres Freund
• 回复：logical decoding: skip unnecessary snapshot distribution. yangboyu
  • Re: logical decoding: skip unnecessary snapshot distribution. Shlok Kyal
• Re：logical decoding: skip unnecessary snapshot distribution. 杨伯宇(长堂)
• 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
  • 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
• Assert failure in create_lateral_join_info Richard Guo
  • Re: Assert failure in create_lateral_join_info Ayush Tiwari
  • Re: Assert failure in create_lateral_join_info Richard Guo
• 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: 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
  • Re: [***DKIM violation***] Re: [PATCH] Fix JSON_SERIALIZE() coercion placeholder type for jsonb input Zsolt Parragi
  • Re: [***DKIM violation***] Re: [PATCH] Fix JSON_SERIALIZE() coercion placeholder type for jsonb input Nikhil Sontakke
• 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
• Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Greg Burd
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Greg Burd
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Greg Burd
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Greg Burd
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Greg Burd
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
  • Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
• [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
  • Re: Showing "Table Block Fetches" in EXPLAIN ANALYZE for index-only scans Greg Burd
• 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
  • 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
  • Re: Reject COPY TO of unlogged relations during recovery Masahiko Sawada
• 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
• Re: [PATCH] Halve peak memory allocation for toast_flatten_tuple Johannes Edmeier
  • Re: [PATCH] Halve peak memory allocation for toast_flatten_tuple Pavel Borisov
• walreceiver: stale hot_standby_feedback xmin on primary when wal_receiver_status_interval = 0 (PG16 and later) Vaibhav Dalvi
  • Re: walreceiver: stale hot_standby_feedback xmin on primary when wal_receiver_status_interval = 0 (PG16 and later) Vaibhav Dalvi
  • Re: 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: SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator David Rowley
  • Re: SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator David Rowley
  • Re: SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator Andrei Lepikhov
• 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
  • Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
  • Re: Publication of same parent table with ONLY-ness mismatch should error shveta malik
  • Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
  • Re: Publication of same parent table with ONLY-ness mismatch should error shveta malik
  • Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
  • Re: Publication of same parent table with ONLY-ness mismatch should error kedar anavardekar
  • Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
  • Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
  • Re: Publication of same parent table with ONLY-ness mismatch should error shveta malik
  • Re: Publication of same parent table with ONLY-ness mismatch should error Chao Li
  • Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
  • Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
• [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
  • Re: [PG19] Indexes from 18 miss rows after pg_upgrade Andreas Karlsson
  • Re: [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
  • Re: [PG19] Indexes from 18 miss rows after pg_upgrade Jeff Davis
• [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

• Earlier messages
• Later messages