pgsql-hackers

Messages by Date

2026/10/14 Re: pg_upgrade fails with a config-only datadir and no --new-bindir Bohyun Lee
2026/10/14 Fix pg_restore gzip stream validation (bug #19754) Chao Li
2026/10/14 Re: Compression of bigger WAL records Michael Paquier
2026/10/14 Re: Incorrect argument passed to buffer_readv_encode_error() Steven Niu
2026/10/14 Re: Assert failure in standard_join_search() Tender Wang
2026/10/14 Re: ERROR: SubPlan found with no parent plan Richard Guo
2026/10/14 Re: pg_upgrade fails with a config-only datadir and no --new-bindir Heikki Linnakangas
2026/10/14 Re: Improving scalability of Parallel Bitmap Heap/Index Scan John Naylor
2026/10/14 Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers Masahiko Sawada
2026/10/13 Re: Test publication.sql racing with subscription.sql might fail due to cache lookup error vignesh C
2026/10/13 Incorrect argument passed to buffer_readv_encode_error() Antonin Houska
2026/10/13 Re: "failed to build any N-way joins" from a five-relation query Richard Guo
2026/10/13 Re: REPACK: warn about skipping foreign partitions solai v
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication Zhijie Hou
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong
2026/10/13 Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned shihao zhong
2026/10/13 Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Corey Huinker
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Tom Lane
2026/10/13 Re: [PG19] Stale state after the join removal restart gives wrong results shihao zhong
2026/10/13 Re: [PG19] jsonb_object_agg as a window function returns stale values shihao zhong
2026/10/13 Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers Bharath Rupireddy
2026/10/13 Re: generic plans and "initial" pruning Manu
2026/10/13 Parallel vacuum: workers together with leader could overrun cost budget Bharath Rupireddy
2026/10/13 Re: [PG19] btree_gin misses rows for a timestamptz bound in the repeated DST hour shihao zhong
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong
2026/10/13 Re: PG19: flat-copied RelOptInfos share extension_state with the original rel Sho Ito
2026/10/13 Parallel vacuum: avoid dangling shared memory pointers Bharath Rupireddy
2026/10/13 Re: Wrong results from an antijoin Richard Guo
2026/10/13 Parallel autovacuum: honor reduced parallel workers after heap scan phase Bharath Rupireddy
2026/10/13 Re: [PATCH] Clear walsender reader pointers after cleanup Michael Paquier
2026/10/13 Re: UNDO with FILEOPS, and the FLUX table AM Manu
2026/10/13 Re: Add missing FreeDir in CheckTablespaceDirectory Chao Li
2026/10/13 Re: CREATE TABLE .. LIKE copies comments to an unrelated table Koshi Shibagaki (Fujitsu)
2026/10/13 Re: Add missing FreeDir in CheckTablespaceDirectory Fujii Masao
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication Zhijie Hou
2026/10/13 Re: Row pattern recognition Tatsuo Ishii
2026/10/13 Re: pg_upgrade fails with a config-only datadir and no --new-bindir Chao Li
2026/10/13 Re: GIN jsonpath scans miss rows when methods follow a predicate Tom Lane
2026/10/13 Re: Memory leak in statext_ndistinct_build() during ANALYZE Michael Paquier
2026/10/13 GIN jsonpath scans miss rows when methods follow a predicate Fujii Masao
2026/10/13 [DEPARSE] Operators on ROW() constructors read back as row comparisons Henson Choi
2026/10/13 [DEPARSE] IS DOCUMENT as an operand loses needed parentheses Henson Choi
2026/10/13 RE: [PATCH] Reduce LWLockWaitListLock() cache-line contention with adaptive spin reads Min, Baohong
2026/10/13 Re: Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses zengxx
2026/10/13 Re: [PG19] btree_gin misses rows for a timestamptz bound in the repeated DST hour Tom Lane
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication Peter Smith
2026/10/13 Re: WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts surya poondla
2026/10/13 Re: Partition-aware simplification of constant IN lists after partition pruning Manu
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Fujii Masao
2026/10/13 Re: Row pattern recognition Henson Choi
2026/10/13 Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned Álvaro Herrera
2026/10/13 Re: Deprecation warnings on Rocky 10.2 with current dev branch Tom Lane
2026/10/13 Re: Parallel autovacuum: DROP DATABASE WITH (FORCE) fails on the parallel workers Masahiko Sawada
2026/10/13 Re: use radix tree for bitmap heap scan David Geier
2026/10/13 Re: use radix tree for bitmap heap scan David Geier
2026/10/13 Re: meson vs. llvm bitcode files harrisontbooth
2026/10/13 [PATCH] pg_test_fsync: close Windows alarm thread handles harrisontbooth
2026/10/13 Re: Improving scalability of Parallel Bitmap Heap/Index Scan David Geier
2026/10/13 Re: find_all_inheritors() with NoLock fails on concurrently dropped sub-partitions Zsolt Parragi
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Tom Lane
2026/10/13 pg_upgrade fails with a config-only datadir and no --new-bindir Heikki Linnakangas
2026/10/13 Re: Proposal: Supporting URI SAN in Certificate Authentication Agustín Martínez Fayó
2026/10/13 Re: CREATE OR REPLACE MATERIALIZED VIEW Robert Haas
2026/10/13 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Sami Imseih
2026/10/13 Re: find_all_inheritors() with NoLock fails on concurrently dropped sub-partitions surya poondla
2026/10/13 [PATCH] pg_upgrade: handle failed nonblocking connects on Windows Harrison Booth
2026/10/13 Re: Why clearing the VM doesn't require registering vm buffer in wal record Melanie Plageman
2026/10/13 Re: Wrong results from an antijoin Tom Lane
2026/10/13 CF6204 test module: explicitly mark the Windows fixture sparse harrisontbooth
2026/10/13 Re: Incremental backups report progress as if they were full backups surya poondla
2026/10/13 Re: Unlogged materialized views Jim Jones
2026/10/13 Re: [PG19] Bugs found comparing 19 with 18, list before I open threads Manu
2026/10/13 Re: find_all_inheritors() with NoLock fails on concurrently dropped sub-partitions Tom Lane
2026/10/13 Re: Reducing relcache memory usage 2: shrink sizeof(RelationData) Matthias van de Meent
2026/10/13 pg_stat_statements: simplify SQL API version tracking Sami Imseih
2026/10/13 Re: Available disk space per tablespace harrisontbooth
2026/10/13 Re: [PG19] jsonb_object_agg as a window function returns stale values Tom Lane
2026/10/13 Re: Make memory checking / sanitizing infrastructure better Ashutosh Bapat
2026/10/13 Re: [PATCH] pg_test_fsync: close Windows alarm thread handles Álvaro Herrera
2026/10/13 Re: Fix WITHOUT OVERLAPS PKs used for functional grouping Álvaro Herrera
2026/10/13 Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned Álvaro Herrera
2026/10/13 Re: Incremental backups report progress as if they were full backups Fujii Masao
2026/10/13 Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned shihao zhong
2026/10/13 Re: [PATCH v2] Fix races in Windows pthread emulation Harrison Booth
2026/10/13 Re: postgres_fdw: transaction mode inheritance corner cases Etsuro Fujita
2026/10/13 Re: [PATCH] numeric: canonicalize wide digit accumulation zengxx
2026/10/13 Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned Richard Guo
2026/10/13 Re: index prefetching Tomas Vondra
2026/10/13 Re: [PATCH] Add memory/disk usage for Function Scan nodes in EXPLAIN Tatsuya Kawata
2026/10/13 Re: postgres_fdw: Emit message when batch_size is reduced Robert Haas
2026/10/13 Re: [PG19] Stale state after the join removal restart gives wrong results shihao zhong
2026/10/13 Re: Re: [PATCH] Fix segmentation fault caused by reentrancy in RI_Fkey_cascade_del (ri_triggers.c) Lucas Jeffrey
2026/10/13 Re: CREATE TABLE .. LIKE copies comments to an unrelated table Jim Jones
2026/10/13 [PATCH] reindexdb: Fix schema name lookup in parallel mode Koshi Shibagaki (Fujitsu)
2026/10/13 Re: pgsql: Don't trust NOT NULL on virtual generated columns of partitioned Álvaro Herrera
2026/10/13 Re: Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) Boris Mironov
2026/10/13 Re: Fix WITHOUT OVERLAPS multirange with location replication Zhijie Hou
2026/10/13 Re: CREATE TABLE .. LIKE copies comments to an unrelated table Koshi Shibagaki (Fujitsu)
2026/10/13 Re: Prevent premature startup of pg_upgrade targets Shubhra Jain
2026/10/13 Re: pull-up subquery if JOIN-ON contains refs to upper-query Alena Rybakina
2026/10/13 Re: [PATCH] numeric: canonicalize wide digit accumulation Heikki Linnakangas
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong
2026/10/13 Re: Fix WITHOUT OVERLAPS multirange with location replication Amit Kapila
2026/10/13 RE: Test publication.sql racing with subscription.sql might fail due to cache lookup error Hayato Kuroda (Fujitsu)
2026/10/13 Re: [(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table Jakub Wartak
2026/10/13 Re: PG19: flat-copied RelOptInfos share extension_state with the original rel Shubhankar Anand Kulkarni
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/13 ERROR: failed to assign all NestLoopParams to plan nodes Richard Guo
2026/10/13 Re: [PATCH] pg_combinebackup: make the OID range check in parse_oid() effective solai v
2026/10/13 Re: Be strict when request to flush past end of WAL in WaitXLogInsertionsToFinish Paul Kim
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/13 Re: Be strict when request to flush past end of WAL in WaitXLogInsertionsToFinish Paul Kim
2026/10/13 RE: Bug in logical decoding with DDL and subtransactions Hayato Kuroda (Fujitsu)
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication Dilip Kumar
2026/10/13 Re: [PATCH] Reduce LWLockWaitListLock() cache-line contention with adaptive spin reads Jakub Wartak
2026/10/13 Re: New test function replace_conf() to get rid of unlink/append pattern Nazir Bilal Yavuz
2026/10/13 Re: json/jsonb cleanup + FmgrInfo caching jian he
2026/10/13 Re: ERROR: SubPlan found with no parent plan Amit Langote
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/13 Re: [PATCH v2] Fix races in Windows pthread emulation Heikki Linnakangas
2026/10/13 Re: [PATCH v1] Fix tab completion for concurrent materialized view refresh Daniel Gustafsson
2026/10/13 Re: [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding Fujii Masao
2026/10/13 Re: Test publication.sql racing with subscription.sql might fail due to cache lookup error vignesh C
2026/10/13 Re: Test publication.sql racing with subscription.sql might fail due to cache lookup error Zhijie Hou
2026/10/13 Re: 041_checkpoint_at_promote.pl might fail due to race condition on child kill Fujii Masao
2026/10/13 Re: Proposal: Conflict log history table for Logical Replication Peter Smith
2026/10/12 RE: Test publication.sql racing with subscription.sql might fail due to cache lookup error Hayato Kuroda (Fujitsu)
2026/10/12 Re: Deprecation warnings on Rocky 10.2 with current dev branch Rui Zhao
2026/10/12 [DEPARSE] An alias named 'set' on an UPDATE, DELETE or MERGE target does not read back Henson Choi
2026/10/12 Re: Fix WITHOUT OVERLAPS multirange with location replication kedar anavardekar
2026/10/12 [DEPARSE] Pretty-printed sublink test expressions lose needed parentheses Henson Choi
2026/10/12 Re: Restructured Shared Buffer Hash Table Alexandre Felipe
2026/10/12 Re: [PG19] pg_dump --statistics restores extended statistics by attribute number shihao zhong
2026/10/12 Re: pgstat: allow a stats kind to use its own dedicated dsa/dshash Michael Paquier
2026/10/12 Re: Test publication.sql racing with subscription.sql might fail due to cache lookup error vignesh C
2026/10/12 Re: Correct documentation for protocol version solai v
2026/10/12 Re: Restructured Shared Buffer Hash Table Dhruv Aron
2026/10/12 Re: [PG19] Stale state after the join removal restart gives wrong results Tom Lane
2026/10/12 Re: [PG19] pg_dump --statistics restores extended statistics by attribute number Michael Paquier
2026/10/12 [PG19] psql backslash commands fail with translated messages and a non UTF-8 client encoding shihao zhong
2026/10/12 Re: [PATCH] Fix pg_dump emitting OVERRIDING SYSTEM VALUE for tables with dropped identity columns Fujii Masao
2026/10/12 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/12 [PG19] pg_dump --statistics restores extended statistics by attribute number shihao zhong
2026/10/12 Re: [PG19] Bugs found comparing 19 with 18, list before I open threads jian he
2026/10/12 [PATCH v1] Fix tab completion for concurrent materialized view refresh Sho Ito
2026/10/12 [PG19] btree_gin misses rows for a timestamptz bound in the repeated DST hour shihao zhong
2026/10/12 Re: Row pattern recognition jian he
2026/10/12 [PG19] Eager aggregation runs a volatile join clause once per group shihao zhong
2026/10/12 Use a hash table for the regexp cache Tianyi Gao
2026/10/12 [PG19] jsonb_object_agg as a window function returns stale values shihao zhong
2026/10/12 Re: [PATCH] numeric: canonicalize wide digit accumulation Junwang Zhao
2026/10/12 Re: [PG19] Stale state after the join removal restart gives wrong results Tom Lane
2026/10/12 Re: [PG19] Stale state after the join removal restart gives wrong results shihao zhong
2026/10/12 [PG19] Stale state after the join removal restart gives wrong results shihao zhong
2026/10/12 [PG19] Bugs found comparing 19 with 18, list before I open threads shihao zhong
2026/10/12 Re: Improving scalability of Parallel Bitmap Heap/Index Scan John Naylor
2026/10/12 Re: Wrong results from an antijoin wenhui qiu
2026/10/12 Re: Re: [PATCH] Discard aborted updaters when expanding a multixact Chee Wooson
2026/10/12 Windows ECPG pthread_once publication ordering Harrison Booth
2026/10/12 Re: Windows locales and tests portability Harrison Booth
2026/10/12 Re: Assorted Win32 error handling fixes (CreateThread, pgwin32_select, pg_usleep) Harrison Booth
2026/10/12 Wrong results from a mergejoin Richard Guo
2026/10/12 Re: [PATCH] Clear walsender reader pointers after cleanup Ayush Tiwari
2026/10/12 Re: [PATCH] numeric: canonicalize wide digit accumulation Quan Zongliang
2026/10/12 Re: First draft of PG 19 release notes Bruce Momjian
2026/10/12 Re: Deprecation warnings on Rocky 10.2 with current dev branch Tom Lane
2026/10/12 Re: Fix WITHOUT OVERLAPS PKs used for functional grouping Paul A Jungwirth
2026/10/12 Re: [PATCH] pg_upgrade: add --initdb option to create the new cluster automatically Heikki Linnakangas
2026/10/12 Re: Fix WITHOUT OVERLAPS multirange with location replication Paul A Jungwirth
2026/10/12 Re: Use WALReadFromBuffers in more places Bharath Rupireddy
2026/10/12 Re: POC: Unlocked path for GetSnapshotDataReuse Bertrand Drouvot
2026/10/12 Re: Proposal: SELECT * EXCLUDE (...) command Hunaid Sohail
2026/10/12 Re: [PATCH v2] meson: Support ECPG tests in runnable cross builds harrisontbooth
2026/10/12 Re: [PATCH v3] Fix pg_basebackup long-path test on Windows harrisontbooth
2026/10/12 Re: [PATCH v2] Fix races in Windows pthread emulation harrisontbooth
2026/10/12 Re: Fix WITHOUT OVERLAPS multirange with location replication Zhijie Hou
2026/10/12 Re: [Patch] New pg_stat_tablespace view shihao zhong
2026/10/12 Re: [PATCH] Fix recovery connection detail in EXEC_BACKEND builds Heikki Linnakangas
2026/10/12 Re: Reduce logging during prepared transaction recovery Ashutosh Sharma
2026/10/12 Re: BUG #19736: `JSON_OBJECT ... ABSENT ON NULL` accepts invalid keys when the value is NULL QQ Mail
2026/10/12 Re: [PATCH] Clear walsender reader pointers after cleanup Michael Paquier
2026/10/12 Re: Proposal: SELECT * EXCLUDE (...) command Kacper Kuras
2026/10/12 Re: examine_variable ignored CollateExpr ZizhuanLiu X-MAN
2026/10/12 Re: Proposal: Conflict log history table for Logical Replication shveta malik
2026/10/12 Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting Xuneng Zhou
2026/10/12 Re: Incremental backups report progress as if they were full backups Daria Lepikhova
2026/10/12 Re: PG19: flat-copied RelOptInfos share extension_state with the original rel Sho Ito
2026/10/12 Re: [Patch] New pg_stat_tablespace view Zsolt Parragi
2026/10/12 Re: Restructured Shared Buffer Hash Table Alexandre Felipe
2026/10/12 find_all_inheritors() with NoLock fails on concurrently dropped sub-partitions Zsolt Parragi
2026/10/12 Re: [PROPOSAL] Expand OR clauses in joins to UNION ALL paths Zsolt Parragi
2026/10/12 Re: Compression of bigger WAL records Zsolt Parragi
2026/10/12 Re: Proposal: Conflict log history table for Logical Replication Nisha Moond
2026/10/12 Re: index prefetching Peter Geoghegan
2026/10/12 Re: Let an ordering index scan hand its ORDER BY value to the target list Oleg Bartunov
2026/10/12 Re: Incremental backups report progress as if they were full backups surya poondla
2026/10/12 Re: [PG19] Three bugs with a CHECK constraint that only the child enforces jian he
2026/10/12 Re: pg_resetwal: refuse to run when backup_label exists Tình Trần
2026/10/12 Re: Fix WITHOUT OVERLAPS multirange with location replication kedar anavardekar