8 min read
PostgreSQL Major Upgrades on Azure: Validate Early, Don't Pay to Wait
Pre-upgrade validation for Azure PostgreSQL Flexible Server is GA and Extended Support is now billed. An upgrade runbook and a version policy to avoid paying.
PostgreSQL
23 articles
8 min read
Hybrid Search in PostgreSQL: What It Costs to Own the Fusion
Azure AI Search and Cosmos DB fuse keyword and vector results for you; pgvector doesn't. What owning RRF in PostgreSQL involves, and when it pays.
9 min read
Six Vector Stores for RAG and Where Each One Hurts
Azure AI Search, DocumentDB, Cosmos DB for NoSQL, pgvector, Pinecone and Redis each fail differently in RAG. Where each one hurts in January 2026.
1 min read
Vector Database Selection: Comparing Azure AI Search, Cosmos DB, and PostgreSQL
Azure AI Search, Cosmos DB with vector indexing, and Azure Database for PostgreSQL with pgvector each provide vector search capabilities with different…
1 min read
PostgreSQL with pgvector: Open Source Vector Search
pgvector enables AI-ready applications using familiar PostgreSQL infrastructure.
7 min read
Hybrid Search in PostgreSQL: pgvector, Full-Text and RRF in One Query
How to build hybrid search inside PostgreSQL with pgvector, full-text search and weighted reciprocal rank fusion, and when a dedicated search service is better.
8 min read
Where Should Your Vectors Live on Azure? Search Index vs Database
Azure AI Search, Cosmos DB for NoSQL and PostgreSQL with pgvector can all hold embeddings now. Here is how I decide between a search index and your database.
1 min read
PostgreSQL in Microsoft Fabric: What to Expect
PostgreSQL in Fabric will bring familiar PostgreSQL capabilities to the unified data platform. Start preparing now by designing schemas that work well with…
1 min read
Azure Arc-Enabled PostgreSQL Hyperscale
Azure Arc-enabled PostgreSQL Hyperscale brings the best of Azure's managed database services to wherever your data needs to live.
1 min read
Azure Database for PostgreSQL Flexible Server Deep Dive
Flexible Server gives you the power of managed PostgreSQL with the flexibility to tune it for your specific needs.
1 min read
Time-Series Data at Scale with Citus and TimescaleDB
This architecture handles billions of time-series data points while maintaining query performance for both real-time and historical analysis.
1 min read
Building Real-Time Dashboards with Citus
Combining Citus's distributed query power with rollup tables and caching enables dashboards that handle millions of events per second.
1 min read
Data Colocation in Citus for Optimal Join Performance
When two distributed tables share the same distribution column and colocation group, their corresponding shards are placed on the same worker node.
1 min read
Mastering Distributed Queries in Citus
Understanding these query patterns helps you leverage Citus effectively for high-performance distributed PostgreSQL applications.
1 min read
Using Reference Tables in Citus for Efficient Joins
Reference tables eliminate network round-trips for joins, significantly improving query performance in distributed setups.
1 min read
Sharding Strategies for Distributed PostgreSQL
The distribution column (also called the shard key) determines how data is partitioned across nodes. Citus uses consistent hashing on this column to assign…
1 min read
Understanding Hyperscale Citus Architecture
Understanding this architecture helps you make informed decisions about data modeling and query optimization in your distributed PostgreSQL deployments.
1 min read
Getting Started with Azure Cosmos DB for PostgreSQL
Azure Cosmos DB for PostgreSQL is a managed database service that extends PostgreSQL with distributed capabilities. It uses the Citus extension to transform…
1 min read
Azure Arc-Enabled Data Services: Run Azure Data Anywhere
Arc-enabled data services bring cloud-native database capabilities to any environment. Whether you need SQL Server or PostgreSQL, you can run managed…
2 min read
TimescaleDB on Azure: Time-Series Data at Scale
TimescaleDB is the time-series database I recommend to teams that are already comfortable with PostgreSQL and don't want to learn a new query language or…
1 min read
PostgreSQL Hyperscale (Citus) on Azure: Distributed Database Patterns
Hyperscale uses the Citus extension to create a distributed database: Coordinator : Routes queries, stores metadata Workers : Store data shards, execute…
2 min read
Azure Arc Data Services: Azure SQL and PostgreSQL Anywhere
Arc data services let you run Azure-managed databases on your own infrastructure while using Azure tools for management.
2 min read
Azure Database for PostgreSQL Flexible Server - A Deep Dive
Flexible Server is the deployment option I now default to when a client asks "which PostgreSQL on Azure should I use?" The original Single Server mode…