pgsql-hackers  

Messages by Thread

• • Re: [PATCH] Remove useless ORDER BY from scalar subqueries David Rowley
• Re: XMLSerialize: version and explicit XML declaration Jim Jones
• HashAggregate loses worker spill stats on rescan Ayush Tiwari
  • Re: HashAggregate loses worker spill stats on rescan Osama Abdul Qader
  • Re: HashAggregate loses worker spill stats on rescan Ayush Tiwari
• ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases Greg Burd
  • Re: ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases Manu
  • Re: ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases Jeff Davis
  • Re: ILIKE '%' never matches a non-ASCII byte in single-byte C-ctype databases Greg Burd
• Reject access to unlogged tables in contrib modules Jim Jones
• Re: psql single-step mode woes Rui Zhao
• [PATCH] Fix plpgsql's R/W optimization for simple expressions run via SPI Muzzammil Sarwar
• [PG19] A canceled notify read leaves the NOTIFY queue stuck shihao zhong
  • Re: [PG19] A canceled notify read leaves the NOTIFY queue stuck Tom Lane
  • Re: [PG19] A canceled notify read leaves the NOTIFY queue stuck Tom Lane
  • Re: [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
  • Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS Fujii Masao
  • Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS Chao Li
  • Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS shihao zhong
  • Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS Chao Li
  • Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS Jeff Davis
  • Re: [PG19] ILIKE index scan misses rows with a libc UTF-8 collation on macOS Jeff Davis
• 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
  • Re: query_int wrongly parses zero-padded input Chao Li
  • Re: query_int wrongly parses zero-padded input Marko Grujic
  • Re: query_int wrongly parses zero-padded input Chao Li
  • Re: query_int wrongly parses zero-padded input Marko Grujic
  • Re: query_int wrongly parses zero-padded input Tom Lane
• Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...) 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
• Re: Internal error codes triggered by regression tests and user queries, take 2 Alexander Lakhin
• 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: 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: [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
• 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
• 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. 杨伯宇(长堂)
• 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
• 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
  • 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: 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
• [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
• [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 shihao zhong
  • Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Masahiko Sawada

• Earlier messages
• Later messages