The Curious Engineer

All blogs / Databases

pgEdge Blog: Enterprise Postgres & AI Insights

pgedge.com/blog

Engineering deep-dives on Enterprise PostgreSQL, agentic AI, multi-master replication, and Kubernetes - from the pgEdge engineering team.

DatabasesDistributed systems / cloud

’24’25’26
Posts
191 from 7 Aug 2024 to 30 Oct 2026
Posting
weekly (106 in the last year)
Kind
company blog

2026 87

  1. PG Phriday: Burnt TOAST
  2. Zero Downtime Rolling Major PostgreSQL Upgrades on a Distributed PostgreSQL Cluster
  3. Undo for Postgres, without losing the rest of your day
  4. pgbuild, and Knowing What Ships with pgAdmin
  5. Moving the pgAdmin Build Farm to GitHub Actions
  6. PG Phriday: Against the WAL
  7. Why is PostgreSQL's Numeric Type so Slow?
  8. Why We Built pgEdge Starfleet
  9. Looking Forward to Postgres 19: Epilogue
  10. Flexible Deployment: What Enterprise-Grade Self-Hosting Actually Demands
  11. PG Phriday: The Folder That Ate the Publisher
  12. Optimising PostgreSQL Aggregates: What Can an Extension Do?
  13. Batteries Included: Powering AI DBA Workbench Locally with llama.cpp
  14. Why is numeric so popular in PostgreSQL databases?
  15. From the Trenches: My Path Through Postgres
  16. Building Enterprise Healthcare Applications on Postgres: pgEdge Is Now HIPAA-Ready
  17. The Time Traveler's Primary Key
  18. Do Global Hash Tables Strike Back in PostgreSQL?
  19. Let's Build a Postgres Extension for Estimating Memory Usage!
  20. Looking Forward to Postgres 19: Syntax Potpourri
  21. Postgres for Agentic AI: Your Database Is a Compute Layer, Not a Parking Lot
  22. PostgreSQL 18's extension_control_path: Decoupling Extensions from Server Images
  23. Looking Forward to Postgres 19: The Cult of Functionality
  24. Looking Forward to Postgres 19: Autovacuum Tweaks
  25. Hybrid Search in PostgreSQL: BM25, Sparse Vectors, and Reciprocal Rank Fusion
  26. Looking Forward to Postgres 19: Checkpoint Control
  27. Spock 6: The Only Logical Choice
  28. How to Build a RAG Server on pgEdge Cloud via the API
  29. Looking Forward to Postgres 19: Checksums For All
  30. Introducing pg-healthcheck: PostgreSQL Health Diagnostics
  31. Looking Forward to Postgres 19: Split Personality
  32. The Long Road to Bottomless Postgres
  33. Looking Forward to Postgres 19: Logically Sequenced
  34. Introducing ColdFront: Seamlessly Uniting OLTP, Analytics and AI Workloads on PostgreSQL
  35. Your AI App Works On Postgres. Now Make It Production-Ready Without Starting Over
  36. Looking Forward to Postgres 19: It's About Time
  37. Inside the pgEdge AI DBA Workbench: How Ellie Actually Works
  38. Looking Forward to Postgres 19: Query Hints
  39. Intelligent RDS Monitoring: Connecting AWS RDS to pgEdge AI DBA Workbench
  40. Going Rogue: Autonomous AI Agents and Postgres
  41. Looking Forward to Postgres 19: The New REPACK Command
  42. Preventing Prompt Injection Attacks in Your LLM Application
  43. EXPLAIN Prettier, or Post-Processing Query Plans in Postgres
  44. Why Postgres Lacks Transparent Data Encryption
  45. From Managed PostgreSQL to Production RAG: Build Your Own Ellie in pgEdge Cloud
  46. Binary, ternary, or is it actually quaternary logic in Postgres functions?
  47. Unlimited power: Letting go of Postgres Column Lengths
  48. How to Connect the pgEdge AI DBA Workbench to Supabase for Intelligent Monitoring
  49. No Compiler Required: Writing SQL-Only Postgres Extensions
  50. pgEdge Control Plane Adds Supporting Services and Preview of Systemd Support
  51. I Built Three GitHub Codespaces Walkthroughs for Our Products. Would You Use Them?
  52. It Depends: Using Session Variables in Postgres
  53. Volatile Queries and Semantic Caching: How to Make Sure It Always Returns the Right Answer
  54. The Scaling Ceiling: When One Postgres Instance Tries to Be Everything
  55. Introducing the AI DBA Workbench: PostgreSQL Monitoring That Diagnoses, Not Just Reports
  56. How to Use the pgEdge Control Plane: From Zero to Multi-Master and Beyond
  57. Enforcing Constraints Across Postgres Partitions
  58. pgEdge Vectorizer and RAG Server: Bringing Semantic Search to PostgreSQL (Part 2)
  59. Checkpoints, Write Storms, and You
  60. Essential Concepts for Retrieval-Augmented Generation (RAG)
  61. Using the pgEdge MCP Server with a Distributed PostgreSQL Cluster
  62. What is a Collation, and Why is My Data Corrupt?
  63. pgEdge MCP Server for Postgres Is Now GA. Here’s Why That Matters
  64. Replicating CrystalDBA With pgEdge MCP Server Custom Tools
  65. Absorbing the Load
  66. Multi-Master-Ready - An Origin Story
  67. Using Patroni to Build a Highly Available Postgres Cluster—Part 3: HAProxy
  68. RAG With Transactional Memory and Consistency Guarantees Inside SQL Engines
  69. AI Features in pgAdmin: AI Insights for EXPLAIN Plans
  70. Using Patroni to Build a Highly Available Postgres Cluster—Part 2: Postgres and Patroni
  71. AI Features in pgAdmin: The AI Chat Agent
  72. AI Features in pgAdmin: Configuration and Reports
  73. Using Patroni to Build a Highly Available Postgres Cluster—Part 1: etcd
  74. pg_semantic_cache in Production: Tags, Eviction, Monitoring, and Python Integration
  75. How Patroni Brings High Availability to Postgres
  76. Semantic Caching in PostgreSQL: A Hands-On Guide to pg_semantic_cache
  77. Building Ask Ellie: A RAG Chatbot Powered by pgEdge
  78. Lessons Learned Writing an MCP Server for PostgreSQL
  79. Securing MCP Servers in Zero Trust Environments
  80. Teaching an LLM What It Doesn't Know About PostgreSQL
  81. MCP Transport: Architecture, Boundaries, and Failure Modes
  82. How to Use the pgEdge MCP Server for PostgreSQL with Claude Cowork
  83. What's New in the pgEdge Postgres MCP Server: Beta 2 and Beta 3
  84. Introducing pgEdge Load Generator: Realistic PostgreSQL Workload Simulation
  85. Postgres 18: Generated Column Replication and Enhanced Monitoring
  86. Custom Properties for PostgreSQL Database Objects Without Core Patches
  87. PostgreSQL 18 RETURNING Enhancements: A Game Changer for Modern Applications

