pgsql-hackers

Messages by Date

2026/10/29 Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
2026/10/29 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Michael Paquier
2026/10/29 Re: 041_checkpoint_at_promote.pl might fail due to race condition on child kill Fujii Masao
2026/10/29 Re: Assert failure in parallel query due to SubPlan double visit for hash join David Geier
2026/10/29 Propagate LIMIT bound through the outer side of left join Andrei Lepikhov
2026/10/29 Uncancellable infinite loop in xpath() with entity references Jim Jones
2026/10/29 [PATCH] dynahash.c refactoring Aleksander Alekseev
2026/10/29 Re: Logical replication: lost updates/deletes and invalid log messages caused by SnapshotDirty + concurrent updates Mihail Nikalayeu
2026/10/29 Re: Proposal: Conflict log history table for Logical Replication Dilip Kumar
2026/10/29 Re: BUG #19776: pg_combinebackup ignores the truncation_block_length of an intermediate incremental backup Rajesh Kumar Thandapani
2026/10/29 Re: Avoid resetting subscription two_phase state to pending when already enabled Bertrand Drouvot
2026/10/29 Re: Avoid resetting subscription two_phase state to pending when already enabled vignesh C
2026/10/29 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces jian he
2026/10/29 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Amit Kapila
2026/10/29 Re: Avoid resetting subscription two_phase state to pending when already enabled shveta malik
2026/10/29 Re: Report buffer access strategies in EXPLAIN Bertrand Drouvot
2026/10/29 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/29 Re: tablecmds: Deadlock caused by Attach Partition Chao Li
2026/10/29 Re: [PATCH] pgcrypto: Fix sha-crypt rounds= values that do not fit in int (BUG #19743) Takeshi Ideriha
2026/10/29 Re: Avoid resetting subscription two_phase state to pending when already enabled Zhijie Hou
2026/10/29 Re: [PATCH] Preserve replication origin OIDs in pg_upgrade Ajin Cherian
2026/10/28 Re: [PG19] Eager aggregation runs a volatile join clause once per group Richard Guo
2026/10/28 Re: Avoid resetting subscription two_phase state to pending when already enabled shveta malik
2026/10/28 Re: [PG19] Indexes from 18 miss rows after pg_upgrade Jeff Davis
2026/10/28 Re: Parallel Apply vignesh C
2026/10/28 Re: [PG19] pg_upgrade --check passes, then the upgrade fails Kirill Reshke
2026/10/28 Re: [PATCH] pgcrypto: Fix sha-crypt rounds= values that do not fit in int (BUG #19743) Takeshi Ideriha
2026/10/28 Remove unused is_redo argument from pgstat_execute_transactional_drops() Chao Li
2026/10/28 Re: Add wait events for server logging destination writes 신성준
2026/10/28 Re: [PG19] pg_upgrade --check passes, then the upgrade fails Kirill Reshke
2026/10/28 Re: ALTER COLUMN SET NOT NULL differ from ALTER TABLE ADD CONSTRAINT Haibo Yan
2026/10/28 Racing in ROLLBACK PREAPRED and checkpoint shihao zhong
2026/10/28 Re: Fix BRIN numeric_minmax_multi_ops out of range value range merging Kirill Reshke
2026/10/28 Re: two small tab-completion patches (ALTER CONSTRAINT, CHECK modifiers) Baji Shaik
2026/10/28 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Bertrand Drouvot
2026/10/28 Re: ALTER COLUMN SET NOT NULL differ from ALTER TABLE ADD CONSTRAINT shihao zhong
2026/10/28 Re: Be strict when request to flush past end of WAL in WaitXLogInsertionsToFinish surya poondla
2026/10/28 Re: SQL/JSON DEFAULT ON ERROR/ON EMPTY evaluation fail should rethrow error unconditionally jian he
2026/10/28 Re: [PATCH]Fix planner's strictness check for JsonExpr ethantran
2026/10/28 Re: PROXY protocol support Julien Riou
2026/10/28 Re: Reduce logging during prepared transaction recovery Chao Li
2026/10/28 Re: [PATCH] Fix PITR pause bypass when initial XLOG_RUNNING_XACTS has subxid overflow Fujii Masao
2026/10/28 Re: [PATCH] Fix PITR pause bypass when initial XLOG_RUNNING_XACTS has subxid overflow Fujii Masao
2026/10/28 Re: Bogus recovery conflicts due to outdated XLogReceiptTime shihao zhong
2026/10/28 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Michael Paquier
2026/10/28 [PG19] NOT NULL constraint is trusted by snapshots older than it shihao zhong
2026/10/28 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Michael Paquier
2026/10/28 Re: [PG19] pg_upgrade --check passes, then the upgrade fails shihao zhong
2026/10/28 Re: SQL/JSON DEFAULT ON ERROR/ON EMPTY evaluation fail should rethrow error unconditionally Amit Langote
2026/10/28 Re: [PG19] Wrong results from Memoize with a nondeterministic collation shihao zhong
2026/10/28 Re: [PG19] Wrong results from Memoize with a nondeterministic collation Richard Guo
2026/10/28 Re: [PG19] Wrong results from Memoize with a nondeterministic collation shihao zhong
2026/10/28 Re: pg_upgrade doesn't copy ICU rules on template0 shihao zhong
2026/10/28 Re: [PG19] Wrong results from Memoize with a nondeterministic collation Richard Guo
2026/10/28 Re: [PATCH] Consider window functions when reordering GROUP BY items Keyerror Smart
2026/10/28 Re: Parallel vacuum: check XID wraparound failsafe between indexes Zsolt Parragi
2026/10/28 Re: Any reason to keep HEAP_HASOID_OLD? shihao zhong
2026/10/28 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/28 Re: [PG19] pg_upgrade --check passes, then the upgrade fails Masahiko Sawada
2026/10/28 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/28 Re: Fix stale relcache fields for TOAST indexes during REINDEX CONCURRENTLY Michael Paquier
2026/10/28 Re: Assert failure in parallel query due to SubPlan double visit for hash join Sami Imseih
2026/10/28 Re: Logical replication: lost updates/deletes and invalid log messages caused by SnapshotDirty + concurrent updates Zsolt Parragi
2026/10/28 LWLock tranches registered by SLRUs are thrown away at startup Bryan Green
2026/10/28 Re: Fix BRIN numeric_minmax_multi_ops out of range value range merging Tomas Vondra
2026/10/28 Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block Thomas Munro
2026/10/28 Re: Add REPACK progress phases for logical decoding setup Sami Imseih
2026/10/28 Re: Add REPACK progress phases for logical decoding setup Masahiko Sawada
2026/10/28 Re: Report buffer access strategies in EXPLAIN Sami Imseih
2026/10/28 inet/cidr: IPv4 prefix length overflows int and passes the range check Iliia Khaprov
2026/10/28 [PATCH] RFC: new_oid_hook, to let an extension propose catalog OIDs RekGRpth
2026/10/28 Re: Fix stale relcache fields for TOAST indexes during REINDEX CONCURRENTLY Bharath Rupireddy
2026/10/28 Re: Publication of same parent table with ONLY-ness mismatch should error Peter Smith
2026/10/28 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Andres Freund
2026/10/28 Re: Hash index inserts serialise on the metapage tuple counter Greg Burd
2026/10/28 Re: Parallel vacuum: workers together with leader could overrun cost budget Masahiko Sawada
2026/10/28 Re: Event trigger table rewrite doc missing ALTER MATERIALIZED VIEW case surya poondla
2026/10/28 Re: [PATCH] Remove useless ORDER BY from scalar subqueries David Rowley
2026/10/28 pg_upgrade doesn't copy ICU rules on template0 Heikki Linnakangas
2026/10/28 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Manu
2026/10/28 Re: Wrong results from an antijoin Dongpo Liu
2026/10/28 Re: PoC: Simplify recovery after dropping a table by LOGGING the restore LSN Salma Elsayed
2026/10/28 Re: pgsql: Set HEAP_XMAX_INVALID for tuples updated by aborted subtransacti Robert Haas
2026/10/28 Review: Price hashed aggregation for hash tables that exceed CPU cache capacity ethantran
2026/10/28 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Sami Imseih
2026/10/28 Re: [(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table Manu
2026/10/28 Re: Assertion with aborted UPDATE in subtransaction Lionel Hamayon
2026/10/28 Re: Parallel vacuum: check XID wraparound failsafe between indexes Bharath Rupireddy
2026/10/28 Re: PoC: true in-place major version upgrades John Naylor
2026/10/28 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Andres Freund
2026/10/28 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Ayoub Kazar
2026/10/28 Re: [PATCH v1 0/7] Wait event timing and tracing instrumentation Andres Freund
2026/10/28 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Tom Lane
2026/10/28 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/28 Re: [PATCH] Use maintenance_io_concurrency for parallel index builds Jingtang Zhang
2026/10/28 Re: kqueue backend for pgbench Jeff Anton
2026/10/28 Re: Quickselect instead of a heap for ORDER BY ... LIMIT N large bounded sorts Greg Burd
2026/10/28 Re: Return pg_control from pg_backup_stop(). David Steele
2026/10/28 Re: Deadlock detector fails to activate on a hot standby replica Xuneng Zhou
2026/10/28 Re: [PATCH] GROUP BY ALL: the regroupening Matheus Alcantara
2026/10/28 Re: kqueue backend for pgbench Roman Khapov
2026/10/28 Re: [PATCH] GROUP BY ALL: the regroupening Matheus Alcantara
2026/10/28 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/28 Re: Proposal: SELECT * EXCLUDE (...) command Hunaid Sohail
2026/10/28 Re: Quickselect instead of a heap for ORDER BY ... LIMIT N large bounded sorts John Naylor
2026/10/28 Re: pg_upgrade doesn't copy ICU rules on template0 Tom Lane
2026/10/28 Re: PoC: true in-place major version upgrades John Naylor
2026/10/28 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Greg Burd
2026/10/28 Re: Report buffer access strategies in EXPLAIN Bertrand Drouvot
2026/10/28 Re: Fix BRIN numeric_minmax_multi_ops out of range value range merging Kirill Reshke
2026/10/28 Re: Reduce logging during prepared transaction recovery Fujii Masao
2026/10/28 Re: Asynchronous MergeAppend Alexander Pyhalov
2026/10/28 Re: Reduce logging during prepared transaction recovery Ashutosh Sharma
2026/10/28 Re: Reporting WAL replay progress during pre-consistency standby reovery Fujii Masao
2026/10/28 Re: Return pg_control from pg_backup_stop(). David Steele
2026/10/28 Re: SQL/JSON DEFAULT ON ERROR/ON EMPTY evaluation fail should rethrow error unconditionally Amit Langote
2026/10/28 Re: Return pg_control from pg_backup_stop(). Heikki Linnakangas
2026/10/28 Re: SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator Andrei Lepikhov
2026/10/28 Re: Add compiler option -fstrict-flex-arrays=1 Peter Eisentraut
2026/10/28 Re: [(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table Jakub Wartak
2026/10/28 Re: [PATCH] Remove useless ORDER BY from scalar subqueries Iliia Khaprov
2026/10/28 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/28 Re: Return pg_control from pg_backup_stop(). David Steele
2026/10/28 Re: [PATCH] Remove unused PageIsPredicateLocked() Fujii Masao
2026/10/28 RE: Logical replication: lost updates/deletes and invalid log messages caused by SnapshotDirty + concurrent updates Hayato Kuroda (Fujitsu)
2026/10/27 Re: multi-row INSERT broken with a sublink in a target column subscript Chao Li
2026/10/27 Re: kqueue backend for pgbench Roman Khapov
2026/10/27 Re: Fix stale relcache fields for TOAST indexes during REINDEX CONCURRENTLY Michael Paquier
2026/10/27 Re: [PATCH] add missed tests for gist index shihao zhong
2026/10/27 Re: SQL/JSON DEFAULT ON ERROR/ON EMPTY evaluation fail should rethrow error unconditionally jian he
2026/10/27 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/27 Re: kqueue backend for pgbench Yura Sokolov
2026/10/27 Re: kqueue backend for pgbench Kirill Reshke
2026/10/27 Re: Print pgbench results on SIGINT Roman Khapov
2026/10/27 Re: Use C11 alignas instead of palloc/malloc for alignment Rui Zhao
2026/10/27 Re: Fix stale relcache fields for TOAST indexes during REINDEX CONCURRENTLY Michael Paquier
2026/10/27 Re: Row pattern recognition jian he
2026/10/27 Re: Any reason to keep HEAP_HASOID_OLD? David Rowley
2026/10/27 Re: [PATCH] regression test: view and rule definitions must round trip Ashutosh Bapat
2026/10/27 Re: Deadlock detector fails to activate on a hot standby replica shihao zhong
2026/10/27 Re: bug: query returns different result with and without memoization. Richard Guo
2026/10/27 Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block shihao zhong
2026/10/27 Re: tablecmds: Deadlock caused by Attach Partition shihao zhong
2026/10/27 Return INT_MAX or INT_MIN from strtoint() on overflow Chao Li
2026/10/27 ICU fixed digit reordering bug Peter Eisentraut
2026/10/27 Re: SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator David Rowley
2026/10/27 multi-row INSERT broken with a sublink in a target column subscript Amit Langote
2026/10/27 Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically shihao zhong
2026/10/27 Re: tablecmds: Deadlock caused by Attach Partition surya poondla
2026/10/27 Re: ICU fixed digit reordering bug Chao Li
2026/10/27 Re: Fix stale relcache fields for TOAST indexes during REINDEX CONCURRENTLY Chao Li
2026/10/27 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/27 Re: First draft of PG 19 release notes shihao zhong
2026/10/27 Re: ICU fixed digit reordering bug Haibo Yan
2026/10/27 Re: Asynchronous MergeAppend Etsuro Fujita
2026/10/27 Re: Report buffer access strategies in EXPLAIN Sami Imseih
2026/10/27 Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed surya poondla
2026/10/27 [PATCH] Prevent lateral dependency cycles in self-join elimination Haibo Yan
2026/10/27 Re: ICU fixed digit reordering bug Laurenz Albe
2026/10/27 Re: ICU fixed digit reordering bug Tom Lane
2026/10/27 Re: [PG19] Promotion hangs behind a backend blocked on a stuck client Masahiko Sawada
2026/10/27 Re: Be strict when request to flush past end of WAL in WaitXLogInsertionsToFinish Bharath Rupireddy
2026/10/27 Re: [PROPOSAL] Expand OR clauses in joins to UNION ALL paths Zsolt Parragi
2026/10/27 Re: Parallel vacuum: check XID wraparound failsafe between indexes Zsolt Parragi
2026/10/27 Re: two small tab-completion patches (ALTER CONSTRAINT, CHECK modifiers) surya poondla
2026/10/27 Re: Parallel vacuum: workers together with leader could overrun cost budget Bharath Rupireddy
2026/10/27 Re: [***DKIM violation***] Re: [PATCH] Fix JSON_SERIALIZE() coercion placeholder type for jsonb input Zsolt Parragi
2026/10/27 Re: [DEPARSE] AT TIME ZONE and similar as a function in FROM do not read back Tom Lane
2026/10/27 [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Sami Imseih
2026/10/27 Re: Fix BRIN numeric_minmax_multi_ops out of range value range merging Tomas Vondra
2026/10/27 Re: [PATCH] GROUP BY ALL: the regroupening David Christensen
2026/10/27 Re: DOCS - CREATE PUBLICATION wording re 'ONLY' for partitioned tables. surya poondla
2026/10/27 Re: First draft of PG 19 release notes Bruce Momjian
2026/10/27 Re: Request to expedite commitfest account cool-off Álvaro Herrera
2026/10/27 Re: [DEPARSE] A COLLATE clause in the URI of XMLNAMESPACES does not read back Tom Lane
2026/10/27 Re: Clean up code comments for pg_wchar_tbl Andreas Karlsson
2026/10/27 Re: First draft of PG 19 release notes Bruce Momjian
2026/10/27 Re: Clean up code comments for pg_wchar_tbl Joel Jacobson
2026/10/27 Fix BRIN numeric_minmax_multi_ops out of range value range merging Kirill Reshke
2026/10/27 Re: First draft of PG 19 release notes Bruce Momjian
2026/10/27 Fix stale relcache fields for TOAST indexes during REINDEX CONCURRENTLY Bharath Rupireddy
2026/10/27 Re: [PATCH] pgcrypto: Fix sha-crypt rounds= values that do not fit in int (BUG #19743) Prashant Chinnam
2026/10/27 Re: Clean up code comments for pg_wchar_tbl Greg Burd
2026/10/27 Re: First draft of PG 19 release notes Bruce Momjian
2026/10/27 Re: Fix concurrent-abort detection for subtransactions of prepared transactions Vaijayanti Bharadwaj
2026/10/27 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Greg Burd
2026/10/27 Request to expedite commitfest account cool-off Ana Bobillo
2026/10/27 Query jumbling of ROLLUP/CUBE, SEARCH/CYCLE and composite fields Staroverov Ilja
2026/10/27 Re: Add compiler option -fstrict-flex-arrays=1 Tristan Partin
2026/10/27 Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically Bohyun Lee
2026/10/27 Re: Fix concurrent-abort detection for subtransactions of prepared transactions Rahila Syed
2026/10/27 Report buffer access strategies in EXPLAIN Bertrand Drouvot
2026/10/27 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Greg Burd
2026/10/27 Re: Proposal: Conflict log history table for Logical Replication Amit Kapila
2026/10/27 Clean up code comments for pg_wchar_tbl Peter Eisentraut
2026/10/27 Re: pg_*_advice: tsv load failure, etc. Jakub Wartak
2026/10/27 Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block Tomas Vondra
2026/10/27 Re: Skip prefetch for block references that follow a FPW or WILL_INIT of the same block shihao zhong
2026/10/27 Re: Reject incompatible options specified with VACUUM ONLY_DATABASE_STATS Jim Jones
2026/10/27 Re: Hash index inserts serialise on the metapage tuple counter Greg Burd