Fujitsu

PostgreSQL migration for enterprise environments: What to plan for

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

NanoHertz Communications

How to Tell Whether Your Slow Query Is a Planning or an Execution Problem

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

split tablecmds.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

[PATCH] Release replication slot on error in SQL-callable slot functions

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

hashjoins vs. Bloom filters (yet again)

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

problems with toast.* reloptions

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

missing possibility to use alternative translated month names in to_char function

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

Introduce XID age based replication slot invalidation

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

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.

NBCUniversal partnered with Databricks and EXL to modernize its data infrastructure, consolidating data engineering, analytics, and machine learning onto a unified platform. The m…

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.

Agentic automation is shifting the developer role away from routine coding toward higher-level decisions about system design, product direction, and creative judgment. Databricks…

UUID v4 has been quietly wrecking B-tree indexes for decades - most shops just chalk it up to Postgres being Postgres.

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…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Social Media Updates