2026-05-25

[PATCH] Add regression test for mismatched ENCODING and LOCALE in CREATE DATABASE

# Analysis: Add Regression Test for Mismatched ENCODING and LOCALE in CREATE DATABASE ## Core Problem The PostgreSQL documentation for `CREATE DATABASE` explicitly states that encoding and locale s...

meson: Make test output much more useful on failure (both in CI and locally)

## Incremental Update: Brief Clarification Question from Andrew Dunstan Andrew Dunstan posted a one-line question (2026-05-24) asking "Why can't the TAP sets set it?" — referring to the environment v...

Available disk space per tablespace

## Solai's testing report on v5 — no new technical substance A new participant (Solai, solai.cdac@gmail.com) posted a brief testing confirmation of v5 on Linux. The message reports: - Clean apply an...

postgres_fdw: use_scram_passthrough on user mapping is ignored when also set on server

## Incremental Analysis: Final Agreement on Backpatching Strategy ### Summary The thread has reached consensus with no new technical content beyond what was previously analyzed. The two new messages...

Inquiry Regarding Parallel DML (Write-Side) Support in Future PostgreSQL Releases

# Analysis: Parallel DML (Write-Side) Support in PostgreSQL ## Core Technical Problem This thread raises a fundamental architectural question about PostgreSQL's parallel execution framework: **why i...

[BUG] CRASH: ECPGprepared_statement() and ECPGdeallocate_all() when connection is NULL

## Minimal New Activity: Brief Post from Satya Narlapuram A new participant (Satya Narlapuram) has posted a very brief message stating "Looks like this committed a case, attached a patch to fix this....

Try a presorted outer path when referenced by an ORDER BY prefix

## Lepikhov's Response to Parragi's Review Lepikhov responds to the two issues raised by Zsolt Parragi, but does **not** provide a new patch version. The response is brief and primarily acknowledges/...

ERROR during COMMIT PREPARED can leave orphaned locks

# ERROR during COMMIT PREPARED Can Leave Orphaned Locks ## Problem Statement This thread identifies a subtle but serious bug in PostgreSQL's two-phase commit (2PC) implementation where an ERROR occ...

splitting pg_resetwal output strings

# Splitting pg_resetwal Output Strings: Dynamic Column Alignment for Translatable Output ## Core Problem PostgreSQL's `pg_resetwal` (and similar tools like `pg_controldata`) produce tabular output ...

Rename Postgres 19 to Postgres 26 (year-based)?

## Incremental Update: Core Committer Opposition Emerges The most significant development since the initial analysis is that **two core committers** (Tom Lane and Peter Eisentraut) have now weighed i...

[PATCH] Make NumericVar storage semantics explicit

## Incremental Update: Review Bump with No Technical Changes The only new message is a polite "ping" from the author requesting reviewer attention. There are no new patches, no design changes, no tec...

Fix pg_get_multixact_stats() members_size calculation

# Fix pg_get_multixact_stats() members_size Calculation ## Core Problem The `pg_get_multixact_stats()` function, introduced to help DBAs monitor multixact storage consumption, contains an integer a...

Prevent setting NO INHERIT on partitioned not-null constraints

## Update: Patch Committed The thread has reached its conclusion with the patch being committed. The two new messages are brief confirmations: 1. **Andreas Karlsson** confirmed agreement that the fi...

Tighten SCRAM iteration parsing and bound libpq PBKDF2 work

# Tighten SCRAM Iteration Parsing and Bound libpq PBKDF2 Work ## Core Problem This thread addresses two distinct but related security/correctness issues in PostgreSQL's SCRAM-SHA-256 authentication...

Permission elevation by pg_amcheck operator overloading via search_path possible?

# Permission Elevation via pg_amcheck Operator Overloading Through search_path Manipulation ## Core Problem This thread raises a security vulnerability in `pg_amcheck` — PostgreSQL's built-in tool ...

Report oldest xmin source when autovacuum cannot remove tuples

# Technical Analysis: Report Oldest Xmin Source When Autovacuum Cannot Remove Tuples ## Core Problem PostgreSQL's VACUUM process cannot remove dead tuples that are still visible to any active transa...

[PATCH] libpq: try all addresses for a host before moving to next on target_session_attrs mismatch

## Incremental Analysis: Evgeny's Rebuttal on getaddrinfo() Reliability and DNS Client Concerns Evgeny returns after an 11-day pause with a carefully researched counter-argument to Jacob Champion's p...

Removing broken support for OpenSSL without ECDH

# Removing Broken Support for OpenSSL without ECDH ## Technical Problem PostgreSQL's SSL/TLS implementation contains dead code paths guarded by the `OPENSSL_NO_ECDH` preprocessor macro, which was i...

[PATCH] psql: Add missing IO option to EXPLAIN tab completion

## Commit Confirmation The patch has been committed by Fujii Masaoyu (masao.fujii@gmail.com). No further technical discussion occurred — this is a simple acknowledgment of the push. The thread is now...

[PATCH] psql: Display SQLSTATE macro name in verbose error reports

# Technical Analysis: psql SQLSTATE Macro Name Display in Verbose Error Reports ## Core Problem When PostgreSQL's `psql` client displays verbose error messages (activated via `\set VERBOSITY verbose...

[PATCH] Improving index selection for logical replication apply with replica identity full

# Technical Analysis: Improving Index Selection for Logical Replication Apply with Replica Identity Full ## Core Problem When PostgreSQL performs logical replication with `REPLICA IDENTITY FULL`, U...

[PATCH] Fix NULL dereference in subscription REFRESH on concurrent DROP

# Technical Analysis: Fix NULL Dereference in Subscription REFRESH on Concurrent DROP ## Core Problem This thread addresses a **crash bug** (segfault) in PostgreSQL's logical replication subscripti...

Adding pg_dump flag for parallel export to pipes

## New External Tester Report — First Substantive Feedback in Months Solai (solai.cdac@gmail.com) provides the first external testing report since Mahendra's earlier reviews. The message confirms bas...

Implement waiting for wal lsn replay: reloaded

## No Substantive Technical Progress The two new messages from Xuneng Zhou are simply: 1. **Agreement/LGTM** on Korotkov's patch approach (calling `wait_for_slot_catchup()` directly in the test rath...

Incremental View Maintenance, take 2

# Incremental View Maintenance (IVM) for PostgreSQL — Deep Technical Analysis ## Core Problem Materialized views in PostgreSQL can only be refreshed via `REFRESH MATERIALIZED VIEW`, which recompute...

Fix pg_stat_wal_receiver to show CONNECTING status

## Incremental Update: Patches Committed + Post-Commit Review ### Resolution: Both Patches Applied Michael Paquier committed the v3 patch set on 2026-05-22: - **v3-0001** (the CONNECTING visibility...

Pg upgrade bug with NOT NULL NOT VALID

## Incremental Update: Continued Discussion on Fix Approach The thread has a brief exchange between Kirill Reshke and Álvaro Herrera clarifying positions on the solution approach, but no patches or s...