- MVCC (Multi-Version Concurrency Control) for high-concurrency OLTP workloads
- EXPLAIN ANALYZE (8.0+) for actual runtime metrics, not just estimates
- B+-tree indexes for most access patterns Review collected by and hosted on G2.com.
- Cardinality estimation can still be poor for complex predicates, even with histograms
- Limited ability to reason about correlated subqueries
- Next-key locking can cause unexpected contention and deadlocks Review collected by and hosted on G2.com.
