pgsql-hackers

Messages by Date

2026/10/31 Re: Optimize MCV stats for sortable types and utilize sorted-order properties ZizhuanLiu X-MAN
2026/10/31 Re: pgsql: Set HEAP_XMAX_INVALID for tuples updated by aborted subtransacti Robert Haas
2026/10/31 Re: ALTER COLLATION misses errcode Kirill Reshke
2026/10/31 [PATCH] doc: clarify psql \watch minimum row behavior R Sri Vishnu
2026/10/31 Re: Fix error handling in pg_flush_data() and FilePrefetch() Heikki Linnakangas
2026/10/31 Re: Fix BRIN numeric_minmax_multi_ops out of range value range merging Kirill Reshke
2026/10/31 Re: ALTER COLLATION misses errcode Heikki Linnakangas
2026/10/31 Re: [PATCH] Corruption Issue: Fix missing tts_tid in ExecForceStoreHeapTuple Heikki Linnakangas
2026/10/30 RE: [PATCH] Restrict partial unique index estimates to base quals Zhang Ziming
2026/10/30 Print latency percentiles in pgbench Roman Khapov
2026/10/30 [PATCH] doc: Clarify pg_checksums --filenode mode restriction R Sri Vishnu
2026/10/30 Re: improving handling of FPIs during recovery prefetching shihao zhong
2026/10/30 Re: Proposal: Conflict log history table for Logical Replication shihao zhong
2026/10/30 Re: [PG19] Bogus errors for polymorphic plpython functions shihao zhong
2026/10/30 Re: Fix BRIN numeric_minmax_multi_ops out of range value range merging shihao zhong
2026/10/30 [PATCH] doc: Fix description of relative extension "directory" setting Mahendrakar Srinivasarao
2026/10/30 Re: [PG19] Bogus errors for polymorphic plpython functions Tom Lane
2026/10/30 Re: [PG19] Bogus errors for polymorphic plpython functions shihao zhong
2026/10/30 Standby stuck after walreceiver restart just before a WAL segment boundary David Shorten
2026/10/30 Re: Fix cumulative WAL statistics double-counting from parallel workers ahmed
2026/10/30 Re: Fix cumulative WAL statistics double-counting from parallel workers ahmed
2026/10/30 Re: [PATCH] RFC: new_oid_hook, to let an extension propose catalog OIDs Michael Paquier
2026/10/30 Re: ZSTD TOAST compression, and an extensible compression method encoding Hannu Krosing
2026/10/30 Re: pgsql: Set HEAP_XMAX_INVALID for tuples updated by aborted subtransacti Michael Paquier
2026/10/30 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Chao Li
2026/10/30 Re: Remove unused is_redo argument from pgstat_execute_transactional_drops() Chao Li
2026/10/30 Re: Return pg_control from pg_backup_stop(). Michael Paquier
2026/10/30 Re: Hash a ScalarArrayOpExpr whose array is fixed for one execution Ayoub Kazar
2026/10/30 Re: Return INT_MAX or INT_MIN from strtoint() on overflow Tom Lane
2026/10/30 [PG19] Bogus errors for polymorphic plpython functions Tom Lane
2026/10/30 Re: Design proposal: grain, exact per-time-bucket aggregates from a summarizing index Jan Bjørge Løvland
2026/10/30 Re: Incorrect CONTEXT reported for errors from parallel apply worker in logical replication vignesh C
2026/10/30 Re: Return pg_control from pg_backup_stop(). Greg Burd
2026/10/30 Re: Add REPACK progress phases for logical decoding setup Masahiko Sawada
2026/10/30 Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation Masahiko Sawada
2026/10/30 Re: pg_*_advice: tsv load failure, etc. Robert Haas
2026/10/30 Re: PL/pgSQL: apply the too_many_rows extra check to EXECUTE ... INTO Pavel Stehule
2026/10/30 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces Andrew Dunstan
2026/10/30 [PATCH] Add an ETW backend for the static probes on Windows Bryan Green
2026/10/30 Re: [PATCH] pgcrypto: Fix sha-crypt rounds= values that do not fit in int (BUG #19743) Prashant Chinnam
2026/10/30 RE: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation Hayato Kuroda (Fujitsu)
2026/10/30 Re: Hash index: stop registering pin-only bucket pages in WAL (remove REGBUF_NO_CHANGE) vignesh C
2026/10/30 Re: Setting the number of digits after the decimal point with a psql's pset variable Guillaume Lelarge
2026/10/30 Re: Fix cumulative WAL statistics double-counting from parallel workers Lukas Fittl
2026/10/30 Re: pg_*_advice: tsv load failure, etc. Nikolay Samokhvalov
2026/10/30 Re: tests: Don't use the initdb template for older installations Nathan Bossart
2026/10/30 Re: Setting the number of digits after the decimal point with a psql's pset variable Nathan Bossart
2026/10/30 Re: Becoming a committer: form for tracking readiness Andrey Borodin
2026/10/30 Re: Remove unused is_redo argument from pgstat_execute_transactional_drops() Nathan Bossart
2026/10/30 tests: Don't use the initdb template for older installations Andres Freund
2026/10/30 Re: WAL record CRC calculated incorrectly because of underlying buffer modification Jeff Davis
2026/10/30 Re: [PATCH] Corruption Issue: Fix missing tts_tid in ExecForceStoreHeapTuple Greg Burd
2026/10/30 Re: amcheck: detect corruption from the recent snapshot-export bug Andrey Borodin
2026/10/30 ALTER COLLATION misses errcode Kirill Reshke
2026/10/30 Re: [PG19] Indexes from 18 miss rows after pg_upgrade shihao zhong
2026/10/30 Re: [PG19] Indexes from 18 miss rows after pg_upgrade Jeff Davis
2026/10/30 Re: Reapply graceful socket shutdown on Windows (revert 29992a6a509) Greg Burd
2026/10/30 Re: 041_checkpoint_at_promote.pl might fail due to race condition on child kill Fujii Masao
2026/10/30 Re: Setting the number of digits after the decimal point with a psql's pset variable Bertrand Drouvot
2026/10/30 Re: SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row Andrey Borodin
2026/10/30 Re: Call CalculateShmemSize() only once Nathan Bossart
2026/10/30 Re: Quickselect instead of a heap for ORDER BY ... LIMIT N large bounded sorts Greg Burd
2026/10/30 Re: [PG19] pg_upgrade --check passes, then the upgrade fails T, Adesh
2026/10/30 Re: Hash index: stop registering pin-only bucket pages in WAL (remove REGBUF_NO_CHANGE) Greg Burd
2026/10/30 Re: [Patch] Don't stop a `vacuumdb --all` on a connection failure Fujii Masao
2026/10/30 Re: Fix BRIN numeric_minmax_multi_ops out of range value range merging Tomas Vondra
2026/10/30 Re: [PATCH] Corruption Issue: Fix missing tts_tid in ExecForceStoreHeapTuple Nathan Bossart
2026/10/30 configure picks a clang that doesn't match LLVM_CONFIG Greg Burd
2026/10/30 Re: Return pg_control from pg_backup_stop(). Greg Burd
2026/10/30 Re: Wrong LSN in WAL decoding error messages surya poondla
2026/10/30 Re: Test publication.sql racing with subscription.sql might fail due to cache lookup error vignesh C
2026/10/30 Re: PoC: Simplify recovery after dropping a table by LOGGING the restore LSN Salma Elsayed
2026/10/30 Re: Wrong LSN in WAL decoding error messages Fujii Masao
2026/10/30 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Sami Imseih
2026/10/30 Re: Introduce XID age based replication slot invalidation Bertrand Drouvot
2026/10/30 Columns assigned by MERGE can be dropped from SQL-standard function bodies Henson Choi
2026/10/30 Re: LLVM JIT: any JIT-compiled query crashes (SIGILL) on a libLLVM 19 + ASAN build Greg Burd
2026/10/30 Re: Tepid: selective index updates for heap relations Greg Burd
2026/10/30 Re: Proposal: Conflict log history table for Logical Replication Amit Kapila
2026/10/30 JIT inlining crashes on non-exported extension functions Greg Burd
2026/10/30 Re: nbtree: opt-in leaf key prefix compression Yao Feng
2026/10/30 Faulty pg_get_shmem_pagesize() on Windows Ashutosh Bapat
2026/10/30 Re: Hash index: stop registering pin-only bucket pages in WAL (remove REGBUF_NO_CHANGE) vignesh C
2026/10/30 PL/pgSQL: apply the too_many_rows extra check to EXECUTE ... INTO Jeevan Chalke
2026/10/30 Call CalculateShmemSize() only once Ashutosh Bapat
2026/10/30 RE: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation Hayato Kuroda (Fujitsu)
2026/10/30 GiST intarray build speedup: two-arg fast path Kirill Reshke
2026/10/30 Re: Reporting WAL replay progress during pre-consistency standby reovery Nitin Jadhav
2026/10/30 Re: Incremental backup can use a summary past a timeline switch Fujii Masao
2026/10/30 Re: Avoid resetting subscription two_phase state to pending when already enabled vignesh C
2026/10/30 Re: Proposal: Include CHECK constraint expression in violation error DETAIL Koshino Taiki
2026/10/30 RE: [PATCH] Preserve replication origin OIDs in pg_upgrade Hayato Kuroda (Fujitsu)
2026/10/30 Re: kqueue backend for pgbench Roman Khapov
2026/10/30 Re: Return pg_control from pg_backup_stop(). David Steele
2026/10/30 Re: [PATCH] Report changes discarded for relations not in the subscription Hüseyin Demir
2026/10/30 Re: Fix "unexpected logical decoding status change" error; from concurrent logical decoding activation Alexander Lakhin
2026/10/30 Re: Optimize mergejoinscansel() by avoiding redundant computations ZizhuanLiu X-MAN
2026/10/30 Re: Fix cumulative WAL statistics double-counting from parallel workers Bertrand Drouvot
2026/10/30 Re: 041_checkpoint_at_promote.pl might fail due to race condition on child kill Ayush Tiwari
2026/10/30 Support "ALTER FOREIGN TABLE ... RENAME CONSTRAINT ..." Ian Lawrence Barwick
2026/10/30 Re: [PG19] pg_upgrade --check passes, then the upgrade fails Masahiko Sawada
2026/10/30 Re: Proposal: SELECT * EXCLUDE (...) command Hunaid Sohail
2026/10/30 PL/pgSQL: "missing X at end of SQL expression" is never reported at end of input Jeevan Chalke
2026/10/29 Re: Fix error handling in pg_flush_data() and FilePrefetch() Chao Li
2026/10/29 Re: psql: tab completion offers invalid COPY option values Chao Li
2026/10/29 Re: Enable partitionwise join for partition keys wrapped by RelabelType solai v
2026/10/29 Re: bug: query returns different result with and without memoization. Yilin Zhang
2026/10/29 Re: Report buffer access strategies in EXPLAIN Bertrand Drouvot
2026/10/29 Re: [PG19] pg_upgrade --check passes, then the upgrade fails Kirill Reshke
2026/10/29 Re: [PATCH] pgstat: Add helper to drop entries from a stats kind's hash Bertrand Drouvot
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