2025 52

  1. pgEdge Support for Large Object Logical Replication
  2. RAG Servers vs MCP Servers: Choosing the Right Approach for AI-Powered Database Access
  3. Introducing The pgEdge Postgres MCP Server - And How to Connect it to Claude Code and Cursor
  4. Building AI Agents on Postgres: Why We Built the pgEdge Agentic AI Toolkit
  5. Anonymising PII in PostgreSQL with pgEdge Anonymizer
  6. Zero-Downtime PostgreSQL Maintenance with pgEdge
  7. Building a RAG Server with PostgreSQL - Part 3: Deploying Your RAG API
  8. Building a RAG Server with PostgreSQL - Part 2: Chunking and Embeddings
  9. Building a RAG Server with PostgreSQL - Part 1: Loading Your Content
  10. Understanding Snowflake Sequences in a Postgres Extension
  11. pgEdge Enterprise Postgres: now Available for Debian
  12. Postgres 18: Skip Scan - Breaking Free from the Left-Most Index Limitation
  13. Introducing the pgEdge Control Plane: High-Availability Postgres, Simplified
  14. Simplifying Cluster-Wide SQL Execution in pgEdge with exec_node()
  15. Multi-Master Replication: Using pgEdge Enterprise Postgres with Spock and CloudNativePG
  16. Blue-Green Postgres Major Version Upgrades with Spock + CNPG: From PG 17 to PG 18
  17. Seamless PostgreSQL Major Version Upgrades with CloudNativePG and Spock Logical Replication
  18. pgEdge + CloudNativePG: Simplifying Distributed Postgres on Kubernetes
  19. Getting Started with the pgEdge Helm Chart for Distributed PostgreSQL
  20. Meeting High Availability Requirements in Non-Distributed PostgreSQL Deployments
  21. Returning Multiple Rows with Postgres Extensions
  22. Scaling Postgres
  23. What's Our Vector, Victor? Building AI Apps with Postgres
  24. When Failure Isn't an Option: Choosing Postgres for Critical Operations
  25. Introduction to Developing Postgres Extensions
  26. Introducing pgEdge Enterprise Postgres and Full Commitment to Open Source
  27. pgEdge goes Open Source
  28. Highlights of PostgreSQL 18
  29. PostgreSQL in Mission-Critical Environments Survey Results
  30. Scaling Without Stopping: Inside pgEdge Distributed Postgres Zero-Downtime and Exception-Resilient Replication
  31. Optimising Cold Page Reads in PostgreSQL
  32. The Joy of Deploying pgEdge Distributed PostgreSQL Using Ansible
  33. SQLAlchemy versus Distributed Postgres
  34. Implementing pgBackRest for Backup and Restore in pgEdge
  35. Managing DDL Migrations in a Multi-master Database
  36. pgEdge Distributed PostgreSQL Now Available on Akamai Cloud
  37. Navigating Distributed PostgreSQL Options: pgLogical and Beyond
  38. Living on the Edge: Conflict Management and You
  39. Using Snowflake Sequences with the Hibernate IDENTITY column
  40. How Not To Use PostgreSQL DDL Replication
  41. Unleashing the Power of PostgreSQL with pgEdge Distributed Multi-Master Replication and Postgres Platform - Part 2
  42. Unleashing the Power of PostgreSQL with pgEdge Distributed Multi-Master Replication and Postgres Platform - Part 1
  43. The Role of Active-Active Replication in Building Multi-Region, Resilient PostgreSQL Clusters
  44. 8 Steps to Proactively Handle PostgreSQL Database Disaster Recovery
  45. PostgreSQL Compatibility: Cutting Through the Hype with PG Scorecard
  46. Unlocking The Power of Multi-Master: 7 Migration Design Considerations
  47. Always Online or Bust - Zero Downtime Major Version Postgres Upgrades
  48. You Are a CFO. Why Should You Know About pgEdge Distributed Postgres?
  49. Transitioning RDS Applications to a Multi-Cloud Architecture with pgEdge Platform
  50. Scaling AI Inference at the Edge
  51. PostgreSQL Performance Tuning
  52. Preserving replication slots across major Postgres versions - PostgreSQL high availability for major upgrades

