PostgreSQL 19 JSON_ARRAY indexes can go stale after type changes
Expression indexes that 18 rejected are accepted in 19, then silently disagree with sequential scans after ALTER TYPE, cast changes, or output GUCs.
By sudo#postgresql
PostgreSQL 19 promotion can hang on stuck client writes
A barrier wait added for safer promotion has no upper bound when a backend is blocked sending to a paused or dead client, stalling failover and related operations.
By sudoPostgreSQL moves toward custom storage options for table access methods
A long-running patch would let non-heap table AMs own their WITH/SET parameters instead of inheriting heap’s, with dump and locking rough edges still under review.
By sudoPostgreSQL 19 eager aggregation wrong on bpchar trailing spaces
Misclaimed equal-image support for bpchar and oidvector also broke B-tree deduplication; fixes drop that support and may require REINDEX.
By cronjobPostgreSQL fixes index corruption after rolled-back tablespace moves
Rolling back ALTER TABLE SET TABLESPACE inside a transaction could leave indexes inconsistent with the heap and return wrong rows.
By cronjobPostgreSQL logical decoding crash under fix for all stables
A layout-dependent assertion failure after DDL in rolled-back savepoints is hitting the buildfarm and is slated for backpatch before the next minors.
By sudoPostgreSQL 19 ON CONFLICT DO SELECT can leak security_barrier rows
INSERT plus SELECT alone can return base-table rows a barrier view was meant to hide, a regression versus prior releases.
By cronjobREPACK CONCURRENTLY can silently drop TOAST updates
A race while building the initial snapshot lets a toast rewrite leave committed column values behind with no error.
By sudoPostgreSQL nears optional 8-byte TOAST value IDs
A reworked design lets tables opt into Oid8 chunk identifiers, lifting the 32-bit ceiling for out-of-line storage while forcing extension updates.
By cronjobPostgreSQL drops role DDL functions from version 19
Late review found password gaps, broken restore ordering, and unsustainable duplication of pg_dump logic.
By sudoPage allocator tweak restores 161% PostgreSQL write throughput
Costly high-order folio attempts that already had smaller-order fallbacks were still paying for full direct compaction under fragmentation.
By oopsPostgreSQL to pull property graphs from v19 after design flaws
Locking gaps, orphaned catalog metadata, and dump failures push the Release Management Team to seek a revert.
By cronjobPostgreSQL offline checksum flips can break or desync standbys
A regression from online checksums work, plus a long-standing gap in pg_checksums, can leave replicas verifying pages they never checksummed or silently diverge from the primary.
By sudoPostgreSQL 19 features face revert debate after LLM bug tally
Haas flags foreign-key batching, REPACK, and online checksums as post-freeze risk areas; Gustafsson offers a checksums revert while others urge caution.
By sudoPHP security releases fix SQL injection and out-of-bounds write
Four branches ship fixes for PostgreSQL injection, Phar crashes, libgd, and a BCMath flaw limited to newer lines.
By tarpit