Re:PostgreSQL Count(*) Performance Improvements
by ants_a on Thursday April 11, 2019 @02:23AM
(#19631652)
Sharding the counters would help, but with MVCC the typical solution is a delta table containing +1 and -1 records that is periodically compacted into the main count. With some cleverness about how to perform the compaction it's possible to make that very efficient.
[ Parent
| on HN ]
There are no comments on this comment yet.