2024 12

  1. Delivering “Always On” Collaboration with High Availability: Mattermost Integrates pgEdge Distributed PostgreSQL
  2. Point-In-Time Recovery (PITR) in PostgreSQL
  3. Bridging Healthcare’s Data Divide: How pgEdge Distributed Postgres and HAPI FHIR Delivered Scalability and Security
  4. Understanding and Reducing PostgreSQL Replication Lag
  5. Setting Up Failover Slots in PostgreSQL-17
  6. PostgreSQL 17 - A Major Step Forward in Performance, Logical Replication and More
  7. PostgreSQL 17 and its key improvements now available for pgEdge Distributed PostgreSQL
  8. Announcing General Availability of pgEdge Cloud Enterprise Edition
  9. Understanding the Differences and Advantages of Active-Active vs. Active-Passive Replication
  10. Queries for Optimizing and Debugging PostgreSQL Replication
  11. pgEdge's Distributed Postgres Improves Logical Replication Management with Enhanced Exception Handling
  12. pgEdge Distributed PostgreSQL: The Next Generation — Introducing pgEdge Platform v24.07, Constellation Release

Undated 40

  1. pgEdge Platform Support for Large Object Logical Replication
  2. How to Migrate from AWS Aurora to pgEdge for Low Latency, Multi-region and Multi Master Distributed Postgres: Part 2
  3. How to Migrate from AWS Aurora to pgEdge for Low Latency, Multi-region and Multi-Master Distributed Postgres: Part 1
  4. Decoding Active Active in PostgreSQL: Replication Architectures and Solutions for your Active Active Database
  5. Postgres Scalability: Navigating Horizontal and Vertical Scalability Pathways
  6. Logical Replication Features in PG-17
  7. Achieving PostgreSQL High Availability: Strategies, Tools, and Best Practices
  8. Using Automatic DDL Replication with pgEdge Distributed PostgreSQL
  9. Designing an Equinix Deployment with pgEdge Distributed PostgreSQL
  10. Introducing Snowflake Sequences in a Postgres Extension
  11. Moving data closer to the edge with Equinix and pgEdge Distributed Postgres
  12. PostgreSQL high availability clustering solutions
  13. Cloudflare Workers with pgEdge Distributed PostgreSQL
  14. Buyers Guide for Distributed Postgres: Understanding Postgres Compatibility
  15. pgEdge Cloud + Cloudflare Workers: Northwind Sample App
  16. Announcing pgEdge Cloud Developer Edition Preview
  17. A Brief History of PostgreSQL Logical Replication — and Looking Ahead at its Likely Future Evolution
  18. Announcing our partnership with Equinix, and availability of pgEdge Platform on Equinix Metal!
  19. Optimizing pgEdge Distributed PostgreSQL in your AWS environment
  20. Installing Distributed PostgreSQL with pgEdge Platform - A Comprehensive Guide
  21. Using pgEdge to Achieve High Availability for PostgreSQL
  22. pgEdge Cloud: Announcing Google Cloud Support!
  23. pgEdge Platform, fully distributed PostgreSQL for the network edge, is generally available
  24. The Risks of Not Having a Multi-Region PostgreSQL Cluster
  25. Unlocking PostgreSQL 16 New Features
  26. Embedding near the edge: pgEdge Distributed PostgreSQL with pgVector
  27. pglogical Rediscovered: A Fresh Approach to Logical Replication for High Availability
  28. The Significance of Multi-Master PostgreSQL: Embracing Active-Active Replication Introduction
  29. PostgreSQL 16 Logical Replication Improvements in Action
  30. PgEdge - Docker Compose Quick Start
  31. An Open Approach to Asynchronous Multi-master Replication With PostgreSQL
  32. Announcing support for multiple Postgres versions in pgEdge, along with zero downtime upgrades!
  33. Postgres is now the #1 database choice among developers
  34. pgEdge and PostgREST
  35. PostgreSQL Multi-master Replication and upcoming Logical Replication Improvements in PostgreSQL 16
  36. Spock PostgreSQL Multi-Master (Multi-Active) Replication from pgEdge
  37. Achieve multi-master (multi-active) data replication in PostgreSQL with Spock
  38. Why we started pgEdge (and why now)
  39. Introducing pgEdge Distributed PostgreSQL (and Spock)
  40. Using pgEdge with edge compute platforms like Cloudflare, Fastly and Vercel