pgsql-hackers

Messages by Date

2026/11/01 Re: Use a hash table for the regexp cache jian he
2026/11/01 007_pre_auth.pl fails if injection_points_wakeup hits unintended process Alexander Lakhin
2026/11/01 Re: Internal error codes triggered by regression tests and user queries, take 2 Kirill Reshke
2026/11/01 Re: Internal error codes triggered by regression tests and user queries, take 2 Kirill Reshke
2026/11/01 Re: [PATCH] Consider window functions when reordering GROUP BY items Henson Choi
2026/10/31 Re: Remove unused arguments from split_selfjoin_quals() Tender Wang
2026/10/31 Re: Proposal: Conflict log history table for Logical Replication Amit Kapila
2026/10/31 pgbench --unlogged-tables silently ignored for branches/tellers/history when --partitions is used Roman Khapov
2026/10/31 Re: [PATCH] doc: Clarify pg_checksums --filenode mode restriction Daniel Gustafsson
2026/10/31 Re: Call CalculateShmemSize() only once Srinath Reddy Sadipiralla
2026/10/31 Re: Speeding up GIST index creation for hstore Kirill Reshke
2026/10/31 Increasing number of unnecessary blank lines in the documentation Noboru Saito
2026/10/31 [PATCH v1] Fix initial sync of zero-column published tables mingjiegao
2026/10/31 Re: Row pattern recognition jian he
2026/10/31 Fix trigger memory leak Paul A Jungwirth
2026/10/31 Re: pg_upgrade doesn't copy ICU rules on template0 Heikki Linnakangas
2026/10/31 Re: ALTER COLLATION misses errcode Tom Lane
2026/10/31 Re: First draft of PG 19 release notes shihao zhong
2026/10/31 Re: Incremental backup can use a summary past a timeline switch shihao zhong
2026/10/31 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Manu
2026/10/31 Re: ALTER COLLATION misses errcode Kirill Reshke
2026/10/31 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Ayoub Kazar
2026/10/31 Hash index corruption and CLOG lookup errors from checkpoint races shihao zhong
2026/10/31 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Manu
2026/10/31 Re: pg_upgrade doesn't copy ICU rules on template0 shihao zhong
2026/10/31 Re: [PG19] Bogus errors for polymorphic plpython functions shihao zhong
2026/10/31 Re: Proposal: Conflict log history table for Logical Replication shihao zhong
2026/10/31 Re: [PG19] pg_upgrade --check passes, then the upgrade fails shihao zhong
2026/10/31 Re: inet/cidr: IPv4 prefix length overflows int and passes the range check Roman Khapov
2026/10/31 Re: O(N^3) planning time in choose_plan_name() since 8c49a484e8e Tom Lane
2026/10/31 Re: ALTER COLLATION misses errcode Alexander Lakhin
2026/10/31 Re: Reject wholerow references where ColumnRef is forbidden Tom Lane
2026/10/31 psql: Don't offer USING INDEX after REPACK (CONCURRENTLY) or (ANALYZE) Ishjaap Singh
2026/10/31 pgbench aggregates final part can be missed at log Roman Khapov
2026/10/31 Reject wholerow references where ColumnRef is forbidden Paul A Jungwirth
2026/10/31 Re: [PATCH] pg_upgrade: handle failed nonblocking connects on Windows Heikki Linnakangas
2026/10/31 Re: Remove obsolete locking comment from AddBufferToRing() Pierre Forstmann
2026/10/31 Re: [PG19] Bogus errors for polymorphic plpython functions Tom Lane
2026/10/31 Re: Speeding up GIST index creation for hstore Roman Khapov
2026/10/31 Re: [PATCH] doc: clarify psql \watch minimum row behavior R Sri Vishnu
2026/10/31 Re: [PATCH] doc: clarify psql \watch minimum row behavior R Sri Vishnu
2026/10/31 Re: Incorrect selectivity estimates for NOT on nullable boolean columns Pierre Forstmann
2026/10/31 Re: Fix error handling in pg_flush_data() and FilePrefetch() Chao Li
2026/10/31 [PATCH] Fix incorrect logical replication updates with a shared leaf partition Mingjie Gao
2026/10/31 Speeding up GIST index creation for hstore Kirill Reshke
2026/10/31 Re: [PATCH] Corruption Issue: Fix missing tts_tid in ExecForceStoreHeapTuple Greg Burd
2026/10/31 Re: Add a hook for handling logical decoding messages on subscribers. Zhijie Hou
2026/10/31 Re: greenfly lwlock corruption in REL_14_STABLE and REL_15_STABLE Alexander Lakhin
2026/10/31 Re: Avoid crashes on a concurrently dropped schema Heikki Linnakangas
2026/10/31 Re: Hash index: stop registering pin-only bucket pages in WAL (remove REGBUF_NO_CHANGE) Amit Kapila
2026/10/31 Re: Proposal: Conflict log history table for Logical Replication Amit Kapila
2026/10/31 Re: PL/pgSQL: "missing X at end of SQL expression" is never reported at end of input Heikki Linnakangas
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