Sequence Access Methods, round two
## Incremental Update: Independent Benchmark Validation by Lepihov ### Summary Lepihov (Andrei Lepikhov) followed up on his earlier suggestion about avoiding unnecessary cache lookups with independe...
2026-05-20
Should IGNORE NULLS cache nullness for volatile arguments?
## No Substantive Progress The only new message is a brief thank-you from Evan Chao acknowledging that Tatsuo Ishii pushed the patch. There is no new technical content, no further discussion, and no ...
pg_recvlogical: honor source cluster file permissions for output files
## Incremental Update: Test Coverage Expansion and Backpatch Strategy ### What's New Fujii Masao reviewed the TAP test proposed by Srinath and identified a gap: the test only verified the group-acce...
relfilenode statistics
# Relfilenode Statistics: Deep Technical Analysis ## The Core Problem PostgreSQL's statistics subsystem (`pgstats`) currently keys relation-level statistics by the relation's OID. This creates a fu...
PSQL - prevent describe listing tables that are already in listed schemas
## Incremental Update: v2→v4 Patch Evolution and Scope Expansion ### Key Development: Scope Expanded to `\d+` Command Jim Jones identified an analogous redundancy problem in the `\d+` (describeOneT...
[PATCH] ternary reloption type
# Technical Analysis: Ternary Reloption Type Patch Review ## Core Problem PostgreSQL's relation options (reloptions) system historically supported boolean, integer, real, enum, and string types. Se...
Review observations for COPY ON_ERROR_TABLE patch
# Technical Analysis: Review Observations for COPY ON_ERROR_TABLE Patch ## Core Problem The COPY ON_ERROR_TABLE feature extends PostgreSQL's existing `COPY ... ON_ERROR` mechanism (introduced in Po...
Failure in test_slru for host gokiburi (REL_16_STABLE only)
# Technical Analysis: Failure in test_slru for host gokiburi (REL_16_STABLE only) ## Core Problem This thread identifies a subtle bug in the `test_slru` contrib module's LWLock initialization logic ...
Implement waiting for wal lsn replay: reloaded
## New Bug: `wait_for_catchup()` with WAIT FOR LSN Causes Race in Replication Slot State Tests Alexander Korotkov reports a **new class of test failure** caused by the WAIT FOR LSN-based `wait_for_ca...
Fix pg_stat_wal_receiver to show CONNECTING status
# Fix pg_stat_wal_receiver to Show CONNECTING Status ## Core Problem Commit `a36164e74` introduced a `WALRCV_CONNECTING` state to the WAL receiver subsystem, explicitly motivated by monitoring use ...
[PATCH] Fix psql tab completion for REPACK boolean options
## Incremental Update: Proposal for Centralized DefElem Option Handling A new participant (Thom) raises an architectural question about the root cause of the duplicate-option bug: the lack of shared ...
postgres_fdw: use_scram_passthrough on user mapping is ignored when also set on server
## Incremental Analysis: Review Discussion on Backpatching and Test Placement ### Summary of New Activity Fujii Masao reviewed the patch set and provided feedback on two key areas: (1) test placemen...
Make the logical replication conflict messages more like each other
# Technical Analysis: Make the Logical Replication Conflict Messages More Like Each Other ## Core Problem The logical replication subsystem in PostgreSQL generates conflict messages (via `conflict.c...
=?UTF-8?B?VkFDVVVNIEZVTEwgb3IgQ1JFQVRFIElOREVYIGZhaWxzIHdpdGggZXJyb3I6?= =?UTF-8?B?IG1pc3NpbmcgY2h1bmsgbnVtYmVyIDAgZm9yIHRvYXN0IHZhbHVlIFhYWA==?=
# Deep Technical Analysis: VACUUM FULL / CREATE INDEX Fails with "missing chunk number 0 for toast value" ## Core Problem This thread identifies a subtle but serious consistency bug in PostgreSQL's ...
Support LIKE with nondeterministic collations
# Support LIKE with Nondeterministic Collations ## Core Problem PostgreSQL's nondeterministic collations (introduced by Peter Eisentraut) enable case-insensitive, accent-insensitive, and other Unic...
duckdb has extensible parser
## Incremental Update: New Participant Shares Concrete Implementation Work ### What's New Greg Burd has responded to Pavel Stehule's original post with a concrete (though incomplete) implementation ...
[PATCH] psql: Make ParseVariableDouble reject values above max
## What's New A single follow-up from **Daniel Gustafsson** confirming the fix has been **committed and backpatched to v18**. Key new data points: 1. **Commit is done.** The fix has been pushed to t...
Function scan FDW pushdown
## New in this round: Korotkov posts v5 addressing all five Pyhalov bugs, then two rapid follow-up fixups for whole-row Var edge cases in DirectModify/outer-join paths This round shows the patch ente...
Review observations for partial REFRESH MATERIALIZED VIEW patc
# Technical Analysis: Review Observations for Partial REFRESH MATERIALIZED VIEW Patch ## Core Problem Materialized views in PostgreSQL currently support only full refresh semantics — the entire mat...
[BUG] Take a long time to reach consistent after pg_rewind
# Technical Analysis: Unbounded Wait to Reach Consistent Recovery State After pg_rewind ## Core Problem After `pg_rewind` is used to resynchronize a former primary with a new primary, the rewound n...
[PATCH] Fix REPACK decoding worker not cleaned up on FATAL exit
## v3 Patch Committed + Follow-up Cleanup Patch ### Key Development: Patch Committed Álvaro Herrera has **committed** the v3 patch (PG_ENSURE_ERROR_CLEANUP approach) with minor cosmetic/comment chan...
remove obsolete comment in AtEOXact_Inval
## Update: Patch Committed Daniel Gustafsson's single-word response "Done." confirms he has pushed the comment removal to the repository. This is the final disposition of the thread — no technical di...
meson: Make test output much more useful on failure (both in CI and locally)
## Incremental Update: Minor Progress Note on Truncation Handling The only new message since the prior analysis is a brief status update from Jelte Fennema-Nio (2026-05-18) regarding the interaction ...
Fix incorrect size check in statext_dependencies_deserialize
# Fix Incorrect Size Check in `statext_dependencies_deserialize` ## Core Problem The function `statext_dependencies_deserialize()` in PostgreSQL's extended statistics subsystem contains a bug in it...
Improve conflict detection when replication origins are reused
## Incremental Update: Alternative Approaches Explored and Dismissed ### Shveta's Agreement and New Alternative Ideas Shveta Malik formally endorsed Approach 2 (origin creation timestamp) as the mos...
Fix typo 586/686 in atomics/arch-x86.h
## Patch Committed Daniel Gustafsson's single-word "Done." confirms the 32-bit atomics removal patch has been committed to HEAD. No new technical discussion, no new arguments, no new participants. Th...
Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment
## No Substantive Progress The new message from Surya Poondla is a brief acknowledgment thanking Solai for testing/confirming and agreeing with a comment suggestion. There is no new technical content...
COPY FROM ON_ERROR SET_NULL bypasses domain NOT NULL with partial column list
# COPY FROM ON_ERROR SET_NULL Bypasses Domain NOT NULL with Partial Column List ## Core Technical Problem This thread addresses a memory safety bug in PostgreSQL's COPY FROM implementation that caus...
[oauth] Fix minimal typo in OAuth
# Technical Analysis: Fix Minimal Typo in OAuth ## Core Problem This is a trivial cosmetic fix addressing a minor typo in PostgreSQL's OAuth authentication code — specifically a forgotten/missing q...
Fix bug of COPY (on_error set_null)
## No Substantive Progress The only new message is a brief acknowledgment from li.evan.chao@gmail.com stating they will review the referenced patch. There is no new technical content, no patch revisi...
Fix SPLIT PARTITION bound-overlap bug and other improvements
## Incremental Update: Patches 0001-0003 Committed, Collation Bug Found in 0004 ### Major Development: Patches Committed Alexander Korotkov pushed patches 0001 through 0003 (the core bound-overlap b...