News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.