PGNexus Daily News PostgreSQL Technical Articles [image: PostgreSQL migration for enterprise environments: What to plan for] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Fujitsu PostgreSQL migration for enterprise environments: What to plan for <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Enterprise PostgreSQL migrations succeed or fail based on planning done well before cutover. The article emphasizes that most teams underestimate the planning phase, rushing towar… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> [image: How to Tell Whether Your Slow Query Is a Planning or an Execution Problem] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fs...> NanoHertz Communications How to Tell Whether Your Slow Query Is a Planning or an Execution Problem <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fs...> PostgreSQL's EXPLAIN ANALYZE output includes both Planning Time and Execution Time, but engineers often ignore the former. On a table partitioned into 500 daily chunks, planning a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fs...> PostgreSQL Hackers Email Discussion Highlights split tablecmds.c <https://pgnexus.ai/hacker-discussions?subject=split%20tablecmds.c> The thread discusses a patch to split `tablecmds.c` by moving partitioning-related code into a new `tablecmds_partition.c` file and introducing `tablecmds_internal.h` for shared d… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=split%20tablecmds.c> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> The discussion concerns a patch (v13) to release replication slots on error in SQL-callable slot functions. Masahiko Sawada reviewed v12 and proposed several comment/naming improv… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> The thread discusses v10 of a patch series adding Bloom filter pushdown to hash joins. Matheus Alcantara addressed several issues from Rui Zhao's review: correcting probe cost cha… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> problems with toast.* reloptions <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20re...> Nathan Bossart has committed most of the patch series addressing problems with toast.* reloptions, leaving only the last two patches pending. He attached a rebased patch set incor… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20re...> missing possibility to use alternative translated month names in to_char function <https://pgnexus.ai/hacker-discussions?subject=missing%20possibility%20to%20u...> The thread discusses a patch by Pavel Stehule adding a `TAMMONTH`/`TAMMON` modifier to PostgreSQL's `to_char()` function. The motivation is that glibc 2.28+ returns month names in… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=missing%20possibility%20to%20u...> Introduce XID age based replication slot invalidation <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based%...> The thread discusses introducing XID-age-based replication slot invalidation, specifically focusing on how synced slots on standbys should be handled. Bharath Rupireddy and Bertra… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based%...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-21-postgresql-daily-news-245.m...> Social Media Updates [image: NBCUniversal modernized its data infrastructure to support the speed and scale of a modern media business, where major content launches, awards shows, and live events can drive sudden spikes in analytics demand.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin NBCUniversal modernized its data infrastructure to support the speed and scale of a modern media business, where major content launches, awards shows, and live events can drive sudden spikes in analytics demand. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> NBCUniversal partnered with Databricks and EXL to modernize its data infrastructure, consolidating data engineering, analytics, and machine learning onto a unified platform. The m… linkedin As agentic automation helps developers get more done, the role is evolving toward higher-level decisions about what to build, how systems should work, and where taste and creativity matter most. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Agentic automation is shifting the developer role away from routine coding toward higher-level decisions about system design, product direction, and creative judgment. Databricks… [image: UUID v4 has been quietly wrecking B-tree indexes for decades - most shops just chalk it up to Postgres being Postgres.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin UUID v4 has been quietly wrecking B-tree indexes for decades - most shops just chalk it up to Postgres being Postgres. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> UUID v4 generates random values that land on arbitrary B-tree leaf pages, causing cache misses, page splits, and high fragmentation. In testing with one million rows, v4 produces… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more