If you’ve used docs.pgedge.com recently, you’ve probably met Ellie. Ask her how to set up multi-master replication, or what port the MCP Server...

   One Database at a Time, or All at Once?You have deployed your new cluster. Now comes the work of moving your data and cutting over to it. Reading...

   PostgreSQL validates function bodies at creation time by default, catching syntax errors early.

   After helping out a buddy with the job title of Data Analyst, who experienced some light Postgres bucketing woes - and given the fact that this was...

   PostgreSQL’s Table Access Method API is finally seeing real action.

   PostgreSQL’s bytea output parameter controls how binary data is formatted when sent to clients: the modern hex format (default since 9.0) or the...

   PgBouncer 1.25.2 shipped a patch for a pre-authentication crash (CVE-2026-6664). Any TCP connection can take down your pooler. Patch this week.

   When the future of pgBackRest suddenly became uncertain, the PostgreSQL ecosystem reacted quickly.At Percona, we believed the most important question...

   PostgreSQL, often through platforms like Supabase, is increasingly becoming part of the default stack for many AI applications. That level of...

   PostgreSQL’s Bonjour parameters let you advertise a server on the local network via Apple’s service-discovery protocol a clever 2002 idea that hasn’t...

   The conversation around AI infrastructure today is heavily focused on models, GPUs, inference speed, and vector databases. These are important...

   Note: this post was not rewritten by AI I’ve been saying for a long time that AI can’t help me because no one else codes the way I do, so...

   PostgreSQL 19 beta arrives with four operational game-changers: 64-bit MultiXact Members kill a decades-old vacuum or die failure mode, parallel...

   This article compares CloudNativePG and Crunchy PGO, two of the most adoptedopen-source operators for running PostgreSQL on Kubernetes. It...

   IntroductionIf you’ve been running PostgreSQL for any length of time, you’ve probably heard about transaction ID (XID) wraparound. It’s one of the...

   A parameter you cannot change. block size lives in the Preset Options section of the docs, alongside its read-only cousins like data checksums, wal...

   These two parameters close out the bgwriter cluster. Together with bgwriter delay, they govern how the background writer decides what to write each...

   The B cluster shifts gears: from one-off oddities to the background writer parameters, which span four GUCs. We do the first two as a pair because...

   Two remote code execution bugs lived in pgcrypto for twenty years until an AI fuzzer found them in a weekend. Here’s what you need to know.

   Debug PostgreSQL errors by capturing C-level stack traces for specific internal functions.

   SQL is fun and not at all boring. The latest article by Markus Winand on Order by Has Come a Long Way sent me on quite a journey.First, set up a...

   PostgreSQL 18.4, 17.10, 16.14, 15.18, and 14.23 are out as of May 14, 2026. The release fixes eleven security issues and more than sixty bugs. That...

   PostgreSQL 19 brings back MERGE PARTITIONS and SPLIT PARTITION but simpler and safer than the first attempt.

   Yesterday, we had our first meetup at our new venue, which we hope will become our permanent home: the Chicago Innovations Center at 1 W. Monroe. We...

   A 2006 SQL injection vulnerability and multibyte character encodings created backslash quote , a GUC parameter that remains in PostgreSQL for...

   It’s that time again. The upcoming Postgres v18.4 release (along with minor releases for all Major versions) has dropped some serious hints in the...

   A heap buffer overflow in pgcrypto’s OpenPGP code lurked for two decades until a December 2025 exploit made it real.

   I’m excited to announce release 1.0 of pg statviz, the minimalist extension and utility pair for time series analysis and visualization of PostgreSQL...

   A step-by-step guide to migrating a PostgreSQL 17 cluster managed by Crunchy PGO v6 to PostgreSQL 18 under CloudNativePG. Two paths are covered: a...

   PGConf Belgium took place on 5 May 2026, organized by Wim Bertels, An Vercammen, and Grégory Gioffredi , who served also at the talk selection team...