pgsql-hackers

Messages by Date

2026/10/29 Re: PSQL - improve tab completion for pub/sub options solai v
2026/10/29 Re: Parallel vacuum: workers together with leader could overrun cost budget surya poondla
2026/10/29 RE: Avoid resetting subscription two_phase state to pending when already enabled Hayato Kuroda (Fujitsu)
2026/10/29 psql: tab completion offers invalid COPY option values Suraj Kharage
2026/10/29 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Manu
2026/10/29 Re: Allow progress tracking of sub-commands Manu
2026/10/29 Re: PoC: Simplify recovery after dropping a table by LOGGING the restore LSN Jim Jones
2026/10/29 Data corruption: checkpoint can lose a multixact created during its start shihao zhong
2026/10/29 Re: Return INT_MAX or INT_MIN from strtoint() on overflow surya poondla
2026/10/29 Fix error handling in pg_flush_data() and FilePrefetch() Chao Li
2026/10/29 Re: Event trigger table rewrite doc missing ALTER MATERIALIZED VIEW case Kirill Reshke
2026/10/29 Re: ZSTD TOAST compression, and an extensible compression method encoding Manu
2026/10/29 Re: pg_upgrade doesn't copy ICU rules on template0 Bohyun Lee
2026/10/29 Re: Return pg_control from pg_backup_stop(). Noah Misch
2026/10/29 Re: Per-table resync for logical replication subscriptions Shlok Kyal
2026/10/29 Re: Avoid resetting subscription two_phase state to pending when already enabled Zhijie Hou
2026/10/29 Re: WAL record CRC calculated incorrectly because of underlying buffer modification shihao zhong
2026/10/29 Check the fd number against FD_SETSIZE in PQsocketPoll Roman Khapov
2026/10/29 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Jeff Davis
2026/10/29 Re: Proposal: Include CHECK constraint expression in violation error DETAIL Yash Jadhav
2026/10/29 Re: Hash a ScalarArrayOpExpr whose array is fixed for one execution David Geier
2026/10/29 Re: pg_upgrade doesn't copy ICU rules on template0 shihao zhong
2026/10/29 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Prashant Chinnam
2026/10/29 Re: [PG19] pg_upgrade --check passes, then the upgrade fails shihao zhong
2026/10/29 Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
2026/10/29 Re: Parallel autovacuum: leader crashes when no DSM segment can be created shihao zhong
2026/10/29 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Tom Lane
2026/10/29 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Prashant Chinnam
2026/10/29 Re: bug: query returns different result with and without memoization. shihao zhong
2026/10/29 Re: ERROR: failed to assign all NestLoopParams to plan nodes Richard Guo
2026/10/29 Re: Assert failure in parallel query due to SubPlan double visit for hash join Lukas Fittl
2026/10/29 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Ayoub Kazar
2026/10/29 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Tom Lane
2026/10/29 Re: Reduce logging during prepared transaction recovery Fujii Masao
2026/10/29 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Michael Paquier
2026/10/29 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Chao Li
2026/10/29 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Takeshi Ideriha
2026/10/29 Re: RI fastpath misses checking EXECUTE on functions Amit Langote
2026/10/29 Avoid resetting subscription two_phase state to pending when already enabled Zhijie Hou
2026/10/29 Re: Tepid: selective index updates for heap relations Greg Burd
2026/10/29 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Sami Imseih
2026/10/29 Re: Use instr_time for pg_stat_database block read/write time counters Lukas Fittl
2026/10/29 Re: Python/pytest test framework take two Nikolay Samokhvalov
2026/10/29 Re: Reduce logging during prepared transaction recovery Tom Lane
2026/10/29 Re: pg_*_advice: tsv load failure, etc. Nikolay Samokhvalov
2026/10/29 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Jeff Davis
2026/10/29 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/29 Fix cumulative WAL statistics double-counting from parallel workers Lukas Fittl
2026/10/29 Re: pg_*_advice: tsv load failure, etc. Robert Haas
2026/10/29 Re: Assert failure in parallel query due to SubPlan double visit for hash join Lukas Fittl
2026/10/29 PGC_S_ARGV vs pg_file_settings and pg_settings Jehan-Guillaume de Rorthais
2026/10/29 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Michael Paquier
2026/10/29 Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
2026/10/29 Hash index: stop registering pin-only bucket pages in WAL (remove REGBUF_NO_CHANGE) Greg Burd
2026/10/29 Re: Improve hash aggregate spilling by writing only the needed columns Ethan Tran
2026/10/29 Setting the number of digits after the decimal point with a psql's pset variable Guillaume Lelarge
2026/10/29 Re: Expanding HOT updates for expression and partial indexes Greg Burd
2026/10/29 Re: Showing "Table Block Fetches" in EXPLAIN ANALYZE for index-only scans Greg Burd
2026/10/29 Re: index prefetching Greg Burd
2026/10/29 Re: CREATE TABLE .. LIKE copies comments to an unrelated table Jim Jones
2026/10/29 Re: PoC: true in-place major version upgrades Nathan Bossart
2026/10/29 Re: pgsql: Set HEAP_XMAX_INVALID for tuples updated by aborted subtransacti Michael Paquier
2026/10/29 Re: Reduce logging during prepared transaction recovery Ashutosh Sharma
2026/10/29 Re: Return pg_control from pg_backup_stop(). Marcel Hofstetter
2026/10/29 Re: [PATCH] Fix PITR pause bypass when initial XLOG_RUNNING_XACTS has subxid overflow Jan Nidzwetzki
2026/10/29 Re: Proposal: SELECT * EXCLUDE (...) command Kacper Kuras
2026/10/29 Re: Reduce logging during prepared transaction recovery Fujii Masao
2026/10/29 Re: Return pg_control from pg_backup_stop(). Burd, Greg
2026/10/29 Re: enhancing pg_basebackup speeds up to ~23Gbps (small fixes + io_uring/Direct I/O) Jakub Wartak
2026/10/29 Re: [GSoC 2026] - B-tree Index Bloat Reduction - Approach & Questions Nikolay Samokhvalov
2026/10/29 Re: pg_*_advice: tsv load failure, etc. Robert Haas
2026/10/29 Re: Parallel vacuum: workers together with leader could overrun cost budget Bharath Rupireddy
2026/10/29 RE: Avoid resetting subscription two_phase state to pending when already enabled Hayato Kuroda (Fujitsu)
2026/10/29 Re: Avoid resetting subscription two_phase state to pending when already enabled Bertrand Drouvot
2026/10/29 Re: Report buffer access strategies in EXPLAIN Sami Imseih
2026/10/29 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/29 Re: PoC: true in-place major version upgrades Robert Haas
2026/10/29 Re: [PATCH] Fix whole-row type errors in postgres_fdw UPDATE joins Sho Ito
2026/10/29 Re: pg_*_advice: tsv load failure, etc. Robert Haas
2026/10/29 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Sami Imseih
2026/10/29 Re: WAL record CRC calculated incorrectly because of underlying buffer modification vignesh C
2026/10/29 Re: kqueue backend for pgbench Roman Khapov
2026/10/29 Re: Check the fd number against FD_SETSIZE in PQsocketPoll Roman Khapov
2026/10/29 Re: CREATE TABLE .. LIKE copies comments to an unrelated table Salma Elsayed
2026/10/29 Re: UNDO with FILEOPS, and the FLUX table AM Greg Burd
2026/10/29 Re: Quickselect instead of a heap for ORDER BY ... LIMIT N large bounded sorts Greg Burd
2026/10/29 Re: Count the last block of the validation scan in CIC progress Manu
2026/10/29 Re: Avoid resetting subscription two_phase state to pending when already enabled Zhijie Hou
2026/10/29 2pc gxact lsn race Maxim Orlov
2026/10/29 Re: Logical replication: lost updates/deletes and invalid log messages caused by SnapshotDirty + concurrent updates Manu
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