Concurrency control Optimistic
Optimistic, document level
MVCC, row-level write locks
Optimistic
Show detailed feature comparison
Single-node transactions Supported
Supported*MongoDB multi-document transactions need a replica set or a sharded cluster.
Supported
Supported, single partition only*CosmosDB supports multi-document transactions only within one logical partition.
Show detailed feature comparison
Distributed transactions Ensures writes on majority of nodes
Ensures writes on majority of nodes
Two-phase commit building block
Not across partitions
Show detailed feature comparison
Querying Fully fledged search-engine capabilities
Query API and aggregation pipeline
SQL, JSONB and SQL/JSON
Multiple querying APIs
Show detailed feature comparison
Indexing Lock-free, background, auto and custom indexes
Sync, on the write path, field values only
Sync, on the write path, many index types
Sync, indexing policy dependent
Show detailed feature comparison
Spatial indexing Highly configurable, supports WKT
Supports GeoJSON
PostGIS extension
Supports GeoJSON
Show detailed feature comparison
Full-text search Lucene or Corax engine with custom analyzers
Basic $text index, or a separate search process
Index-based, configurable dictionaries
Built-in, BM25 ranking
Show detailed feature comparison
Vector search Built-in, generates embeddings
Separate mongot process
pgvector extension
Built-in, API for NoSQL
Show detailed feature comparison
Aggregation Precomputed and incremental, instant results
Aggregation pipelines
SQL aggregations
SQL-like aggregates, computed at query time
Show detailed feature comparison
Replication Multiple replication strategies, high availability and load-balancing
Single primary, seconds-long failover
Primary-standby only
Multi-region, last-writer-wins conflicts
Show detailed feature comparison
Sharding Supported, sharding on document ID
Multiple sharding strategies, needs specialized services
No built-in sharding*Core PostgreSQL has no built-in sharding.
Sharding on user-defined key
Show detailed feature comparison
ETL Built-in, real-time, 9 destination types
A few options: Kafka or Atlas only
3rd-party
Through other Azure services
Show detailed feature comparison
Database event notification Multiple options: Subscriptions, Changes API, Queue ETL
Filtering and field projection, resumable
Not durable
Change feed, no filtering, no deletes by default
Show detailed feature comparison
Storing binary blobs Transactional, cloud-native blob support
Supported, large files non-transactional
Supported, transactional
Deprecated
Show detailed feature comparison
Management tools Integrated
Separate tools
psql, pgAdmin and 3rd-party
Integrated
Show detailed feature comparison
DBaaS costs Flat-rate
Per tier, with additional costs
3rd-party provider pricing
Request Units costs
Show detailed feature comparison
