pgsql-hackers

Messages by Date

2026/09/20 Re: Optimize MCV stats for sortable types and utilize sorted-order properties ZizhuanLiu X-MAN
2026/09/20 Assert failure in get_baserel_parampathinfo with lateral UNION ALL Richard Guo
2026/09/20 psql: avoid over-reading unterminated prompt escapes Chao Li
2026/09/20 Video about non-volatile memory technology Bruce Momjian
2026/09/20 [PATCH] Assertion in pg_get_shmem_pagesize() in single-user mode Ayush Tiwari
2026/09/20 Re: [Patch] Add WHERE clause support to REFRESH MATERIALIZED VIEW Adam Brusselback
2026/09/20 Re: Row pattern recognition Henson Choi
2026/09/20 Re: [patch] Cache invalidation for I/O Workers shihao zhong
2026/09/20 Re: Serverside SNI support in libpq Noah Misch
2026/09/20 Re: COMMENTS are not being copied in CREATE TABLE LIKE Alex Liapychev
2026/09/20 Re: pg_walinspect: fix LSN validation messages and empty range handling Kiran Kaki
2026/09/20 Re: pg_regress: schedule multi-line test groups Alexandre Felipe
2026/09/20 Re: [PATCH] Combine qual-based and NOT NULL proofs when reducing outer joins Ziming Zhang
2026/09/20 [PATCH] Use bounded GIN pending-list cleanup in parallel autovacuum Jingtang Zhang
2026/09/20 Re: Optimize MCV stats for sortable types and utilize sorted-order properties ZizhuanLiu X-MAN
2026/09/20 Re: [PATCH] Two remaining shmem attachment issues in single-user mode Ayush Tiwari
2026/09/20 Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg Heikki Linnakangas
2026/09/20 Re: Add a Nix flake Álvaro Herrera
2026/09/20 ERROR: SubPlan found with no parent plan Richard Guo
2026/09/20 Re: Add a Nix flake Wolfgang Walther
2026/09/20 Re: Row pattern recognition Henson Choi
2026/09/20 Intermittent Assert("plan->magic == _SPI_PLAN_MAGIC") in 027_stream_regress Trakshan Mishra
2026/09/20 Re: [PATCH] Two remaining shmem attachment issues in single-user mode Chao Li
2026/09/20 Re: Row pattern recognition Tatsuo Ishii
2026/09/20 Re: [patch] Cache invalidation for I/O Workers Alexandre Felipe
2026/09/20 Re: pg_regress: schedule multi-line test groups Alexandre Felipe
2026/09/19 Re: Add a hook for handling logical decoding messages on subscribers. Bharath Rupireddy
2026/09/19 pg_walinspect: fix LSN validation messages and empty range handling Chao Li
2026/09/19 Re: Severe performance degradation with concurrent updates due to excessive EvalPlanQual (EPQ) re‑evaluation Wei Sun
2026/09/19 Re: test: avoid redundant standby catchup in 049_wait_for_lsn Xuneng Zhou
2026/09/19 Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg Tom Lane
2026/09/19 Re: Do we reduce autovacuum_naptime max values shihao zhong
2026/09/19 Re: PG 19 status blog report Michael Paquier
2026/09/19 [PATCH] Two remaining shmem attachment issues in single-user mode Ayush Tiwari
2026/09/19 Re: Row pattern recognition Henson Choi
2026/09/19 Re: [PATCH] Remove unused PageIsPredicateLocked() Pierre Forstmann
2026/09/19 Re: Race conditions in logical decoding Rui Zhao
2026/09/19 Re: [PG19][PATCH] Make postgres_fdw statistics import atomic Etsuro Fujita
2026/09/19 Re: remove_useless_joins vs. bug #19560 Richard Guo
2026/09/19 Re: JSON_TABLE: table => column ON ERROR propagation Alexander Korotkov
2026/09/19 Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg Noah Misch
2026/09/19 Re: pg_plan_advice: add NO_ scan and join method tags Florin Irion
2026/09/19 Re: Possible race condition in pg_basebackup Nick Ivanov
2026/09/19 Re: Do we reduce autovacuum_naptime max values wenhui qiu
2026/09/19 Re: Possible race condition in pg_basebackup Nick Ivanov
2026/09/19 [PATCH v1] Batch B-tree TIDs when building a bitmap Tomás Senart
2026/09/19 Re: remove_useless_joins vs. bug #19560 Richard Guo
2026/09/19 Re: pg_rewind does not rewind diverging timelines Mats Kindahl
2026/09/19 Re: Regression tests failures due to concurrent grants Alexander Lakhin
2026/09/19 Re: PG 19 status blog report wenhui qiu
2026/09/19 Re: Several issues with postgres_fdw stats import Etsuro Fujita
2026/09/19 Re: [PATCH] postgres_fdw: Fix cost estimation for semi join pushdown Ziming Zhang
2026/09/19 subquery pullup misses lateral refs in join alias Vars Richard Guo
2026/09/19 Re: PG19: two RI fast-path issues found while testing the batching revert Amit Langote
2026/09/18 Re: ERROR: unsupported join alias expression Richard Guo
2026/09/18 Re: [PG19][PATCH] Make postgres_fdw statistics import atomic Corey Huinker
2026/09/18 Re: Wrong results from join removal with DISTINCT ON + SRF subquery Kirill Reshke
2026/09/18 Re: [Patch] New pg_stat_tablespace view shihao zhong
2026/09/18 Re: PG 19 status blog report Bruce Momjian
2026/09/18 Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg Naga Appani
2026/09/18 Re: remove_useless_joins vs. bug #19560 Richard Guo
2026/09/18 Re: [PATCH] Use Boyer-Moore-Horspool for simple LIKE contains patterns Atsushi Ogawa
2026/09/18 Re: Support for 8-byte TOAST values, round two Bharath Rupireddy
2026/09/18 Re: Support for 8-byte TOAST values, round two Michael Paquier
2026/09/18 Re: PG 19 status blog report Michael Paquier
2026/09/18 Re: Implement missing join selectivity estimation for range types Haibo Yan
2026/09/18 Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) Melanie Plageman
2026/09/18 Add REPACK progress phases for logical decoding setup Sami Imseih
2026/09/18 Re: [PATCH] Reduce LWLockWaitListLock() cache-line contention with adaptive spin reads Okanovic, Haris
2026/09/18 [PATCH] Add a check_hook for output_plugin_libraries Jacob Champion
2026/09/18 Re: Credits For v19 Corey Huinker
2026/09/18 Re: [Patch] New pg_stat_tablespace view Bernd Reiß
2026/09/18 Re: Implement missing join selectivity estimation for range types Bryan Green
2026/09/18 Re: Reject WAIT FOR earlier in transaction-snapshot mode Alexander Korotkov
2026/09/18 Re: Unexpected reindex when altering column types for partitioned tables Álvaro Rodríguez
2026/09/18 Re: remove_useless_joins vs. bug #19560 Haibo Yan
2026/09/18 Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master Álvaro Herrera
2026/09/18 Happy Birthday, Tom Lane! Andrey Rachitskiy
2026/09/18 Re: pgoutput: schema cache cleanup after streamed 2PC Masahiko Sawada
2026/09/18 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/09/18 Temp schema drop leaves an inconsistent state behind Marko Grujic
2026/09/18 Re: Allow pg_read_all_stats to read replication origin status Virender Singla
2026/09/18 Re: REPACK enhancements Antonin Houska
2026/09/18 Re: [PATCH] Release replication slot on error in SQL-callable slot functions Masahiko Sawada
2026/09/18 Re: Make pg_prewarm, autoprewarm yield for waiting DDL Bharath Rupireddy
2026/09/18 Re: Report index currently being vacuumed in pg_stat_progress_vacuum Bharath Rupireddy
2026/09/18 Re: Reject WAIT FOR earlier in transaction-snapshot mode Nathan Bossart
2026/09/18 Re: 64-bit MultiXactOffset vs. 9.3->9.4 upgrade, pg_resetwal, "wraparound" msg Heikki Linnakangas
2026/09/18 Re: Regression tests failures due to concurrent grants Jeff Davis
2026/09/18 Skip a redundant singleton GROUP BY node zengxx
2026/09/18 Re: [PATCH] libpq: Add PQpassfileLookup() Diego
2026/09/18 Re: Reject WAIT FOR earlier in transaction-snapshot mode Sami Imseih
2026/09/18 Re: Introduce XID age based replication slot invalidation Bharath Rupireddy
2026/09/18 Re: Several issues with postgres_fdw stats import Nathan Bossart
2026/09/18 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/09/18 Re: [patch] Cache invalidation for I/O Workers Alexandre Felipe
2026/09/18 Re: Regression tests failures due to concurrent grants Jacob Champion
2026/09/18 Re: PANIC serves too many masters Ayush Tiwari
2026/09/18 Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...) Hannu Krosing
2026/09/18 Re: Regression tests failures due to concurrent grants Andres Freund
2026/09/18 Re: [PG19][PATCH] Make postgres_fdw statistics import atomic Andres Freund
2026/09/18 Re: SHMEM_ATTACH_UNKNOWN_SIZE reaches InitShmemIndexEntry() Heikki Linnakangas
2026/09/18 Re: [PATCH] Use Boyer-Moore-Horspool for simple LIKE contains patterns Atsushi Ogawa
2026/09/18 Re: Regression tests failures due to concurrent grants Jacob Champion
2026/09/18 Stop asserting that Unicode normalization consumes its whole input Tristan Partin
2026/09/18 Re: [patch] Cache invalidation for I/O Workers shihao zhong
2026/09/18 Regression tests failures due to concurrent grants Andres Freund
2026/09/18 Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...) Hannu Krosing
2026/09/18 Re: JIT works only partially with meson build? Yugo Nagata
2026/09/18 Re: [PATCH] Release replication slot on error in SQL-callable slot functions Bharath Rupireddy
2026/09/18 Re: add list of major features to the v19 release notes Nathan Bossart
2026/09/18 Re: [PATCH] Reject nonpositive Bloom filter element estimates Nathan Bossart
2026/09/18 PG 19 status blog report Bruce Momjian
2026/09/18 Re: Unprocessed SubLink from whole-row join alias expansion Ayush Tiwari
2026/09/18 [patch] Cache invalidation for I/O Workers Alexandre Felipe
2026/09/18 Re: Proposal: Supporting URI SAN in Certificate Authentication Jacob Champion
2026/09/18 Re: Race conditions in logical decoding Antonin Houska
2026/09/18 Re: Use correct collation in pg_trgm David Geier
2026/09/18 Re: Possible race condition in pg_basebackup Shashishekar Hullahally Anantharamu
2026/09/18 Re: Track skipped tables during autovacuum and autoanalyze Sami Imseih
2026/09/18 Re: Add ASCII fast path to Unicode normalization functions Tristan Partin
2026/09/18 Re: Race conditions in logical decoding Alvaro Herrera
2026/09/18 Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master Dmitry Dolgov
2026/09/18 [PATCH] Reject nonpositive Bloom filter element estimates CharSyam
2026/09/18 Re: Add ASCII fast path to Unicode normalization functions Andrew Dunstan
2026/09/18 Re: Stabilize and shorten test_checksums/013_rewind test Nazir Bilal Yavuz
2026/09/18 Re: Race conditions in logical decoding Antonin Houska
2026/09/18 Re: Severe performance degradation with concurrent updates due to excessive EvalPlanQual (EPQ) re‑evaluation Osama Abdul Qader
2026/09/18 Re: Track skipped tables during autovacuum and autoanalyze Yugo Nagata
2026/09/18 Re: Logical replication can lose an update after concurrent index invalidation Amit Kapila
2026/09/18 Re: Stabilize and shorten test_checksums/013_rewind test Daniel Gustafsson
2026/09/18 Re: Do we reduce autovacuum_naptime max values Virender Singla
2026/09/18 Re: Race conditions in logical decoding Alvaro Herrera
2026/09/18 Re: Use correct collation in pg_trgm solai v
2026/09/18 COMMENT/SEC LABEL tab complete support suggests wrong SQL. Kirill Reshke
2026/09/18 Re: Reduce WAL volume for heap tuple hint bits Andrey Borodin
2026/09/18 Re: JIT works only partially with meson build? Yugo Nagata
2026/09/18 Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master Álvaro Herrera
2026/09/18 Re: Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master Álvaro Herrera
2026/09/18 RE: table-write trigger can bypass ATPrepChangePersistence Hayato Kuroda (Fujitsu)
2026/09/18 Re: Warn when creating or enabling a subscription with max_logical_replication_workers = 0 Rafia Sabih
2026/09/18 Re: add list of major features to the v19 release notes Jonathan S. Katz
2026/09/18 Re: pg_regress: schedule multi-line test groups Daniel Gustafsson
2026/09/18 Re: [PATCH v2] Optimize 64-bit atomic access on RV64 王红岩
2026/09/18 Re: Distinguish publication exclusions in object addresses Amit Kapila
2026/09/18 Stabilize and shorten test_checksums/013_rewind test Nazir Bilal Yavuz
2026/09/18 Re: [PG19][PATCH] Make postgres_fdw statistics import atomic Etsuro Fujita
2026/09/18 Re: PG19: two RI fast-path issues found while testing the batching revert Amit Langote
2026/09/18 Re: RFC: Logging plan of the running query Andrei Lepikhov
2026/09/18 Re: Several issues with postgres_fdw stats import Etsuro Fujita
2026/09/18 Re: different result of regexp_instr than on Oracle Pavel Stehule
2026/09/18 [PATCH v1] Use RVV for bounded NUL scans in pq_getmsgstring 王红岩
2026/09/18 Re: [PATCH] Release replication slot on error in SQL-callable slot functions kedar anavardekar
2026/09/18 Re: COMMENT/SEC LABEL tab complete support suggests wrong SQL. Chao Li
2026/09/18 aio: worker: Free SMGR objects when idle Nazir Bilal Yavuz
2026/09/18 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/09/18 Re: Init connection time grows quadratically Matthias van de Meent
2026/09/18 Re: table-write trigger can bypass ATPrepChangePersistence Ajin Cherian
2026/09/18 Re: different result of regexp_instr than on Oracle Gilles Darold
2026/09/18 Re: Init connection time grows quadratically Jakub Wartak
2026/09/18 Re: meson vs. llvm bitcode files Christoph Berg
2026/09/18 SHMEM_ATTACH_UNKNOWN_SIZE reaches InitShmemIndexEntry() Ashutosh Bapat
2026/09/17 Re: Reject WAIT FOR earlier in transaction-snapshot mode Alexander Korotkov
2026/09/17 Re: table-write trigger can bypass ATPrepChangePersistence Ajin Cherian
2026/09/17 Re: gist_trgm_ops '=' operator: planner picks it over btree, ~300x slower Vaibhav Dalvi
2026/09/17 Re: Fix XLogFileReadAnyTLI silently applying divergent WAL from wrong timeline solai v
2026/09/17 Re: Row pattern recognition Henson Choi
2026/09/17 different result of regexp_instr than on Oracle Pavel Stehule
2026/09/17 Re: RANGE partition pruning can still exclude the default partition David Rowley
2026/09/17 RE: Allow pg_read_all_stats to read replication origin status Hayato Kuroda (Fujitsu)
2026/09/17 Re: Distinguish publication exclusions in object addresses shveta malik
2026/09/17 Re: Row pattern recognition Henson Choi
2026/09/17 Re: Distinguish publication exclusions in object addresses Amit Kapila
2026/09/17 Re: Distinguish publication exclusions in object addresses shveta malik
2026/09/17 Re: Global temporary tables Haibo Yan
2026/09/17 Re: Distinguish publication exclusions in object addresses Amit Kapila
2026/09/17 pg_walinspect: add functions to locate and list WAL by time and LSN Chao Li
2026/09/17 Re: Global temporary tables Haibo Yan
2026/09/17 Re: Python/pytest test framework take two shihao zhong
2026/09/17 Re: Distinguish publication exclusions in object addresses Amit Kapila
2026/09/17 Re: Row pattern recognition Henson Choi
2026/09/17 Re: RANGE partition pruning can still exclude the default partition Ewan Young
2026/09/17 Re: Distinguish publication exclusions in object addresses Peter Smith
2026/09/17 Re: Bug in logical decoding with DDL and subtransactions Bingshuai Li
2026/09/17 Re: JIT works only partially with meson build? shihao zhong
2026/09/17 Re: Add a test for index_rebuild_count of REPACK (CONCURRENTLY) Michael Paquier
2026/09/17 Re: pg_xmin_horizon: a system view of everything pinning the xmin horizon Sami Imseih
2026/09/17 Re: pg_xmin_horizon: a system view of everything pinning the xmin horizon Sami Imseih
2026/09/17 Re: Init connection time grows quadratically shihao zhong
2026/09/17 RE: pgoutput: schema cache cleanup after streamed 2PC Hayato Kuroda (Fujitsu)
2026/09/17 Re: Bug in logical decoding with DDL and subtransactions Bingshuai Li
2026/09/17 Re: issues with eager aggregation Richard Guo
2026/09/17 Re: pg_plan_advice: add NO_ scan and join method tags shihao zhong
2026/09/17 Re: Report index currently being vacuumed in pg_stat_progress_vacuum shihao zhong
2026/09/17 Re: REPACK (CONCURRENTLY) decoding worker is canceled by lock_timeout shihao zhong
2026/09/17 Unprocessed SubLink from whole-row join alias expansion Richard Guo
2026/09/17 Re: REPACK (CONCURRENTLY) decoding worker is canceled by lock_timeout shihao zhong
2026/09/17 Re: issues with eager aggregation Tomas Vondra
2026/09/17 Re: issues with eager aggregation Richard Guo
2026/09/17 Re: Reject WAIT FOR earlier in transaction-snapshot mode Sami Imseih