PostgreSQLIntermediateWhy is SELECT COUNT(*) so slow in PostgreSQL?
MVCC means Postgres doesn't store a row count. Make exact counts cheaper, get instant estimates from the planner, and keep exact counters when you really need them.
#internals#mvcc#performance
Tanishk · 8 min