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…
PostgreSQL
18 articles
1 min read
PostgreSQL with pgvector: Open Source Vector Search
pgvector enables AI-ready applications using familiar PostgreSQL infrastructure.
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…